Cannot run Ad Hoc custom reports in CABI 4.1 SP3 in Linux
Article ID: 38608
Updated On:
Products
Issue/Introduction
The following errors are displayed when Ad Hoc custom reports are launched:
An internal error occurred while calling 'getPromptList' API. (Error: ERR_WIS_30270) (WIS 30270)
An internal error occurred while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270) (WIS 30270)
com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: FatalException occured. The cause was : com.businessobjects.corba.generic.container.proxy.internal.DependencyFailoverCallbackImpl$FailoverFatalException: Prepare failover failed
at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)
at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)
at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:183)
at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:133)
at com.businessobjects.services.coresdk.wsgateway.GatewayPortImpl.processRequest(GatewayPortImpl.java:126)
at sun.reflect.GeneratedMethodAccessor226.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)
at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:61)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)
at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:102)
at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:464)
at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:188)
at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:148)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)
at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110)
at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30)
at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46)
Environment
CA Spectrum 10.2.3 or below integrated with CABI 4.1 SP3 installed on Linux
Cause
The MySQL ODBC driver was not properly configured to 64 bit in the mysql.sbo file under folder <CABI install directory>/sap_bobj/enterprise_xi40/dataAccess/connectionServer/odbc
Resolution
Steps to be performed on CABI system:
1. Login to CABI machine and navigate to /opt/CA/SharedComponents/CommonReporting4/sap_bobj directory and stop SIA server (./stopservers)
2. Then locate mysql.sbo file under folder <CABI install directory>/sap_bobj/enterprise_xi40/dataAccess/connectionServer/odbc directory.
3. Open the file and modify <Library Platform="Unix32">dbd_wuxodbc3</Library> & <Library Platform="Unix32">dbd_uxodbc3</Library> to <Library Platform="Unix">dbd_wuxodbc3</Library> & <Library Platform="Unix">dbd_uxodbc3</Library>
4. Also disable the ARRAY FETCH parameter: <Parameter Name="Array Fetch Available">True</Parameter>. Set it to False.
5. After setting the parameters start the servers from /opt/CA/SharedComponents/CommonReporting4/sap_bobj using ./startservers command.
Now you will be able to run the reports successfully.
Feedback
