Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
5 replies
Subscribers
6 subscribers
Views
2530 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Export to Excel throws error 500. It works sporadically and errored 500 most of
saravanana
over 9 years ago
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
0
sikhivahans
over 9 years ago
@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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saravanana
over 9 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sikandar Dadan
over 9 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saravanana
over 9 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel