Cannot run Ad Hoc custom reports in CABI 4.1 SP3 in Linux

book

Article ID: 38608

calendar_today

Updated On:

Products

CA Spectrum

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)

 

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 

Environment

CA Spectrum 10.2.3 or below integrated with CABI 4.1 SP3 installed on Linux

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.