Skip to Content
-3

SAP TID is duplicate for two different transactions

Mar 16 at 03:36 PM

76

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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.

1

Ask your colleagues?

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Raymond Giuseppi SAP Mentor Mar 20 at 12:58 PM
3

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)

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Animesh Mohanty SAP Employee Mar 22 at 04:48 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Sandra Rossi Mar 17 at 08:52 AM
0

how do you generate this TID?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0