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

[Former Member]

Hi Hugo,

I've another problem here, SUM had stopped with the above error .. at this point I stopped the update process and tried to troubleshoot the 3 TABNAMES under the TABLE DDXTT ... from SQLPLUS ... in the process I restarted the SAP SYSTEM

I know I shouldn't have restarted the SAP SYTEM while SUM was running/ongoing/stopped .. But then did it unkowingly ..

Now when I try to use TCODES like SE11, SE16,  SE14 or SA38 .. SE38 .. it throws a ABAP DUMP !! Previous to the restart I was able to use all these t codes and view the details in them..

Any idea what should be done now ??

[hugo_amo]

Hi Krish,

You may need to start the SUM from scratch, but before, let's try to find out something else. Please, attach the dump and the relevent dev_w* trace.

Regards,

Hugo

[Former Member]

ABAP DUMP :

==========

Short text
    Syntax error in program "SAPLPA_PACKAGE_CHECKS ".

What happened?
    Error in the ABAP Application Program

    The current ABAP program "SAPLSDYY" had to be terminated because it has
    come across a statement that unfortunately cannot be executed.

    The following syntax error occurred in program "SAPLPA_PACKAGE_CHECKS " in
     include "IF_PACKAGE_INTERFACE==========IU " in
    line 23:
    "The type "SUPPRESS_TRANSL_TECH_TEXTS" is unknown."
    " "
    " "
    " "

    The include has been created and last changed by:
    Created by: "SAP "
    Last changed by: "SAP ".

DEV_W* Trace :

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

A Thu May 09 18:29:46 2013

A  *GENER* starting remote generation: CL_TPDA_SUBSCREEN_HANDLER=====CP (requested by W20).

A 

A Thu May 09 18:29:47 2013

A  *GENER* starting remote generation: CL_TPDA_DEFAULTS_SUPER========CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_ICONS=================CP (requested by W20).

A 

A Thu May 09 18:29:50 2013

A  *GENER* starting remote generation: CX_TPDA_TOOL_DEFAULTS=========CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA=======================CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA_PRESETTINGS===========CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_DEBUG_SESSION_HANDLER=CP (requested by W20).

A 

A Thu May 09 18:29:51 2013

A  *GENER* starting remote generation: CL_TPDA_SERVICES==============CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA_TOOL_CUST=============CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_TOOL_EDITOR===========CP (requested by W20).

A 

A Thu May 09 18:29:52 2013

A  *GENER* starting remote generation: CL_TPDA_TOOL_INSTANCE_HANDLER=CP (requested by W20).

A  *GENER* starting remote generation: IF_TPDA_TOOL==================IP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_OK_CODE_HANDLER=======CP (requested by W20).

A 

A Thu May 09 18:29:53 2013

A  *GENER* starting remote generation: CL_TPDA_SOURCE================CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_SOURCE_ABAP===========CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_TOOL_STACK============CP (requested by W20).

A 

A Thu May 09 18:29:54 2013

A  *GENER* starting remote generation: CL_TPDA_BP_HANDLER============CP (requested by W20).

A  *GENER* starting remote generation: SAPLSTPDA_TOOL_EDITOR (requested by W20).

A 

A Thu May 09 18:29:55 2013

A  *GENER* starting remote generation: CL_TPDA_TOOL_QUICK_VARS=======CP (requested by W20).

A 

A Thu May 09 18:29:56 2013

A  *GENER* starting remote generation: IF_TPDA_OPTIONS===============IP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_VAR_CHANGE_HANDLER====CP (requested by W20).

