SUM - Error : Checks after phase MAIN_TRANSEXEC/PARCONV_TRANS were negative

[Former Member]

Dear All,

I'm facing issues with the SUM tool  Ver1.0 SP07 Patch lvl 1.0, while trying to upgrade the DEV system to EHP6 .. SUM throws a error

at phase : MAIN_TRANSEXEC/PARCONV_TRANS ...

It says : Checks after phase MAIN_TRANSEXEC/PARCONV_TRANS were negative

I've gone through the SUM logs and other individual logs ..

I've summarized my findings below :

I've already updated TP ( 18th Mar 2013 ) and R3Trans ( 25th Mar 2013 ) with the latest versions available on Service Mkt Place !!

1.) SUM/abap/log/PARCONV.log

//

1 ETQ399 20130509162356 Created UPGANA.XML within 0 seconds

2 ETQ399 Operation 'delntabs' looking for pattern 'PL00....\.DEV'

3 ETQ399 20130509162356: PID 25728 execute 'E:\usr\sap\DEV\DVEBMGS00\exe\tp pf=F:\SUM\abap\var\DEFAULT.TPP getconvent DEV' , output written to 'F:\SUM\abap\log\TOOLOUT.LOG'.

3 ETQ399 20130509162357: PID 25728 exited with status 0

1 ETQ399 Conversion entries found:

2 ETQ399 CONV ENTRY TBATG SQLTDVPOOLTEXT               0CNVIE20130508DDIC       

2 ETQ399 CONV ENTRY TBATG SQLTGLSP                             0CNVIE20130508DDIC       

2 ETQ399 CONV ENTRY TBATG SQLTGLTP                             0CNVIE20130508DDIC       

2 ETQ399 Using 'tp' from path 'E:\usr\sap\DEV\DVEBMGS00\exe'.

2 ETQ399 Requested task ID is 'COUNT_MODEFLAGS'.

3 ETQ399 Generating TQL file 'DDXTTCNT.XQL' with log file 'DDXTTCNT.LOG'.

4 ETQ276 Executing SQL-script "DDXTTCNT.XQL"

3 ETQ399 20130509162357: PID 26328 execute 'E:\usr\sap\DEV\DVEBMGS00\exe\tp pf=F:\SUM\abap\var\DEFAULT.TPP execdbscript DEV -x ..\var\DDXTTCNT.XQL' , output written to 'F:\SUM\abap\log\TPSQLSTD.OUT'.

3 ETQ399 20130509162357: PID 26328 exited with status 0

3 ETQ399 Reading selections from 'DDXTTCNT.LOG'.

4 ETQ399 Read 5 entries for table 'LIST'.

2 ETQ399 Found 8369 times modeflag 'V'.

2 ETQ399 Found 17 times modeflag 'W'.

2 ETQ399 Found 3 times modeflag 'U'.

1EETQ399 Unhandled entries found in inactive nametab:

2EETQ399 Modeflag 'U' appears 3 times

2 ETQ399 Found 388109 times modeflag 'A'.

2 ETQ399 Found 16038 times modeflag 'F'.

4 ETQ010 Date & Time: 20130509162357 

1EETQ399 Last error code set is 'Unhandled mode flags found, check 'PARCONV.LOG' for details'

1EETQ203 Upgrade phase "PARCONV_TRANS" aborted with errors ("20130509162357")

//

2.) SUM/abap/log/DDXTTCNT.log

tp_exec_statement: SELECT MODEFLAG, COUNT(*) FROM DDXTT GROUP BY MODEFLAG
SELRESULT01>>V 8369   
SELRESULT01>>W 17     
SELRESULT01>>U 3       
SELRESULT01>>A 388109 
SELRESULT01>>F 16038   

tp_exec_dbscript: 1 statement(s) successfully processed.

===========================================================

SAPup broke during phase PARCONV_TRANS in module MAIN_TRANSEXEC / Downtime for transport mode

Error Message: Unhandled mode flags found, check 'PARCONV.LOG' for details

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

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

Summary of SAPup:

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

SAPehpi Release: lmt_008

SAPehpi Version: SAPup release lmt_008 version 52.000

Start Release:  700

Target Release:  731

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

Summary of host system details:

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

SID:  DEV

Host:  INBL-SAP-XXXX

MS Host:  INBL-SAP-XXXX

GW Host:  INBL-SAP-XXXX

Start Path:  E:\usr\sap\DEV\DVEBMGS00\exe

Kernel Path:  E:\usr\sap\DEV\DVEBMGS00\exe

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

Summary of operating system details:

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

OS Type:  Windows NT X86_64

OS Version:  6.1

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

Summary of database details:

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

Database Type:  ora

Database Version: 11.2.0.3.0

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

=====================================================================

