Metadata connection to SAS

[mstyers]

Trying to connect to SAS using Metadata => Db Connections => New Database Connection

Getting the following error:

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/log4j/Logger
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: org/apache/log4j/Logger
at com.sas.rio.MVADriver.<clinit>(MVADriver.java:69)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:121)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:146)
... 9 more
Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Logger
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 14 more

This error appears to be with a missing class definition for log4j.logger.  I'm not sure how to resolve.  I've added the modules for SAS (attached file SAS_Modules.jpg), and the pluginrg.apache.log4j is installed (log4j.jpg).  What next?

Thanks,

Mike

[Anonymous]

Hello,

So far, Talend doesn't support for log4j2 with existing and custom appenders.

Could you please try to uncheck "activate log4j in components" option in project settings to see if it works?

Best regards

Sabrina

[mstyers]

It was already unchecked.  I have noticed that I get the following warnings when running jobs:

log4j:WARN No appenders could be found for logger (org.apache.cxf.common.logging.LogUtils).
log4j:WARN Please initialize the log4j system properly.

Also, I don't get the log4j error with other metadata DB Connections.  Just the SAS connection.

[Anonymous]

Hello @mstyers 

Did you restart your studio after installing external modules? Could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

[mstyers]

Restarted, rebooted and restarted.  We are on version 6.1

[Anonymous]

Hello,

With your subscription solution, could you please create a case on talend support portal so that we could give you a remote assistance(Webex session) to see if it is a bug on V 6.1 through support cycle with priority.

Best regards

Sabrina