A  *GENER* starting remote generation: SAPLSTPDA_TOOL_QUICK_VARS (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_SETTINGS==============CP (requested by W20).

A 

A Thu May 09 18:29:57 2013

A  *GENER* starting remote generation: CX_TPDA_DEBUG_SESSION=========CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA_NO_DEBUG_SETTINGS=====CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_EXCEPTION_SERVICES====CP (requested by W20).

A  *GENER* starting remote generation: CL_TPDA_DEBUGGER_STATUS=======CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA_SCREEN_STACK==========CP (requested by W20).

A  *GENER* starting remote generation: CX_TPDA_SUBSCREEN_ADMIN=======CP (requested by W20).

A  *GENER* starting remote generation: SAPLSTPDA_CARRIER (requested by W20).

A 

A Thu May 09 18:29:58 2013

A  *GENER* starting remote generation: SAPLSTPDA_TOOLBAR (requested by W20).

A 

A Thu May 09 18:29:59 2013

A  *GENER* starting remote generation: IF_TPDA_TOOL_SERVICES=========IP (requested by W20).

Y 

Y  ===> running separate LUW generation: 20130509182959

Y    ===> requesting WP: 20

D  GuiStatus generate status prog >RSTPDAMAIN< status >MAIN100< ts >20130509125959,247<

D  GuiStatus set generate inline ts >20130509125959,247<

D  GuiStatus object with old version prog >RSTPDAMAIN< status >MAIN100< ts >20130509125959,263<

D  GuiStatus clear generate inline ts >20130509125959,372<

Y 

Y  ===> running separate LUW generation: 20130509182959

Y    ===> requesting WP: 20

D  GuiStatus generate texts prog >RSTPDAMAIN< ts >20130509125959,372<

D  GuiStatus set generate inline ts >20130509125959,372<

D  GuiStatus clear generate inline ts >20130509125959,403<

Y 

Y  ===> running separate LUW generation: 20130509182959

Y    ===> requesting WP: 20

D  GuiStatus update texts prog >RSTPDAMAIN< ts >20130509125959,403<

D  GuiStatus set generate inline ts >20130509125959,403<

D  GuiStatus store texts prog >RSTPDAMAIN< ts >20130509125959,403<

D  GuiStatus clear generate inline ts >20130509125959,434<

Y 

Y  ===> running separate LUW generation: 20130509182959

Y    ===> requesting WP: 20

D  GuiStatus update status prog >RSTPDAMAIN< status >MAIN100< ts >20130509125959,434<

D    dynamic text state >W<

D  GuiStatus set generate inline ts >20130509125959,434<

D  GuiStatus store status prog >RSTPDAMAIN< status >MAIN100< ts >20130509125959,434<

D  GuiStatus clear generate inline ts >20130509125959,434<

[hugo_amo]

Hi Krish,

Have you run report RADPOCNV for tables DVPOOLTEXT, GLTP and GLS according

note 686357 ?

Please, see Note:

1281521 - Syntax error in SAPLPA_PACKAGE_CHECKS

Regards,

Hugo

[Reagan]

Hello

Are you able to run the above mentioned Tx's now ? If not try to do a buffer sync

/$SYNC

Back to the modeflag issue check this discussion.

http://scn.sap.com/thread/1985451

Cheers

RB

[Former Member]

Hi Regan,

The discussion doesn't have any useful information for this issue i'm facing.. the buffer resync didn't help either .. still can't access the t codes.

Any suggestions ?

[Reagan]

Hello

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';

Cheers

RB

[Former Member]

Hi krish,

Currently I am running SUM to update HR components

I got a message to update R3Trans to the latest one

There a latest one which been released on 4/413 Patch level 112 I have updated R3Trans and it is running.

With Regards

Rathish

[Former Member]

Hi Rathish,

The latest R3trans version for system was released on 25/03/2013
SAP Kernal 7.20 64bit UC - Win 64bit - Database independednt componenet ..

I can't see any new R3trans verision there ...

Regards

Krish

[Former Member]

Hi Krish,

Please check in sap 7.21 kernal becouse R3Trans under usr/sap/sid/sum/abap/exe R3Trans will be 721. You can verify it by Right click R3trans- properties- Details.

With regards,

Rathish

[Former Member]

Hi Ratish,

Its 720 , not 721 ... I believe i've got the right R3trans and TP programs running ... the issue is with the table entries in DDXTT.

I've got three name tabs with MODEFLAG : U

This won't let me continue the upgrade

[hugo_amo]

Hi Krish,

Try to run report RADPOCNV for table DVPOOLTEXT according note 686357 and check the behaviour again. I am not 100% sure this will help, but I believe it worths a try.

Regards,

Hugo