Primavera P6 R8.2 Progress Reporter Application Deployment In 'Prepared' State After PUBUSER Password Was Changed And Logs The Following Error: "Login failed for user 'pubuser'." (Doc ID 1550694.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : Primavera P6 8.2 version, P6 Install, Upgrades, and Configuration

ACTUAL BEHAVIOR
---------------
Having changed PUBUSER and PRIVUSER password in development environment, Progress Reporter deployment is in "Prepared" state and unusable.

ERROR:
-------------
PR in 'Prepared' state with the following Error in Weblogic:
" weblogic.application.ModuleException: :com.microsoft.sqlserver.jdbc.SQLServerException:Login failed for user 'pubuser'. "

EXPECTED BEHAVIOR
-----------------------
After changing PUBUSER passwords Progress Reporter Deloyment should be 'Active' and and be able work successfully.

STEPS
-----------------------
1. Stop Primavera Application

2. Change PUBUSER passwords

3.  From within P6EPPM\P6 directory run
a) dbconfigpv.cmd 
b) adminpv.cmd

4. Start Primavera Application

5. Note that PR is in 'Prepared' state in Weblogic, and an attempt to restart PR gives the error:

" weblogic.application.ModuleException: :com.microsoft.sqlserver.jdbc.SQLServerException:Login failed for user 'pubuser'. "



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Progress Reporter

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms