You may receive an error message when you try to perform a drillthrough query or retrieve data from a writeback table (327239)
The information in this article applies to:
- Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q327239 SUMMARY When you try to perform a drillthrough query or
retrieve data from a writeback operation by using a Microsoft SQL Server database as the
relational source, you may receive the following error message: Data source provider error. Statement(s) could not be
prepared.;42000;Cannot resolve collation conflict for equal to operation.;42000
An error occurred during attempt to get cell value. The error
message may occur if the collation sequence between the tempdb database is different from the user database that is used as the
OLAP data source. MORE INFORMATIONThis known issue occurs when the collation
sequence between the tempdb database and the user databases is different. When you run a
drillthrough query or a query against a writeback table, the number of
parameters that are passed in the query is evaluated. If the number of
parameters exceeds 2,000, a temporary table is created in the tempdb database, and the query is split. Because the tempdb database is built every time that SQL Server starts, the default
collation for the tempdb database is the same collation that is used for the model database. In situations where the collation sequence between the tempdb database and the user database is different,
the temporary tables that are created and stored in the tempdb database have collations that are different from similar objects
that are created in permanent tables. REFERENCESFor more information, see the "Mixed Collation
Environments" topic in SQL Server Books Online.
| Modification Type: | Major | Last Reviewed: | 10/22/2004 |
|---|
| Keywords: | kbinfo KB327239 kbAudDeveloper |
|---|
|