Skip to main content

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.

 

 

Suggest Edit

Published October 9, 2014 - Updated October 8, 2020

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us