Records Not Updating

  • 118Views
  • Last Post 13 June 2017
0
votes
Kelvyn Deoleo posted this 07 June 2017

I'm having issues syncronizing one table of my sets. I update the records, create new ones but the records show no updates and the records not appears in the CRM. see attached files.

Attached Files

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 08 June 2017

Most likely, you SQL Server database table doesn't have autogenerated primary key.

The main requirement for synchronizing database data is that the primary key columns of the database tables must be autogenerated.

Please refer to: https://skyvia.com/resources/docs/index.html?synchronization_overview.htm

0
votes
Kelvyn Deoleo posted this 08 June 2017

I made the corrections suggested but still have the same symptoms. This is converting in an urgent issue. See attached screens.

0
votes
Mariia Zaharova posted this 09 June 2017

Open your package, click Edit and reset the LastSyncTime value in the Parameters section. Save the changes and run the package again. What is the result?

0
votes
Kelvyn Deoleo posted this 09 June 2017

I don't want to duplicate the records, the last time I did that all the records was duplicated.

0
votes
Kelvyn Deoleo posted this 09 June 2017

I did it but the records doesnt sync. cero records updated/ 200 failed cause doesnt have one field resolution correct but this ones arent impacting me, the ones is impacting me is the 12k thats not replicating.

0
votes
Kelvyn Deoleo posted this 11 June 2017

The system is working from target to source but is not working from source to target. any help? this is becoming urgent.

0
votes
Simon Bubnov posted this 13 June 2017

A Synchronization package synchronizes data between a source and a target in both directions. When synchronization is performed for the first time, it does not check whether the records in sources are identical and simply copies data from one side to another and vice versa, and "maps" the original records to their copies in another source. During subsequent synchronizations, if a record is modified or deleted in one source, Skyvia modifies or deletes the data, mapped to this record in another source, and vice versa.

 

If a record synchronization fails when a synchronization is performed for the first time or after resetting LastSyncTime parameter, the changes, made to this record, won’t be detected and synchronized during the subsequent package runs. However, if you add a new record to one of the sources, the next package run will add it to another source.

 

We have studied your package. You use constant mapping with the value "true" for the SourceCRM field in the target to source mapping. You have also selected "Use this value as filter of target records" check box. This means, that when you add a new record or change an existing one in the SQL Server table and the SourceCRM is not equal to true, this record won't be synchronized. A tracking table will have a value for this record, but the package filter will filter out this row. For more information, please refer to https://skyvia.com/resources/docs/index.html?constant_mapping.htm

 

Please make sure that you set true for the SourceCRM column when you add a new value to the SQL Server table.

Close