AnsweredAssumed Answered

Sync service occasionally fails with error ORA-01012: not logged on

Question asked by fimpe001 on Jun 2, 2015
Latest reply on Jun 9, 2015 by mukesh2803

I'm occasionally seeing the ArcGIS Collector error "An error occured while synchronizing edits." with these messages showing up in the ArcGIS Server logs:

The StandaloneTable:'tablename here' in Map:'Layers' is invalid. The base table definition string "tableowner.tablename" is invalid. Underlying DBMS error [ORA-01012: not logged on Process ID: 26520

Session ID: 912 Serial number: 22779 ] [SDE.DEFAULT].

System/SyncTools.GPServer

 

Has anyone successfully tweaked oracle database, sync or feature service parameters successfully to avoid these errors?

Outcomes