[PROBLEM] OLAP connection with SSO doesn't work af...

Former Member · ‎10-27-2017

Hello,
After updating our SAP BusinessObjects server in BI 4.2 SP4 patch 3
(patch application only) OLAP connections in SSO no longer work with the WebIntelligence application (Web and Rich Client), Information Design Tool but works with the Alanysis for Olap application.

The following error appears: [error.openSapBwBrowsingSessionFailed]

BEFORE update, the server was in BI 4.2 SP4, the application of patch 3 create the error.

CLUSTER technical environment :
Cluster environment, two SERVER1 servers (third processing server) for processing and SERVER2 (third-party management)

BW Version: 7.30 SP12

1513/5000

Here is the set of tests performed:

SAP authentication update: OK
Update roles: OK
Change the OLAP connection to pass it pre-filled: OK
Single connection on the OLAP connection: KO
Repair (repair) of the two servers: KO
Editing connections and checking servers: KO
Modification of servers and associated services: KO
Emptying the server cache and tomcat: KO
Implementation of several SAP Note similar: KO
Changing the language of the connection: KO
Login from Webi Rich Client: KO
Connection from IDT and connection test: KO
Using this same CONNECTION from Analysis For Olap (in WEB mode): OK
Test in JAVA mode: KO
Verification of associated passwords: OK
Creation of a new server associated with the DSL Bridge service: KO

Moreover, for the tests, I forced in a connection, a totally FALSE server name, and the result is exactly the same, it means that the WebIntelligence application does not even go as far as checking the forced information in the connection and connection information.

Here the logs of WIPS and DSL Bridge :

tackTrace: 
*** com.businessobjects.dsl.services.sapbw.SapBwBrowsingServiceImpl.connect(SapBwBrowsingServiceImpl.java:499)

[[error.openSapBwBrowsingSessionFailed] 0] <<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ConnectionString>
   <Properties>
      <Initial Catalog />
      <Language>fr_FR</Language>
      <Data Source>ZBIWEM3</Data Source>
      <Cube Type>Unknown</Cube Type>
      <SaveLanguage>true</SaveLanguage>
      <Initial Cube />
      <TargetProvider>SAPNETWEAVER7X</TargetProvider>
      <MaxParallelQueries>4</MaxParallelQueries>
      <NetworkLayer>SAPBW_BICS</NetworkLayer>
      <Authentication Mode>2</Authentication Mode>
   </Properties>
   <ExtendedProperties>
      <JCO_ASHOST>ZBIWEM3</JCO_ASHOST>
      <SapLoginMode>0</SapLoginMode>
      <JCO_R3NAME>QBI</JCO_R3NAME>
      <ManagedMode>SERVER</ManagedMode>
      <JCO_CLIENT>100</JCO_CLIENT>
      <JCO_SYSNR>00</JCO_SYSNR>
      <JCO_LANG>FR</JCO_LANG>
   </ExtendedProperties>
</ConnectionString>>,<java.lang.IllegalStateException: com.crystaldecisions.sdk.exception.SDKServerException: 

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2

detail:
The server supplied the following details: A java.io.IOException occurred; original exception message Error decoding PKCS 12 input.


*** com.businessobjects.mds.olap.protocol.sap.jco.JCOConnection.connect(JCOConnection.java:378)

java.lang.IllegalStateException: com.crystaldecisions.sdk.exception.SDKServerException: 

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2

detail:
The server supplied the following details: A java.io.IOException occurred; original exception message Error decoding PKCS 12 input.

*** com.businessobjects.mds.olap.protocol.sap.jco.SSOCredentialProvider.handleError(SSOCredentialProvider.java:116)

com.crystaldecisions.sdk.exception.SDKServerException: 

cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:
The server supplied the following details: A java.io.IOException occurred; original exception message Error decoding PKCS 12 input.

*** com.crystaldecisions.sdk.exception.SDKServerException.map(SDKServerException.java:99)

And here, the configuration of my olap connexion :

I tried every SAP Note of the community.... 😞

If someone have an idea... 🙂

Ralf_Berhorst · ‎11-10-2017

Hello,

i solve the issue on my side. I renew the SSO Certificates .

1. Remove the cert*.* and keystore.p12 files

2. remove all OLAP Stuff and SSO Settings (SAP Authentication)

3. follow this sap note

https://launchpad.support.sap.com/#/notes/1670073

4. create the required SAP Authentications again and the OLAP Connection too.

Best regards
Ralf

Ralf_Berhorst · ‎11-07-2017

Hello Enzo,

It looks like I have the same problem. The system is a “DEV-System” and it work with is the same version 4.2 Support Pack 4 Patch 3 (Version: 14.2.4.2545)

