Data Services error while executing batch job to HANA

[former_member199283]

Hi All,

We have DS installed on Linux, DS designer is on local windows machine. We have installed required HDBODBC driver on windows machine. Now when we try to create a simple flow (source table and template table to HANA DB), we are receiving the following error

31250	2260449056	JOB	4/11/2014 2:52:28 AM	The initial environment locale <eng_us.utf-8> has been coerced to <Unicode (UTF-16)> ().
31250	2260449056	JOB	4/11/2014 2:52:28 AM	Reading job <6edace34_60cc_4ed5_9dd4_1d8cddf0c5fc> from the repository; Server version is <14.2.1.224>; Repository version is <14.2.1.0000>.
31250	2260449056	JOB	4/11/2014 2:52:28 AM
31250	2260449056	JOB	4/11/2014 2:52:28 AM	Current directory of job <6edace34_60cc_4ed5_9dd4_1d8cddf0c5fc> is </opt/sap/dataservices/bin>.
31250	2260449056	JOB	4/11/2014 2:52:28 AM
31250	2260449056	JOB	4/11/2014 2:52:29 AM	Job <DF_001> of runid <20140411025228312502260449056> is initiated by user <oraods>.
31250	2260449056	JOB	4/11/2014 2:52:29 AM	Processing job <DF_001>.
31250	2260449056	DB_LIB	4/11/2014 2:52:29 AM	Load odbc driver library </usr/sap/hdbclient/libodbcHDB.so>.
31250	2260449056	DB_LIB	4/11/2014 2:52:29 AM	Load odbc driver library </usr/sap/hdbclient/libodbcHDB.so>.
31250	2260449056	DB_LIB	4/11/2014 2:52:29 AM	Load odbc driver library </usr/sap/hdbclient/libodbcHDB.so>.

Please provide thought how do we solve this error.

[AtulKumarJain · Accepted solution]

Dear Sohil,

As per above log there is no error ,it is just information/trace.

Could you please paste teh screen shot for same.

BR

Atul

[former_member199283 · Accepted solution]

Thanks Atul for the reply. Here is the error:

13779	455309088	CON-120103	4/10/2014 4:23:52 PM	|Data flow DF2
13779	455309088	CON-120103	4/10/2014 4:23:52 PM	System call <LoadLibrary> to load and initialize functions failed for </usr/sap/hdbclient/libodbcHDB.so>. Please make sure the
13779	455309088	CON-120103	4/10/2014 4:23:52 PM	shared library is installed and located correctly.

[lohitkumar_ap · Accepted solution]

Hi Sohil,

Data services server cannot find HANA client.

Have you installed a 64 bit HANA client on Data services server?

If yes, also try mantaining the location of client installation in Environment Variable "PATH"

Best regards,

Lohit

[former_member199283 · Accepted solution]

Thanks Lohit.

Well, we have already installed the required HANA client on DS server. Now we are facing the following error. Any suggestions?

31451	2749794080	CON-120302	4/11/2014 3:07:09 PM	|Data flow DF1
31451	2749794080	CON-120302	4/11/2014 3:07:09 PM	ODBC call <SQLDriverConnect> for data source <HDBODBC> failed: <[SAP AG][LIBODBCHDB SO][HDBODBC] Communication link
31451	2749794080	CON-120302	4/11/2014 3:07:09 PM	failure;-10709 Connect failed (no reachable host left)>. Notify Customer Support.

[Former Member · Accepted solution]

the error message through from HANA ODBC driver, "no reachable host left" means data services not able to reach HANA server, you may need to check 1) full qualified hostname for hana server 2) HANA server port 3) server running on IPv4.

Hope it help,

Jack

[former_member199283 · Accepted solution]

Thanks Jack.

Our DS is running on Linux so point # 3 may not be applicable? We did give the IP for point 1) and 2) provided the server port.

Do you have any other suggestion?

[former_member205400 · Accepted solution]

Sohil,

This is really a question for the BODS discussion forum.

When you are using Designer and creating a dataflow you can access the HANA content using a DataStore with a configured odbc driver on your client, e.g. we called ours "HANA_DI3". I assume you can see the table, columns, rows, etc. in Designer.

When you "run" this job then it gets run "on the server" and you have to configure that same odbc connection on the linux server. Use DSConnectionManager.sh for that purpose. Remember that the name of the odbc connection onthe server and on your client should be the same, e.g. "HANA_DI3".

Mike

[former_member199283 · Accepted solution]

Thanks Michael for the reply.

Yes, we have already configured the ODBC the same way you have described. We are connecting TeraData (13.10) to HANA through DS. So we now we receive the different error as follows. Here DevTera is the DSN for TeraData.

Any suggestion? Do we require to install TeraData 13.10 client (which in turn will configure ODBC for TeraData) as well on DS server?

17219	703575840	CON-120302	4/15/2014 11:02:56 PM	|Data flow DF_001
17219	703575840	CON-120302	4/15/2014 11:02:56 PM	ODBC call <SQLDriverConnect> for data source <DevTera> failed: <[DataDirect][ODBC lib] Data source name not found and no
17219	703575840	CON-120302	4/15/2014 11:02:56 PM	default driver specified>. Notify Customer Support.

[former_member205400 · Accepted solution]

Sohil, The source and the target has to be configured onthe server for each datastore in the dataflow. Mike

[former_member781746 · Accepted solution]

nice information on the top of this topic.

Thanks 🙂

[subbuchennuru · Accepted solution]

Vinosh is right. Good information. Thanks all.