Red Gate forums :: View topic - Unable to cast object of type redgate.sqlcompare.engine.stat
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

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

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
msigman



Joined: 19 Jul 2011
Posts: 8

PostPosted: Wed Oct 26, 2011 3:26 pm    Post subject: Unable to cast object of type redgate.sqlcompare.engine.stat Reply with quote

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

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


Any ideas?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Thu Oct 27, 2011 4:59 pm    Post subject: Reply with quote

Can you confirm the version of SQL Doc and the version of SQL Server please?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
msigman



Joined: 19 Jul 2011
Posts: 8

PostPosted: Thu Oct 27, 2011 5:00 pm    Post subject: Reply with quote

SQL Server 2008

SQL Doc 2 (Most recent release, downloaded & installed yesterday)
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Thu Oct 27, 2011 5:07 pm    Post subject: Reply with quote

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

http://www.red-gate.com/messageboard/viewtopic.php?t=9983
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
msigman



Joined: 19 Jul 2011
Posts: 8

PostPosted: Thu Oct 27, 2011 5:21 pm    Post subject: Reply with quote

It says that SQL Doc 2.1 is already installed. Apparently that patch comes pre-installed on the latest download.
Back to top
View user's profile Send private message
hazelj



Joined: 02 Nov 2011
Posts: 2

PostPosted: Wed Nov 02, 2011 3:57 pm    Post subject: Reply with quote

I am also having this issue - any fixes yet???
Back to top
View user's profile Send private message
jfichera



Joined: 17 Nov 2011
Posts: 1

PostPosted: Thu Nov 17, 2011 6:55 pm    Post subject: Also having the issue Reply with quote

Having the same problem

Trying to document SQL 2005 server
SQL Doc version 2.1.0.223
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Thu Nov 17, 2011 7:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
zsbostonma



Joined: 05 Dec 2011
Posts: 1

PostPosted: Mon Dec 05, 2011 9:08 pm    Post subject: fixed yet? Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Tue Dec 06, 2011 11:27 am    Post subject: Reply with quote

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_doc/sql_doc_2.1.0.242.zip
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group