Export to Excel throws error 500. It works sporadically and errored 500 most of

Export to Excel throws error 500. It works sporadically and errored 500 most of the times.

com.appiancorp.ps.plugins.downloaddatasubsetfromprocess.ExportDataSubsetToExcelFromProcessServlet -
16:04:35,072 INFO [stdout] (ajp-/0.0.0.0:8009-31) java.lang.ClassCastException
16:04:35,072 INFO [stdout] (ajp-/0.0.0.0:8009-31) 2015-12-16 16:04:35,072 [ajp-/0.0.0.0:8009-31] ERROR com.appiancorp.ap2.PortalResponse - Error: 500

OriginalPostID-184647

OriginalPostID-184647

  Discussion posts and replies are publicly visible

  • @saravanana A few reasons that I could think of at the moment out of my experience re the 500 error in this plugin's implementation is:
    1. If the input parameter's length is abnormal, as it could result in hitting the maximum limit of the characters expected by plugin in forming the URL.
    2. If you are trying to export huge datasets.

    And it would be grateful if you could add some more information re the amount of data(approximate number of rows and columns) you are trying to export in cases of failure, the way you are sending input parameter(number of filters and the data carried by this filterset), some more log data as we might find a 'Caused By' in the logs.
  • Number of filters and data size is same.. but works for one filter, not work for same filter criteria with different data. Both returns same data volume - 35 total count. Is there any time limitation to fetch records? It would be good plug-in provides more details error for failure
  • @saravanana AFAIK the plugin won't be providing you clearly with the errors exactly we experience but exploring the logs should help us to some extent.

    Re time limitation, the process has to complete within 60 seconds. Also please bear in mind that the 'input' parameter should be kept as much as simple, that is it shouldn't hold characters of more length. Not sure if you haven't gone through the 'Data Export' section at https://forum.appian.com/suite/help/7.11/Download_DataSubset_Plugin.html but these are the limitations currently as per my knowledge.
  • @Saravana, if you have issues with the date or date time filter and that's what is causing the error, we would need to convert them to Text while setting to json
    Refer : forum.appian.com/.../e-163797
  • @sikandard, We are not using Data Time filter, only text filter alone passing as input.
    @sikhivahans, We are not exceeding 3 sec to fetch data and even URI length is 300 chars in Access logs..

    I tried to increase logger level to debug.. No help
    com.appiancorp.ps.plugins.downloaddatasubsetfromprocess.ExportDataSubsetToExcelFromProcessServlet -
    20:54:17,192 INFO [stdout] (ajp-/0.0.0.0:8009-29) java.lang.ClassCastException
    20:54:17,192 INFO [stdout] (ajp-/0.0.0.0:8009-29) 2015-12-16 20:54:17,192 [ajp-/0.0.0.0:8009-29] ERROR com.appiancorp.ap2.PortalResponse - Error: 500
    20:54:17,192 INFO [stdout] (ajp-/0.0.0.0:8009-29) 2015-12-16 20:54:17,192 [ajp-/0.0.0.0:8009-29] DEBUG com.appiancorp.ps.plugins.downloaddatasubsetfromprocess.ExportDataSubsetToExcelFromProcessServlet - Total Time: (ms)2314