webi Export to excel error using SDK

[former_member360424]

Hi,

We have a Java BO SDK used to convert the schedule webi instance into PDF\ Excel\ CSV format.

The BO session is passed from Html page to CMS using user name which is present in BO.

According to access in BO the categories are displayed then the corresponding webi instance of the report. It shows three option there to convert the instance into PDF\excel\Test.

The same code is working for 4.1 SP9 however it working intermittently on BI 4.2 SP3 Patch 9.

I have observed that WIPS service is restarting randomly and getting Tomcat error is below.

TTP Status 500 - Request processing failed; nested exception is com.businessobjects.sdk.core.server.CommunicationException$InvalidServerResponseException: (Error: RWI 00200) type Exception report message Request processing failed; nested exception is com.businessobjects.sdk.core.server.CommunicationException$InvalidServerResponseException: (Error: RWI 00200) description The server encountered an internal error that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.businessobjects.sdk.core.server.CommunicationException$InvalidServerResponseException: (Error: RWI 00200) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)

com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: recv() failed: I/O error during read: java.net.SocketException: Connection reset com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:144) com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:101)

com.crystaldecisions.thirdparty.org.omg.CORBA.COMM_FAILURE: recv() failed: I/O error during read: java.net.SocketException: Connection reset minor code: 0x4f4f0001 completed: Maybe sun.reflect.GeneratedConstructorAccessor168.newInstance(Unknown Source)

WIPS error logs shows

|506cd9c7-9c0f-6aa4-4bbe-bb7684328fbf|2017 12 07 07:20:20:666|+0200|Error| |>>|E| |webiserver_KESBOQAPP01.WebIntelligenceProcessingServer8|20200|25488|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|kesboqapp03:5060:74.9717:1|Webi SDK.CorbaServerImpl.doProcess()|kesboqapp03:5060:74.9717:1|webiserver_KESBOQAPP01.WebIntelligenceProcessingServer8.openSession|localhost:20200:25488.21312:1|Cp5rLxuev0H7oHABcIEyAPI25f1|||||||||||**ERROR:Missing CtxtInfo‑

d:\r364\src\repoaccess\export\iface\cdztools\dgb\handler_impl.hpp:228:bool __cdecl dbg::HandlerBaseClass::exec(const class dbg::ContextError &): TraceLog message 3

|ef9429ad-aeeb-1b54-fad3-445f843e87bf|2017 12 07 07:20:20:667|+0200|Error| |>>|E| |webiserver_KESBOQAPP01.WebIntelligenceProcessingServer8|20200|25488|| |1|0|1|0|Webi SDK.CorbaServerImpl.doProcess()|kesboqapp03:5060:74.9717:1|Webi SDK.CorbaServerImpl.doProcess()|kesboqapp03:5060:74.9717:1|webiserver_KESBOQAPP01.WebIntelligenceProcessingServer8.openSession|localhost:20200:25488.21312:1|Cp5rLxuev0H7oHABcIEyAPI25f1|||||||||||**ERROR:

PID : '20200'

TID : '25488'

Exception: 'EXCEPTION_ACCESS_VIOLATION'

OS:Windows

Context infos local:

No infos

Context infos:

‑

[DellSC]

When you upgraded your BI Platform, did you also update the SDK libraries that your code is using? If you didn't, that might solve the problem. The library version and the BI Platform version should be the same - SAP won't support mixed versions, even though the mixed versions frequently will appear to work correctly.

If that doesn't solve the problem, it looks like you may have found a bug. In that case, you'll need to open a ticket. However, I wouldn't open the ticket under the SDK tags, but instead open it tagged to the platform for the WIPS errors.

-Dell