We need to dump ~30 MB Excel data into DB and we are using Import Excel to Database (Plugin to extract data from file to DB) with batch size=5000(parameter in plugin)
While doing this process, heap size is reaching threshold (4 GB) and causing the environment down. Is there any way to dump this data into DB via Appian without increasing the Heap size.
We need to do via Appian as User has to upload the excel via Common User interface.
Discussion posts and replies are publicly visible
Do you need to do this frequently? If yes, I suggest to perform an environment sizing assessment and adjust memory as required.
It will be done weekly basis by end uses. Do you think if any other solution is possible in Appian to accomplish it apart from resizing?
Not really. Look, while Appian is certainly capable of some simple data processing, it is just not made for this kind of jobs. And if you still want to do it with Appian, you will have to somehow deal with certain limitations and find workarounds.