Microsoft KB Archive/327239

= You may receive an error message when you try to perform a drillthrough query or retrieve data from a writeback table =

Article ID: 327239

Article Last Modified on 11/21/2006

-

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 INFORMATION
This 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.

