Skip to Content
0
Former Member
Jan 15, 2014 at 01:29 PM

HANA session switches automatically to SYSTEM schema.

981 Views

Hi Developers,

We're facing an issue in which during our work with HANA the session switches to the system database after a period of idie activity against the DBMS.

For example we have the SCHEMA ABC and in it the table XYZ,

We've got the code the query:

"SET SCHEMA ABC"

...

...

After a while we have the query

SELECT * FROM XYZ;

but sometimes we get the error:

[SAP AG][LIBODBCHDB DLL][HDBODBC] Base table or view not found;259 invalid table name: Could not find table/view XYZ in schema SYSTEM

Can you please assist?

Thank you,

Tal.