Skip to content
ProjectControls.com
Oracle Primavera - PM6

Error Code PRMDB-0900-0

In the Open Standard
Tarek BarhamMember for 18 years 5 months
Created
1
5
0

Dear Planners,

i'm using P6 version 24 Server , with 5 Users , every thing is ok, untill the user is leaving the P6 idle ( not used for 10 to 15 min, then when the user try to dop any filter or layout the below error showing up/  

Event Code: Error Code PRMDB-0900-0.

Exception EPRM DBSQLexecution Failure Model PM.EXE  at 000000000941B23B 

PRMDB Access Error: Error Received Fro,

No DBAPI.Tansmitand receive : Orcake ORA-12571

 

Encountered 

 

Below more details   

 

*****************************************************

*                EXCEPTION  REPORT                  *

*****************************************************

Date:          03-Apr-25

 

Executable:    PM.EXE

Application:   Primavera P6 Professional 24

Event Code:    PRMDB-0900-0

Message:      

  PRM DBAccess Error: Error executing query. Error:

  Oracle error ORA-12571 encountered.

  Time: 03-Apr-25 10:57:55

 

Context:

  1: TDevxMainForm.actProjectActivitiesExecute

  2: TDevxMainForm.BeforeFormShow

  3: TDevxMainForm.actProjectWBSExecute

  4:

  5:

  6:

  7:

  8:

  9:

  10:

 

Detail:

  Type:        EprmDBSQLExecutionFailure

  Object Type: TPopupList

 

Database Error:

   Error Code:     0

 

 

System Info

===========

Username: 20378723   Hostname: PLO20378723ADO

OS Version: Windows NT ver 6.2, build 9200,  ((unknown))

 

 

 

About P6:  

About: Primavera P6 Professional 24
Release: 24.12.0.51267
Industry: Engineering and Construction
Platform: x64
Username: 0000(00000);<Admin Superuser>
PM Database: PMDB_24_12: Oracle (0000, //172.16.100.40:1521/PMDBPDB)
Database Schema Version: PMDB,2412.0000.0000.0006
Optimal Refresh Performance: On.
Login mode: Native

 



Any solution or suggestion to fix this issue ???

Regards,

 

 

Tarek 

Save Follow Follow forum Report
Reply New topic

1 reply

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    it appears that your session

    it appears that your session is timing out 

     

    run this scritp in sql 

    1. 1. Launch the SQL Server Management Studio, select SQL Server Authentication, and connect as the schema owner (default sa). 

    1. 2. On the left expand Databases. 

    1. 3. Right-click the P6 database name and choose New Query from the pop-up menu. 

    1. Paste the following script in the query window and click Execute: 

    ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON ; 

    1. 5 Execute the following query to confirm the setting has been updated: 

     

    select name, value from sys.database_scoped_configurations where name like 'LEGACY_CARDINALITY_ESTIMATION' 

    The result should indicate that 'LEGACY_CARDINALITY_ESTIMATION' now has a value of '1'.

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?