Solution Manager SPS12 Upgrade issue

[khampariamukesh]

Hello Friends,

While doing SPS12 stack upgrade on New Solman 7.1 system we are facing issue in preprocessing phase.

The error in Phase -

MAIN_SHDIMP/PARMVNT_SHD were negative.

I have activated the table "/SDF/SMODIDEVC" and

also updated tp and R3trans latest but the still issue remain same.

Error in PA010508.SOL

3 ETP379Xactivating Nametab "/SDF/SMODIDEVC":
2 ETP000 >> Name of inactive nametab to read : DDXTT~
2 ETP000 >> Format of inactive nametab to read: 5.0
3 ETP000 ntab export with reset DBTABPOS
2 ETP000 --------------- DB-ROLLBACK() ---------------
2AETP000XWrite table "/SDF/SMODIDEVC ": pgntab call: invalid arguments.
2 ETP301 ----------------------------------------------------------------------
3 ETP365 "0" Shadow-Nametabs activated
2 ETP362 "1" Shadow-Nametab activations failed
2 ETP364 Begin: Act. of Shadow-Nametabs ("2015/05/08 08:42:03")
2 ETP366 End: Act. of Shadow-Nametabs ("2015/05/08 08:42:03")
2 ETP301 ----------------------------------------------------------------------
1 ETP180 UNKNOWN ACTION
1 ETP110 end date and time : "20150508084203"
1 ETP111 exit code : "12"
1 ETP199 ######################################

The table not in active status /SDF/SMODIDEVC.

I tried to activate from SE11 but I received dump DBIF_PGNT_INVALID_ARGUMENTS.

So I have executed below steps to resolve the activation problem (as per note)

  Goto se37 function module DD_NAMETAB_DELETE

After this I activated successfully the table from SE11. I re-ran the SUM but still the same issue .

I have upgraded latest tp and R3trans as well but no luck .

tail -10 TP01.ECO
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=SOL
    PWD: /usr/sap/SOL/SUM/abap/tmp

EXECUTING /usr/sap/SOL/SUM/abap/exe/tp pf=/usr/sap/SOL/SUM/abap/var/MVNTSHD.TPP actntabs SOL protyear=01 shadow_only strel=702 substext=4G -Dbuffreset=no touch=NO
This is tp version 380.29.43 (release 721, unicode enabled)
tp finished with return code: 12
meaning:
  A tool used by tp aborted
SAPup> Process with PID 29163556 terminated with status 12 at 20150508120120!

Thanks

Mukesh

[Former Member · Accepted solution]

Hello Mukesh,

Just to make sure, the actions you took above were in the SHADOW instance ?

Amerjit

[khampariamukesh · Accepted solution]

Hi Amerjit,

We had done the changes in both running and Shadow instance EXE dir. Also Restarted the running system just for satisfaction.

We had tried starting the SHADOW system but it is NOT being started with message that we have crossed the SHADOW instance stop step hence not possible to start.

Could you please help further?

Thanks

Mukesh

[Former Member · Accepted solution]

Hello Mukesh,

I see you have had a lot of suggestions but what I believe is being missed is that even if you resolve the problem in your "normal/active instance" (which you have done correctly) you are in the SHADOW nametab phase.

Cross check for shadow nametab tables to determine the correct table name and tablespace.

select owner, segment_name, tablespace_name from dba_segments where segment_name like 'DDNT%' and segment_type = 'TABLE' ;

Please post the output of the above command as I want to be 1000000% sure that the name of the shadow nametab tables hasn't changed before giving you further advice.

ps: Perform the same SQL for the tables DDFTX - DDXTT - DDXTF.

KR,

Amerjit

[khampariamukesh · Accepted solution]

Hi Amerjit,

Here is your requested data.

SQL> select owner, segment_name, tablespace_name from dba_segments where segment_name like 'DDNT%' and segment_type = 'TABLE';

SAPSR3

DDNTF

PSAPSR3

SAPSR3

DDNTF_CONV_UC

PSAPSR3

SAPSR3

DDNTF_CONV_UC~

PSAPSR3

SAPSR3

DDNTF_HIST

PSAPSR3

SAPSR3

DDNTF~

PSAPSR3

SAPSR3

DDNTLANG~

PSAPSR3

