Skip to Content
4

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

Oct 27, 2017 at 02:36 PM

350

avatar image
Former Member

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... :)

12-olap-sso.png (50.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ralf Berhorst Nov 07, 2017 at 10:43 AM
0

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=9ee8a72025b6525c3edccbb7f0d7f173

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


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ralf,

Thank you so far for your answer.

Q1 : does the function you try worked before you update to the current version ?

A1: Yes, SSO worked before the update in patch 3. We were on BI 4.2 SP4 (without patch), everything worked fine (SSO, OLAP, etc). And 2 months after, we applied patch 3 and SSO doesn't work anymore. :(

I check the password associated.. and all of the article that you sent me..

0
Ralf Berhorst Nov 10, 2017 at 08:50 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ralf,

Thank you, I'll try this ! :)

0