Last post Apr 23, 2006 02:57 PM by dancemax
Apr 11, 2006 09:00 AM|dxgb|LINK
I'm trying to get past stage DWR.10.
When I run the PwDbDeployment.bat script I eventually get the following message:
Msg 446, Level 16, State 9, Server DXSMOM01, Procedure spGetIMFActivity, Line 93
Cannot resolve collation conflict for equal to operation.
An error occurred. Unable to continue.
End of batch file.
Any idea what is going wrong here? :(
Thank you in advance,
Apr 11, 2006 05:58 PM|jjstreic|LINK
Apr 12, 2006 05:20 AM|dxgb|LINK
Apr 12, 2006 07:43 PM|ssallms|LINK
English (UK) will implement a sorting preference that is incompatible with PWDB. Please drop the database, set the language to be English (US) and reinstall.
Apr 18, 2006 12:10 PM|dxgb|LINK
Apr 23, 2006 12:34 PM|dancemax|LINK
I have the same error. Where do I have to add the collocate bit? Could you may post
Apr 23, 2006 02:57 PM|dancemax|LINK
Got how to fix this problem with the approach of dxgb. If you have this issue do the following steps.
Open the files spGetIMFActivity.sql and spIMFUsageProfile.sql and replace all lines wich contains
a.server = s.FullComputerName with a.server = s.FullComputerName COLLATE database_default
r.server = s.FullComputerName with r.server = s.FullComputerName COLLATE database_default
do a copy of your files!