Unable to cast object of type redgate.sqlcompare.engine.stat

msigman

Attempting to generate documentation, receiving this error after the Documenting phase:

Unable to cast object of type redgate.sqlcompare.engine.statistics to type redgate.sqlcompare.engine.relationalindex

Any ideas?

chriskelly

Can you confirm the version of SQL Doc and the version of SQL Server please?

msigman

SQL Server 2008

SQL Doc 2 (Most recent release, downloaded & installed yesterday)

chriskelly

Can you try installing the patch detail on this forum post:

http://www.red-gate.com/messageboard/vi ... php?t=9983

msigman

It says that SQL Doc 2.1 is already installed. Apparently that patch comes pre-installed on the latest download.

hazelj

I am also having this issue - any fixes yet???

jfichera

Having the same problem

Trying to document SQL 2005 server
SQL Doc version 2.1.0.223

chriskelly

Thank you for your posts.

Basically SQL Doc is suffering from a small change in the SQL Compare engine which it uses to gather data about the schema. The development team now believe that they know what the problem is so hopefully there will be a fix soon (although i cannot say when at the moment).

A possible workaround which has helped another user (to an extent) is to remove any manually created statistics and then SQL Doc 'should' be able to successfully document the schema. While I know that this is in no way ideal, hopefully it will only be required in the short term.

zsbostonma

I just downloaded this product and the first time i use it i get this error.
Also what does it mean to remove manual statistics?

Brian Donahue

We had just fixed this yesterday and have a patch for it. DO NOT install this patch unless you have the problem above! Thanks.
ftp://support.red-gate.com/patches/sql_ ... .0.242.zip