Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Database Malformed error

No replies
Phil Bedford
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 23 Jun 2016
Posts: 18

Morning folks,

I have a Primavera P6 v21.12 standalone SQL Lite database which I was working on yesterday, however this morning I have gone to open P6 and it is giving me a "database disk image is malformed"

Thankfully I did create an xer backup last Friday, so still have the main project available which I have imported to a new DB, however I'd really like to be able to access the corrupt DB.

Anyone know of a way this can be repaired?

Thanks,

Phil B.

Santosh Bhat
User offline. Last seen 1 year 3 weeks ago. Offline
Joined: 15 Apr 2005
Posts: 381

There is a complicated set of steps that Oracle says is a workaround, not a solution. Go to the ORacle support site and find this Doc ID.

Error 'Database disk image is malformed' When Attempting to Open a Project, or 'Catastrophic error' When Logging into P6 Standalone with an SQLite Database (Doc ID 2021648.1)

Phil Bedford
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 23 Jun 2016
Posts: 18

.

Phil Bedford
User offline. Last seen 1 year 12 weeks ago. Offline
Joined: 23 Jun 2016
Posts: 18

Thanks for the suggestion.

I have made a copy of the corrupt DB and renamed it.

Went to connect but sadly had the same error.

Thanks again.

Rodel Marasigan
User offline. Last seen 3 days 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699

If you are using SQL Lite and you know where the location folder of SQL Light database is (ex: *.db), try to create a copy of the database and rename it. Then try to edit the database configuration of the rename copy of SQL Light database and connect it. Sometimes it works.