Frequently Asked Question

Applies to

• Primavera P6 Professional Project Management - Version 8.4.0.0 and later
• Primavera P6 Enterprise Project Portfolio Management - Version 4.1 and later

Goal

This document is intended to provide a set of instructions for removing a user's application user preferences if their account has corrupted for Project Management or Web Access.

It has been used to resolve numerous application issues, for example:

• AVAA or AVAA0 exceptions in layouts
• Application Login Freezes at 98% for Standalone Environments.
• P6 Crashes after login.
• P6 Crashes after login with error 'Exception in module PM.exe at 00231F7D.
• And many more .... :)

SOLUTION

Following this workaround will cause the user account to lose all user defined preferences within the software and will will be reset to default settings (durations in days, show time, etc). User baselines, layouts, filters, etc. will still be there.

Prior to performing the steps below, a backup of the database and/or user preferences should be made.

The steps listed below are a *WORKAROUND* and not an actual solution. The complexity of root causing issues associated with user preferences takes time, and the *WORKAROUND* will allow users to regain proper functionality within the application while continuing to work with support on root causing the underlying issue. If removal of user preferences resolve the reported issue, the backup taken of your database should be investigated with the support organization to root cause why the user preferences may have resulted in the issue.

Log into the affected database using one of the following methods depending on database type:

• For Oracle
  
  • Log into the instance using SQLPlus or equivalent with the privileged SQL user for the schema (e.g. "privuser", "prvprm$pm")
• For Microsoft SQL Server
  
  • Launch SQL Server Management Studio and login with SQL Authentication as 'privuser'
• For SQLite
• • Download SQLite Expert Personal edition (free): http://www.sqliteexpert.com/download.html
  • Install the product.
  • After the product is installed:
  • • 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.

P6 Professional client: the following steps will remove a user's Project Management application settings and should be performed by the database administrator or equivalent:

Delete the user preferences by running the following Update Statement

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

where is the user's login id for Web Access (remove the brackets)
If using Oracle run the following statement after the update:

commit;

Login to Project Management as the user, and the user preferences will be re-created with default settings and the original issue might be resolved.

P6 Web: the following steps will remove a user's Web Access application settings and should be performed by the database administrator or equivalent:

Delete the user preferences by running the following Update Statement:

Update userdata set user_data = null where topic_name = 'pweb_settings' and user_id in (select user_id from users where user_name = '');

where is the user's login id for Web Access (remove the brackets).
If using Oracle run the following statement after the update:

commit;

Login to Web Access as the user, and the user preferences will be re-created with default settings.