HANA Studio Smart Data Access Error [403]

[mrwong05]

Full error:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Oracle][ODBC][Ora]ORA-24315: illegal attribute type

background: We had this SDA working from HANA to Oracle, but then this error started to occur.

CAN connect to Oracle Server via isql through HANA server

Configuration files located exactly the same on a separate Oracle server (.odbc.ini & customer.sch & tnsnames.ora)

If we can get some help on this issue, it would be very helpful. Thank you.

[former_member429431]

Hi Matthew,

Can i know what permission was set by you for this

Regards,

Shashank

[mrwong05]

I actually forgot how this was solved. But usually you have to make sure HANA can read your .odbc.ini file from <sid>adm user and that the drivers are all set correctly. make sure your UTF encoding is set correctly in your DSN.

[Former Member]

problem solved, update the permissions of the .odbc.ini, tnsnames.ora, .customer.sh, .customer.sch using chmod or winSCP

[mrwong05]

SO after getting some feedback from SAP, we installed an older Oracle ODBC driver on the HANA server at their request. This worked to re-establish the connection, but now less than one month later, without any changes, the same error appears:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Oracle][ODBC][Ora]ORA-24315: illegal attribute type

[mrwong05]

sorry, the roll back driver version is unixODBC 2.3.2

[mrwong05]

Some possible relevant details

UNIXODBC 2.3.4

Driver = /usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1

Hana version 1.00.097.00.1434028111 (fa/newdb100_maint_rel)