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

[AndreGrift]

Hello,

[AndreGrift]

Hello,

[AndreGrift]

We are also facing the similar issue with 'MS SQL Server 2014' , exactly same error stack trace. Can we get some guidance

[AndreGrift]

Hello , 

I am using MS SQL Server 2014.

Getting exception with exactly same stack trace.

Can you please share the solution if it's fixed for you.

Thanks !!