Skip to Content

EHP1 to EHP2 upgrade - downtime - entries in table DDXTT

Hi All,

I'm performing NW EHP1 to EHP2 upgrade for BW, MSSQL2008. Basically i'm doing in sandbox where copied from production.

All prerequisites have been performed and notes applied accordingly.

However, during downtime phase, this message prompts out:

ERROR: There are still entries in table DDXTT left, which

should have been processed in an earlier phase.

The corresponding entries in table DDXTF will be deleted

during the next phase, thus these entries have to be

processed before!

The entries still left are listed in file 'CNTXTT.LOG'.

ATTENTION: Do not delete these entries!

Do not ignore this phase!

and the option is either Continue or Cancel.

when check CNTXTT.log and execute command "select TABNAME from sid.DDXTT" there are 300++ entries which seem so abnormal!! I know the problem can be fixed by activate those entries in DDXTT.. how i would like to what's the possible reason for many entries in DDXTT. Entries are like:

*where P is the modeflag:: what's does P means btw?

TABNAME =IACML_DEV P

TABNAME =IACMU_DEV P

TABNAME =IACR_C_DEV P

TABNAME =IACR_DEV P

TABNAME =IACST_DEV P

TABNAME =IACS_C_DEV P

TABNAME =IACS_DEV P

TABNAME =IACTL_DEV P

TABNAME =IACTU_DEV P

TABNAME =IMPL_DATA P

TABNAME =INFO_BMEP P

TABNAME =INFO_BMEPT P

TABNAME =INFO_VIEW2 P

TABNAME =INFO_VIEWT P

TABNAME =LDAPMAP12 P

TABNAME =LDAPMAP62 P

TABNAME =LNGTINFO P

TABNAME =LXE_TRINFO P

TABNAME =MEMON_TECH_VIEW P

TABNAME =STWB_STAT P

TABNAME =STWB_STA_1 P

TABNAME =STWB_STA_2 P

TABNAME =SUBTYPE_INFO P

TABNAME =SV_FLIGHTS P

TABNAME =SV_IOASGN P

TABNAME =SV_IOASGN1 P

TABNAME =SV_LOC P

TABNAME =SV_LOCTTY P

When i checked in SE14, the status for above table is "upgrade"... what's the reason? I ran the statement "select TABNAME from sid.DDXTT" in the source system (Prod) but there's no entry!

Just want to confirm is it a bug or something not right on the EHP2 upgrade? If yes, anyway i can activate all the entries in DDXTT in one shot and is the above table useful?

Thanks,

Nicholas Chang

Edited by: Nicholas Chang on Dec 8, 2011 6:47 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 05:33 AM

    Hi,

    Please find explanation of the Mode 'P' as below:

    DDL Statements generated but processed in Basis conversion (Shadow upgrade)

    Guess these are inactive and hence shown here. You can go ahead and activate all these and continue with the updated.

    Regards,

    Srikishan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi All,

      I would like to share the finding of this problem:

      Although manually activate & adjust 300++ entries solved the problem and our upgrade completed successfully.

      I grease my elbow to investigate the root cause and finally, found out the possible culprit.

      In TP.SAV, there's an return code 212 when executing MVNTVIEW.TPP scripts:

      EXECUTING F:\EHPI\abap\exe\tp.exe pf=F:\EHPI\abap\bin\MVNTVIEW.TPP -Dbuffreset=no touch=no ddlntabs ddlmode=P protyear=06 tablow=PF tabhigh=U_275 BSB

      F:\EHPI\abap\tmp\SLOG702.LOC is already in use (4), I'm waiting 2 sec (20111208044652). My name: pid 22084 on HOSTNAME (bsbadm)

      F:\EHPI\abap\tmp\SLOG702.LOC is already in use (5), I'm waiting 2 sec (20111208044654). My name: pid 22084 on HOSTNAME (bsbadm)

      F:\EHPI\abap\tmp\SLOG702.LOC is already in use. Giving up after (6) tries because MAX_SEMAPHORE_WAIT is set. My name: pid 22084 on HOSTNAME (bsbadm)

      tp returncode summary:

      TOOLS: Highest return code of single steps was: 0

      ERRORS: Highest tp internal error was: 0212

      tp finished with return code: 212

      However, this error message wasn't catch and pass to EHPI, therefore, it assumed everything completed successfully and continue to the next stage. As a result, numbers of view weren't activate and still resided in table DDXTT.

      Appreciate if anyone from SAP can confirm is this a bugs? I'm using latest TP version - 720/107.

      Thanks,

      Nicholas Chang

  • Posted on Dec 12, 2011 at 08:31 AM

    bugs on TP ?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.