Skip to Content

HANA Studio Smart Data Access Error [403]

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 14, 2017 at 09:19 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • May 05, 2017 at 06:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2017 at 07:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded