cancel
Showing results for 
Search instead for 
Did you mean: 

Severe error in phase MAIN_NEWBAS/MVNTAB_UPG!

Former Member
0 Kudos

Hello All,

We are applying EHP3 on CRM installation on Mssql DB an Windows OS. We are on execution part in phase MAIN_NEWBAS/MVNTAB_UPG!

The sap is stop in this Phase I get this error:

"SHPOSITION", DD30L."AUTOSUGGEST" AS "AUTOSUGGEST" FROM "DD31S"

       3 ETP399 INNER JOIN "DD30L" ON "SHLPNAME" = "SUBSHLP" WHERE "AS4LOCAL" =

       3 ETP399 'A' AND "AS4LOCAL" = 'A' AND "HIDEFLAG" = ' ' AND "AUTOSUGGEST" = 'X'

       3 ETP399

       2WETP000 08:42:04: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED                " - repeat

       2EETP345 08:42:16: Retcode 1: SQL-error "209-Ambiguous column name 'SHLPNAME'." in DDL statement fo

       2EETP345 r "V_DSH_ASSIGNED                "

       2 ETP399  --------------- DB-ROLLBACK() ---------------

       2EETP334 08:42:16: error in DDL, nametab for "V_DSH_ASSIGNED" not activated

     

       3 ETP399 "TABCLASS", DD03L."SHLPORIGIN" AS "SHLPORIGIN" FROM "DD02L" INNER

       3 ETP399 JOIN "DD03L" ON "TABNAME" = "TABNAME" WHERE "AS4LOCAL" = 'A' AND

       3 ETP399 "AS4LOCAL" = 'A'

ETP301 ----------------------------------------------------------------------

3 ETP379X08:52:09: activating Nametab "V_DSH_ASSIGNED":

2 ETP399   >> Name of inactive nametab to read  : DDXTT

2 ETP399   >> Format of inactive nametab to read: 5.0

3 ETP355Xstatements:

3 ETP399 CREATE VIEW "V_DSH_ASSIGNED" AS SELECT DD31S."SHLPNAME" AS

3 ETP399 "SHLPNAME", DD31S."SUBSHLP" AS "SUBSHLP", DD31S."SHPOSITION" AS

3 ETP399 "SHPOSITION", DD30L."AUTOSUGGEST" AS "AUTOSUGGEST" FROM "DD31S"

3 ETP399 INNER JOIN "DD30L" ON "SHLPNAME" = "SUBSHLP" WHERE "AS4LOCAL" =

3 ETP399 'A' AND "AS4LOCAL" = 'A' AND "HIDEFLAG" = ' ' AND "AUTOSUGGEST" = 'X'

3 ETP399 

2WETP000 08:52:09: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED                " - repeat

2EETP345 08:52:21: Retcode 1: SQL-error "209-Ambiguous column name 'SHLPNAME'." in DDL statement fo

2EETP345 r "V_DSH_ASSIGNED                "

2 ETP399  --------------- DB-ROLLBACK() ---------------

2EETP334 08:52:21: error in DDL, nametab for "V_DSH_ASSIGNED" not activated

3 ETP379X08:52:21: activating Nametab "V_DSH_TF_DETAIL":

3 ETP355Xstatements:

3 ETP399 CREATE VIEW "V_DSH_TF_DETAIL" AS SELECT DD02L."TABNAME" AS

3 ETP399 "TABNAME", DD03L."FIELDNAME" AS "FIELDNAME", DD02L."TABCLASS" AS

3 ETP399 "TABCLASS", DD03L."SHLPORIGIN" AS "SHLPORIGIN" FROM "DD02L" INNER

3 ETP399 JOIN "DD03L" ON "TABNAME" = "TABNAME" WHERE "AS4LOCAL" = 'A' AND

3 ETP399 "AS4LOCAL" = 'A'

3 ETP399 

2WETP000 08:52:21: Retcode 1: error in DDL statement for "V_DSH_TF_DETAIL               " - repeat

2EETP345 08:52:33: Retcode 1: SQL-error "209-Ambiguous column name 'TABNAME'." in DDL statement for

2EETP345  "V_DSH_TF_DETAIL               "

2 ETP399  --------------- DB-ROLLBACK() ---------------

2EETP334 08:52:33: error in DDL, nametab for "V_DSH_TF_DETAIL" not activated

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

2 ETP362 "2" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2014/03/16 08:52:09")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2014/03/16 08:52:33")

2 ETP301 ---------------------------------------------------------------------

Any help the sap is Down in this phase.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Reza ,

How you doing.

There are several fix for the issue.First unlock the system as per the sapnote

1901463 - How to unlock the SAP system to perform correction(s) during an upgrade.

1. Use the latest TP and R3trans(sometimes it resolve the issue)

2. start the sap system

3. Run the transaction SE16n and enter DDXTT and execute it

    If any entry exist , then you need to delete it

4. Then run the transaction SE16n, enter DDXT and enter /h to bring it in Debug mode

     then use GD-EDIT & GD-SAPEDITwith value X to edit the table.(involve the developer team)

5. Then mark the entry and delete .

