Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP TID is duplicate for two different transactions

Saru
Advisor
Advisor

‎03-16-2017 3:36 PM

0 Kudos

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.

8 REPLIES 8

Sandra_Rossi
Active Contributor

‎03-17-2017 8:52 AM

0 Kudos

how do you generate this TID?

Saru
Advisor
Advisor
In response to Sandra_Rossi

‎03-21-2017 5:27 AM

0 Kudos

Hi colleages,

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

SuhaSaha
Advisor
Advisor
In response to Sandra_Rossi

‎03-21-2017 8:54 AM

0 Kudos

It would be helpful if you could clarify "how" you generate this TID and not "what" is generated as the TID.

raymond_giuseppi
Active Contributor

‎03-20-2017 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)

Saru
Advisor
Advisor
In response to raymond_giuseppi

‎03-21-2017 5:27 AM

0 Kudos

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

matt
Active Contributor

‎03-21-2017 7:26 AM

SAP TID or SAP ITD? What's the context? What are the transactions?

If you want help, then you'll help yourself if you give complete details, and take care with spelling.

horst_keller
Product and Topic Expert
Product and Topic Expert

‎03-21-2017 8:27 AM

0 Kudos

Ask your colleagues?

Former Member

‎03-22-2017 4: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