Error while loading local business layer

[Former Member]

Hello,

This is our first attempt at developing with BO SL SDK using Java code.

We have retrieved the universe file locally and are trying to load the same using the following syntax:

.....

RelationalBusinessLayer businessLayer = (RelationalBusinessLayer) lrservice.load(localUniversePath);

.....

This is throwing an exception as shown below:

Exception in thread "main" com.sap.tools.commons.exception.NestedException: Specified RDBMS is invalid : Oracle 11

  at com.sap.tools.commons.exception.NestedException.create(Unknown Source)

  at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:82)

  at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.<init>(DataFoundationSQLDecoder.java:97)

  at com.businessobjects.mds.services.parser.decoder.UniverseSQLDecoder.<init>(UniverseSQLDecoder.java:40)

  at com.businessobjects.mds.services.parser.EncodeDecodeHelper.decodeExpression(EncodeDecodeHelper.java:301)

  at com.businessobjects.mds.services.helpers.BindingHelper.decodeExpression(BindingHelper.java:250)

  at com.businessobjects.mds.services.helpers.BindingHelper.decodeResultExpression(BindingHelper.java:264)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.getResultExpression(MdsToSdkBusinessLayerConverter.java:356)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyBusinessItemProperties(MdsToSdkBusinessLayerConverter.java:311)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkItem(MdsToSdkBusinessLayerConverter.java:260)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:212)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.copyMdsToSdk(MdsToSdkBusinessLayerConverter.java:219)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:151)

  at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)

  at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:191)

  at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:170)

  at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:131)

  at ConnectionPOC.ConnectionClass.main(ConnectionClass.java:46)

Caused by: com.sap.connectivity.cs.core.CSError: Specified RDBMS is invalid : Oracle 11

  at com.sap.connectivity.cs.extended.NLDBProvider.getManager(NLDBProvider.java:223)

  at com.sap.connectivity.cs.extended.Provider.getEnvironment(Provider.java:93)

  at com.sap.connectivity.cs.extended.ConnectionServer.JobProfile(ConnectionServer.java:532)

  at com.sap.connectivity.cs.api.trace.EnvironmentLogger.JobProfile(EnvironmentLogger.java:609)

  at com.businessobjects.mds.services.relational.PrmProperties.getDbParameterSet(PrmProperties.java:1403)

  at com.businessobjects.mds.services.relational.PrmProperties.loadFunctions(PrmProperties.java:1446)

  at com.businessobjects.mds.services.relational.PrmProperties.loadParameters(PrmProperties.java:1420)

  at com.businessobjects.mds.services.relational.PrmProperties.<init>(PrmProperties.java:155)

  at com.businessobjects.mds.services.relational.CsService.getPRMProperties(CsService.java:1194)

  at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:80)

  ... 16 more

Caused by: com.sap.connectivity.cs.core.CSError: Interface requested not found : csOCA

  ... 26 more

Caused by: com.sap.connectivity.cs.core.CSError: Session ID was not specified

  ... 26 more

Have tried to search online and other forums but could not gather much information about the issue.

Could it be that we need local Oracle 11 installation on the machine on which I am coding or we are missing some jar file?

Any suggestion  regarding how to resolve the issue or what is the cause would be immensely appreciated.

Thanks in advance.

-

Aachin Chalana

[DellSC · Accepted solution]

The machine where you are coding will need to have the database client software installed for any of the connections that your universes are using.  I know that the IDT is 32-bit, you you might also have to have the 32-bit version of the db clients instead of the 64-bit version.

-Dell

[Former Member · Accepted solution]

Thanks ! We could make some progress after making the suggested change.

[jalda · Accepted solution]

@dell.stinnett-christy I too got the same issue but couldn't figure this out... below is the trace... Could you please help me with this?
Do I need to configure any ODBC drivers in the machine where I'm coding?

com.sap.tools.commons.exception.NestedException: Specified RDBMS is invalid : MS SQL Server 2017
at com.sap.tools.commons.exception.NestedException.create(Unknown Source)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:82)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.<init>(DataFoundationSQLDecoder.java:97)
at com.businessobjects.mds.services.parser.decoder.UniverseSQLDecoder.<init>(UniverseSQLDecoder.java:40)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.MdsToSdkBusinessLayerConverter.createSdkModel(MdsToSdkBusinessLayerConverter.java:246)
at com.sap.sl.sdk.authoring.businesslayer.internal.services.BusinessLayerModelToModel.createSdkModel(BusinessLayerModelToModel.java:31)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.createSdkBusinessLayer(LocalResourceServiceImpl.java:217)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.loadInternal(LocalResourceServiceImpl.java:196)
at com.sap.sl.sdk.authoring.local.internal.services.LocalResourceServiceImpl.load(LocalResourceServiceImpl.java:129)
at com.ovaledge.universe.Program.main(Program.java:49)
Caused by: com.sap.connectivity.cs.core.CSError: Specified RDBMS is invalid : MS SQL Server 2017
at com.sap.connectivity.cs.extended.NLDBProvider.getManager(NLDBProvider.java:225)
at com.sap.connectivity.cs.extended.Provider.getEnvironment(Provider.java:93)
at com.sap.connectivity.cs.extended.ConnectionServer.JobProfile(ConnectionServer.java:572)
at com.sap.connectivity.cs.api.trace.EnvironmentLogger.JobProfile(EnvironmentLogger.java:613)
at com.businessobjects.mds.services.relational.PrmProperties.getDbParameterSet(PrmProperties.java:1500)
at com.businessobjects.mds.services.relational.PrmProperties.loadFunctions(PrmProperties.java:1543)
at com.businessobjects.mds.services.relational.PrmProperties.loadParameters(PrmProperties.java:1517)
at com.businessobjects.mds.services.relational.PrmProperties.<init>(PrmProperties.java:185)
at com.businessobjects.mds.services.relational.CsService.getPRMProperties(CsService.java:1458)
at com.businessobjects.mds.services.parser.decoder.DataFoundationSQLDecoder.getPRM(DataFoundationSQLDecoder.java:80)
... 8 more
Caused by: com.sap.connectivity.cs.core.CSError: Interface requested not found : csOCA
... 18 more
Caused by: com.sap.connectivity.cs.core.CSError: Session ID was not specified

[DellSC · Accepted solution]

The machine where the IDT is running needs to have 32-bit connections configured, including any ODBC DSNs, in order to work with universes.

-Dell