Business Objects Enterprise Reporting fails with ZCC login as user source user

  • 7000980
  • 18-Jul-2008
  • 01-Jun-2012

Environment

Novell ZENworks 10 Configuration Management

Situation

After logging into the ZCC using a super administrator based on a user source (for example, Administrator@windomain.com), running reports for Business Objects Enterprise Reporting shows the following
 
ERROR: "Error:   An error occurred while trying to launch the Business Objects Java Infoview. For more details, see the ZCC log."

Resolution

Login as a database super administrator, not a user source super administrator.

Status

Reported to Engineering

Additional Information

Additional troubleshooting:
 
This error could also be caused if the mysql service is not started.  Check Windows services to ensure that this service is started. 
 
Also, check that the installation logs: boeinstall_0.log and ZENworks_Install*.xml show that the installation completed sucessfully.  Use the CCM (Central Configuration Manager) to ensure that the services are all running.  Check the odbc data source for the Business Objects CMS and run test connection to determine that communication to the database as the BOE user is successful. 
 
 
ERROR (From the BOE logs, CMS_*.log):
 
[Thu Jul 17 10:00:02 2008] 2656 2672 assert failure: (\backend\Cms\DatabaseSubsystems\MySQLDatabaseSubsystem\mysqlwrapper\MySQLDatabase.cpp:526). (0 : MySQL Database: ERROR while connecting to the MySql database host.).
[Thu Jul 17 10:00:02 2008] 2656 2672 assert failure: (\backend\cms\include\AuditDBSubsystem.h:276). (0 : MySQL database error: ERROR1045(28000): Access denied for user
'ODBC'@'localhost' (using password: NO)).
 
ERROR (from zcc.log):
 
17 Jul 2008 10:46:06 ============== Exception (begin) ===========================
17 Jul 2008 10:46:06 Exception occured
com.novell.zenworks.reports.exception.ReportException: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No and had the following message: Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
 at com.novell.zenworks.reports.boe.SessionManager.getToken(SessionManager.java:226)
 at com.novell.zenworks.admin.pages.reports.ReportRedirection.getInfoViewURL(ReportRedirection.java:264)
 at com.novell.zenworks.admin.pages.reports.ReportRedirection.launchStandardReport_Clicked(ReportRedirection.java:139)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at com.novell.web.controls.WebControl.fireEvent(WebControl.java:1975)
 at com.novell.web.controls.WebControl.fireEvent(WebControl.java:1950)
 at com.novell.zenworks.admin.controls.Task.raisePostBackEvent(Task.java:219)
 at com.novell.web.controls.Page.raisePostBackEvent(Page.java:862)
 at com.novell.web.controls.Page.raisePostBackEvents(Page.java:849)
 at com.novell.web.controls.Page.internalProcessRequest(Page.java:581)
 at com.novell.web.controls.Page.processRequest(Page.java:525)
 at com.novell.zenworks.admin.layout.Index.processRequest(Index.java:516)
 at com.novell.web.controls.PageTag.doEndTag(PageTag.java:83)
 at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:179)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
 at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
 at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet.java:82)
 at com.novell.zenworks.admin.NRMServlet.service(NRMServlet.java:176)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1090)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
 at java.lang.Thread.run(Thread.java:595)
Caused by: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No and had the following message: Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
 at com.crystaldecisions.sdk.exception.SDKException.map(Unknown Source)
 at com.crystaldecisions.sdk.occa.security.internal.t.a(Unknown Source)
 at com.crystaldecisions.sdk.occa.security.internal.t.a(Unknown Source)
 at com.crystaldecisions.sdk.occa.security.internal.t.userLogon(Unknown Source)
 at com.crystaldecisions.sdk.occa.security.internal.l.userLogon(Unknown Source)
 at com.crystaldecisions.sdk.framework.internal.d.logon(Unknown Source)
 at com.novell.zenworks.reports.boe.SessionManager.getToken(SessionManager.java:217)
 ... 47 more
Caused by: com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
 at com.crystaldecisions.enterprise.ocaframework.j.find(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.i.a(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.i.buildServerInfo(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.aa.for(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.for(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.p.a(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getManagedService(Unknown Source)
 ... 53 more
Caused by: com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
 at com.crystaldecisions.thirdparty.com.ooc.OCI.FSSLIOP.Transport_impl.<init>(Transport_impl.java:459)
 at com.crystaldecisions.thirdparty.com.ooc.OCI.FSSLIOP.Connector_impl.connect(Connector_impl.java:177)
 at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.createTransport(GIOPClient.java:233)
 at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClientWorkersPool.next(GIOPClientWorkersPool.java:122)
 at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.getWorker(GIOPClient.java:105)
 at com.crystaldecisions.thirdparty.com.ooc.OB.GIOPClient.startDowncall(GIOPClient.java:409)
 at com.crystaldecisions.thirdparty.com.ooc.OB.Downcall.preMarshalBase(Downcall.java:181)
 at com.crystaldecisions.thirdparty.com.ooc.OB.Downcall.preMarshal(Downcall.java:298)
 at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.preMarshal(DowncallStub.java:250)
 at com.crystaldecisions.thirdparty.com.ooc.OB.DowncallStub.setupRequest(DowncallStub.java:530)
 at com.crystaldecisions.thirdparty.com.ooc.CORBA.Delegate.request(Delegate.java:556)
 at com.crystaldecisions.thirdparty.org.omg.CORBA.portable.ObjectImpl._request(ObjectImpl.java:118)
 at com.crystaldecisions.enterprise.ocaframework.idl.ImplServ._OSCAFactoryStub.getServices(_OSCAFactoryStub.java:806)
 at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.do(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.a(Unknown Source)
 at com.crystaldecisions.enterprise.ocaframework.ServiceMgr.getUnmanagedService(Unknown Source)
 ... 60 more
17 Jul 2008 10:46:06
Exception Info:
17 Jul 2008 10:46:06     Class....... com.novell.zenworks.reports.exception.ReportException
17 Jul 2008 10:46:06     Message..... com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.enterprise.ocaframework.OCAFrameworkException$CommunicationError: Communication error occurred when trying to connect to server myserver.com
cause:com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
detail:Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No and had the following message: Communication error occurred when trying to connect to server myserver.com
The exception originally thrown was com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: socket() failed: unable to obtain socket InputStream: com.rsa.ssl.SSLException: An IOException occured while saying hello: Connection reset by peer: socket write error  minor code: 0x4f4f0005  completed: No
17 Jul 2008 10:46:06     Logged at... ReportRedirection...273
17 Jul 2008 10:46:06 ============== Exception (end) =============================
17 Jul 2008 10:46:06 MessageUtil..........78 :Error:  An error occurred while trying to launch the Business Objects Java Infoview. For more details, see the ZCC log.