"Out of synchronization" warning for column that is not mapped

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
JFlanigan
Posts: 11
Joined: Thu 04 Aug 2016 13:32

"Out of synchronization" warning for column that is not mapped

Post by JFlanigan » Fri 16 Sep 2016 15:20

Recently, the width of a column in Salesforce was changed. The Salesforce Destination Component then warned of that column being "out of synchronization". The column is not mapped.

Why is the component tracking un-mapped columns? One of the features of Salesforce is that columns can be easily added. Will I have to be constantly monitoring all components because of possible unrelated changes?

Resolving the issue requires that I hunt down the differences (over time, there could be many) and make the required changes in the advanced editor. If a changed column is mapped, this is acceptable and expected.

Refreshing the component is not an acceptable solution. With the large number of column involved, re-mapping is tedious and error-prone and it is a serious software change that would require that the project go through full QA again, for basically no reason.

Yes, it is a warning and (probably) does not impact operation. However, the component only displays one warning at a time. I cannot ignore a warning that is for a column that is not mapped because how do I know that there is not a second warning waiting behind it that does involve a mapped column?

This useless and unwarranted dependency is no different than if someone on the other side of the world turns on a particular light switch which requires you to go around your house and flush all the toilets.

Regards,
John

Devart SSIS Data Flow Components v1.5.283 (Salesforce)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: "Out of synchronization" warning for column that is not mapped

Post by Shalex » Mon 19 Sep 2016 17:30

A similar issue (fixed) was discussed at viewtopic.php?f=38&t=34080.

Please upgrade to SSIS Data Flow Components v1.5.287 (01-Sep-2016): https://www.devart.com/ssis/download.html.

JFlanigan
Posts: 11
Joined: Thu 04 Aug 2016 13:32

Re: "Out of synchronization" warning for column that is not mapped

Post by JFlanigan » Tue 20 Sep 2016 12:33

Please open a ticket. Upgrading to the current version does not resolve this issue.

SSIS Data Flow Components v1.5.287

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: "Out of synchronization" warning for column that is not mapped

Post by Shalex » Fri 23 Sep 2016 14:51

JFlanigan wrote:Recently, the width of a column in Salesforce was changed. The Salesforce Destination Component then warned of that column being "out of synchronization". The column is not mapped.
We have reproduced the case and are investigating the possibility to turn off warnings related to unmapped columns.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: "Out of synchronization" warning for column that is not mapped

Post by Shalex » Mon 04 Sep 2017 12:16

Please set ValidateExternalMetadata=False in the properties of Devart Salesforce Destination to avoid generation of the warnings.

Post Reply