Full Transaction ID is not unique across days

[todd_szatkowski]

Hi, we used the article at

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-New-Header-Transaction-Full-I...

to implement the $AR_H_FULL_TRANSACTION_ID in our source table grabs from Oracle, but we were seeing behavior where we were getting the same transaction id from one day to the next. The Oracle database we were using does get refreshed nightly, but the transactions from day to day would be different.

Trying to understand how the same Full Transaction ID would come through on different days.

Thx.

[Heinvandenheuvel]

edit: I see that the OP creates a second topic just now which clarifies the use case some:  https://community.qlik.com/t5/Qlik-Replicate/Change-Sequence-Numbers-From-Oracle/td-p/2142138

Hmm, the AR_H_FULL_TRANSACTION_ID  does not yet appear in the main documentation and as such cannot be trusted IMHO.  Maybe it should be called "AR_H_FULLER_TRANSACTION_ID" with the caveat that it needs more to be truly unique. A date perhaps.

As you know the AR_H_TRANSACTION_ID is documented with the caveat. "The transaction ID is not guaranteed to be unique and therefore should not be used to create reports or any other operation that relies upon its uniqueness."

I know, this is all not very helpful. Maybe if you can define more clearly why you think you need AR_H_FULL_TRANSACTION_ID then someone in the community can possibly come up with an other/better solution?

Hein.

[john_wang]

Hello @todd_szatkowski ,

Oracle xid consists of three parts (XIDUSN, XIDSLOT, XIDSQN), the full xid is unique for the entire instance existence, Qlik Replicate provides two header variables, $AR_H_TRANSACTION_ID contains first two parts only. The enhanced header variable, $AR_H_FULL_TRANSACTION_ID contains the full xid, all 3 parts. Please take note the xid is different for each transaction, would you please elaborate "Full Transaction ID would come through on different days"? what's the expression of the xid? Any information is welcome.

A sample of the xid:

CC @Heinvandenheuvel 

Thanks,

John.