Support Article
Issue with exporting data to MS Excel using Edit In Excel UI
SA-954
Summary
On-click of Edit in Excel button on the UI of Data Table, data was not getting exported from Pega to MS Excel for editing. However, user was able to see the data getting loaded in User Interface of Data Table (Data-->Data Table-->Any table).
"Invalid Data XML Message received from the Pega Rules Server".
Functionality is working for some of the data tables and not working for few data tables only..
Error Messages
On clicking the edit in excel, following error message pop-up when excel is loaded.
"Invalid Data XML Message received from the Pega Rules Server"
Following exception trace was noticed in the log file -
java.lang.ArrayIndexOutOfBoundsException
at com.pega.pegarules.data.internal.access.CompressImpl.isCompressed(CompressImpl.java:265)
at com.pega.pegarules.data.internal.clipboard.StorageStreamCommonImpl.inflateStream(StorageStreamCommonImpl.java:580)
Fiddler snapshot shows following response when user clicks on Edit in Excel button -
Steps to Reproduce
N/A
Root Cause
The database table corresponding to the data table has rows with null stored instead of valid Stream data (BLOB). During parsing the stream data having null data, java.lang.ArrayIndexOutOfBoundsException was thrown in the log file and same was returned to the excel as response (can be seen in captured fiddler trace).
Resolution
Following approaches were suggested to mitigate the behaviour -
1. If the issue was observed in just one environment then one way could be to migrate the database table along with the data from lower environment to the issue reported environment .
2. Another way is to export all the data (having null value in BLOB) to an excel and then delete the column from table containing null value in BLOB. Once deleted, open the data table instances using Edit in Excel and then insert the data which has null BLOB in excel and then re-save the excel which makes an entry in the table with valid BLOB.
Published October 9, 2014 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.