Hi All
I have a requirement where I have to query the data from database for a particular column of type varchar(max) which has data more than 1 MB .
While fetching the data from query entity, I am getting memory threshold error.
Please recommend me some way of how can we fetch more than 1 mb data.
Many thanks in Advance!
Discussion posts and replies are publicly visible
Hi yogeshc,
Can you elaborate more about the use case? Why you need more than 1 MB data in Appian SAIL or PM?
Hi Harsh Kumar Agarwal
We need to send the Appian document to the external system and the external system is a soap service.
The External system only accepts documents in base 64 format.
So, I am using plugin Base64 Document Database Integration .to covert document to base 64 format.
This plugin helps to store document data in base 64 format. So I have to retrieve the data and send that base 64 data in Request body of soap web service.While retrieving the data of base 64 document field from database, I am getting memory threshold error.
AFAIK, custom plugin should be the option as Stefan suggested. You can also check with Appian support for other options.
If you can also tell how you are receiving base 64 in DB? If it is from a API call then Appian has OOTB functionality to convert it to document.