SQlite DB Any Way to Extract Projects?

I am in version 15.2 using a SQLlite DB and I keep getting the error code:

Exception EAccessViolation in module PM.exe at 0000000001E1C9A1.

TCVirtualTable.RefreshAppend: TASKACTV: Access violation at address

00000000221C9A1 in module 'PM.eve' Read of address

000000000000000.

I have searched everywhere to solve this error and cannot find a solution. If anyone has answers or a way to get my projects out of the DB file, it would be appreciated.

Oracle Primavera - PM6

Zoltan Palffy 👤 Member for 16 years 10 months

Tue, 2020-09-22 12:33 · Permalink

Sqlitebrowser:
- To download, access http://sqlitebrowser.org
- Choose the appropriate version (32 or 64 bit) for Windows.
- Choose to download and Save the file to disk OR run the executable to install.

If the executable is saved to disk, the executable must still be run to install the product.

After the product is installed:

Update userdata set user_data = null where topic_name = 'pm_settings' and user_id in (select user_id from users where user_name = '<username>');

where <username> is the user's login id for Project Management (remove the brackets)

Note: If using Oracle run the following statement after the update: commit;

Start -> All Programs -> SQLite expert
File -> Open database
Browse to the users MyDocuments folder to locate the PPMDBSQLite database.
In the SQL tab, enter the desired sql statement to run.
Delete the user preferences by running the following Update Statement:
- Login to Project Management as the user, and the user preferences will be re-created with default settings.

Santosh Bhat 👤 Member for 21 years 1 month

Tue, 2020-09-22 03:50 · Permalink

Alexandre,

I'm fairly confident that P6 SQLite databases don't allow multiple users. I've opted not to pay Oracle support any more for P6, so cannot access their support portal, but there will be instructions on there on this error.

Alexandre Faulx-Briole 👤 Member for 23 years 4 months

Sat, 2020-09-19 15:58 · Permalink

Hi Cynthia,

Try to set-up a new user connexion to the database, it could (maybe) solve the problem:

in the P6 tools (Windows Start Menu), open the database manager and create a new connexion to the current database.

As I said, it could maybe help, not sure

The only other way I can imagine is to open the database itself by using the SQLite software and try to repair the database.

Alexandre

Cynthia Stiffler 👤 Member for 5 years 8 months

Wed, 2020-09-16 19:05 · Permalink

It is happening when I log into the database. I cannot access any of my files.

Zoltan Palffy 👤 Member for 16 years 10 months

Wed, 2020-09-16 13:47 · Permalink

looks like corrupt data

when are you getting this error ?

If corruption happens repeatedly with respect to layouts, create a new layout and save it as a "Template" layout. Then copy of that "Template" layout (using Save As) and work in the copied layout. If corruption then occurs, open the "Template" layout and create a new copy (using Save As) to work from that again always keeping the "Template" and not using it in Production.

Menu

SQlite DB Any Way to Extract Projects?

Forum Sponsor

Spider Project is most functional and powerful professional project management software.

Top Posters