Video Screencast Help

Table Generator Changes Are Not Available In Workflow Project

Created: 10 Apr 2013 | 3 comments

I recently added a new column to a database table that is used in a Workflow project.  I recompiled the Integration project to pick up the new column, which is now displayed in the Query preview pane as well as in the Selected columns list.  I then reloaded the Workflow project which includes the updated Integration project.  When I am in the Workflow project and review the properties of the database table object from the Integration project, the new column is not displayed.  I also tried adding the Integration to a different Workflow project (which did not previously use it) to see if the newly added column would be displayed.  It was not.   See the attached document for screen prints from the Integration project and the Workflow project.  Is there something special that needs to be done when adding a column to an existing table generator? 

Operating Systems:

Comments 3 CommentsJump to latest comment

reecardo's picture

This was a known issue that we fixed:

Date: Monday, April 02, 2012 9:19:21 AM
2736753 SQL Table generator component datatype doesn't update to include new columns even after multiple adjust definitions and recompiles.

This may/may not be in one of our rollups. Which version of WF are you using? If there's a need, you can contact Support and get it pushed down to the appropriate rollup version.

M Rutledge's picture

I am using Workflow Version 7.1.1460.1974  Do you know which version includes the fix?

reecardo's picture

From what I can tell, the SP2 rollup is the earliest version that has this fix (which will be 7.1.1600.*)