Unable to publish reports using Solution Manager

  • 7008294
  • 05-Apr-2011
  • 26-Apr-2012

Environment

Novell Sentinel 6.1
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)
---

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