Unable to expand/save a Denodo datasource in TIBCO Spotfire Information Designer with "NoClassDefFoundError".

Unable to expand/save a Denodo datasource in TIBCO Spotfire Information Designer with "NoClassDefFoundError".

Expanding/Saving a Denodo datasource in TIBCO Spotfire Information Designer may fail with the following warning message in server.log

----------------------------------------
 WARN 2020-05-05T16:01:33,900-0600 [xxxxxxxxx, #8, #117] cxf.phase.PhaseInterceptorChain: Application {http://www.springframework.org/schema/beans}ElementManagerService#{http://spotfire.tibco.com/ws/2008/11/im.xsd}updateElement has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: org/apache/commons/lang/StringUtils
-
-
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/lang/StringUtils
    at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.connect(VDBJDBCDriver.java:176) ~[denodo-vdp-jdbcdriver-basic.jar:6.0.3]
-
-    
Caused by: java.lang.ClassNotFoundException: org.apache.commons.lang.StringUtils
    at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1365) ~[catalina.jar:9.0.30]
    at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1188) ~[catalina.jar:9.0.30]
    at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.connect(VDBJDBCDriver.java:176) ~[denodo-vdp-jdbcdriver-basic.jar:6.0.3]
---------------------------------------- This issue may be seen if the Denodo JDBC driver is missing completely or duplicate versions of Denodo JDBC driver are present in Spotfire Server installation folders.

To resolve,  make sure to have only one version of Denodo JDBC driver under tomcat\custom-ext  ( Applicable for TSS 10.3 and higher) or tomcat\lib ( Applicable for 7.11)  folder in Spotfire Server installation. Delete any duplicate versions of it and restart the Spotfire Server Service.

For clustered set up with more than one Spotfire server, follow above steps on all servers in sequence.
 

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration.  It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.