Upgrades Questions on upgrading to version 7.x.
Version 7.x > Upgrades > Upgrade to & SQL error: Failed to run SQLscript: Invalid column name 'ConnectorLastModified'. View modes: 
User avatar
Member
Member
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'.

User avatar
Kentico Support
Kentico Support
kentico_radekm - 1/12/2014 4:35:09 AM
   
RE:Upgrade to & SQL error: Failed to run SQLscript: Invalid column name 'ConnectorLastModified'.
Hello.

Does it help when you run upgrade SQL script directly over your DB in SQL Management studio?

Could you please check your KCMS 6.0 DB whether it contains Integration_Connector table? How many columns are there? Does it contain ConnectorLastModified column? If not, can you write me all columns it contains in your DB?

Also, were you using any custom connector in your KCMS 6.0? Thank you.

Best Regards,
Radek Macalik

User avatar
Member
Member
Snarrak - 2/20/2014 8:51:53 AM
   
RE:Upgrade to & SQL error: Failed to run SQLscript: Invalid column name 'ConnectorLastModified'.
SQL Script was expecting the ConnectorLastModified column, I added the column to the table (with type datetime) and ran the SQL script mnnaually, no issues.

Thanks