SQL Anywhere (ASA) database "File is shorter than expected – transaction rolled back" bug fix

I 've picked up a couple of days Sqlanywhere (ASA) database, where two of the databases are reported as "File isshorter than expected-transaction rolled back" error,

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/84/61/wKiom1ePD7Hyg0xRAABBOiL-9xQ267.png-wh_500x0-wm_3 -wmp_4-s_1269407155.png "style=" Float:none; "title=" Qq20160720133433.png "alt=" Wkiom1epd7hyg0xraabboil-9xq267.png-wh_50 "/>

Through the customer's description, the customer is using "Jewelry Management Information System", in the use of a sudden crash, forced restart, the software can not connect to the database, and database start error.

after getting the database file (jewel.db), can over Winhex analysis file structure, found that the file structures are damaged, manual correction error, the database started normally, to the database to do DBUnload, There are no errors.

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/84/61/wKioL1ePD7GwzXI9AAEW5mC2Cxk011.png-wh_500x0-wm_3 -wmp_4-s_978822016.png "style=" Float:none; "title=" QQ picture 20160720134242.png "alt=" Wkiol1epd7gwzxi9aaew5mc2cxk011.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/84/61/wKiom1ePD7KBVy4ZAADR9J_uTfU315.jpg-wh_500x0-wm_3 -wmp_4-s_2373943825.jpg "style=" Float:none; "title=" QQ picture 20160720134203.jpg "alt=" wkiom1epd7kbvy4zaadr9j_ Utfu315.jpg-wh_50 "/>

Contact information: Zhang Zuo, 13146539790, qq:86066616

This article is from the Data Recovery technology blog, so be sure to keep this source http://zzblog.blog.51cto.com/1395999/1828049

SQL Anywhere (ASA) database "File is shorter than expected – transaction rolled back" bug fix