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:
Post a Comment