Corrupted data in map cache .db file - GlobalID / feature data saved incorrectly

588
0
05-01-2012 10:24 AM
StevenSchuldt
New Contributor
Greetings,

We have a custom developed windows mobile project which is working fine, users have been saving and submitting data throw the service regularly for over a month.  But I believe somehow when a feature was being saved to the cache, it didn't write it correctly.  When the user attempts to post the cache, the error message comes back "Guid should contain 32 digits with 4 dashes...Set failure (ParseFailureKindfailure, String failureMessageID, Object failureMessagerFormatArgument, String failureArgumentNAme, Exception inner Exception) "

I've opened the .db file with  SQL-Lite browser, and I can see the row that I believe is causing the problem.  While all other rows have completely valid data, one rows seems to have saved incorrectly - the GlobalID is {9057C3D9-5220-4E44-9D12-51?????????? and all every other field after that has what look like binary values.  The example below shows a few valid rows from the table and the last one is the invalid one.  What I"d like to do is just delete the offending feature from the mobile cache, however i know I'd have to modify more than one table to completely remove that feature.  I deleted the row from layer0_current_feature, but then I get a different error when I try to transfer.

Has anybody dug into the inner workings of the mobile cache, or would any ESRI folks care to let me know if this happens again how I can delete an invalid row from the mobile cache?

Thanks for any ideas.

-77 1 0 229256665 1 ????I?? 0 {32A124F8-32B6-40FF-9D9E-80C1CCF81268} 042712TLC2 Shovel Test      -96.1400231 36.75092488  4/27/2012 11:43 urscorp 4/27/2012 11:43 urscorp 31 4/27/2012 11:43
-75 1 0 650062530 1 ?C??@<?? 0 {028AC7BF-4567-4F36-BBC2-998C022B5D64} 042712CSB2 Shovel Test      -96.13957125 36.75091072  4/27/2012 11:40 urscorp 4/27/2012 11:40 urscorp 31 4/27/2012 11:40
-73 1 0 1463101579 1 ?????6?? 0 {84DDE0D3-2D8D-4D22-AFE2-77E6DA36A03F} 042712MDA1 Shovel Test      -96.13948947 36.75063283  4/27/2012 11:39 urscorp 4/27/2012 11:39 urscorp 31 4/27/2012 11:39
-71 1 0 982395837 1 7 ??'x?? 0 {E247B599-BC79-4A18-AC68-E96ADC1D15DC} 042712TLC1 Shovel Test      -96.13906772 36.75179097  4/27/2012 11:32 urscorp 4/27/2012 11:32 urscorp 31 4/27/2012 11:32
-69 1 0 1175529696 1 2??  ?? 0 {9057C3D9-5220-4E44-9D12-51?????????? ????q???? ?????l???ww      -1.24E+67 2.75E+91  ????07??????w=:31 w????? ??7v???????????9:?y }r?o?? -1 ?q5?m<?=???{5?>???{
0 Kudos
0 Replies