Re: GenSchemaSpy

Hi Daulat,

Check documentation
https://schemaspy.readthedocs.io/en/latest/new.html

Since 6.1.0 you can add the flag in the commandline argument -vizjs and
schemaspy skip the graphviz installation.

https://schemaspy.readthedocs.io/en/latest/configuration/commandline.html

Cheers

A terça, 28/12/2021, 17:58, Daulat <daulat(dot)dba(at)gmail(dot)com> escreveu:

> Thanks Tim,
>
> I am getting the following messages.
>
> INFO - Starting Main v6.1.0 on SDGL1143 with PID 29536
> (D:\schemaspy-6.1.0.jar started by allen in C:\Users\allen)
> INFO - The following profiles are active: default
> INFO - Started Main in 1.136 seconds (JVM running for 1.617)
> INFO - Starting schema analysis
> INFO - Connected to PostgreSQL - 10.2
> INFO - Gathering schema details
> Gathering schema
> details...................................................................(33sec)
> Connecting
> relationships...................................................................(79sec)
> Writing/graphing summary.INFO - Gathered schema details in 79 seconds
> INFO - Writing/graphing summary
> WARN - Failed to query Graphviz version using 'dot -V'
> Cannot run program "dot": CreateProcess error=2, The system cannot find
> the file specified
> INFO - Graphviz rendered set to ''
> ..ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.real.compact.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.real.large.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.implied.compact.dot
> ERROR - RelationShipDiagramError
> Failed to produce diagram for:
> D:\schemapy\diagrams\summary\relationships.implied.large.dot
> .ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\tempcategory_placeholder_map.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\users_external_tool_id.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\cluster_reload_objects.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\owasp_extra_replacements.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\owasp_skip_params_for_urls.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\placeholder.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\mt_org_template.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\system_configuration.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\registeruser.1degree.dot
> Failed to generate Orphan diagram
> ERROR - Failed to produce diagram for:
> D:\schemapy\diagrams\orphans\user_current_assignment_report.1degree.dot
> Failed to generate Orphan diagram
> .....(5sec)
> Writing/diagramming detailsINFO - Completed summary in 5 seconds
> INFO - Writing/diagramming details
> Exception in thread "main" java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
> at
> org.springframework.boot.loader.Launcher.launch(Launcher.java:50)
> at
> org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51)
> Caused by: org.schemaspy.output.diagram.DiagramException: Failed to
> generate Table diagram
> at
> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:71)
> at
> org.schemaspy.output.html.mustache.diagrams.MustacheDiagramFactory.generateTableDiagram(MustacheDiagramFactory.java:44)
> at
> org.schemaspy.output.html.mustache.diagrams.MustacheTableDiagramFactory.generateTableDiagrams(MustacheTableDiagramFactory.java:80)
> at
> org.schemaspy.SchemaAnalyzer.generateHtmlDoc(SchemaAnalyzer.java:426)
> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:260)
> at org.schemaspy.SchemaAnalyzer.analyze(SchemaAnalyzer.java:123)
> at
> org.schemaspy.cli.SchemaSpyRunner.runAnalyzer(SchemaSpyRunner.java:98)
> at org.schemaspy.cli.SchemaSpyRunner.run(SchemaSpyRunner.java:87)
> at org.schemaspy.Main.main(Main.java:55)
> ... 8 more
> Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or
> invalid version
> at
> org.schemaspy.output.diagram.graphviz.GraphvizDot.generateDiagram(GraphvizDot.java:193)
> at
> org.schemaspy.output.diagram.DiagramFactory.generateTableDiagram(DiagramFactory.java:68)
> ... 16 more
>
> C:\Users\allen>
> C:\Users\allen>Graphviz
>
>
>
>
> On Tue, Dec 28, 2021 at 11:07 PM Tim Clarke <tim(dot)clarke(at)minerva(dot)info>
> wrote:
>
>> On 28/12/2021 17:30, Daulat wrote:
>>
>> Hello Team,
>>
>> I have to generate an ER Diagram in postgres using schemaspy tool.
>> Can you please share the basic steps for the same.
>>
>> Thanks
>>
>> The wiki page has basics https://wiki.postgresql.org/wiki/SchemaSpy and
>> there are good hits from github on this as well. Get back to us with any
>> specifics to your problem once you've got it running.
>> Tim Clarke
>>
>>
>>
>> Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 |
>> Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1
>> 647 503 2848
>> Web: https://www.manifest.co.uk/
>>
>> Watch our latest Minerva Briefings on BrightTALK
>> <https://www.brighttalk.com/channel/18792/?utm_source=brighttalk-sharing&utm_medium=web&utm_campaign=linkshare>
>>
>>
>>
>> Minerva Analytics Ltd - A Solactive Company
>> 9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United
>> Kingdom
>>
>> ------------------------------
>>
>> Copyright: This e-mail may contain confidential or legally privileged
>> information. If you are not the named addressee you must not use or
>> disclose such information, instead please report it to admin(at)minerva(dot)info
>> Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd:
>> Registered in England Number 11260966 & The Manifest Voting Agency Ltd:
>> Registered in England Number 2920820 Registered Office at above address.
>> Please Click Here https://www.manifest.co.uk/legal/ for further
>> information.
>>
>