|Anonymous | Login||2017-11-23 04:28 EST|
|Main | My View | View Issues | Change Log | Roadmap | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002309||graphviz||Dot||public||2013-07-22 11:32||2014-06-11 17:17|
|Platform||Windows||OS||7||OS Version||Service Pack 1|
|Summary||0002309: Dot.exe freezes when using SchemasSpy 5.0.0 and force-metadata-jdbc-driver-2.2|
|Description||I am currently using SchemasSpy, the force-metadata-jbdc-driver, and Graphviz to draw ERD diagrams for a series of custom objects in Salesforce.com. When I launch SchemaSpy through the command prompt, the dot.exe application occasionally freezes when trying to draw 1-degree and 2-degree relationship diagrams and output them as PNG files. |
What's interesting is that dot.exe freezes on the same objects every time I run SchemaSpy. Furthermore, I can kill dot.exe within the task manager, and SchemaSpy and Graphviz will continue drawing the remaining diagrams, unless it gets held up on another object, upon which I must kill dot.exe in the task manager once again.
After SchemaSpy finishes running, any object that caused dot.exe to freeze will not have any diagrams saved.
Killing dot.exe does generate an error message, which I've listed below. Also, regarding the objects that cause dot.exe to free, they are simple in nature and consist of a simple parent/child relationship. There are no self references or anything that I could see causing an infinite loop to crash dot.exe. Finally, these same objects are successfully drawn in the overall summary ERD diagram that draws the relationships between every object in Salesforce, so I'm not sure why the diagrams would fail when focusing on the objects individually.
|Steps To Reproduce||Launch SchemasSpy from the command prompt: |
java -cp schemaSpy_5.0.0.jar;force-metadata-jdbc-driver-2.2.jar net.sourceforge.schemaspy.Main -t force -u myusername -p mypassword -font Arial -fontsize 8 -hq -norows -o doc -db na14 -desc "Extracted from na14 on Force.com"
|Additional Information||Here is the error message I receive whenever I use the task manager to kill the dot.exe file|
Using database properties:
ForceMetaDataDriver: Filter [exclusionNames=[user], inclusionNames=, keepCusto
Gathering schema details................(10sec)
'dot -Tpng:cairo doc3\diagrams\Candidate__c.1degree.dot -odoc3\diagrams\Candidat
e__c.1degree.png -Tcmapx' failed with return code 1
.......net.sourceforge.schemaspy.util.Dot$DotFailure: 'dot -Tpng:cairo doc3\diag
rams\Position__c.1degree.dot -odoc3\diagrams\Position__c.1degree.png -Tcmapx' fa
iled with return code 1
Wrote relationship details of 13 tables/views to directory 'doc3' in 32 seconds.
View the results by opening doc3\index.html
|Tags||No tags attached.|
|Attached Files|| Candidate__c.1degree.dot [^] (6,764 bytes) 2013-07-22 11:49|
Candidate__c.2degrees.dot [^] (7,938 bytes) 2013-07-22 11:50
Is there some way you can preserve that input file to dot and attach it to this report?
|Hi ellson. I've attached both .dot files that should have corresponding .PNG files created.|
I can process these files without error using:
dot - graphviz version 2.31.0 (20130719.1336)
on Fedora, so it sounds like either a recent fix, or a Windows issue.
We had another report last week that turned out to have been fixed recently.
Could you try updating to the latest nightly snapshot from:
|I downloaded and extracted graphviz-2.31.20130722.zip. I reran SchemaSpy but the dot.exe got help up again on my Candidate object in Salesforce. I compared the new Candidate dot files with the old ones, but they were the same.|
|I've also attempted to install the latest snapshot MSI file instead of the Zip file, but the dot.exe freezing still occurred.|
|I somehow missed this bug or it slipped my mind. In any case, we have gone from 2.31 to 2.38, and I have no trouble running 2.38 dot on either of your files in a Windows environment. If possible, please try upgrading again. And make sure SchemaSpy is picking up the newest version. Sometimes applications get set to an older version.|
|2013-07-22 11:32||mikeyjamjams||New Issue|
|2013-07-22 11:47||ellson||Note Added: 0000392|
|2013-07-22 11:49||mikeyjamjams||File Added: Candidate__c.1degree.dot|
|2013-07-22 11:50||mikeyjamjams||File Added: Candidate__c.2degrees.dot|
|2013-07-22 11:50||mikeyjamjams||Note Added: 0000393|
|2013-07-22 12:01||ellson||Note Added: 0000394|
|2013-07-22 12:27||mikeyjamjams||Note Added: 0000395|
|2013-07-22 13:56||mikeyjamjams||Note Added: 0000396|
|2014-06-11 17:17||erg||Note Added: 0000755|
|MantisBT 1.2.5[^] Copyright © 2000 - 2011 MantisBT Group|