6. Save the changes

Reexecute the phase.

With Regards

Ashutosh Chaturevdi

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Also follow the below links

With Regards

Ashutosh Chaturvedi

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Also check the below thread to change the table

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi Ashutosh,

Thanks for reply. I am doing good, how are you?

As I told I am in execution Phase and SAP centrl instance is dowon. I tried to restart the full system.

But now I cannot see the shodow instance in SAPMMC. As I see the shadow instance is not running and I can not start that to make any change.  Strang. Any ide?

Thanks Again Reza

Reagan
Advisor
Advisor
0 Kudos

Hello Reza

You are in the downtime phase.

Please start the main system and unlock the system using the TP tool.

First try to activate the table and then repeat the phase.

If that doesn't help then remove the entry from the DDXTT table.

Regards

RB

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Thank you , am fine!

Do the same as suggested by . Yu will not find the shadow system in this phase.

Try to activate the view V_DSH_ASSIGNED and retry the phase.(most of the time it works)

With Regards

Ashutosh

Former Member
0 Kudos

Is it on client 000?

Thanka

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Yes

With Regards

Ashutosh

Former Member
0 Kudos

Hi,

When I try to remove  thw view from se11 I get this: SAP system has status 'not modifiable'

I have change the this for client 000 on TCO SCC4- But still the same-

How can deletete this view? Any idea?

Thanks

Reagan
Advisor
Advisor
0 Kudos

Change the system settings to modifiable in Tx SE06 - System Change Option

Regards

RB

Sriram2009
Active Contributor
0 Kudos

Hi Reza

Could you check this SAP Note

Error Message "SQL-error "209-Ambiguous column name 'TABNAME"

1793979 - Remote-DB framework: Missing table qualifier in where-clause


Regards

Sriram

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Run the transaction se03 and under administration label choose System Change option.

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

When I wante to deletete V_DSH_ASSIGNED view from SE11, that ask me for create Object Directory entry.

Can it made some problem leater  on during this execution phase. I am not sur abut this.

Thanks Again for help.

Reza

former_member185239
Active Contributor
0 Kudos

Hi Reza,

I don't have any idea of Object Directory. You can seek help from your developers.

Wait for few minutes for the other SCN members to reply though it wont make any problem hopefully

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Thanks Again for reply.

This installation is a sandbox a copy of production system.

When I try to deletete view I get this one.

former_member185239
Active Contributor
0 Kudos

Hi Reza,

You can save the changes with package $TMP.

It will keep the track of changes made to the objects.

Object Directory (SAP Library - Software Logistics)

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi Ashutosh,

Pleas see this:


former_member185239
Active Contributor
0 Kudos

Hi Reza,

Run the transaction se03

select Change Object Directory Entries and then look R3TR VIEW V_DSH_ASSIGNED

Now double click to check the package of it.

Please include developer team.

With Regards

Ashutosh Chaturvedi

former_member185239
Active Contributor
0 Kudos

Hi Reza,

Did you get the package?

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi Ashutosh,

No I didnot, I get this massage when I run se03 there is no object name- I cannot deletete this view from SE11.:(-

Thanks for reply

former_member185239
Active Contributor
0 Kudos

Hi Reza ,

I too checked in my system view V_DSH_ASSIGNED does not exit , you need to delete from sqlcmd or MSSQL database.

Logon to the database and delete the entry with the help of sql commad.

1. select count(*) from sj1.DDXTT where TABNAME='V_DSH_ASSIGNED'

    if any row exist for this then

2. delete from sj1.DDXTT where TABNAME='V_DSH_ASSIGNED'

4. commit

With Regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi Ashutosh,

Thanks for help, There was to entry in DDXIT table;

'V_DSH_TF_DETAIL' and 'V_DSH_Assigned' I could deletete this to from DB. Now I can continue.

Thanks for help

Reza

Reagan
Advisor
Advisor
0 Kudos

I do not agree with the suggestion to save the object to the $TMP package.

This is a wrong suggestion. The suggestion to delete the entry from the table DDXTT is the once should be done.

Regards

RB

former_member185239
Active Contributor
0 Kudos

Thank you for rectifying my mistake and Save the time for Former Member

I have learned a lot!!!

Thank you Former Member

With Regards

Ashutosh Chaturvedi

Answers (2)

Answers (2)

Reagan
Advisor
Advisor
0 Kudos

Why are you trying to delete the view from the ABAP dictionary using Tx SE11 ?

Connect to the database and execute this query.

select * from SAPR3.DDXTT where TABNAME='V_DSH_ASSIGNED';

Regards

RB

Former Member
0 Kudos

Hi Regards,

Thanks agin for reply,

Reza

Sriram2009
Active Contributor
0 Kudos

Hi Reza

Just restart the full system and retry again in the same phase

BR

SS

Former Member
0 Kudos

Hi Sriram,

Thanks for reply. I have done that but still the same.

Thanks

Sriram2009
Active Contributor
0 Kudos

Hi Reza

Could you check this SAP Note

1793979 - Remote-DB framework: Missing table qualifier in where-clause


Regards

Sriram