SAPSR3

DDNTT

PSAPSR3

SAPSR3

DDNTT_CONV_UC

PSAPSR3

SAPSR3

DDNTT_CONV_UC~

PSAPSR3

SAPSR3

DDNTT_HIST

PSAPSR3

SAPSR3

DDNTT~

PSAPSR3

11 rows selected.

SQL>

SQL> select owner, segment_name, tablespace_name from dba_segments where segment_name like 'DDFTX' and segment_type = 'TABLE';

SAPSR3

DDFTX

PSAPSR3702

SQL>select owner, segment_name, tablespace_name from dba_segments where segment_name like 'DDXTT' and segment_type = 'TABLE';

SQL> SAPSR3

DDXTT

PSAPSR3702

SQL> select owner, segment_name, tablespace_name from dba_segments where segment_name like 'DDXTF' and segment_type = 'TABLE';

SAPSR3

DDXTF

PSAPSR3702

SQL>

Thanks

Mukesh

[Former Member · Accepted solution]

Hi Mukesh,

Thanks for that. I just like to be sure before I suggest things.

1. Please take a backup of the DDNTT~ and DDNTF~ tables.

2. Cross check the above tables for your problematic table.

select TABNAME from SAPSR3."DDNTT~" where TABNAME = '/SDF/SMODIDEVC' ;

select TABNAME from SAPSR3."DDNTF~" where TABNAME = '/SDF/SMODIDEVC' ;

nb: you should get one entry returned from each select.

3. Delete from the above tables for your problematic table.

delete from SAPSR3."DDNTT~" where TABNAME = '/SDF/SMODIDEVC' ;

delete from SAPSR3."DDNTF~" where TABNAME = '/SDF/SMODIDEVC' ;

commit ;

4. Retry your SUM step with INIT option.

Let us know how you get on.

In the absolute worst worst case, you just have to reset your SUM and start all over again as you have already corrected the problem in the normal instance.

KR,

Amerjit

[khampariamukesh · Accepted solution]

Hi Amerjit,

Thanks for your reply. I have checked for table DDNTT~ and DDNTF~. Entry is not present in one table and it is in another.

I have checked for ANOTHER table which is in logs, Entry is also present for this table "DDXTT~".

So do we need to delete the entry from there as well?

SQL> select TABNAME from SAPSR3."DDNTT~" where TABNAME = '/SDF/SMODIDEVC';

no rows selected

SQL> select TABNAME from SAPSR3."DDNTF~" where TABNAME = '/SDF/SMODIDEVC';

TABNAME

--------------------------------------------------------------------------------

/SDF/SMODIDEVC

SQL> select TABNAME from SAPSR3."DDXTT~" where TABNAME = '/SDF/SMODIDEVC';

TABNAME

--------------------------------------------------------------------------------

/SDF/SMODIDEVC

SQL>

[khampariamukesh · Accepted solution]

Hi Amerjit/Manu,

I have deleted the entry from table SAPSR3."DDXTT~" (as this was coming in our error log) and repeated the phase with INT. It failed with some error. I just REACTIVATED the table "/SDF/SMODIDEVC" from SE11 and CONTINUE.

SQL> create table SAPSR3."DDXTT~backup" as select * from SAPSR3."DDXTT~";

Table created.

SQL>

SQL> Select count(*) from SAPSR3."DDXTT~";

  COUNT(*)

----------

         1

SQL>

SQL> delete from SAPSR3."DDXTT~" where TABNAME='/SDF/SMODIDEVC';

1 row deleted.

SQL> commit;

Commit complete.

SQL>

Issue resolved.

A big THANKS to both of you.

Reg,

Mukesh

[Former Member · Accepted solution]

Hello Mukesh,

Yes you also want to delete the entry in the DDXTT~table.

KR,

Amerjit

[Former Member · Accepted solution]

Ah ..... I didn't read you had resolved it before replying to your earlier post .... oops 🙂

Anyway, you did what I would have suggested anyway. Well done and good luck with the remainder of your upgrade.

Cheers,

Amerjit

[manumohandas82 · Accepted solution]

Thanks a lot for   the Update   Mukesh . Good luck with the rest of theactivities

Hi Amerjit ,

That was just too good .. I missed to check though

Thanks ,

