topic Re: Metadata connection to SAS in Talend Studio

Metadata connection to SAS

mstyers — Thu, 28 Mar 2019 19:55:17 GMT

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

Re: Metadata connection to SAS

Anonymous — Tue, 02 Apr 2019 06:51:43 GMT

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

Re: Metadata connection to SAS

mstyers — Tue, 02 Apr 2019 12:27:42 GMT

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.

Re: Metadata connection to SAS

Anonymous — Wed, 03 Apr 2019 08:55:47 GMT

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

Re: Metadata connection to SAS

mstyers — Wed, 03 Apr 2019 14:53:07 GMT

Restarted, rebooted and restarted. We are on version 6.1

Re: Metadata connection to SAS

Anonymous — Thu, 04 Apr 2019 10:47:46 GMT

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