Hi,
I have a requirement where I have to query the data from database for a particular column of type CLOB which has data more than 1 MB and display it in a text file .
While fetching the data from queryEntity it is reaching to memory threshold or it is reading the column data as null while trying to fetch the output directly from store procedure to flat file.
Please recommend me some way of how we can handle large files in Appian.
Thanks in Advance!
Discussion posts and replies are publicly visible
This is unclear to me. Is this about displaying > 1MB of text on screen or about writing > 1MB of text from DB into a document? Is each individual field larger than 1MB?
In general the memory restrictions are quite strict but could be changed. But to what level? Do you know what your upper limit would be?