Design Studio: JCO_ERROR_DESTINATION_DATA_INVALID

[Former Member]

Hi experts,

we are getting different "JCO_ERROR_DESTINATION_DATA_INVALID" errors if we are navigating through design studio applications (-> OLAP connection SAP BW) released at our SAP BO BI Platform caused by different reasons:

java.lang.IndexOutOfBoundsException: Index: 1, Size: 1

Invalid axis tuple size: Provider Result set ROWS

Invalid program status
...

The problem only occurs if there are more than 20 - 30 contemporaneous OLAP/BIP connections (different users). If there are i.e. 5 OLAP connections/BIP sessions we are not able to reproduce the error.

In every case we get the same warning:
JCO_ERROR_DESTINATION_DATA_INVALID: Destination
custom_cuid:AZx__tBaMIdNjIp5nH3cCNA is invalid because destination
cuid:AZx__tBaMIdNjIp5nH3cCNA was changed. Refresh the destination
instance with the JCoDestinationManager.

Complete exception chain:
com.sap.ip.bi.bics.exceptions.BicsProgrammErrorException: Invalid
program status
at
com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.ProviderSelection
Object.synchronizeStateVariables(ProviderSelectionObject.java:2148)
at
com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.SelectionObject.onEv
ent(SelectionObject.java:1229)
at
com.sap.ip.bi.bics.dataaccess.consumer.impl.queryview.QueryView.onEvent
(QueryView.java:1626)
at
com.sap.ip.bi.base.event.impl.EventSourceHelperStandalone.raiseEvent
(EventSourceHelperStandalone.java:333)
at
com.sap.ip.bi.base.event.impl.EventSourceHelperStandalone.raiseEvent
(EventSourceHelperStandalone.java:248)
at
com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.Va
riableProcessor.raiseEvent(VariableProcessor.java:347)
at
com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.variableprocessor.Va
riableProcessor.synchronizeStateVariables(VariableProcessor.java:1055)
at
com.sap.ip.bi.base.application.variableprocessor.impl.VariableContainer.s
ynchronizeStateVariables(VariableContainer.java:1172)
at
com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProces
sor.executeStandardDpReset(PageStateProcessor.java:1112)
at
com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProces
sor.setState_alignDataProviders(PageStateProcessor.java:804)
at
com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProces
sor.setState(PageStateProcessor.java:697)
at
com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageStateProces
sor.alignState(PageStateProcessor.java:2404)
at
com.sap.ip.bi.webapplications.runtime.impl.page.processor.PageBackProcess
or.backToPreviousState(PageBackProcessor.java:340)
at
com.sap.ip.bi.webapplications.runtime.impl.page.Page.doBackToPreviousStat
eCommand(Page.java:5928)
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:597)
at com.sap.ip.bi.util.MethodInvoker.callMethod
(MethodInvoker.java:155)

