Issue with exporting data to MS Excel using Edit In Excel UI
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..
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 -
Fiddler snapshot shows following response when user clicks on Edit in Excel button -
Steps to Reproduce
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).
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.