Error during Job execution

[Former Member]

Hello community,

We are executing a Job through data services designer. This jobs connects to a remote MySQL database and the error bellow appears in the logs:

CON-120103 7/28/2014 10:30:05 AM System call <LoadLibrary> to load and initialize functions failed for </usr/local/lib/libmyodbc3.so>. Ensure the shared library

We configured the data connection as mentioned in the Administrators Guide. Probably the issue is because the library libmyodbc3.so really doesn´t exist (I checked in the OS (Red Hat Enterprise Linux Server release 5.5 (Tikanga)).

I´m not a Linux expert so I don´t know how to add this library. The package mysql-connector-odbc.x86_64 5.1.5r1144-7.el6 @rhel-x86_64-server-6 is already installed.

Someone knows how to add this librarie? Or then how should I proceed to solve the issue?

Thanks in advance,

Pedro

[Former Member · Accepted solution]

Hi,

Not sure, but i think the issue is with the driver version mismatch. What version are you using? Your mysql connector is version 5 and libodbc is using version 3.

Arun

[Former Member · Accepted solution]

Hello Arun,

You´re probably right. I removed the packages bellow:

Removing:

unixODBC                                 x86_64                     2.2.14-12.el6_3                         @rhel-x86_64-server-6                     1.1 M

Removing for dependencies:

mysql-connector-odbc                     x86_64                     5.1.5r1144-7.el6                        @rhel-x86_64-server-6                     345 k

unixODBC-devel                           x86_64                     2.2.14-12.el6_3                         @rhel-x86_64-server-6                     182 k

And installed the packages bellow:

mysql-connector-odbc-3.51.30-1.rhel5.x86_64.rpm

unixODBC-2.2.12-93.3.x86_64.rpm

Now the error changed:

24671

1013921568

CON-120302

7/28/2014 2:57:37 PM

ODBC call <SQLConnect> for data source <db_Site_Pedidos> failed: <[MySQL][ODBC 3.51 Driver]Can't connect to local MySQL server

Probably now I should configure some file to point to the remote MySQL database. I´m searching for this configuration in the Administrator Guide, please let me know if you know something about.

Thanks,

Pedro

[Former Member]

Hello Arun,

Problem solved. I edited the file:

/usr/sap/SID/dataservices/DataDirect/odbc/odbc.ini

Edited with the database details (hostname, port, user, password) and now it´s working fine.

Thanks for your help!

Regards,

Pedro

[Former Member]

Hi Pedro,

Glad to know that.

Arun