cancel
Showing results for 
Search instead for 
Did you mean: 

IMPORT_PROPER Error stop

Former Member
0 Kudos

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"

Accepted Solutions (1)

Accepted Solutions (1)

former_member182657
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi Evgeniy,

had check the table DDXTT,but empty.

and sap told me,

have to restore the system because SPAM queue cannnot be reset at the this point.

so,it done.

Thanks everybody.

will close the topic.

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Former Member
0 Kudos

se14 can't create or delete these view

former_member193518
Active Participant
0 Kudos

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:

Generated DDL SQL views are only supported in limited way by SE11

Message no. E2340

Diagnosis

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.

Procedure

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.

former_member193518
Active Participant
0 Kudos

Here's the second one mentioned in the log:

Former Member
0 Kudos

Sorry,I don't get your mean.

but these view can see in se11,in se11 show the warning.

View V_DSH_TF_DETAIL is not in the database

Message no. E2302

Diagnosis

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.

System Response

Information.

Procedure

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.

View V_DSH_ASSIGNED is not in the database

Message no. E2302

Diagnosis

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.

System Response

Information.

Procedure

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.

Former Member
0 Kudos

Hi,

did you try se13 and see if it helps or try to reactivate the view and see if it changes any thing.

Thanks

Rishi abrol

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Key field DD31S-AS4LOCAL missing

Message no. MC763

Diagnosis

In the view, not all of the mandatory fields were included as key fields. The key of the view therefore is not unique.

System Response

All the fields are regarded as key fields in order to guarantee that the key lengths are unique.

Procedure

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.

Notes

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.

Former Member
0 Kudos

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

former_member193518
Active Participant
0 Kudos

My meaning, is that you can't do anything to create these in the normal ABAP environment.
They are create during code activation.

Which version of SUM are you using for your upgrade?

Former Member
0 Kudos

hi,

I'm using spam install the patch but not sum.

Thanks

Former Member
0 Kudos

hi ,

seems spam has no shadow.

Thanks

Former Member
0 Kudos

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

    • You can find information about browser support in SAP note 1853989.
    • You want to upgrade from SAP ERP 2004 to EHP7 FOR SAP ERP 6.0 please see SAP note 1742750.
    • For the required component versions, see SAP Note 1818596.
    • Technical Usages - You can select the Technical Usages required to install or upgrade your solution. For more information, see SAP note 1818596.
    • You want to additionally install the Java components SAP-UCES or IS-R-SRS on an ERP Java system, please see SAP Note 1898253
    • Certain Support Packages can only be applied using the SUM tool. For more information please refer to SAP Note 1803986.
    • Additional Information on upgrading to EHP7 for SAP ERP 6.0 can be found in SAP note 1771467

Check the below note.

1803986 - Rules to use SUM or SPAM/SAINT to apply SPs for ABAP stacks


  • For SAP NetWeaver AS ABAP 7.40, when specific SP versions are part of the import queue, only SUM can be used

From the above comments you can use only SUM toll not SPAM.

Thanks

Rishi Abrol

Former Member
0 Kudos

hi,

Thanks for your post.

But I'd checked,if sapkb74005 or above need SUM,and would not proceed with spam.

but sap_appl2 is just require sapkb74004,and proceed with spam.

So,I think it support spam.

and your post note,I checked but no found useful info for the issue.

Thanks.

former_member193518
Active Participant
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi guy,

downgrade the kernel to 740 with latest level.

the error insist.

any advise will be appreciate.

Thanks.

Former Member
0 Kudos

checked with service.sap.com/pam.ehp7 supported krnl741:

Database Version

Operating System

Scope

Status

Valid from

Additional Information

 
ORACLE 11.2 64-BIT

maintained until

2018-01-31

:

LINUX REDHAT EL6/X86_64 64BIT

maintained until

2020-11-30

:

SAP KERNEL 7.41 64-BIT UNICODE

maintained until

2020-12-31

2013-12-18
Former Member
0 Kudos

Hi,

Last time when i say was not in the list and that is the reason i mentioned I was aware it was 740 kernel.


Thanks

Rishi abrol

Former Member
0 Kudos

hi

Are you able to see the view V_DSH_ASSIGNED  and V_DSH_TF_DETAIL  in SE14 ?

Also please see the following thread about a similar issue :

Thanks

RD

Rishi

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi

As you are able to see the same in SE14 , can you please create it in the DB .

Thanks

RD

former_member182034
Active Contributor
0 Kudos

hi bbs,

this error should be resolved after update the latest TP and R3trans.

Regards,

Former Member
0 Kudos

I'd try the lastest TP and R3trans,But error insist.

thanks anyway.