ESP version for hana_out

[Former Member]

Hi team,

I'm trying connecting ESP to HANA, but it didn't work well.

If you know about hana output adapter, please give me some advices.

The below is my situation.

1) I created test.ccl file. please see the attachment file. (test.ccl.txt) * .txt extension is dummy for uploading.

2) I compiled test.ccl file to test.ccx

3) I started test project by using ccx file, but it failed

4) I checked esp_server.log. I found the error, "OutConnection HANA_Output1 is invalid: No connection with type hana_out for this version of the Sybase Event Stream Processor." Please see the attachment file.(esp_server.log) * .txt extention is dummy for uploading.

5) I checked esp version by using esp utility commands (esp_server, esp_cluster_admin, esp_compiler). The version is 5.1.04.

I have already set up the HANA Client, unixODBC, odbc.ini and service.xml.

And I think there is no problem of ESP version.

HANA version is 7.4(SuSE).

Thank you in advance,

Yusuke

test.ccl.txt.zip

esp_server.ccr.txt.zip

esp_server.log.txt.zip

[former_member217348 · Accepted solution]

Hi Yusuke,

1. Stop the cluster.

2. Check what version of unixODBC you installed - should be 2.3.1 or higher:

$ cd $ESP_HOME

$ odbcinst -j

It will return with the version it is using, e.g.

unixODBC 2.3.2
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /usr/u/nstack/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

3. Then do:

$ whereis libodbc.so.1
It will return with something like this:
libodbc.so: /usr/local/lib/libodbc.so.1 /usr/local/lib/libodbc.so.2
/usr/local/lib/libodbc.so

Then, set your LD_LIBRARY_PATH to include the directory where "libodbc.so.1" is found.

4. What's in your .odbc.ini file? Set the Driver to the path for your libodbcHDB.so

[archer_hana]
Driver=/work/HANA_client/libodbcHDB.so
servernode=archer:30015
USER=SYSTEM
Password=<password>
CHAR_AS_UTF8=true

5. Restart the cluster

Thanks,

Alice

[Former Member · Accepted solution]

Hi Alice,

Thank you for your quick and kind reply!

I read your advice and tried again. Then my test project work well!

The below is my checking point.

2)
[root@xx]# odbcinst -j
unixODBC 2.3.2
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

3)
# whereis libodbc.so.1
libodbc.so: /usr/local/lib/libodbc.so.2 /usr/local/lib/libodbc.so

so I create libodbc.so.1 as symbolic link of libodbc.so.2.0.0

→libodbc.so: /usr/local/lib/libodbc.so.2 /usr/local/lib/libodbc.so /usr/local/lib/libodbc.so.1

# echo $LD_LIBRARY_PATH
/usr/sap/hdbclient:/usr/local/lib:and other path

4) What's in your .odbc.ini file? Set the Driver to the path for your libodbcHDB.so

[HANA_CON]
Driver = /usr/sap/hdbclient/libodbcHDB.so
ServerNode = hanahost:30015

Thank you very match!

The test is very well, but my working ccl has onther error.

"Unable to get the number of columns for target DB table "XXX.XXX""

Now I'm shooting this problem...

Sincerely,

Yusuke