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