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.
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.
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.
For more information, see the "Mixed Collation
Environments" topic in SQL Server Books Online.