1893514 - MobiLink server reports a 10075 warning: "Unable to access ORACLE table 'gv$transaction'. Access is needed to ensure no data is missed if using timestamp-based downloads"

Symptom

The MobiLink server could report the following -10002 errors and 10075 warning while connected to an Oracle database:

I. 2010-12-04 21:17:54. <Main> Translated SQL: SELECT COUNT(*) FROM GV$TRANSACTION
E. 2010-12-04 21:17:54. <Main> [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-00942: table or view does not exist (ODBC State = 42S02, Native error code = 942)
W. 2010-12-04 21:19:11. <Main> [10075] Unable to access ORACLE table 'gv$transaction'. Access is needed to ensure no data is missed if using timestamp-based downloads

I. 2010-12-07 08:53:01. <7> Translated SQL: SELECT SID,SERIAL# FROM V$SESSION WHERE AUDSID = (SELECT USERENV ('SESSIONID') FROM DUAL)
E. 2010-12-07 08:53:01. <7> [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-00942: table or view does not exist (ODBC State = 42S02, Native error code = 942)

Environment

SAP SQL Anywhere (all supported versions, all supported platforms)

Product

SAP SQL Anywhere all versions

Keywords

ML, Sybase , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.