Troubleshooting
Problem
Using the "Generate Report" functionality to export search results to Microsoft Excel file using the Default Rich Search Results Report Script (Excel 2007 - xlsx format) fails after some time with Error message "Error occurred".
Symptom
In the User Interface only the simple message "Error Occurred" is displayed.
Cause
There are various reasons which may cause the Rich Search Results Report Script to fail.
Diagnosing The Problem
To identify the reason for the script failure, it is recommended to check for details in exception.log in either $TOP/appsvr* or $TOP/logs/scheduler* directory.
Exceptions logged by a "generateReport.wpc" thread provide more details for the reasons:
for example:
2014-09-10 16:09:20,028 [jsp_70: generateReport.wpc] ERROR com.ibm.ccd.common.error.AustinException - CWPCM0002E:Generic error / Exception: Script execution failed (java.lang.IllegalArgumentException) Exception:Invalid column index (16384). Allowable column range for EXCEL2007 is (0..16383) or ('A'..'XFD')
java.lang.IllegalArgumentException: Invalid column index (16384). Allowable column range for EXCEL2007 is (0..16383) or ('A'..'XFD')
at org.apache.poi.xssf.usermodel.XSSFCell.checkBounds(XSSFCell.java:853)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellNum(XSSFCell.java:706)
at org.apache.poi.xssf.usermodel.XSSFRow.createCell(XSSFRow.java:173)
In this example, the script tried to create more columns than the allowed 16384 columns in the excel sheet. This may happen if the used catalog view uses a large attribute collection which total more than 16384 attribute node references.
Resolving The Problem
The default Rich Search Results Report Scripts provided out of the box samples only and may not be production-ready. Customization of such scripts may be required depending on the usage scenario. Customization may involve modifying or optimizing the out of the box script or writing an entirely new script and selecting the new script when running the particular functionality.
The scripts can be accessed via the Script Console by selecting in the drop down list: "Rich Search Result Report Script"
Related Information
Was this topic helpful?
Document Information
More support for:
InfoSphere Master Data Management Collaboration Server
Software version:
10.1, 11.0, 11.3
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
251289
Modified date:
16 June 2018
UID
swg21684901