AnsweredAssumed Answered

Open Transactions in Oracle

Question asked by mukesh2803 on Mar 31, 2015
Latest reply on Mar 13, 2018 by gkatsamb

Hello,

We have a feature service published on ArcGIS Server, with offline mode enabled (sync operation) which is edited using mobile device (android). After some time of continuous editing we observed that the syncing is not happening, after 5-6 times of syncing next syncing is not happening. After restarting the services the syncing is working, again for 2-3 times.Checked the arcgis server logs found that there is an error saying "Error: Failure to access the DBMS server [ORA-01012: not logged on Process ID: 3596 Session ID: 340 Serial number: 33 ] "

When checked in Oracle DB we found that there are many open transactions for the ArcSDE user. The transactions opened while applying editing is not been closed. I understand that these transactions should be closed automatically if the edits are successful.

Please let me know how these transactions will auto closed. Is there any settings with ArcGIS Server or Database?

 

ArcGIS Server 10.2.2

Oracle 11.2.0.1

ArcSDE 10.2.2

 

 

Thanks in advance.

Outcomes