| Author |
Message |
msigman
Joined: 19 Jul 2011
Posts: 8
|
 Posted: Wed Oct 26, 2011 3:26 pm Post subject: Unable to cast object of type redgate.sqlcompare.engine.stat |
 |
|
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 |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
|
| Posted: Thu Oct 27, 2011 4:59 pm Post subject: |
|
|
Can you confirm the version of SQL Doc and the version of SQL Server please?
_________________
Chris Kelly
Technical Support Engineer |
|
| Back to top |
|
|
msigman
Joined: 19 Jul 2011
Posts: 8
|
| Posted: Thu Oct 27, 2011 5:00 pm Post subject: |
|
|
SQL Server 2008
SQL Doc 2 (Most recent release, downloaded & installed yesterday) |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
|
|
| Back to top |
|
|
msigman
Joined: 19 Jul 2011
Posts: 8
|
| Posted: Thu Oct 27, 2011 5:21 pm Post subject: |
|
|
| It says that SQL Doc 2.1 is already installed. Apparently that patch comes pre-installed on the latest download. |
|
| Back to top |
|
|
hazelj
Joined: 02 Nov 2011
Posts: 2
|
| Posted: Wed Nov 02, 2011 3:57 pm Post subject: |
|
|
| I am also having this issue - any fixes yet??? |
|
| Back to top |
|
|
jfichera
Joined: 17 Nov 2011
Posts: 1
|
| Posted: Thu Nov 17, 2011 6:55 pm Post subject: Also having the issue |
|
|
Having the same problem
Trying to document SQL 2005 server
SQL Doc version 2.1.0.223 |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 251
Location: Cambridge, UK
|
| Posted: Thu Nov 17, 2011 7:11 pm Post subject: |
|
|
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 |
|
|
zsbostonma
Joined: 05 Dec 2011
Posts: 1
|
| Posted: Mon Dec 05, 2011 9:08 pm Post subject: fixed yet? |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6345
Location: Red Gate Software
|
| Posted: Tue Dec 06, 2011 11:27 am Post subject: |
|
|
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
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
