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?
I think that trying to load more than 1 MB of data into memory is not a good solution. Help us to understand the purpose and we can help to find other options.
Try to make several querys, each one of them consulting one portion of that data, but as Stefan says, it's not a good approach to have the data stored in that way,
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.
Hi Stefan Helzle
I understand. IMHO, this is the end of what you can/should do with standard Appian. I suggest to consider building a custom plugin to handle these calls. You could use the existing plugin "Advanced Call Webservice" to start with.
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.