Column 'Name' does not belong to table Schema Table

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

Column 'Name' does not belong to table Schema Table

Post by JFlanigan » Mon 08 Aug 2016 20:49

Devart Salesforce Lookup and Destination are configured to update a subset of fields in the Opportunity table. The package works without issues.

A column is added to the Opportunity table. The package fails with the following error:

Code: Select all

The component has detected potential metadata corruption during validation.
Error at Data Flow Task [Devart Salesforce Destination [101]]: System.ArgumentException: Column 'Name' does not belong to table SchemaTable.
   at System.Data.DataRow.GetDataColumn(String columnName)
   at Devart.SSIS.DestinationComponent.b()
   at Devart.SSIS.DestinationComponent.Validate()
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostValidate(IDTSManagedComponentWrapper100 wrapper)
The column "Name" is a standard field. The component does not reference it.

If I refresh and remap the columns, the package runs again.

This is very worrisome. Is the design of the devart components so brittle that adding/deleting a table column not referenced by the component will cause the component to fail?

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

Re: Column 'Name' does not belong to table Schema Table

Post by Shalex » Wed 10 Aug 2016 15:08

1. The name of the product you are using is "SSIS Data Flow Components", isn't it?
2. The version (x.x.x) of this product. You can check it via the Control Panel > All Control Panel Items > Programs and Features window.

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

Re: Column 'Name' does not belong to table Schema Table

Post by JFlanigan » Sat 13 Aug 2016 03:11

Yes, "SSIS Data Flow Components" version 1.5.247.

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

Re: Column 'Name' does not belong to table Schema Table

Post by Shalex » Tue 16 Aug 2016 12:06

Thank you for the report. We have reproduced the issue. We will notify you when it is fixed.

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

Re: Column 'Name' does not belong to table Schema Table

Post by Shalex » Fri 26 Aug 2016 14:19

The bug with throwing "Column 'Name' does not belong to table SchemaTable." after adding/removing columns via web interface is fixed (Salesforce). We will notify you when the corresponding public build of Devart SSIS Data Flow Components is available for download.

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

Re: Column 'Name' does not belong to table Schema Table

Post by Shalex » Fri 02 Sep 2016 15:53

SSIS Data Flow Components v1.5.287 (01-Sep-2016) are available for download: https://www.devart.com/ssis/download.html.

Post Reply