FDMEE Connection to JDEdwards Fails When JDEdwards is on SQL Server Database (Doc ID 1579525.1)

Last updated on MAY 20, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.000 and later
Information in this document applies to any platform.
***may 2016***

Symptoms

 When trying to test the connection to JDEdwards with the OracleDIAgent, after going through all of the steps in the FDMEE admin guide, getting the following message:

 

oracle.odi.runtime.agent.invocation.InvocationException: java.lang.IllegalArgumentException: Could not load JDBC driver class [com.jdedwards.jdbc.driver.JDBCDriver]

            at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:265)

            at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:780)

            at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:584)

            at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.access$10(SnpsDialogTestConnet.java:581)

           at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:558)

            at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$5.doInBackground(SnpsDialogTestConnet.java:1)

            at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

            at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)

            at java.lang.Thread.run(Thread.java:662)

 

Also, seeing this error in the JDEdwards Agent log:

 

[SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System - 900. java.sql.SQLException: No suitable driver found for jdbc:sqlserver://SERVERNAME:1433

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms