Builtin "AD replication" search not work after upgrade

Question

Hi.&nbsp;We have OMS AD Replication Status solution, after the workspace upgrade, the solution shows generic visual information but when we want to search for more detailed info, all standard queries included break with an error like "A recognition error occurred. Token: "5". Position: 175."One of the searchs:ADReplicationResult | summarize arg_max(TimeGenerated, *) by&nbsp; SourceServer, DestinationServer, PartitionName, TenantId&nbsp; | where LastSyncResult != 0 and "PercentOfTSLRange == "Over 100 % TSL"" | sort by TimeGenerated desc&nbsp;That piece of search code:where LastSyncResult != 0 and "PercentOfTSLRange == "5-25 % TSL""The error is just before the bold letters.&nbsp;I've just now changed it to:where LastSyncResult != 0 and (PercentOfTSLRange == "5-25 % TSL")&nbsp;And it works, but I don't know if it is the best option, and I don't know why these "standard queries" included in the different solutions don't get correctly translated.&nbsp;Thanks in advance.Regards,Héctor&nbsp;

yossiy · Answer

A fix for the issue is being deployed.

joão henrique mortati fuzinelli · Answer

Hi Héctor,&nbsp;On the log search portal, we have a query conversor. Are you tried to use that to convert your old query?&nbsp;

héctor garcía de llano gonzález · Answer

Hi Joao.&nbsp;I've tried that conversion but it ends with an error in another position.Solution goes to modify the query to avoid nested quotes, but, again, this is not a query created by me, it is the standard query included in OMS.&nbsp;Regards,Héctor

ketan ghelani · Answer

We will look into the conversion issue.&nbsp; Are there other queries that were converted incorrectly.
Adding&nbsp;Dan Hadari and&nbsp;Noa Kuperberg

héctor garcía de llano gonzález · Answer

Hi.&nbsp;It happens with about 50% of all queries inside AD Replication Status Solution. I mean, when I click on AD Replication Status, it shows me 4 blocks (Source&nbsp;servers..., Destination servers..., Replication error types and Tomstone Lifetime):- If I click directly on the lower part of those blocks (i.e., on one of the servers in the list), then there is always an error in the query, I need to modify the query to quit nested&nbsp; quotes.- If I click on the upper part of those blocks (i.e., on the graphic of Tombstone Lifetime) and then click on one item of the list that it shows, there is no error, the query is OK.&nbsp;I hope this info will give you an idea to solve the conversion when you migrate this solution on another clients.&nbsp;Regards,Héctor&nbsp;

Forum Discussion

Builtin "AD replication" search not work after upgrade

6 Replies

Resources