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
ODCIIndexStart() routine"
// *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.
Carel
Carel,
I assume your Enterprise geodatabase 10.2. How about your server? Is your server ArcGIS 10.2.2 or later? Does your configuration meet the requirement at offline data section
Supported data—Collector for ArcGIS | ArcGIS ?
-Miaogeng
Dear Miaogeng,
Geodatabase and ArcGis Server are both 10.2.2
Most of the time synchronization works correctly. But at least in 10% of the cases it hangs.
Carel
Verzonden vanaf Samsung Mobile.
This needs investigation. I suggest contact Esri Support to have a support case logged so you can work with support analysts to troubleshoot the issue.
Hi Miaogeng,
I already made a call (in The Netherlands), but hoped that their might be some user experience on this subject as it seems to be on the interface between ArcGIS and Oracle.
Met vriendelijke groet,
Carel Bodegraven
Van: Miaogeng Zhang
Verzonden: zaterdag 24 oktober 2015 0:40
Aan: Carel Bodegraven
Onderwerp: Re: - synchronizing offline collector data to Oracle DB fails
GeoNet <https://community.esri.com/?et=watches.email.thread>
synchronizing offline collector data to Oracle DB fails
reply from Miaogeng Zhang<https://community.esri.com/people/miaogeng_zhang-esristaff?et=watches.email.thread> in Collector for ArcGIS - View the full discussion<https://community.esri.com/message/562929?et=watches.email.thread#562929>
Carel,
Here is additional comment from my colleague
The error (ORA-29902) is a domain index (SDO) error that executes ODCIIndexStart to kick-off a spatial selection.
Has this sync worked before on the same data? One thing you can try is that the Oracle Spatial index needs to be dropped and recreated. A few posts have mentioned this worked in their case.
-Miaogeng
Hi Miaogeng,
I combined with our DBA to rebuild all indexes and try again. I will let you know the outcome. In addition we will try the same service with an iPad (to eliminate the influence of the device), and try a service with ESRI_Spatial format instead of SDO_Geometry. The latter being suboptimal as we want to be able -in future- to access the dataset with Oracle tooling as well.
Met vriendelijke groet,
Carel Bodegraven
Van: Miaogeng Zhang
Verzonden: maandag 26 oktober 2015 18:38
Aan: Carel Bodegraven
Onderwerp: Re: - synchronizing offline collector data to Oracle DB fails
GeoNet <https://community.esri.com/?et=watches.email.thread>
synchronizing offline collector data to Oracle DB fails
reply from Miaogeng Zhang<https://community.esri.com/people/miaogeng_zhang-esristaff?et=watches.email.thread> in Collector for ArcGIS - View the full discussion<https://community.esri.com/message/563343?et=watches.email.thread#563343>