Skip to Content
0

HANA Studio Smart Data Access Error [403]

Mar 13, 2017 at 03:21 AM

224

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Matthew Wong Mar 14, 2017 at 09:19 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded
Matthew Wong May 05, 2017 at 06:52 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

sorry, the roll back driver version is unixODBC 2.3.2

0
Matthew Wong May 25, 2017 at 07:23 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded