I am running an Ultralite database - version 11.0.1.2960 with .NET CF 3.5 on a Win 6.5 handheld. Something crashed today while performing normal work (we've been running this software for years) and it looks like we've lost a database. Here are the details when trying to connect to the .udb with Sybase Central:

[ODBC] [UltraLite Database] Internal database error 100005 -- transaction rolled back Error code=-301 SQL state=40W01

What can I do to recover the database?

Please help! Thank you in advance!

Paula

asked 03 Dec '14, 11:45

Paula%20M's gravatar image

Paula M
105349
accept rate: 0%


The 100005 internal error is usually fatal; it is a report that the metadata has been corrupted. This is most likely related to a file system/media failure.

You can attempt to unload the data using the ulunload utility (or dbisql) but if that also reports the same error your database is unusable; and will need to replace the database and recreate any missing data.

To help avoid any future occurrences, you should run with a newer build of 12.0.1 to avoid the issue addressed by engineering change#693111: - "Files were not always properly flushed to the storage medium on CE."

That fix was checked into the 12.0.1#3578 build and has the description

      "On Windows Mobile / CE, database files were not always properly
       flushed when necessary. The file metadata was the most likely data
       not to be flushed and assertion failure 201129 (File shorter than
       expected) is the most likely corruption to be seen in the event of
       a full power outage (eg. if the CE device battery runs out). 
       This problem has been fixed."
permanent link

answered 04 Dec '14, 10:40

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

Thank you for the response. I tried the ulunload utility this morning which resulted in the same error. I will work on getting everything upgraded to 12.

Again, thanks for responding!

(04 Dec '14, 12:38) Paula M

Upgrading to 12.0.1 can work as well; just double check that the final build of the software is >=12.0.1#3578 as that is where the engineering change#693111 was checked into that version.

(04 Dec '14, 13:06) Nick Elson S...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×93
×14

question asked: 03 Dec '14, 11:45

question was seen: 4,535 times

last updated: 04 Dec '14, 13:06