I made the update two ago and we had that problem before! Coming from a 4.2 Support Pack 3 Patch 3 (Version: 14.2.3.2277). Therefore I am not really shure that the reason belongs to the new Version.

.

I assume my java client or only the jave settings is different from yours, because I have a “detailed” check box. I post the full error message after klick on details.

com.businessobjects.sdk.core.server.CommunicationException$UnexpectedServerException: [[error.openSapBwBrowsingSessionFailed] 0] <<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ConnectionString>
   <Properties>
      <Initial Catalog />
      <Language>en_US</Language>
      <Data Source>SAP-X99.company.com</Data Source>
      <Cube Type>Unknown</Cube Type>
      <SaveLanguage>true</SaveLanguage>
      <Initial Cube />
      <TargetProvider>SAPNETWEAVER7X</TargetProvider>
      <MaxParallelQueries>4</MaxParallelQueries>
      <NetworkLayer>SAPBW_BICS</NetworkLayer>
      <Authentication Mode>2</Authentication Mode>
   </Properties>
   <ExtendedProperties>
      <JCO_MSHOST>SAP-X99.company.com</JCO_MSHOST>
      <SapLoginMode>1</SapLoginMode>
      <JCO_R3NAME>X99</JCO_R3NAME>
      <JCO_GROUP>X99</JCO_GROUP>
      <ManagedMode>SERVER</ManagedMode>
      <JCO_CLIENT>010</JCO_CLIENT>
      <JCO_LANG>EN</JCO_LANG>
   </ExtendedProperties>
