problem with replication

  • 77Views
  • Last Post 2 weeks ago
0
votes
Gabriel Longarai posted this 4 weeks ago

There is a problem with replication. At the origin of CRM Dynamics there is information in the fields, but they are not being replicated in the PostgreSQL destination.

 

https://app.skyvia.com/#/76069/packages/123206

Attached Files

Order By: Standard | Newest | Votes
0
votes
Olena Romanchuk posted this 3 weeks ago

Hello Gabriel,

Kindly ask you for providing more details:
Could you please clarify if the problem is common for all the tables selected for replication?
Please provide us with export of one of the problem tables.

Thank you!

 

0
votes
Gabriel Longarai posted this 3 weeks ago

I noticed this problem only in that table "csh_analiseimovel".

In the attached image it is very clear which fields are not replicating the content of the data.

0
votes
Olena Romanchuk posted this 3 weeks ago

Please clear the metadata cache in the Dynamics connection, it should help.
If it doesn't help, please create the test export package of the source table which is not being replicated, 
and look if there are values in problem fields. 
If there are no values, please provide us with this package ID so that we could test it on our side.

0
votes
Gabriel Longarai posted this 3 weeks ago

I created an export package. And the problem also occurs, a column is empty.

https://app.skyvia.com/#/76069/packages/124140

 

0
votes
Olena Romanchuk posted this 3 weeks ago

Hello Gabriel, Thank you for providing the test package. Our development team is investigating the problem.
We will come back to you with the result. 

0
votes
Olena Romanchuk posted this 2 weeks ago

Hello Gabriel,

Our connector is using CRM SDK v9 as API to access Dynamics CRM data:
https://www.nuget.org/packages/Microsoft.CrmSdk.CoreAssemblies/   We performed test runs of your package and also noticed that two columns are absent in the results despite they are specified in the query.
These fields may be accessible only via user interface, not API because of custom access rights for them.
We suggest you to try to contact Dynamics support also to find out if the data for this columns should be returned through CRM SDK.

 

Close