Skip to Content
avatar image
-3
Former Member

SAP TID is duplicate for two different transactions

Hi ,

Any idea what are the possible scenarios where SAP TID can be duplicate & how we can fix the issue.

While executing a sap transaction an SAP TID is generated & it is stored in log database table as a primary key. Later on after 7 months ,for an other sap transaction the same SAP TID has generated which is causing primary key constraint issue.

Any solution on how we can fix it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 20, 2017 at 12:58 PM

    Are you refering to the TID returned by ID_OF_BACKGROUNDTASK or a similar FM, I don't think you can use it as primary key, look at a database like TRFCQOUT, SAP added other fields to create a unique key. (queue, RFC dest and a counter)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      We identified SAP TID AC19002F12705883B48233A7 is duplicate. First it was created on Sat Jan 21 2017 19:20:34 and another was created on Thu Feb 02 2017 17:24:00.

      any idea how to resolve or possible measure when does it occur

  • Mar 17, 2017 at 08:52 AM

    how do you generate this TID?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 04:48 AM

    Hello Sarish,

    As per note:1610630, if work process is restarted very quickly (t < 1s), duplicate entries might appear in the table.

    This occurs only on machines in which the work process restart requires less than one second if a large number of transactional RFCs are started and a work process is restarted at the same time.

    To rectify this you have to Set the profile parameter "rdisp/build_tid_millisec_based" to 1 in all instances of your system.

    Kindly refer the note for better assistance. Hope this will solve your issue.

    Regards,

    Animesh

    Add comment
    10|10000 characters needed characters exceeded