Replication Failure

  • 16Views
  • Last Post 3 weeks ago
0
votes
Dexter Martin posted this 3 weeks ago

I am attempting to replicate data from a Dynamics 365 instance to a Azure SQL Server database. I also want to schedule the package to run every 30 minutes to get new or change data replicated.I am recieving the following error messages. The database and tables are already created on SQL Server. Is it better to allow Skyvia to create the tables and schema initially? Does Incremental Updates have to be selected in order for Skyvia to pick up changed or modified data?

Error: 1
Failed to get the schema from data source. Detailed error messages are: Invalid object name 'roletemplate'.

Error:2
Failed to get the schema from data source. Detailed error messages are: Invalid object name 'interprocesslock'.

Error
The source object 'accountleads' does not have 'modifiedon' column and cannot be used when the 'Incremental Updates' check box is selected.

In error number three the 365 Dynamics Entity does not use modifiedon at the field that records the changes. The record creation field is SinkCreatedOn and the date/time change value is saved in SinkModifiedOn. SinkModifiedOn is standard throughout the entire schema. How can I make Skyvia replication use SinkModifiedOn as the date the record has been changed? Also, to pick up new records Skyvia has to use SinkCreatedOn.

 

0
votes
Mariia Zaharova posted this 3 weeks ago

The database and tables are already created on SQL Server. Is it better to allow Skyvia to create the tables and schema initially? 

Yes, it is better to allow Skyvia to create initial tables. Skyvia replication will create tables identical to corresponding source tables (with corresponding names, data types, etc.). According to the errors you get, we recommend you to perform these steps:

- first, open your Dynamics CRM connection(s) in Skyvia and refresh its metadata cache:http://prntscr.com/krml2t

- edit your Replication package: select 'Drop Tables', 'Create Tables', 'Incremental Updates' options, reset the 'LastSyncTime' value in the Parameters section;

- check selected tables;

- save and run package.

 

Does Incremental Updates have to be selected in order for Skyvia to pick up changed or modified data?

Yes, the 'Incremental Updates' option is used for copying only the data that was changed in the cloud CRM since the last package execution. This option is available for objects that have createdonmodifiedon fields.

 

The source object 'accountleads' does not have 'modifiedon' column and cannot be used when the 'Incremental Updates' check box is selected.

Skyvia works via Dynamics CRM API. Please refer to: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/accountleads?view=dynamics-ce-odata-9

This table does not have createdon, modifiedon fields and fields you have mentioned (sinkmodifiedon, etc.). There is no way to change Replication so that it uses another fields for data changes tracking.

Close