Manu

[Former Member]

This message was moderated.

[manumohandas82]

Hi Mukesh ,

Make sure that you have a backup of the SUM directory   ( Preserve all the Logs )

While waiting for SAP , If i were you i would  give a try with the following reports

umg_check_nametabs & umg_check_nametab_tab  [ But wont recommend to u ] to check the status of the tables

1428028 - Unicode Conversion: check nametabs report UMG_CHECK_NAMETABS

1426513 - Unicode Conversion: check nametab tables

All the best

Thanks ,

Manu

[manumohandas82]

One more and leaving this to experts comments

1 ) You mentioned you are using the latest TP / R3trans  - Can you confirm ?

A similar issue

1580792 - Termination of EHP5 in phase NTACT_NODBPOS

2 ) Raise paralley a message with SAP

Thanks ,

Manu

[khampariamukesh]

Hi Manu,

Yes TP was updated with latest present in SMP based on this SNOTE only.

I have raised SAP Incident on Friday but seems they are not active like you are helping..

Thank you.

Mukesh

[manumohandas82]

Hi Mukesh ,

Please check the following note

1043931 - DBIF_PGNT_INVALID_ARGUMENTS with DDIC activation

Thanks ,

Manu

[khampariamukesh]

Thanks Manu,

I have tried with given SNOTE (accurately I had tried this before as well but no luck) and did not resolve this issue.

I tried with repeat step and same issue reported.

Could you please help further?

Thanks

Mukesh

[manumohandas82]

Hi Mukesh ,

Please share the test results

Did you try restart of the database  ?

Stop all the SUM opertaions , save a copy of the SUM directory . stop all sap applications and database  ( if possible a restart of server ) and try once again .

Please let us know the status

Thanks ,

Manu

[khampariamukesh]

Hi Manu,

DB was not started this time but yes I did it for last time when I did this work.

Also SUM was restarted with SLControler restart. I can not restart SERVER as other SAP application is running in host.

Thanks

Mukesh

[manumohandas82]

Hi Mukesh ,

Please check the table DDXTF  *( whether empty )  in the schema SAPSR3   ( and share the results )

Thanks ,

Manu

[khampariamukesh]

SQL> select * from SAPSR3.DDXTF;

no rows selected

SQL>

Nothing there in the table.

Thanks

Mukesh

[manumohandas82]

Hi Mukesh ,

Can you check for any invalid temp tables from SE14  ( Extras - > Invalid Temp Table )

Also check the consistency from SE14 for tables DDXTF and DDXTT

Thanks ,

Manu

[khampariamukesh]

Thank Manu.

Seems there is not like invalid temp table and consistency is also OK

Reg,

Mukesh

[former_member185239]

Hi Mukesh,

Can you check the table DDXTT and search for the /SDF/SMODIDEVC nametab.

Also try to use the latest kernel as well.If the latest kernel does not work , then follow the below suggestion

Delete the nametab /SDF/SMODIDEVC from the table DDXTT.

With Regards

Ashutosh Chaturvedi

[khampariamukesh]

Hi Ashutosh,

DDXTT table was already empty, we had checked initially..

Could you please help further,

Thanks

Mukesh

[former_member185239]

Hi Mukesh,

check the table DDXTT table in shadow schema.

Kindly paste the screenshot also.

With Regards

Ashutosh Chaturvedi

[khampariamukesh]

Thanks for your immediate reply.

Total USER List :

SQL> select USERNAME from DBA_USERS;

USERNAME

------------------------------

SAPSR3

SAPSR3DB

SYSTEM

SYS

OPS$SOLADM

OPS$SAPSERVICESOL

SAPSR3SHD

OPS$ORASOL

OUTLN

APPQOSSYS

ORACLE_OCM

USERNAME

------------------------------

DBSNMP

DIP

13 rows selected.

DDXTT table not present in SAPSR3SHD Schema:

SQL> select * from SAPSR3SHD.DDXTT;

select * from SAPSR3SHD.DDXTT

                        *

ERROR at line 1:

ORA-00942: table or view does not exist

No Entry present in DDXTT table in SAPSR3 Schema:

SQL> select * from SAPSR3.DDXTT;

no rows selected

SQL> desc SAPSR3SHD.DDXTT;