Last year we had trouble synchronising collector app data which was registered offline on the Samsung tablet to our ArcGIS 10.2 Oracle spatial database (spatial format SDO_Geometry). A call was made. Later that year a new release of the Collector app was presented (10.3.1) in which the synchronisation issue was (supposed to be) solved. We tried again but have to conclude that the synchronisation process from time to time still "hangs", and after that it is impossible to continue or restart the synchronisation process on that device. Also recovering the data is very complex. We found in the ArcGIS Server log: db_archive_update_lock_row: OCI Execute/Fetch Error (29902)
We did not find any info about the Oracle error ORA-29902 which we could relate to our problem either:
29902, 00000, "error in executing
// *Cause: The execution of
ODCIIndexStart routine caused an error.
// *Action: Examine the error messages
produced by the indextype code and
take appropriate action.
We would like to implement the offline functionality for production purposes as soon as possible.
We hope that someone can give us a thread to a solution.