KB36474: Error "[JCO] set version before use" appears when connecting to SAP BW system with JCo 2.x connectors in MicroStrategy Intelligence Server 9.x and 10.x

• Strategy

Error "[JCO] set version before use" appears when connecting to SAP BW system with JCo 2.x connectors in MicroStrategy Intelligence Server 9.x and 10.x

SYMPTOM:
Error " set version before use" appears when connecting to SAP BW system with JCo 2.x connector files in Strategy Intelligence Server 9.2.x, as shown in the image below:


Database Classes Error <>: Connect failed. Unable to connect.  Error type: JCO layer error. JCOConnection.connect failed. java.lang.Exception: set version before use. at com.Strategy.Database.JCO.JCOConnection.checkVersion(Unknown Source) at com.Strategy.Database.JCO.JCOConnection.connect(Unknown Source). Connection String: APPSERVER=;SYSNR=03;CLIENT=800;LANG=EN;JCO;UID=;

CAUSE:
In Strategy Intelligence 9.x and 10.x, JCo 3.x is used to connect to SAP BW system by default, which can be configured in Administration > Configuration Managers > Database Instances, by editing the SAP BW Database Instance in Advanced tab, as shown in the image below:

ACTION:
Edit SAP BW Database Instance in Administration > Configuration Managers > Database Instances, click Advance tab, switch to the option "Use JCo 2.x".

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 8, 2017