on 08-28-2014 7:59 AM
Hello All,
I am upgrading our ECC system from EHP4 to EHP7, during the initial phase , SUM is throwing below error
Mapping of Table Classes to Container
INFO: The program has detected an inconsistency in your system:
Container pair 'PSAPSR3'/'PSAPSR3701X' for tabart 'CLUST' not identical.
Container pair 'PSAPSR3'/'PSAPSR3701X' for tabart 'DDIM' not identical.
Container pair 'PSAPSR3'/'PSAPSR3701X' for tabart 'DFACT' not identical.
Container pair 'PSAPSR3'/'PSAPSR3701X' for tabart 'DODS' not identical.
The inconsistency could cause problems when new tables are created. It may additionally lead to incorrect free space requirements.
We highly recommend that you fix the entries listed above and repeat the check. For more information, see SAP Note 541542
Below are the TAORA and IAORA for PSAPSR3 and PSAPSR3701X
TAORA
TABART TABSPACE PCTINC OFREELIST OFREEGROUP OPCTFREE OPCTUSED
SLDEF PSAPSR3701X 0000 001 01 10 40
SLEXC PSAPSR3701X 0000 001 01 10 40
SSDEF PSAPSR3701X 0000 001 01 10 40
SSEXC PSAPSR3701X 0000 001 01 10 40
IAORA
TABART TABSPACE PCTINC OFREELIST OPCTFREE
CLUST PSAPSR3701X 0000 001 10
DDIM PSAPSR3701X 0000 001 10
DFACT PSAPSR3701X 0004 001 10
DODS PSAPSR3701X 0004 001 10
SLDEF PSAPSR3701X 0000 001 10
SLEXC PSAPSR3701X 0000 001 10
SSDEF PSAPSR3701X 0000 001 10
SSEXC PSAPSR3701X 0000 001 10
PSAPSR3 - TAORA
TABART TABSPACE PCTINC OFREELIST OFREEGROUP OPCTFREE OPCTUSED
APPL0 PSAPSR3 0000 001 01 10 40
APPL1 PSAPSR3 0000 001 01 10 40
APPL2 PSAPSR3 0000 001 01 10 40
CLUST PSAPSR3 0000 001 01 10 40
DDIM PSAPSR3 0000 001 01 00 60
DFACT PSAPSR3 0000 004 01 10 60
DODS PSAPSR3 0000 004 01 00 60
POOL PSAPSR3 0000 001 01 10 40
SDIC PSAPSR3 0000 001 01 10 40
SDOCU PSAPSR3 0000 001 01 10 40
SLOAD PSAPSR3 0000 001 01 10 40
SPROT PSAPSR3 0000 001 01 10 40
SSRC PSAPSR3 0000 001 01 10 40
TEMP PSAPSR3 0000 001 01 10 40
IAORA
TABART TABSPACE PCTINC OFREELIST OPCTFREE
APPL0 PSAPSR3 0000 001 10
APPL1 PSAPSR3 0000 001 10
APPL2 PSAPSR3 0000 001 10
POOL PSAPSR3 0000 001 10
SDIC PSAPSR3 0000 001 10
SDOCU PSAPSR3 0000 001 10
SLOAD PSAPSR3 0000 001 10
SPROT PSAPSR3 0000 001 10
SSRC PSAPSR3 0000 001 10
TEMP PSAPSR3 0000 001 10
i have tried creating entries manually from SE16 for missing ones in TAORA and IAORA, but system says "a data record for specified key already exists" and i can see that entry from sqlplus but not from SE16.
I have followed all related forum threads , but not luck, i am not able to fix this issue.
Please help
Thanks,
Aravind
The problem here is the assignment of the tabarts CLUST, DDIM, DFACT, DODS in the system
Could you list all the tablespaces in the system please ?
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Aravind,
If you look at the TABART assignment (eg: CLUST), it is assigned to the tablespace PSAPSR3 in TAORA and PSAPSR3701X in IAORA.
This is not correct. You should set the tablespace as PSAPSR3 in both TAORA and IAORA.
You need to update the IAORA for CLUST with the correct tablespace name and correct the other three as well.
Regards
RB
Dear RB,
WOW - Your solution worked correctly. Below is the the IAORA after making changes
TABART TABSPACE PCTINC OFREELIST OPCTFREE
CLUST PSAPSR3 0000 001 10
DDIM PSAPSR3 0000 001 10
DFACT PSAPSR3 0004 001 10
DODS PSAPSR3 0004 001 10
SLDEF PSAPSR3701X 0000 001 10
SLEXC PSAPSR3701X 0000 001 10
SSDEF PSAPSR3701X 0000 001 10
SSEXC PSAPSR3701X 0000 001 10
Upgrade went ahead, Thank You so much for your timely help
Btw - Do i need to make any more changes here ?
Thanks,
Aravind
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.