on 03-16-2014 8:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reza
Just restart the full system and retry again in the same phase
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Reza
Could you check this SAP Note
1793979 - Remote-DB framework: Missing table qualifier in where-clause
Regards
Sriram
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.