topic 10.2.2 Server SQL2008R2 and Archiving Issues in ArcGIS Collector Questions

10.2.2 Server SQL2008R2 and Archiving Issues

PeterTimmers — Fri, 09 May 2014 02:38:16 GMT

Hi All,

Is anyone else having trouble with archiving for offline?

I'm getting the following...

"Incorrect syntax near ')' ???

Error executing tool.: ErrorMsg@SyncGPService:{"code":500,"description":"Failed to synchronize."} Failed to execute (Sync Feature Service Replica).

Error: Failed to export data changes to replica.

Failed in acquiring Archive Difference Cursor for Dataset: GISPDB.GISADMIN.MOB_AGM_Recon for Replica: GISADMIN.Ags_Fs_1399593325880 [GUID: F2ABEC6D-BFDC-4D5F-A288-18BBAA050414]. Time taken: 0.022000 seconds. Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.] [GISPDB.GISADMIN.MOB_AGM_Recon]

Re: 10.2.2 Server SQL2008R2 and Archiving Issues

RussRoberts — Fri, 09 May 2014 15:16:07 GMT

I haven't seen that error before and have passed it along to the Service team. If possible it would be good to maybe log a support incident and see if this issue can be looked into further.

Russ

Re: 10.2.2 Server SQL2008R2 and Archiving Issues

PeterTimmers — Sun, 11 May 2014 22:57:31 GMT

Can I confirm whether you need SDE 10.2? Will SDE 10.1 work? Because maybe that's my issue.

Re: 10.2.2 Server SQL2008R2 and Archiving Issues

RussRoberts — Mon, 12 May 2014 17:24:29 GMT

Yup if you are using an ArcGIS Server 10.2.2 it is recommended that the underlying SDE be running 10.2.2 as well. If you are using a 10.1 SDE it will be using versioned archiving and that will only support sync download.

Russ

Re: 10.2.2 Server SQL2008R2 and Archiving Issues

PeterTimmers — Mon, 12 May 2014 22:14:54 GMT

Yes, thanks Russ. It does say that in the doco below but I had to read 4 or 5 times because of the link with versioning.

At first I thought you had to have versioning and 10.1 was OK for editing but it's really the opposite. Versioning is only OK for non-editable data.

http://resources.arcgis.com/en/help/main/10.2/index.html#//0154000006m1000000

Now I've just got to upgrade production SDE 😕

Re: 10.2.2 Server SQL2008R2 and Archiving Issues

PeterTimmers — Thu, 15 May 2014 04:13:45 GMT

Found the problem.

You can't use SQL Geography Types for offline Collector (Haven't tried SQL Geometry but I wouldn't be surprised if it doesn't also work).

Create whole new DB with SDE10.2.2 to find the same error. Created a new feature class with same fields and SDE binary and it works.

We use SQL Geography on triggers to do intersections with other featureclasses to fill fields post collection.

Now we have no shortage of SDE 10.2.2s... 😕