Environment
Novell Sentinel 6.1
Reporting
Crystal XI R2
Linux
Reporting
Crystal XI R2
Linux
Situation
Sentinel Control Center log (control_center0.*.log) throws the following exception:
Thu Mar 31 20:10:43 BRT 2011|SEVERE|Thread-53|Unknown.unknown
Error installing control Dashboard Status.; Exception Error publishing report Collector_Pack_Status_Dashboard_Oracle.rpt in folder SentinelReports/Novell_eDirectory.; com.esecurity.content.io.BaseInstallerException;
Thu Mar 31 20:10:43 BRT 2011|SEVERE|Thread-53|Unknown.unknown
com.esecurity.content.io.BaseInstallerException: Error publishing report Collector_Pack_Status_Dashboard_Oracle.rpt in folder SentinelReports/Novell_eDirectory.
at com.esecurity.content.install.reports.crystal.CrystalReportsHTTPContentInstaller.install(CrystalReportsHTTPContentInstaller.java:55)
at com.esecurity.content.install.AbstractDelegatorContentInstaller.install(AbstractDelegatorContentInstaller.java:33)
---
Thu Mar 31 20:10:43 BRT 2011|SEVERE|Thread-53|Unknown.unknown
Error installing control Dashboard Status.; Exception Error publishing report Collector_Pack_Status_Dashboard_Oracle.rpt in folder SentinelReports/Novell_eDirectory.; com.esecurity.content.io.BaseInstallerException;
Thu Mar 31 20:10:43 BRT 2011|SEVERE|Thread-53|Unknown.unknown
com.esecurity.content.io.BaseInstallerException: Error publishing report Collector_Pack_Status_Dashboard_Oracle.rpt in folder SentinelReports/Novell_eDirectory.
at com.esecurity.content.install.reports.crystal.CrystalReportsHTTPContentInstaller.install(CrystalReportsHTTPContentInstaller.java:55)
at com.esecurity.content.install.AbstractDelegatorContentInstaller.install(AbstractDelegatorContentInstaller.java:33)
---
Resolution
Troubleshooting the issue on Crystal XI R2 server side (<bobje_home_dir>/bobje/tomcat/logs/localhost_log.<date>.txt), you will find
publish_report_jsp.class Java servlet looking for the script
responsible for adding the report in a wrong path:
2011-04-01 14:51:58 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred
cause:java.io.IOException: java.io.IOException: /opt/crystal_xi/bobje/enterprise115/linux_x86/plugins/desktop/CrystalEnterprise.Report/ReportAddSh.sh: not found
detail:An unexpected error has occurred
The exception originally thrown was java.io.IOException: java.io.IOException: /opt/crystal_xi/bobje/enterprise115/linux_x86/plugins/desktop/CrystalEnterprise.Report/ReportAddSh.sh: not found
---
1) Edit CCM service configuration file (<bobje_home_dir>/bobje/ccm.config), and make sure variable BOBJEDIR has been set to the correct Crystal Server home directory:
For example: BOBJEDIR="/opt/crystal_xir2/bobje"
2) Restart tomcat server:
<bobje_home_dir>/bobje/tomcatshutdown.sh
<bobje_home_dir>/bobje/tomcatstartup.sh
2011-04-01 14:51:58 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred
cause:java.io.IOException: java.io.IOException: /opt/crystal_xi/bobje/enterprise115/linux_x86/plugins/desktop/CrystalEnterprise.Report/ReportAddSh.sh: not found
detail:An unexpected error has occurred
The exception originally thrown was java.io.IOException: java.io.IOException: /opt/crystal_xi/bobje/enterprise115/linux_x86/plugins/desktop/CrystalEnterprise.Report/ReportAddSh.sh: not found
---
1) Edit CCM service configuration file (<bobje_home_dir>/bobje/ccm.config), and make sure variable BOBJEDIR has been set to the correct Crystal Server home directory:
For example: BOBJEDIR="/opt/crystal_xir2/bobje"
2) Restart tomcat server:
<bobje_home_dir>/bobje/tomcatshutdown.sh
<bobje_home_dir>/bobje/tomcatstartup.sh