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?