Semantic layer SDK: Invalid network layer ODBC

[rguziy]

Hi All,

Problem description:

After migrating to SAP BO 4.3 from SAP BO 4.2 the issue with invalid network layer appears for using “com.sap.sl.sdk.authoring.cms.internal.services.CmsResourceServiceImpl.loadConnection” method of SAP BI Semantic Layer Java SDK API:

The issue appears just for loading ODBC type of connections:

the other types of connection work well with using this method.

Here is the stack trace of the issue:

Notes:

• JVM 32-bit has been used for loading connection information.
• The following issue happens with using JVM 64-bit for all connection types:

An error occurred while getting the list of connection drivers {0}. (SLS 16002)

• From experiments the issue does not appear when we replace 32-bit native libraries in SAP BO client 4.3 SP1 with previous version of 4.2 SP7 in the following folders:

"C:\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\drivers\lib32"

"C:\SAP BusinessObjects Enterprise XI 4.0\win32_x86"

So, it looks the problem is related with native code which is used in new version of Semantic Layer Java SDK API.

Question:

Do you have any ideas how we can resolve this issue in SAP BO 4.3 SP1 client?

--

Thanks, Ruslan

[daniel_paulsen · Accepted solution]

BI 4.3 should be 64bit.
Try changing the Path variable to include the win64_x64 directory instead of the win32_x86 directory. I think this should work with the 64bit jvm.

[rguziy · Accepted solution]

It works.

Thanks Daniel!