GDI+ error when exporting large PDF

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

GDI+ error when exporting large PDF

Postby PCurd » Wed Mar 05, 2014 1:54 pm

When I export PDF Diagram I get the error "A generic error occurred in GDI+" and no PDF is produced. I've been able to export very large diagrams before (although not this particular diagram), but today it seems to be broken.

I can export the PDF Dependency List and that is 1090 pages long. The largest diagram I have been able to export before had a 897 page Dependency List so this isn't that much bigger.

Any ideas?
PCurd
 
Posts: 7
Joined: Wed Feb 20, 2013 4:41 pm
Location: United Kingdom

Postby eddie davis » Thu Mar 06, 2014 3:16 pm

Thank you for your forum post and sorry that you have encountered this problem.

The error indicates insufficient disk space but instead crashing with an error to indicate this, it errors out with the Microsoft error "A generic error occurred in GDI+".

By default SQL Dependency Tracker will create a number of temporary files in the Windows temp directory.

You can try setting a new system environment variable called RGTEMP and set the value to be a folder location with plenty of free disk space and then retry the export to pdf.

To set the environment variable:
1. Right-click on My Computer and choose Properties.
2.On the Advanced tab click the Environmental Variables button.
3.Then under User or System variables click New and give the variable name as RGTEMP and the variable value as the path you want the RGTEMP folder to be created.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby PCurd » Thu Mar 06, 2014 5:41 pm

Hi Eddie,

I have 102GB free disk space on the drive in question, I've set up the RGTEMP variable as suggested and opening the file produces around 260MB of files - 185 files. The GDI+ error still occurs and takes less than 2 seconds to come up after I choose a filename so I can't imagine it's chewing up 102GB of data and deleting it in that little time.

Is there anything else than could cause that error?

Thanks,
PCurd
 
Posts: 7
Joined: Wed Feb 20, 2013 4:41 pm
Location: United Kingdom

Postby eddie davis » Tue Mar 11, 2014 2:52 pm

Thank you for your reply.

I have added the details of this forum post to a Bug Report whose reference is DT-400 and requested that the SQL Dependency Tracker Product Manager review the report. Sadly I do not known when this bug will be fixed.

You are only second customer in 5 years to report this particular bug, previous report was in May 2009.

I will be maintaining what our Bug Tracking system calls a watch on the bug report submitted, which means I will be notified when a fix for the bug becomes available.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby PCurd » Tue Mar 11, 2014 3:18 pm

Thanks Eddie,

Let me know if I can provide more evidence etc.
PCurd
 
Posts: 7
Joined: Wed Feb 20, 2013 4:41 pm
Location: United Kingdom

Postby trankimanh89 » Wed Mar 26, 2014 3:41 am

@eddie davis: Thanks Eddie,

Your advises are very useful for me to over come this problem.
Tran Kim Anh
trankimanh89
 
Posts: 1
Joined: Wed Mar 26, 2014 3:33 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests