SAP_COLLECTOR_FOR_PERFMONITOR cancelled

[Former Member]

Hi All,

SAP_COLLECTOR_FOR_PERFMONITOR job is scheduled hourly but it is getting cancelled only twice a day for a specific time. rest of the schedule are running fine. Please suggest what could be the problem. Below is the ST22 dump log.

Error analysis

    An entry was to be entered into the table

     "\FUNCTION-POOL=SDBORA3\FORM=GET_SE_AGG_GE_HISTORY\DATA=TAB_HELP" (which

     should have

    had a unique table key (UNIQUE KEY)).

    However, there already existed a line with an identical key.

    The insert-operation could have ocurred as a result of an INSERT- or

    MOVE command, or in conjunction with a SELECT ... INTO.

    The statement "INSERT INITIAL LINE ..." cannot be used to insert several

     initial lines into a table with a unique key.

How to correct the error

    Probably the only way to eliminate the error is to correct the program.

    -

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "ITAB_DUPLICATE_KEY" " "

    "SAPLSDBORA3" or "LSDBORA3F02"

    "GET_SE_AGG_GE_HISTORY"

    If you cannot solve the problem yourself and want to send an error

    notification to SAP, include the following information:

    1. The description of the current problem (short dump)

       To save the description, choose "System->List->Save->Local File

    (Unconverted)".

    2. Corresponding system log

       Display the system log by calling transaction SM21.

       Restrict the time interval to 10 minutes before and five minutes

    after the short dump. Then choose "System->List->Save->Local File

    (Unconverted)".

    3. If the problem occurs in a problem of your own or a modified SAP

    program: The source code of the program

       In the editor, choose "Utilities->More

    Utilities->Upload/Download->Download".

    4. Details about the conditions under which the error occurred or which

    actions and input led to the error.

thanks for your help in advance.

Regards,

Shanthosh

[Former Member]

Hi

Go to ST22 AND open ITAB_DUPLIACTE_KEY dump search for monikey ,these monikeys are looks like DEF 652.

Note down all monikey entries you found in dump, go to ST03 Expand Collector and Performance DB in that Performance Database ,Monitoring Database then double click on contents and search for monikeys you found in dump , delete these monikey just by double clicking on that and save.

This will solve your problem.

Thanks

[former_member189797]

Hello Santosh,

Please check the Note 1064524.

1064524 - DB02 ITAB_DUPLICATE_KEY

Regards,

Gaurav

[ashish_vikas]

please try to find SAP Note for this problem.. there will be many notes for this.. search keywords:

    "ITAB_DUPLICATE_KEY" " "

    "SAPLSDBORA3" or "LSDBORA3F02"

    "GET_SE_AGG_GE_HISTORY"

as Notes will be depending on your system version and database. also check this note if it is valid for your system : Note 1260104 - DBACockpit: SAP_COLLECTOR_FOR_PERFMONITOR/ITAB_DUPLICATE_KEY

Best Regards

ashish