topic Re: Connection failure. You must check the SAP settings in Talend Studio

Connection failure. You must check the SAP settings

gouravd_7 — Thu, 15 Nov 2018 07:08:07 GMT

Hi Team,

We have been trying since long but we are not able to connect to SAP from our Talend server.

Attached is the screenshot of the error.

Request you to please help us in this scenario. Thanks much in advance.

Re: Connection failure. You must check the SAP settings

manodwhb — Thu, 15 Nov 2018 07:40:06 GMT

@gouravd_7,from the machine where the Talend server is there,are you able to connect to SAP server by using ping command? also make sure that the credentials are correct.

Re: Connection failure. You must check the SAP settings

gouravd_7 — Thu, 15 Nov 2018 07:45:02 GMT

Hi Manohar,

Yes, I am able to connect it from the same machine. Even the same credentials are working in SSIS too.

Somehow , I have added the required sapjco3 jar files still it throwing the same error to me everytime.

Thanks & Regards,

Gourav Dubey

Re: Connection failure. You must check the SAP settings

manodwhb — Thu, 15 Nov 2018 07:53:59 GMT

@gouravd_7,have you installed sap-api-x.x.x.jar and sap-impl-x.x.x.jar? which version of Talend are you using?

Re: Connection failure. You must check the SAP settings

gouravd_7 — Thu, 15 Nov 2018 08:14:12 GMT

Hi ,

I am using Talend 6.5 and have installed sapjco3 and ngdbc jar which was required for the same.

Thanks,

Gourav

Re: Connection failure. You must check the SAP settings

manodwhb — Thu, 15 Nov 2018 11:46:40 GMT

@gouravd_7,can you re-start your spoon an d try?

Re: Connection failure. You must check the SAP settings

gouravd_7 — Thu, 15 Nov 2018 14:34:38 GMT

Hi Manohar,

I did restarted my machine and talend after importing the jars but still no luck on the issue.

Thanks,

Gourav

Re: Connection failure. You must check the SAP settings

gouravd_7 — Fri, 16 Nov 2018 14:21:34 GMT

Hi Team,

Everytime, I try to connect to SAP am getting below error

Connection failure. You must change the SAP Settings.
java.lang.NoClassDefFoundError: com/sap/conn/jco/ext/DestinationDataProvider
at org.talend.repository.sap.SAPClientManager.init(SAPClientManager.java:121)
at org.talend.repository.sap.ui.wizards.SAPConnectionForm$10.run(SAPConnectionForm.java:374)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
Caused by: java.lang.ClassNotFoundException: com.sap.conn.jco.ext.DestinationDataProvider cannot be found by org.talend.libraries.sap_6.5.1.20180116_1512
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 3 more

I am using Talend 6.5 and have installed Sapjco, saprfc and their respectives DL's as well.

I am attaching the screenshot of the error .

The credentials which I am using is working fine in SSIS but connecting through Talend is seems to be challenging now. Whole development is too affected because of this issue.

Requesting someone from the team to please help me in this scenario.

Thanks much in advance.

Thanks & Regards,

Gourav Dubey

saperror.JPG

Re: Connection failure. You must check the SAP settings

gouravd_7 — Tue, 20 Nov 2018 09:03:50 GMT

Hi Team,

Please help as the issue still persists.

Thanks,

Gourav

Re: Connection failure. You must check the SAP settings

Anonymous — Tue, 04 Jun 2019 13:52:02 GMT

Hello Everyone,

Anyone able to resolve this issue. Thanks

Re: Connection failure. You must check the SAP settings

Anonymous — Tue, 04 Jun 2019 13:52:45 GMT

Hi,
Is the issue resolved for you ? If yes, could you share the results

Re: Connection failure. You must check the SAP settings

gouravd_7 — Tue, 04 Jun 2019 14:29:02 GMT

Yes the issue is resolved try to check all the jars it should not be the old jars all the jar files should be of same version. All the versions should be compatible and it should be of same version of java which is compatible to your version of Talend.

Do let me know if this resolves your issue.

Thanks,

Gourav

Re: Connection failure. You must check the SAP settings

gouravd_7 — Tue, 04 Jun 2019 16:21:38 GMT

Do check the sapjco3 and sapjco jar versions that is where my issue got resolved. Just in case you still facing the issue drop your error here and I will try to fix it.

Thanks,

Gourav