Skip to Content

SPAM error in IMPORT_PROPER

Good afternoon,

I am applying a SPS in an ECC system with SPAM.

I have the following error in phase IMPORT_PROPER:
The import was stopped, since an error occurred during the phase
IMPORT_PROPER, which the Support Package Manager is unable to resolve
without your input.

After you have corrected the cause of the error, continue with the
import by choosing Support Package -> Import queue from the initial
screen of the Support Package Manager.

The following details help you to analyze the problem:


- Error in phase: IMPORT_PROPER

- Reason for error: TP_STEP_FAILURE

- Return code: 8

- Error message: OCS Package SAPKH61712, tp step "I", return code

Could you help me to diagnose the root cause of the problem?

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Good afternoon,

    In order to better describe the problem, I have found the following error:

    1 duplicate key error during insert into table EDOPROCSPINTDET occured

    In the DB there are the following indexes:

    EDOPROCSPINTDET~0 & EDOPROCSPINTDET~00.

    In DDIC, there is 001 index without index name.

    Thanks in advance for your help.

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 10, 2017 at 06:30 AM

    Good morning,

    Deleting the ~00 index in the DB has fixed the problem:

    SQL> drop index sapsr3."EDOPROCSPINTDET~00";

    But there is still the ~001 index in DDIC and not in DB.

    There I have to do the post processing, after the SPAM.

    With FM DB_DROP_INDEX, I can not enter EDOPROCSPINTDET~001

    because it is one character too long.

    Have you succeeded to perform this on your side?

    Can I delete this ~001 index during working hours on a productive system?

    What are the possible impacts of deleting this index during production?

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 30, 2017 at 08:12 AM

    Hi Benoît,

    could you please check the note 2354221 and follow the instructions to solve the issue?

    Cheers,
    Andreas

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I guess this a custom Index created on the table, anyway editing index in production system during business hours is always a risky task. As such this task utilizes lot of resources and can impact system (performance issue).

      I would suggest you to perform this activity after business hours or may be in weekends.

      Regards,

      Prithviraj