Select to view content in your preferred language

Post Updates Failed - how to save data that was captured

2885
20
05-13-2011 05:52 AM
DavidCarpenter
Frequent Contributor
We have had two field crews whose "Post Updates" has failed.  The project only has one editable feature class / service.  I have tried to pull the project file off the problem laptops and use my own ArcGIS Mobile install to try and post their data with the same result.  So what I am left with is around 100 edits that I need to get into SDE....

Is there a suggested method to try and recover the data?

Thanks

Windows XP
ArcGIS Mobile 10 build 2500  (hotfix applied to solve exessive time to sync data)
0 Kudos
20 Replies
PeterTimmers
Frequent Contributor
Interestingly I had a similar Post Updates failure.  Like yours there were a large number of updates (90 in our case).  In our case (and I didn't know about the tool above) it looks like the points still went through.

I blamed it on the fact we had a raster field with a photo in each...

Maybe it's timing out?
0 Kudos
PaulSchneider
Regular Contributor
Denise - Two things:

1)  Maybe put the instructions out as a readme in the source files... this is beneficial for those of us who can't get it to open

2)  Any ideas as to why this won't open?  on Windows 7 (64-bit)?  ArcGIS Mobile 10 and ArcGIS Desktop installed.  Attachment...


The instructions were under the applications "Help" dropdown.  So I get the "no license available" error which I click ok to dismiss, then the application opens.  If I click help it provides install info and how to use the tool which I have attached as a txt file.


Thank you David for posting that additional information.

Denise
0 Kudos
DavidCarpenter
Frequent Contributor
Like I mentioned the reason I couldn't get the mobilecache2shape app to work was because I was using an ArcEditor but it was looking specifically for an ArcView. 

ESRI Canada tweaked the mobilecache2shape code so it looks for an ArcView, then Editor, then Info and starts without issue no matter what desktop "license" you are using. 

I have the recompiled app, if you email me (my email is my user name) I can send it to you.  I am reluctant to just post it here; the ideal solution is for ESRI to update their application to do the same and make that available for download by everyone.  Denise, I can pass the app along to you as well if you want?

In terms of the Post Updates failing due to timeout I am not sure that is the case.  Because it only posts the changes our average 20 - 50 updates out of 800,000 point features is taking maybe a minute or two to Post depending on connection speed.  That said we are using a hotfix from ESRI that solved an issue we ran into on the Trimble Juno with build 2475 where the post of one attribute change out of 800,000 features took 40min.  A laptop with XP was always faster but with the hotfix applied both laptop and Juno now take seconds to just a few minutes to Post updates.....
0 Kudos
AnthonyFarndon
Frequent Contributor
Like I mentioned the reason I couldn't get the mobilecache2shape app to work was because I was using an ArcEditor but it was looking specifically for an ArcView. 

Sorry I missed that part. We have arcview concurrent as well, so will just flip to one of those for now.
0 Kudos
PaulSchneider
Regular Contributor
Thanks everybody-

Other followers of this thread: I tried this on a 32-bit XP machine and was able open and get pleasing results.
0 Kudos
DavidCarpenter
Frequent Contributor
Just an update to keep this going.  While I am not yet 100% sure this is the cause I have a suspect.  In alot of the cases where Post Updates failed, using the mobilecache2shape tool to extract the modified records has allowed me to notice what seems to be a consistent issue.

I have 8 fields in the feature class to capture numeric test results, the fields are all identical, all are Float with a scale of 3 and a precision of 6 (ex. 123.456).  This was based on looking at historic data that was captured previously on paper and then reentered into a non-spatial table.  As it turns out, readings can sometimes reach 1000, 1200, etc.  What I am seeing is the Posts that fail always have one or two instances of 1000 or 1200, etc in them.  Until corrected to say 999.999 I can't even (obviously) load them from shape to the parent SDE FC.

Since noticing this we have educated the users to use 999.999 for readings over that level and the number of failed Posts has dropped to almost nothing.  For the two that still occured in the last two weeks, while the user was adament that they were using 999.999 I was able to find one or two higher readings.  Lucky for us for any reading that high doesn't really need to be captured as is and can be substituted with 999.999.

If this is the cause I am curious as to how the form in Mobile actually accepts a number with a scale of 4 when the field in the geodatabase is set to 3?  Mobile so far has done a great job of honoring what is set up on the desktop, so this anomoly doesn't make sense yet seems to be the cause of our issue.
0 Kudos
DavidCarpenter
Frequent Contributor
So this is the problem.  I spoke with the user this morning, he remembered entering two readings with 4 digits.  I got him to view edits in Mobile and change them to 3 digits after which he was able to Post without issue.  Since I have this issue open with ESRI Canada Support we will begin the process of reporting this as a bug.  I assume they will need to do some independant testing before making that report however in my case this is the issue causing failed Posts.
0 Kudos
DavidCarpenter
Frequent Contributor
Final update ..... the issue I was having has been logged as a bug with ESRI by ESRI Canada Support. 

NIM070087 - Mobile allows you to enter values that do not meet the DBMS field definitions, resulting in mobile edits that cannot be synchronized.
0 Kudos
JavadSalimi
Occasional Contributor
I am getting the same error message as you. I'm also running on a 64 bit machine (Vista Enterprise, SP 2). Did you ever get passed that message? If so, how? Thanks in advance.


Denise - Two things:

1)  Maybe put the instructions out as a readme in the source files... this is beneficial for those of us who can't get it to open

2)  Any ideas as to why this won't open?  on Windows 7 (64-bit)?  ArcGIS Mobile 10 and ArcGIS Desktop installed.  Attachment...
0 Kudos
TravisSmith1
Occasional Contributor
I am getting the same error message as you. I'm also running on a 64 bit machine (Vista Enterprise, SP 2). Did you ever get passed that message? If so, how? Thanks in advance.


I'm getting the same error. The program just crashes. I'm also running Windows 7 64 bit. I desparately need this tool to work! Has anyone found a way to get this to work on Windows 7 64-bit? Is there any other way to recover edits made if you can't upload the cache map? Frustrating.
0 Kudos