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

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

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

Postby msigman » Wed Oct 26, 2011 3:26 pm

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

Code: Select all
Unable to cast object of type redgate.sqlcompare.engine.statistics to type redgate.sqlcompare.engine.relationalindex


Any ideas?
msigman
 
Posts: 8
Joined: Tue Jul 19, 2011 4:20 pm

Postby chriskelly » Thu Oct 27, 2011 4:59 pm

Can you confirm the version of SQL Doc and the version of SQL Server please?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby msigman » Thu Oct 27, 2011 5:00 pm

SQL Server 2008

SQL Doc 2 (Most recent release, downloaded & installed yesterday)
msigman
 
Posts: 8
Joined: Tue Jul 19, 2011 4:20 pm

Postby chriskelly » Thu Oct 27, 2011 5:07 pm

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

http://www.red-gate.com/messageboard/vi ... php?t=9983
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby msigman » Thu Oct 27, 2011 5:21 pm

It says that SQL Doc 2.1 is already installed. Apparently that patch comes pre-installed on the latest download.
msigman
 
Posts: 8
Joined: Tue Jul 19, 2011 4:20 pm

Postby hazelj » Wed Nov 02, 2011 3:57 pm

I am also having this issue - any fixes yet???
hazelj
 
Posts: 2
Joined: Wed Nov 02, 2011 2:58 pm

Also having the issue

Postby jfichera » Thu Nov 17, 2011 6:55 pm

Having the same problem

Trying to document SQL 2005 server
SQL Doc version 2.1.0.223
jfichera
 
Posts: 1
Joined: Thu Nov 17, 2011 6:54 pm

Postby chriskelly » Thu Nov 17, 2011 7:11 pm

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.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

fixed yet?

Postby zsbostonma » Mon Dec 05, 2011 9:08 pm

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?
zsbostonma
 
Posts: 1
Joined: Mon Dec 05, 2011 9:04 pm

Postby Brian Donahue » Tue Dec 06, 2011 11:27 am

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
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 1 guest