Home > Archive > SQL Anywhere ultralite > March 2006 > Corrupted database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Corrupted database
Rafael

2006-03-17, 1:23 pm

Hi folks.
Some weeks ago, mobilink log wrote the 'Protocol_Error' after syncing a
client.
After i got the .udb file from this client, i deleted all row from the
folowing tables (CustomStoreQuestDat
a and 'Order') and for my surprise
the CustomStoreQuestData
keep getting 40 rows (before the 'Delete from
CustomStoreQuestData
' it was 12456 rows). There's no way to delete. All
operations going normal (Select, Update).
After some research my opinion is that the .udb is corrupt.
An observation is when i sync with those config (40 rows in
CustomStoreQuestData
and 0 rows in 'Order') i get the
'SQLE_UNCOMMITTED_TR
ANSACTIONS'.
I tried then call rollback in the query analyzer. Right after these
command i tried to sync again and my application crash.

Im sorry about my awful english. If you can you may speach in spanish,
french or portuguese.
Any help is welcome

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com