I understand that there are 3 nametabs in the DDXTT table that have MODEFLAG - ' U ' because of which SUM is unable to continue with the upgrade.

The nametab conversion is not happening succcessfully ...

What should be done here so that I can go ahead and finish off the upgrade through SUM ??

Please share your thoughts on this ...

Krish

[former_member144433 · Accepted solution]

Hi Krish,

The upgrade is stuck in the PARCONV_TRANS phase as the DDXTT have three entries with the U-Flag

Can you please check the NCONV* logs with return code 8 and find that which tables have inactive nametabs.

After finding the tables please perform the runtime & database check of the tables in the SE11 to find if there are any inconsistencies.

Thank You.

Regards,

Deepika

[Former Member · Accepted solution]

Hi Deepika,

You have understood the issue .. I've checked all the NCONV* logs none of them have error code 8.

I tried to run the runtime and database check on table DDXTT in SE11, the database check was all green and the runtime objects check was also green for the said table ...

Hmmm ...

I'm all stuck in the execution phase here ...  😐

[former_member144433 · Accepted solution]

Hi,

Ideally the table information will be visible in these logs but it is very strange that none of the logs reflect the error. Can you please check the contents of the table DDXTT for the table names with modeflag U at the database level.

Thank You.

Regards,

Deepika

[Former Member · Accepted solution]

Hi,

I did that , I got 3 name tabs that has MODEFLAG 'U' in the table DDXTT.

I used the statement :

select tabname from sapsr3.ddxtt where modeflag='U';

OUTPUT:

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

GLTP

DVPOOLTEXT

GLSP

Further Details :

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

These three name tabs are POOLS/CLUSTERS

Status : Upgrade - saved

category : TRANSPARENT.

I ran a database and runtime obj check on these 3 tabsnames ... DATABASE CHECK is CONSISTANT no errors.

But the runtime obj check for these three name tabs show INCONSISTANCIES.

"It says data inconsistancies found when compared to source data"

After this step I'm stuck ... I mean I have a DDXTT table that has 3 nametabs

GLTP

DVPOOLTEXT

GLSP

with modeflag U ... now these name tabs have runtime inconsistancies .. their status is URGRADE - SAVED

Hmmm ... now what can be done ??

[former_member144433 · Accepted solution]

Hi Anantara,

Please run report RADPOCNV for tables DVPOOLTEXT, GLTP and GLSP using

transaction code SA38 instead of SE38. Please follow the instructions

from note 686357 and check the behaviour again.

Please do NOT use SE38, because it is dumping since table RCCHAR is no

longer available in your system. Table RCCHAR was already deleted by

the Upgrade 731 packages.

Thank You.

Regards,

Deepika

[Former Member · Accepted solution]

Hi Deepika,

I've run the report RADPOCNV from Tcode SA38 ...

OUTPUT :

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

  Program start============================================================

  ABAP Dictionary: Table Pool Conversion (For Unicode)

  =========================================================================
  Process..................: INBL-SAP-TEST_21
  User.....................: DDIC
  Date, time...............: 09.05.2013, 19:52:58
  Platform.................: CUSTOMER-DEV(700)/ORACLE/WindowsNT/INBL-SAP-TEST
  Tool.....................: SA38/RADPOCNV
  Log......................: T, TPOCNV20130509195258

  Program parameters:
  Task:....................: Extension of RAW Fields of Table Pool
  =========================================================================

  Table pool ATAB already successfully converted
  Table pool DVPOOLTEXT already successfully converted
  Table pool GLSP already successfully converted
  Table pool GLTP already successfully converted

  =========================================================================
  ABAP Dictionary: Table Pool Conversion (For Unicode)
  =========================================================================
  Process..................: INBL-SAP-TEST_21
  Return code..............:
  Date, time...............: 09.05.2013, 19:52:58
  Program end==============================================================

[Former Member · Accepted solution]

Hi,

I've run the abap report as discussed, the output says ..

  Table pool ATAB already successfully converted

  Table pool DVPOOLTEXT already successfully converted

  Table pool GLSP already successfully converted

  Table pool GLTP already successfully converted

I restarted SUM from the phase it stopped at, still it stops with the same error .. the concerned logs still show that ..

There are 3 nametabs in DDXTT table with MODEFLAG - U ..

[Reagan · Accepted solution]

Hello

Once more if you have missed it:

In the above thread i have provided there is a suggestion to update the DDXTT table with modflag set to A for the affected tables from the SQL.

As you have already executed the report can you run the SQL and check the output ?

SELECT TABNAME, MODEFLAG FROM SAPSR3.DDXTT WHERE MODEFLAG = 'U';

If you have the entries there with take a backup of the table DDXTT (export using BRTools) and then update the corresponding table by changing the flag.

Cheers

RB