Red Gate forums :: View topic - Out of memory exception
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

Out of memory exception

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
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Wed Jun 10, 2009 11:17 am    Post subject: Out of memory exception Reply with quote

Hi,

just tried documenting our HR database and SQL Doc crashed in the documenting stage with an Out of memory exception.

Any requests on log files to track issue?

SQL Doc 2.0.0.733
Windows Vista Client
SQL 2005 Standard 64bit sp2 server
<2GB database and only scripting views and programmability
output chosen was .doc

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Thu Jun 11, 2009 3:36 pm    Post subject: Reply with quote

Thank you for your post and apologies you are having issues with SQL Doc.
Could you kindly let us know if trying the output in html format gives the same error?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Fri Jun 12, 2009 11:47 am    Post subject: Reply with quote

Hi Anu,

No, the html version is created completely and successfully.

regards

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Fri Jun 12, 2009 3:53 pm    Post subject: Reply with quote

Thanks for the update.

Could you kindly send us the log files for the error from the path:
C:\Documents and Settings\<User name>\Local Settings\Application Data\Red Gate\Logs\SQL Doc 2?

That will help us to investigate further.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
fatherjack



Joined: 13 Mar 2007
Posts: 224
Location: Cornwall

PostPosted: Fri Jun 12, 2009 4:25 pm    Post subject: Reply with quote

Hi Anu

I am sorry to say that I cant send you the requested file.

In the C:\Documents and Settings\allenj\Local Settings\Application Data\Red Gate\Logs folder I only have a folder called "SQL Response 1", there is no "SQL Docs 2" folder.

There is no folder by that name one level up either, there are however SQL Backup, SQL Compare, SQL Data Compare 7, SQL Dependency Viewer 2.0, SQL Prompt 3, SQL Prompt 4, SQL Refactor and SQL Response Client.

The only file on my PC with the name "SQL Doc 2" is the shortcut in C:\Documents and Settings\All Users\Start Menu\Programs\Red Gate

regards

Jonathan
_________________
-----------------------------------------
Senior DBA
Careers South West Ltd
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 661
Location: Cambridge

PostPosted: Fri Jun 12, 2009 4:54 pm    Post subject: Reply with quote

Hello Jonathan

Thanks for the update.

Ideally the file must exist on your machine.

Could you check if SQL Doc is installed on another drive?

As you should also have another folder named SQL Doc under program files where the actual application exists.

Can you kindly chekc th path of installation and also serach for log files?
with format SQL Doc 2-YYYY_MM_DD_HH_MM_SS_0 for eg. SQL Doc 2-2009_06_08_14_14_07_0 .

Thanks.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Thu Apr 29, 2010 11:41 am    Post subject: Reply with quote

Hi Jonathan

I just wanted to update this post for any other users experiencing an out of memory exception with SQL Doc when generating the documentation in Word format. This is a known issue with one of the third party components we use to generate the documentation with no suggestion as to when it might be fixed. It is logged in our tracking system with reference SDOC-1402. A possible workaround would be to generate individual documentation for each database. Alternatively, use HTML which does not exhibit the same behaviour.
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