Support package update error

[former_member459694]

Dear all,

I am currently update my system.

The current version is ECC6 EHP7 based on NW7.4

SAP_BASIS 740 0002

SAP_ABA 740 0002

I would like to upgrade to SPS level 5

We use DB2 LUW 10.5

In the update phase, we encountered an error message:

SQL-error "-203-SQL0203N  A reference to column "TABNAME" is ambiguou

2EETP345 s.  SQLSTATE=42702" in DDL statement for "V_DSH_TF_DETAIL

As I can see  in the log file, error messages are as below

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

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 06:42:38: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED                " - repeat

2EETP345 06:42:50: Retcode 1: SQL-error "-203-SQL0203N  A reference to column "SHLPNAME" is ambiguo

2EETP345 us.  SQLSTATE=42702" in DDL statement for "V_DSH_ASSIGNED                "

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

2EETP334 06:42:50: error in DDL, nametab for "V_DSH_ASSIGNED" not activated

3 ETP379X06:42:50: 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 06:42:50: Retcode 1: error in DDL statement for "V_DSH_TF_DETAIL               " - repeat

2EETP345 06:43:02: Retcode 1: SQL-error "-203-SQL0203N  A reference to column "TABNAME" is ambiguou

2EETP345 s.  SQLSTATE=42702" in DDL statement for "V_DSH_TF_DETAIL               "

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

2EETP334 06:43:02: 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/19 06:42:38")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2014/03/19 06:43:02")

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

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

2 ETP364 Begin: Act. of Shadow-Nametabs ("2014/03/19 06:43:02")

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

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

2 ETP338XTouch Load of nametabs

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

I have checked another system which is also ehp7 based on NW740 0005, the view "V_DSH_TF_DETAIL" totally doesn't exist, but that is oracle database, here in my case is DB2 database, I have searched for SAP OSS but seems no sap notes for it.

Do you have any idea how to solve this problem? Big thanks!

Best regards,

Fresh man

[Former Member · Accepted solution]

Hi Fresh man,

Have you checked for dependencies?

Thanks,

Dheeraj

[former_member185239 · Accepted solution]

Hi Dheeraj,

You need to delete the entry of V_DSH_TF_DETAIL from DDXTT table.

To resolve the issue.

With Regards

Ashutosh Chaturvedi

[former_member185239 · Accepted solution]

Hi Fresh,

You need to delete 'V_DSH_TF_DETAIL' and 'V_DSH_ASSIGNED from DDXTT table

Also checked the thread.

With Regards

Ashutosh Chaturvedi

[former_member459694 · Accepted solution]

Hi Ashutosh,

Many thanks for your reply, yes this definitely solve my problem.

But I feel quite confused what's the real reason.

Several weeks ago, I update a system (EHP7+Oracle) from 74002 to 74005, with SUM, no such problem, however this time, its EHP7+DB2 10.5, from 74002 to 74004, with SPAM, met this kind of problem...

The support packages are totally the same...

is it because I should upgrade from 02 to 05 directly? 04 has problem?

or I should update with SUM instead of SPAM?

or it is because of DB2??

or I should involve other packages like something like ST into the update queue?

Best regards,

Fresh

[former_member185239 · Accepted solution]

Hi Fresh Man,

Happy that it has resolved your error.

I think ,there is some problem with SP04 only. This is the solution what sap has provided.

If you want to know much more about this wait for other members to reply and also raise a message with SAP as we are facing the issue with SP04 only.

With Regards

Ashutosh Chaturvedi

[former_member185239 · Accepted solution]

Dear Fresh Man,

Mark the thread as answered.

With Regards

Ashutosh Chaturvedi

[former_member459694 · Accepted solution]

Sure..Big thanks

[Sriram2009]

Hi

Refer the link with same error message

BR

SS

[Reagan]

This was discussed couple of days ago.

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

Remove the entry from the DDXTT table and repeat the phase.

Regards

RB