BigQuery/GA4, all events since this morning have the same bundle sequence id

[khookssharpimg]

Hello. We're trying to track down what seems like a bug with GA4/BigQuery. In our intraday tables for today, nearly every record has the exact same bundle sequence id.

Any ideas what could be causing this? Do we need to reach out to Google?

This has been over 50,000 events that this hasn't changed, over thousands of sessions.

Edit: I figured out the cause at least, Google is using a 32 bit number to store the bundle sequence id, and they have run out of numbers at 2147483647 event bundles. This is almost definitely a Google/GA4/BigQuery issue and they need to fix this (increase to 64 bit number?)

Edit #2:

They fixed it now, they switched over to a 64 bit integer.

[magray]

Also have this issue. Did you ever find an answer? I can't find anything regarding it being a bug and if it will be fixed. It broke a lot of my logic I use for reporting.

[khookssharpimg]

I figured out the cause at least, Google is using a 32 bit number to store the bundle sequence id, and they have run out of numbers at 2147483647 event bundles.

[magray]

Thank you for posting the issue.

Good job, Google. Hopefully someone on their end sees this so it can get fixed. I have a workaround in place, but, come on...

[khookssharpimg · Accepted solution]

They fixed it now, they switched over to a 64 bit integer.

[mesakov]

Has anyone ever heard what is going on with all events since this 5-19 have the same bundle sequence id ?????

[khookssharpimg]

Nope I'm still sitting around waiting for some kind of explanation. I put an issue in with Google at the same time as I made this post, but there is no issue tracking system so I have no idea if they're even looking into it.

[magray]

I found a workaround for my purposes. If you are using the event bundle sequence id as a way to distinctly count the events, you can use a combination of user_psuedo_id and timestamp to do the same thing. The distinct counts should come out the same as when event bundle sequence id was unique.