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 24Release: 24.12.0.51267Industry: Engineering and ConstructionPlatform: x64Username: 0000(00000);<Admin Superuser>PM Database: PMDB_24_12: Oracle (0000, //172.16.100.40:1521/PMDBPDB)Database Schema Version: PMDB,2412.0000.0000.0006Optimal Refresh Performance: On.Login mode: Native
Any solution or suggestion to fix this issue ???
Regards,
Tarek
it appears that your session is timing out
run this scritp in sql
1. Launch the SQL Server Management Studio, select SQL Server Authentication, and connect as the schema owner (default sa).
2. On the left expand Databases.
3. Right-click the P6 database name and choose New Query from the pop-up menu.
Paste the following script in the query window and click Execute:
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON ;
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'.