We are using Exportable datasubset plug-in in one of our tempo reports for “Expo

sanjeevr over 10 years ago

We are using Exportable datasubset plug-in in one of our tempo reports for “Export to Excel” feature. We are facing issues in exporting couple of columns from the report. The tempo report actually has a grid that show filtered results on screen along with a provision to export results to excel. While the grid seamlessly renders 24 columns, export functionality fails to do the same, although both use same query entity.
Failing columns are text strings with no visible difference from those that are successfully getting exported.

Excerpt from the log while all 24 columns couldn’t be exported.

2015-04-30 15:00:25,010 [ajp-/0.0.0.0:8009-27] ERROR com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet -
java.lang.NullPointerException
at com.appiancorp.tools.shared.ExcelHelperUtils.writeDsToExcel(ExcelHelperUtils.java:218)
at com.appiancorp.tools.shared.ExcelHelperUtils.convertDataToExcel(ExcelHelper...

Discussion posts and replies are publicly visible

0 sanjeevr over 10 years ago

...Utils.java:98)
at com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet.doGet(ExportDataSubsetToExcelServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

What version of this plug-in are you using? I looked at the most recent version 1.1.0 and I couldn't correlate the stack trace lines you're getting with the ones in the source code

Can you install the latest version and re-test to see if we can find out the root cause by looking at the source code?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sikandar Dadan over 10 years ago

We updated to the latest plugin 1.1.0, still we have the same response
2015-05-01 15:14:40,891 [ajp-/0.0.0.0:8009-1] ERROR com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet -
java.lang.NullPointerException ......
2015-05-01 15:14:40,906 [ajp-/0.0.0.0:8009-1] ERROR com.appiancorp.ap2.PortalResponse - Error: 500
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Can you paste the whole stack trace just like before so I can see the exact lines where the error is happening? This output is too short to troubleshoot.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sethulakshmis over 10 years ago

We are not able to reproduce the error now. But we could see the column headers alone getting exported though they have definite data. Also, nothing got logged in the stack trace.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sethulakshmis over 10 years ago

We tried to filter values without any special characters for those two problematic columns, trying to sort out if that is the culprit, but still unable to see them on the exported excel. Eduardo, can you please advise.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Is this Download DataSubset (On-Premise) or Download DataSubset (Cloud)?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sethulakshmis over 10 years ago

On-Premise
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

Add this to line 21 (or whatever EMPTY line you have) in <APPIAN_HOME>\\runtime_ear|ear\\suite.ear\\resources\\appian_log4j.properties

log4j.logger.com.appiancorp.ps.plugins=DEBUG

wait 5 minutes and test. Then search for DEBUG entries in the application-server.log
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sikandar Dadan over 10 years ago

We added the line in appian.log4j.properties files. it just logs the below line in the log file,

2015-05-08 19:59:03,333 [ajp-/0.0.0.0:8009-12] DEBUG com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet - Execute Time (ms): 268
2015-05-08 19:59:11,595 [ajp-/0.0.0.0:8009-12] DEBUG com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet - Transform Time (ms): 8256
2015-05-08 19:59:11,596 [ajp-/0.0.0.0:8009-12] DEBUG com.appiancorp.ps.plugins.downloaddatasubsetfromrule.ExportDataSubsetToExcelServlet - Total Time (ms): 8531
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel