I have started to reduce the number of projects and copies of projects in Primavera P6 8.3 as I have reached the 4 GB space allowance.
All went fine up to a point where I received the message: “The request exceeds the maximum allowed database size of 4 GB”. As from that point I was unable to delete any projects. As the rest of Primavera worked fine I continued with my normal cleaning up of Project activity data, codes etc.
Now some days later I copied an existing Project. In deleting certain activities from the copied Project
I received the following Application Event:
*****************************************************
* EXCEPTION REPORT *
*****************************************************
Date: 19-Aug-19
Executable: PM.exe
Application: Primavera P6 Professional R8.3
Event Code: PRMDB-3663-F
Message:
PRM DBAccess Error: ORA-12952: The request exceeds
the maximum allowed database size of 4 GB
Following this I logged off from Primavera and via ORACLE Database Express Edition logged in to the Database and did a Compact Storage with the hope that I could recover some unused free space. This was without success and now I sit with an additional problem in not being able to login to Primavera.
The Application Event received is PRMDB-3346-2. Refer Exception Report details below. I’m also including some clips from ORACLE Database Express Edition depicting some storage details.
I will really appreciate any help on this
I urgently need some assistance.
Much appreciated in advance
*****************************************************
* EXCEPTION REPORT *
*****************************************************
Date: 19/08/2019 14:52:51
Executable: PM.exe
Application: Primavera P6 Professional R8.3
Event Code: PRMDB-3346-2
Message:
PRM DBAccess Error: ORA-12952: The request exceeds
the maximum allowed database size of 4 GB
ORA-06512:
at "ADMPRM$PM.RT_USESSION", line 12
ORA-04088:
error during execution of trigger 'ADMPRM
$PM.RT_USESSION'
ORA-06512: at line 4
Context:
1: TfrmLogin.FormCreate
2:
3:
4:
5:
6:
7:
8:
9:
10:
Detail:
Type: EprmDBSQLExecutionFailure
Object Type: TCUltraButton
Database Error:
Error Code: 0
System Info
===========
Below are the details re. Storage utilization, Table space and Data file views as per ORACLE Database Express Edition
Storage Utilisation
Space Allocated:5,110 MB
Available: 10 MB
Physical Limit: 5,120 MB
Percent Used: 100%
Details of Tablespace View:
Details of Data files View:
