Wednesday, August 08, 2007

Errors in PageFlowInstanceStore.sql when installing DB for PageFlowQuickstart in WCSF



When trying to install PageFlowQuickstart.sql to create DB for the PageFlowQuickstart of WCSF I've encountered the following errors:



OSQL -S "localhost" -d "PageFlowPersistenceStore" -E -n -i "..\..\Blocks\PageFlow\Scripts\PageFlowInstanceStore.sql"
Msg 137, Level 15, State 2, Server localhost, Procedure pageFlow_DeleteInstance, Line 6
Must declare the scalar variable "@instanceId".
Msg 207, Level 16, State 1, Server localhost, Procedure pageFlow_GetLastRunningInstanceByCorrelationToken, Line 12
Invalid column name 'running'.
Msg 207, Level 16, State 1, Server localhost, Procedure pageFlow_GetInstanceByTypeAndByCorrelationToken, Line 6
Invalid column name 'InstanceId'.
Msg 137, Level 15, State 2, Server localhost, Procedure pageFlow_ChangeInstanceStatus, Line 8
Must declare the scalar variable "@Running".
Msg 137, Level 15, State 2, Server localhost, Procedure pageFlow_SetRunningInstanceForCorrelationToken, Line 24
Must declare the scalar variable "@instanceID".
Msg 207, Level 16, State 1, Server localhost, Procedure pageFlow_GetTypeByInstanceId, Line 9
Invalid column name 'InstanceId'.




If you're getting hit by this problem - here is the reason: whole SQL script is written in assumption that DB collation is case-insensitive.
Just fix the letters case ( @InstanceId instead of @instanceId , etc.) and you have it fixed.

No comments: