Dynamic JO Sync Issue when using Query Builder Source
I am finding that the new Dynamic JO for Advanced Programs is not syncing properly after I make changes to the Query.
I change the Query, Save and Sync, then review data but I still see values from prior iteration of the query changes and result set that says there is 2630 records. Even if I select Sync All, I do not see a new full replacement sync of the result set.
I end up having to go into Advanced Settings, and changing the Uniqueness criteria, syncing again, then changing the uniqueness back to what it was to get a full reset of the Sync. which results in 1209 records.
Before I enter this as a bug, is there something I am missing on how to force a full replacement sync?
Page 1 / 1
I had this same issue and submitted a support ticket late yesterday. No updates or additional details to share yet.
Hello Gainsight Admins!
This issue was identified as a bug; as of 3 hours ago, the fix has been applied to all affected Programs for US1, US2, & EU. Please check now to make sure you can sync your participants and makes changes to the Program!
We have been able to sync and issue does seem to be resolved. Yay!
Hi, @ebell
We are able to Sync all, but we still don’t see the data change reflected after adding a new filter criteria - still requires us to change the Uniqueness criteria to force the new data to display. Our bug report is still open.
We re-opened the ticket as well because we were seeing something similar when we cloned other programs and this is the last response we received but we have not tested yet.
“ ...it will not drop the previous participants that are brought in. You will either have to manually remove them and then re-sync or completely delete the source and rebuild it. Modifications to the query are only going to effect NEW participants being brought in, not existing ones that were already brought in from a previous sync.”
So I guess when cloning the system thinks the sync has already happened. But I still don’t understand why this would be the solution because in a new program you can edit and resync the query multiple times and it gives you a fresh participant list. (Unless I’m wrong, which worries me about other programs we have released.)
We’re just having problems troubleshooting the result set/participant list at this point. If I add a new filter or change the criteria I want to be sure my FULL result set/participant list looks good and if it doesn’t I want to be able to see where in the multiple query steps something went wrong. Think changing from North America to Europe or adding a new filter for Market, after you sync, you see a mix of old and new. Whereas before in the old JO we had the option to Sync and Replace the Full participant list. In addition, we can no longer see the result set of each step in the query in the Execution history and export it unless Im just missing it.
This is what I was told regarding this behavior, “This IS considered expected as making updates to the query and re-syncing will not remove participants that were already brought in unless you either delete the source as a whole or manually remove participants that were previously brought in.”
@dayn.johnson You’re more experience than me. Does this sound right to you?
Hi @ebell, could you please clarify this for me?
What Dynamic JO sources are you saying are able to be modified within an active program?
We have exactly ONE dynamic JO running (internal), with a query source (screenshot), and to make ANY changes to the query, I am REQUIRED to clone and start a new program, and find some way of excluding the prior participants. (which is made more difficult since I can’t just exclude based on email addresses or whether they received the email previously).
EDIT: here’s the idea about editing active dynamic JO queries:
I’ve begun rebuilding a higher-level source as a Data Design template (and Data Design) so I can bring that in and then apply the specific program filters in the audience menu, rather than in the query, but that’s also made more time consuming since you are unable to save existing query sources as a Data Design template.
I was following the big big issue (below) quite closely in the GGA community, but this sounds like a different issue, unless I’m misunderstanding.
Hello Gainsight Admins!
This issue was identified as a bug; as of 3 hours ago, the fix has been applied to all affected Programs for US1, US2, & EU. Please check now to make sure you can sync your participants and makes changes to the Program!
Response to @AdriP
For what it’s worth, while most of our current JOs (advanced) all run on multiple queries, I’m now thinking it might be in our best interest to develop a few higher-level audience DDs (all active users, new users, internal audience, etc.) and filter the DDs in the program, and then use a conditional evaluate step to time our different sends, rather than having individual queries within each program. That way if we need to make adjustments to our regularly recurring programs, we just update the DD or the audience filters in the active programs, rather than having to clone or make changes to every single active JO.
Hi everyone, Just wanted to let you know that I’ve informed our team internally on this discussion & they are looking into it.
If you ever had a profile with us, there's no need to create another one. Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.