SQlite DB Any Way to Extract Projects?

• 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.

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.

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.

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

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.