Skip to main content
H
harshw0876
February 28, 2024
Question

Limit of CDT variable in process model

  • February 28, 2024
  • 3 replies
  • 0 views

Hi Experts

I have a problem where I need to generate an excel without storing the data in DB.

I'm using Export CDT to excel smart service,

But I have nearly 6000 rows to fetch with only 3 columns(Request ID, DOC ID, Doc Name).

I want to know what is the maximum amount of data in terms of size(MB or KB) a process variable of type CDT can hold.

And if is there any better solution of what I'm doing, please suggest me.

Thank you in advance

3 replies

csteward
csteward
February 28, 2024

I do not believe there is a defined maximum here.  In my experience 6000 rows with 3 columns is not much data for Appian to handle.  I would just pay attention to your process archiving/deleting settings for server health but it should be no issues to process that size data.

To note, while the Export CDT to Excel service is deprecated, I still utilize it as well as there is no other service with it's capability available.

stefanhelzle0001
stefanhelzle0001
Brainy
February 28, 2024

Where is that data coming from? Can you share some details about this use case?

In general, you should avoid storing larger volumes of data in process variables.

mathieud0001
mathieud0001
Brainy
February 29, 2024

Any particular reason why you can't use the following built-in Smart Services?

  • Export Data Store Entity to Excel Smart Service 
  • Export Process Report to Excel Smart Service
Terms & ConditionsAccessibility statement