topic How to order by StreamPosition in Qlik Replicate

How to order by StreamPosition

MoeE — Mon, 26 May 2025 02:19:13 GMT

Hi,

I'd like some advice on how to order the changes in a change table by the streamposition column, to find out the order of change events on the source.

We've tried ordering by the header__change_seq but this sometimes didn't convey the correct sequence of change events. For example, sometimes an insert record came after the update record.

This is an example of our streamposition value. I assume that the part to the left of the "|" is for the logstream, however I'm not sure exactly what each number represents.

3332;637844887646347750;20210612080418483693|00000005.8058f956.00000001.0001.01.0000:184334.179113.16

I know this part "00000005.8058f956" after the "|" is the SCN in hexadecimal format. But this is inconvenient for sorting as it needs to be converted to decimal first.

The value on the left side of the "|", "637844887646347750", looks to give a correct sequence of events when it is used to order. Does anyone know what this number represents? and also, if using this number to sort by the order in which events occurred on the source is a wise idea?

Kind regards,

Mohammed

Re: How to order by StreamPosition

DesmondWOO — Mon, 26 May 2025 03:56:42 GMT

Hi @MoeE ,

Thank you for reaching out to Qlik Community.

I could not find the details about the logstream position. Could you please create a support ticket?

Regards,
Desmond

Re: How to order by StreamPosition

MoeE — Tue, 27 May 2025 02:47:40 GMT

Hi Desmond,

Thanks. From my best guess. It looks like a change position from within the Logstream file. This is what I already know:

3332 - Logstream file number

20210612080418483693 - Logstream folder number

This is what I am assuming:

637844887646347750 - It could be the logstream change number for that change. This number would exist in the logstream file.

I will try to confirm this in a case. Thank you.

Regards,

Mohammed