at com.sap.ip.bi.zen.boe.model.session.Session.executeBIRequest
(Session.java:205)
at
com.sap.ip.bi.zen.boe.server.transport.corba.SessionServant.executeBIRequ
est(SessionServant.java:90)
at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sap.framework.services.zen.ZenInterceptor.forwardRequest
(ZenInterceptor.java:47)
at com.sap.framework.services.zen.ZenInterceptor.invoke
(ZenInterceptor.java:39)
at
com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTr
ansportInterceptor.invokeHelper(CommonTransportInterceptor.java:125)
at
com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTr
ansportInterceptor.invoke(CommonTransportInterceptor.java:87)
at
com.businessobjects.framework.servers.common.proxy.cglib.MethodIntercepto
rChain.intercept(MethodInterceptorChain.java:136)
at
com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA$$EnhancerByCGLIB$$a
e5ee408.executeBIRequest(<generated>)
at
com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA._OB_op_executeBIReq
uest(CorbaSessionPOA.java:117)
at
com.sap.ip.bi.zen.boe.transport.corba.CorbaSessionPOA._invoke(CorbaSessionPOA.java:84)
at
com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.ServantDispatche
r.dispatch(ServantDispatcher.java:234)
at
com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._do_OB_
dispatch(POA_impl.java:1980)
at
com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._OB_dis
patch(POA_impl.java:1916)
at
com.crystaldecisions.thirdparty.com.ooc.OB.DispatchRequest_impl.invoke
(DispatchRequest_impl.java:122)
at
com.businessobjects.framework.servers.platform.adapters.ebus.orb.ThreadPo
olDispatchStrategy$Dispatcher.run(ThreadPoolDispatchStrategy.java:271)
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 java.util.concurrent.ThreadPoolExecutor$Worker.runTask
(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run
(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:763)

Our environemnet is:

SAP Design Studio 1.6 SP 1 Patch 2
SAP Netweaver BW 7.31 SP14 with BI JAVA Version 7.31 SP15 Patch 20

Due to load distribution we are using three application servers for our BW system (Java stack)

SAP BO BI Platform 4.1 SP6 with newest DS Add On 1.6 SP 1 Patch 2.

Any ideas?

Best regards

Sebastian

[Former Member]

/Hi Robert,

in our case it's the same reason.

Extract from our SAP incident 218449/2016 (SAP development team Design Studio):

Status : We have possible fix for the issue from the Design Studio end

- this needs to be verified by QA and then would be released in the

next SP which would be SP3 if QA confirms the fix.

There maybe be an option to have a patch on SP2 with changes for this

issue - I am following up with managers here to see if that is a

possibility and will let you know.

Best regards,

Sebastian

[robert_roedel]

Hi Sebastian,

thanks for sharing this information. Great to hear that this bug will hopefully be fixed soon.

I will add this information to my SAP incident to link both incidents.

Best regards,

Robert

[robert_roedel]

Hi Sebastian,

I really thought that "would be released in the next SP" means that the bugfix will be released in the next support package which was released yesterday. Now I found out that the one from yesterday was SP2 and didn't include the bugfix. That's why I was asking SAP support today if it's possible to get this bugfix earlier. It could possibly be released with patch 1 for SP2 or maybe even earlier. I should reply to your incident aswell which isn't possible I guess. And the developer assigned to your incident will also be informed about the request of getting this bugfix earlier. Could you please have a look at your incident if there are any status changes.

Best regards,

Robert

[Former Member]

Hi Robert,

last status change/SAP information due to my incident[23.05.2016]:

Hi Sebastian,

It has been agreed that the fix will be included for DS 1.6 SP02 Patch

01 assuming testing for the patch verifies fix.

SAP Note 1760372 details the SAP BusinessObjects Design Studio future

release schedule. So when a date becomes available for that patch it

should be detailed in that note.

Regards,

David

Best regards,

Sebastian

[Former Member]

Hi Daniel,

no, unfortunately not. We are in contact with SAP for two weeks -> no solution so far.

Could you tell me more about your problems?

Which Design Studio version/BW system/BIP version you are using -> implemented SSO?

Regards

Sebastian

[robert_roedel]

Hi Sebastian,

we are facing the same or a similar problem. I also get "JCO_ERROR_DESTINATION_DATA_INVALID" errors, IndexOutOfBoundsException and "Invalid program status" errors. I found out that this happens in our application if two users with different language settings in the BI platform try to access the same pages/reports of the application.

With the following test scenario I can reproduce the error:

1. User A with language German executes the application. Some filters to datasources and query variables are set for him dynamically.

2. While user A remains in the application user B with language English executes the application. Some filters to datasources and query variables are set for him dynamically.

3. User A now tries to set a filter to da datasource or a query variable (for example by selecting a new value from a dropdown box). This results in an "Invalid program status" error or a "JCO_ERROR_DESTINATION_DATA_INVALID" error.

4. If both users are using the same language settings this error doesn't occur.

You get the same error in method ProviderSelectionObject.synchronizeStateVariables:

com.sap.ip.bi.bics.exceptions.BicsProgrammErrorException: Invalid program status

at

com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.ProviderSelectionObject.synchronizeStateVariables

So maybe it's the same reason as in my case. Are you able to test this?

I tested this on BIP 4.1 and BIP 4.2 and got the same results.

I have also created an SAP incident for this and I'm currently waiting for a response from SAP.

Best regards,

Robert

[ddbr]

Hi Sebastian

Did you found any solutions to this issue? We are facing similar problems. With Design Studio and BICS

Thanks for your feedback

Daniel

[Former Member]

Hi Sebastian,

the issue appears to occur when the system is under heavier load.
See the following link:

Regards,
Amine.