topic Re: synchronizing offline collector data to Oracle DB fails in ArcGIS Collector Questions

synchronizing offline collector data to Oracle DB fails

CarelBodegraven — Thu, 22 Oct 2015 07:54:35 GMT

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

Re: synchronizing offline collector data to Oracle DB fails

MiaogengZhang — Thu, 22 Oct 2015 17:15:42 GMT

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

Re: synchronizing offline collector data to Oracle DB fails

CarelBodegraven — Thu, 22 Oct 2015 18:07:16 GMT

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.

Re: synchronizing offline collector data to Oracle DB fails

MiaogengZhang — Fri, 23 Oct 2015 22:39:12 GMT

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.

Re: synchronizing offline collector data to Oracle DB fails

CarelBodegraven — Mon, 26 Oct 2015 07:31:00 GMT

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>

Re: synchronizing offline collector data to Oracle DB fails

MiaogengZhang — Mon, 26 Oct 2015 17:37:47 GMT

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

Re: synchronizing offline collector data to Oracle DB fails

CarelBodegraven — Wed, 28 Oct 2015 15:32:20 GMT

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