on 01-13-2014 12:56 PM
hi all,
my ecc6 ehp7 import appl sp2 error stop
rhel64+krnl741 sp13+oracle11203 sp201312+spam 7.40/0051
create/activate the view failed,se14 show the view Does not exist in the database
please guide,thanks
in the log show:
1 ETP199X######################################
1 ETP172 MOVE OF NAMETABS
1 ETP101 transport order : "ALL"
1 ETP102 system : "E6X"
1 ETP108 tp path : "tp"
1 ETP109 version and release : "380.09.46" "741"
1 ETP198
3 ETP399XMove Nametabs started in batch mode.
2 ETP399 processing modeflag 'A'
2 ETP301 ----------------------------------------------------------------------
2 ETP364 Begin: Act. of Shadow-Nametabs ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP338XActivation of Shadownametabs
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP365 "0" Shadow-Nametabs activated
3 ETP362 "0" Shadow-Nametab activations failed
2 ETP364 Begin: Act. of Shadow-Nametabs ("2014/01/13 20:40:44")
2 ETP366 End: Act. of Shadow-Nametabs ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP399 processing modeflag 'W'
2 ETP301 ----------------------------------------------------------------------
2 ETP347XActivation of Shadownametabs (delete) with DDL
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP368 "0" Shadow-Nametabs deleted, DDL executed
3 ETP369 "0" Shadow-Nametab deletions failed
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP399 processing modeflag 'X'
2 ETP301 ----------------------------------------------------------------------
2 ETP347XActivation of Shadownametabs (delete) with DDL
2 ETP301 ----------------------------------------------------------------------
2 ETP347XActivation of Shadownametabs (delete) with DDL
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP368 "0" Shadow-Nametabs deleted, DDL executed
3 ETP369 "0" Shadow-Nametab deletions failed
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP399 processing modeflag 'Y'
2 ETP301 ----------------------------------------------------------------------
2 ETP347XActivation of Shadownametabs (delete) with DDL
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP368 "0" Shadow-Nametabs deleted, DDL executed
3 ETP369 "0" Shadow-Nametab deletions failed
2 ETP367 Begin: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP370 End: Act. of Shadow-Nametabs (delete) with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP399 processing modeflag 'F'
2 ETP301 ----------------------------------------------------------------------
2 ETP330XActivation of Shadownametabs with DDL
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP361 "0" Shadow-Nametabs activated, DDL executed
3 ETP362 "0" Shadow-Nametab activations failed
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2014/01/13 20:40:44")
2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2014/01/13 20:40:44")
2 ETP301 ----------------------------------------------------------------------
2 ETP399 processing modeflag 'V'
2 ETP301 ----------------------------------------------------------------------
2 ETP330XActivation of Shadownametabs with DDL
2 ETP301 ----------------------------------------------------------------------
3 ETP379X20:40:44: activating Nametab "V_DSH_ASSIGNED":
3 ETP355Xstatements:
3 ETP399 CREATE VIEW "V_DSH_ASSIGNED" AS SELECT DD31S."SHLPNAME" AS
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 20:40:44: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED " - repeat
2EETP345 20:40:56: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen
2EETP345 t for "V_DSH_ASSIGNED "
2 ETP399 --------------- DB-ROLLBACK() ---------------
2EETP334 20:40:56: error in DDL, nametab for "V_DSH_ASSIGNED" not activated
3 ETP379X20:40:56: 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 20:40:56: Retcode 1: error in DDL statement for "V_DSH_TF_DETAIL " - repeat
2EETP345 20:41:08: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen
2EETP345 t for "V_DSH_TF_DETAIL "
2 ETP399 --------------- DB-ROLLBACK() ---------------
2EETP334 20:41:08: 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/01/13 20:40:44")
2 ETP363 End : Act. of Shadow-Nametabs with DDL ("2014/01/13 20:41:08")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP364 Begin: Act. of Shadow-Nametabs ("2014/01/13 20:41:08")
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
2 ETP338XTouch Load of nametabs
2 ETP301 ----------------------------------------------------------------------
2 ETP301 ----------------------------------------------------------------------
3 ETP365 "0" TouchLoad succeeded
3 ETP362 "0" TouchLoad failed
2 ETP364 Begin: TouchLoad of Nametabs ("2014/01/13 20:41:08")
2 ETP366 End: TouchLoad of Shadow-Nametabs ("2014/01/13 20:41:08")
2 ETP301 ----------------------------------------------------------------------
1 ETP172 MOVE OF NAMETABS
1 ETP110 end date and time : "20140113204108"
1 ETP111 exit code : "8"
Hi bbs,
As i faced same issue some days back with both views V_DSH_ASSIGNED and V_DSH_TF_DETAIL and was getting SQL error like as you are getting
Retcode 1: error in DDL statement for "V_DSH_ASSIGNED " - repeat
2EETP345 20:40:56: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen
2EETP345 t for "V_DSH_ASSIGNED "
2 ETP399 --------------- DB-ROLLBACK() ---------------
2EETP334 20:40:56: error in DDL, nametab for "V_DSH_ASSIGNED" not activated
3 ETP379X20:40:56: activating Nametab "V_DSH_TF_DETAIL":
For the resolution try to find any entries in table DDXTT and if you find any entries related to views V_DSH_ASSIGNED and V_DSH_TF_DETAIL then you need to remove both the entries for there.
Also you can navigate the link for more
Thanks,
Gaurav Rana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gaurav,
thanks a lot for the valuable reference.
We have 3 EHP7 systems. Two of them are on kernel 740 and with SP02.
They have no content in table DDXTT.
One of them is on kernel 741 and with SP01. It has in table DDXTT the two objects mentioned here.
When SP02 installing on it I got the other error about TP_FAILURE
File: SLOG1404.EEQ
ERROR ALL EEQ 6 0008
STOP tp_getprots EEQ P
STOP MOVE NAMETABS EEQ 6
ERROR: stopping on error 8 during MOVE NAMETABS
START INFORM SAP-SYSTEM OF EEQ Q
START tp_getprots EEQ Q
STOP tp_getprots EEQ Q
STOP INFORM SAP-SYSTEM OF EEQ Q
STOP imp all EEQ 0008
START imp all EEQ
INFO: event SAP_IMPORT_START triggered successfully
INFO TBATG CONVERSION OF EEQ N not needed
START MOVE NAMETABS EEQ 6
START tp_getprots EEQ P
ERROR ALL EEQ 6 0008
STOP tp_getprots EEQ P
STOP MOVE NAMETABS EEQ 6
and after following your reference I was able to proceed SP02 installation.
In addition our NW740 SP05 has no content in table DDXTT either.
Regards, Evgeniy
hi all,
sap reply has no solution for spam.but advise use sum.
will let you know if it works.
but has no time now.maybe do it after half month.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The view is not a normal view.
I've checked on my system and it shows as a generated view.
DDL SQL View.
I'm uploading a screenshot of the fields, but the help says that you cannot create this in SE11. It is created from compilation of ABAP DDL somewhere:
Message no. E2340
DDL SQL views are generated objects that are created from ABAP DDL source code. Direct changes to generated DDL SQL views are not possible with SE11 (Dictionary View Editor). In SE11, all change functions are deactivated for DDL SQL views.
The display of generated DDL SQL views is supported in SE11 to a limited degree only. This applies particularly to SQL features that are not within the function range of SE11, but can be used in ABAP DDL source code. Examples include UNION, UNION ALL, LEFT OUTER JOIN. The displayed information on generated DDL SQL views is possibly incomplete or unclear for these features.
Use the editor for ABAP DDL source code (part of the ABAP development tools in Eclipse) in order to change DDL source code. These changes are propagated to the generated DDL SQL view when the DDL source code is activated.
Sorry,I don't get your mean.
but these view can see in se11,in se11 show the warning.
Message no. E2302
This is a database view which is defined in the ABAP/4 Dictionary but does not exist on the database. No data can be read for this reason.
Information.
You can create the view on the database with the database utility (SE14). You can also activate the view again. The view is automatically created on the database in this case.
Message no. E2302
This is a database view which is defined in the ABAP/4 Dictionary but does not exist on the database. No data can be read for this reason.
Information.
You can create the view on the database with the database utility (SE14). You can also activate the view again. The view is automatically created on the database in this case.
but in se14,the create view function is gray as my previous post screen.
Thanks anyway.
I'd try to activate again,but
VIEW V_DSH_ASSIGNED activated
Check view V_DSH_ASSIGNED (DDIC/14-01-16/11:23)
Key field DD30L-AS4LOCAL missing
Key field DD31S-AS4LOCAL missing
All fields are evaluated as key field
View must be deleted from the database and created again
View V_DSH_ASSIGNED is consistent
will check it again
yes ,try reactivate.
VIEW V_DSH_ASSIGNED activated
Check view V_DSH_ASSIGNED (DDIC/14-01-16/11:23)
Key field DD30L-AS4LOCAL missing
Key field DD31S-AS4LOCAL missing
All fields are evaluated as key field
View must be deleted from the database and created again
View V_DSH_ASSIGNED is consistent
help is
Message no. MC763
In the view, not all of the mandatory fields were included as key fields. The key of the view therefore is not unique.
All the fields are regarded as key fields in order to guarantee that the key lengths are unique.
For views with a large number of fields, this could have a negative effect on the performance for the language construction described below. In this case, all the mandatory key fields should be included in the view.
The key information is relevant for the ABAP/4 language constructs SELECT SINGLE, SELECT ... ORDER BY PRIMARY KEY and SELECT ... FOR ALL ENTRIES.
In these cases, SELECT SINGLE is handled like a simple SELECT ... ENDSELECT, where the first (random) record found is returned.
ORDER BY PRIMARY KEY and (indirect) SELECT FOR ALL ENTRIES sort according to all fields in these cases.
Hi,
Have you seen this blog...
http://scn.sap.com/thread/610276
can you try to unlock the shadow system and make the adjustments and add the field.
Key field DD30L-AS4LOCAL missing
Key field DD31S-AS4LOCAL missing
1901463 - How to unlock the SAP system to perform correction(s) during an upgrade. |
If you cant proceed further you need to raise message with sap and see what they say.
Thanks
Rishi Abrol
Hi,
This is the first time i can to know that you are using SPAM .
My mistake it should haveasked you..
But read the below note.
1737650 - EHP7 for SAP ERP 6.0 SP Stacks - Release & Information Note
Installation and Upgrade Information
Check the below note.
1803986 - Rules to use SUM or SPAM/SAINT to apply SPs for ABAP stacks
From the above comments you can use only SUM toll not SPAM.
Thanks
Rishi Abrol
SUM doesn't just do the install.
It prepares the system by doing a lot of little tasks (such as dropping temporary objects etc), then does the import/upgrade, then does some post tasks.
It's possible that your import queue might be defined differently to how SUM would have done it, or there's a pre-requisite note/task that needs to be done, that SUM would have done for you.
It's just a lot easier with SUM (most of the time).
You need to find the code that uses that DDL SQL view, and try to re-activate/generate the code.
Regards,
Darryl
Hi,
rhel64+krnl741 sp13+oracle11203 sp201312+spam 7.40/0051
first of all I don't think kernel 741 is supported on EHp7 . I was aware it was 740 kernel.
Second thing if the table is present in sap and not in DB level please create it in SE14.
Thanks
Rishi Abrol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
checked with service.sap.com/pam.ehp7 supported krnl741:
Database Version | Operating System | Scope | Status | Valid from | Additional Information |
---|
ORACLE 11.2 64-BIT | LINUX REDHAT EL6/X86_64 64BIT | SAP KERNEL 7.41 64-BIT UNICODE maintained until 2020-12-31 | 2013-12-18 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes,can see in se11 and se14,but propt don't exist in db.
had check the link you provide,
updated tp &R3trans to sp14 and restart sap and db,but the error insist
and
se16,in table PUTTB_SHD search for "V_DSH_ASSIGNED" "V_DSH_TF_DETAIL" ,failed
BTW:The system is fresh install with the newest kernel 741
User | Count |
---|---|
83 | |
24 | |
12 | |
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.