| 
                                                                            
                                                                                Snarrak
                                                                            - 
                                                                                1/8/2014 2:37:57 PM
                                                                            
                                                                         
                                                                        Upgrade to & SQL error: Failed to run SQLscript: Invalid column name 'ConnectorLastModified'. 
                                                                            Hi all,
 Running the upgrade from version 6 to 7 via KIM raises the error below when the SQL script is executed.
 
 How can I resolve this error?
 
 ALTER VIEW [View_Integration_Task_Joined]
 AS
 SELECT     Integration_Synchronization.SynchronizationID, Integration_Synchronization.SynchronizationTaskID,
 Integration_Synchronization.SynchronizationConnectorID, Integration_Synchronization.SynchronizationLastRun,
 Integration_Synchronization.SynchronizationErrorMessage, Integration_Synchronization.SynchronizationIsRunning, Integration_Connector.ConnectorID, Integration_Connector.ConnectorName,
 Integration_Connector.ConnectorDisplayName, Integration_Connector.ConnectorAssemblyName, Integration_Connector.ConnectorClassName,
 Integration_Connector.ConnectorEnabled, Integration_Connector.ConnectorLastModified, Integration_Task.*
 FROM         Integration_Synchronization RIGHT OUTER JOIN
 Integration_Task ON Integration_Synchronization.SynchronizationTaskID = Integration_Task.TaskID INNER JOIN
 Integration_Connector ON Integration_Synchronization.SynchronizationConnectorID = Integration_Connector.ConnectorID
 
 Failed to run SQLscript: Invalid column name 'ConnectorLastModified'.
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |