Not able to query data using SAP adapter in TIBCO Spotfire Advanced Data Services: "Could not initialize class com.compositesw.cdms.ds.sap.table.SAPTableResult". – Revvity Signals

Date Posted: 2017-09-25
Product: TIBCO Spotfire®

Problem:

Not able to query data using SAP adapter in TIBCO Spotfire Advanced Data Services: "Could not initialize class com.compositesw.cdms.ds.sap.table.SAPTableResult".

Solution:

After installing TIBCO Spotfire Advanced Data Services 7.0.2 and installing the SAP JCO driver, you may notice that it works to create data sources towards SAP. Introspecting them and adding resources to the data source works. When you try to query one of these resources for data however, the following error is reported:

com.compositesw.cdms.webapi.WebapiException: Cache for "/shared/Folder/DataSourceName" failed to refresh with reason: Could not initialize class com.compositesw.cdms.ds.sap.table.SAPTableResult
    Cache for "/shared/Folder/DataSourceName" failed to refresh with reason: Could not initialize class com.compositesw.cdms.ds.sap.table.SAPTableResult
    at com.compositesw.server.cache.DefaultCacheManager.waitForCacheToBeLoaded(DefaultCacheManager.java:654)
    at com.compositesw.server.cache.DefaultCacheManager.waitForCacheToBeLoaded(DefaultCacheManager.java:529)
    at com.compositesw.server.cache.DefaultCacheManager.waitForCacheToBeLoaded(DefaultCacheManager.java:526)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    ...
The problem here is that the SAP JCO driver version 3.0.14 (and possibly other versions) does not contain the required class. Solution is to use SAP JCO driver 3.0.11, which has the required class and has been confirmed to work with the SAP adapter in TIBCO Spotfire Advanced Data Services 7.0.2. If needed, contact SAP to get the driver.