</ConnectionString>>,<java.lang.IllegalStateException: com.crystaldecisions.sdk.exception.SDKServerException: 
cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:
The server supplied the following details: A java.io.IOException occurred; original exception message Error decoding PKCS 12 input.
>
 at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:152)
 at com.businessobjects.sdk.core.exception.ExceptionBuilder.make(ExceptionBuilder.java:109)
 at com.sap.sl.sdk.requests.doit.DoItRequestHandler.afterProcessing(DoItRequestHandler.java:54)
 at com.businessobjects.sdk.core.server.internal.AbstractServer.processIt(AbstractServer.java:201)
 at com.businessobjects.sdk.core.server.internal.AbstractServer.process(AbstractServer.java:160)
 at com.businessobjects.sdk.core.server.internal.InstanceServer.process(InstanceServer.java:101)
 at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processDoIt(SapBwBrowsingServiceImpl.java:249)
 at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processInvocation(SapBwBrowsingServiceImpl.java:207)
 at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.processOpenSecureSession(SapBwBrowsingServiceImpl.java:190)
 at com.sap.sl.sdk.olap.sapbw.service.SapBwBrowsingServiceImpl.openSession(SapBwBrowsingServiceImpl.java:72)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.getSapBrowsingSession(OpenBexPanel.java:1218)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.beginFetchNode(OpenBexPanel.java:911)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.onNodeSelected(OpenBexPanel.java:645)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.valueChanged(OpenBexPanel.java:1129)
 at javax.swing.DefaultListSelectionModel.fireValueChanged(Unknown Source)
 at javax.swing.DefaultListSelectionModel.fireValueChanged(Unknown Source)
 at javax.swing.DefaultListSelectionModel.fireValueChanged(Unknown Source)
 at javax.swing.DefaultListSelectionModel.changeSelection(Unknown Source)
 at javax.swing.DefaultListSelectionModel.changeSelection(Unknown Source)
 at javax.swing.DefaultListSelectionModel.setSelectionInterval(Unknown Source)
 at javax.swing.JTable.changeSelectionModel(Unknown Source)
 at javax.swing.JTable.changeSelection(Unknown Source)
 at com.jidesoft.grid.JideTable.changeSelection(Unknown Source)
 at com.jidesoft.grid.NavigableTable.changeSelection(Unknown Source)
 at com.jidesoft.grid.TreeTable.setSelectedRow(Unknown Source)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.onDetailDblClick(OpenBexPanel.java:832)
 at com.sap.webi.ui.dialog.bex.OpenBexPanel.mouseClicked(OpenBexPanel.java:1163)
 at java.awt.AWTEventMulticaster.mouseClicked(Unknown Source)
 at java.awt.Component.processMouseEvent(Unknown Source)
 at javax.swing.JComponent.processMouseEvent(Unknown Source)
 at java.awt.Component.processEvent(Unknown Source)
 at java.awt.Container.processEvent(Unknown Source)
 at java.awt.Component.dispatchEventImpl(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
 at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
 at java.awt.Container.dispatchEventImpl(Unknown Source)
 at java.awt.Window.dispatchEventImpl(Unknown Source)
 at java.awt.Component.dispatchEvent(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$500(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.awt.EventQueue$4.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.WaitDispatchSupport$2.run(Unknown Source)
 at java.awt.WaitDispatchSupport$4.run(Unknown Source)
 at java.awt.WaitDispatchSupport$4.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.awt.WaitDispatchSupport.enter(Unknown Source)
 at java.awt.Dialog.show(Unknown Source)
 at com.jidesoft.dialog.StandardDialog.show(Unknown Source)
 at java.awt.Component.show(Unknown Source)
 at java.awt.Component.setVisible(Unknown Source)
 at java.awt.Window.setVisible(Unknown Source)
 at java.awt.Dialog.setVisible(Unknown Source)
 at com.sap.webi.toolkit.ui.dialog.GenericDialog.setVisible(GenericDialog.java:128)
 at com.sap.webi.ui.dialog.bex.OpenBexDialog.setVisible(OpenBexDialog.java:109)
 at com.sap.webi.ui.data.BexQueryDataSourceProvider.createDataSourceInfo(BexQueryDataSourceProvider.java:81)
 at com.sap.webi.ui.context.managers.DataManager.createDataSourceInfo(DataManager.java:415)
 at com.sap.webi.ui.tasks.workflows.CreateDataSourceInfoUITask.doneProcess(CreateDataSourceInfoUITask.java:131)
 at com.sap.webi.toolkit.ui.tasks.WebITask$PrivateWorker.done(WebITask.java:378)
 at javax.swing.SwingWorker$5.run(Unknown Source)
 at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
 at sun.swing.AccumulativeRunnable.run(Unknown Source)
 at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
 at javax.swing.Timer.fireActionPerformed(Unknown Source)
 at javax.swing.Timer$DoPostEvent.run(Unknown Source)
 at java.awt.event.InvocationEvent.dispatch(Unknown Source)
 at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
 at java.awt.EventQueue.access$500(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.awt.EventQueue$3.run(Unknown Source)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
 at java.awt.EventQueue.dispatchEvent(Unknown Source)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
 at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.businessobjects.sdk.core.server.ServerException: [[error.openSapBwBrowsingSessionFailed] 0] <<?xml version="1.0" encoding="UTF-8" standalone="yes"?><ConnectionString>
   <Properties>
      <Initial Catalog />
      <Language>en_US</Language>
      <Data Source>SAP-X99.company.com</Data Source>
      <Cube Type>Unknown</Cube Type>
      <SaveLanguage>true</SaveLanguage>
      <Initial Cube />
      <TargetProvider>SAPNETWEAVER7X</TargetProvider>
      <MaxParallelQueries>4</MaxParallelQueries>
      <NetworkLayer>SAPBW_BICS</NetworkLayer>
      <Authentication Mode>2</Authentication Mode>
   </Properties>
   <ExtendedProperties>
      <JCO_MSHOST>SAP-X99.company.com</JCO_MSHOST>
      <SapLoginMode>1</SapLoginMode>
      <JCO_R3NAME>X99</JCO_R3NAME>
      <JCO_GROUP>X99</JCO_GROUP>
      <ManagedMode>SERVER</ManagedMode>
      <JCO_CLIENT>010</JCO_CLIENT>
      <JCO_LANG>EN</JCO_LANG>
   </ExtendedProperties>
</ConnectionString>>,<java.lang.IllegalStateException: com.crystaldecisions.sdk.exception.SDKServerException: 
cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
detail:
The server supplied the following details: A java.io.IOException occurred; original exception message Error decoding PKCS 12 input.
>
 at com.sap.sl.sdk.requests.doit.DoItRequestHandler.afterProcessing(DoItRequestHandler.java:50)
 ... 90 more

I rename some internal information. But i can find the same error line:

“The server
supplied the following details: A java.io.IOException occurred; original
exception message Error decoding PKCS 12 input.”

If found another hint belongs to a tomcate memory setting, but I don´t think that this is the real cause: http://www.forumtopics.com/busobj/viewtopic.php?t=206301&view=next&sid=9ee8a72025b6525c3edccbb7f0d7f...

The "PKCS 12" Point to a certifcation issue belongs to the communication with the backend System.

Another article Point to an old user/Password setting. Did you check that - last post.

https://archive.sap.com/discussions/thread/2027431

.

My question to you, does the function you try worked before you update to the current version?

Best regards

Ralf

[PROBLEM] OLAP connection with SSO doesn't work after update PATCH 3 (BI 4.2 SP4)

Accepted Solutions (0)

Answers (2)

Answers (2)

Re: How to define ajax call in SAP MDK

How to navigate from ALV report output to Outlook ...

Iterating through JSONModel with multiple nested a...

Re: Connecting SAP CAP with SAP Cloud ALM

How to use CopyProvider on Table created by TypeSc...