Zak Cole
Forum Replies Created
-
Posts
-
Hi John,
We realize that this a very large disk requirement but we have it in place because of the wide range of functionality of the Replicator Agent. Our customers have the ability to create very detailed logs and combining that with the Agent’s ability to process millions of records quickly and any other options the customer enables, it can add up. So we ask that you have 100 Gb disk space because failure to create these giant logs could cause the agent to fail, which could be very hard to recover from.
In short we have that requirement just in case, and to prevent customers from losing records.
Thanks!
JosephNot sure is you’ve seen this documentation, but you can get discrepancy check using table compare
https://docs.perspectium.com/display/fluorineplus/Table+Compare
And if checking between servicenow instances (InstanceSync), you can also generate a list of sys_id’s missing locally and automatically create a bulk share for it https://wiki.perspectium.com/doku.php?id=replicator_table_compare
David
That was for quick smaller lists. I later ran into tables that were missing 200k records. The script is not so good for that many. I created an import table and transform map that allowed me to populate the table a little quicker.
If I want to check my queues, I use this link:
<instance name>.service-now.com/perspectium_queue_status.doIt shows my queues and current number of messages in them.
There are a few questions we have:
Do you have any insert triggers in your sys_audit table in your database?
And do you have dynamic shares set up for sys_audit table directly?We suggest try running multiple agents, one for sys_audit table specifically and another for other tables.
Hi abcw460,
We currently support up to SQL Server 2017 on the Carbon Replicator Agent, so there should be no problem with your update to 2014.
Hi NeoDUnn,
Because Replicator is a native app, it is aware and can filter on the sys_domain field of each record to push the appropriate record to the appropriate warehouse.
By default, the data collection is executed using queryNoDomain and can see all records in all domains for you to use the filter.
Click “Get Started” and have one of our solution architects show you how easy it is.
Cheers,
David
