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
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.
Hi Stefan Helzle
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.
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.