ODS ClassNotFound Exception

[Former Member]

Hi,

Our ODS transfer has stopped working and the error is quite strange.

It complains about ClassNotFound Exception for an Oracle Class, but we are running SQL Server.

The ODS Transfer was working for ODSNonConformanceETL and ODSProductionETL.
We had an out-of-memory problem with ODSGenealogy and when I was running it manually to catch up
I got error and closed it by closing the Command Line window.

After this all our ODS Transfer are getting this error:

Wed Aug 10 08:10:18 CEST 2016 ODSNCDataExtract: Started Wed Aug 10 08:10:19 CEST 2016 ODSNCDataExtract: Exception Occurred. java.lang.RuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource at com.sap.me.ods.database.OracleDataSourceFactory.getDataSource(OracleDataSourceFactory.java:18) at com.sap.me.ods.olap.ODSBase.getODSDataSource(ODSBase.java:351) at com.sap.me.ods.olap.ODSBase.init(ODSBase.java:232) at com.sap.me.ods.olap.ODSBase.(ODSBase.java:181) at com.sap.me.ods.olap.ODSNCDataRollupProcess.(ODSNCDataRollupProcess.java:60) at com.sap.me.ods.ODSNCDataExtract.main(ODSNCDataExtract.java:36) Caused by: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource at java.net.URLClassLoader$1.run(URLClassLoader.java:255) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:243) at java.lang.ClassLoader.loadClass(ClassLoader.java:372) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:344) at java.lang.ClassLoader.loadClass(ClassLoader.java:313) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:171) at com.sap.me.ods.database.OracleDataSourceFactory.getDataSource(OracleDataSourceFactory.java:16) ... 5 more

I don't understand why it is complaining about Oracle when we have SQL Server

[Former Member · Accepted solution]

Hi,

I found the issue myself. It was an issue that the clientEnvironment.bat file

had a missing "=" character when setting JAVA_OPTIONS so that the options
were not set correctly.

Best regards,

Johan