Обсуждение: GenSchemaSpy

Поиск
Список
Период
Сортировка

GenSchemaSpy

От
Daulat
Дата:
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

Re: GenSchemaSpy

От
Tim Clarke
Дата:
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

 

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@minerva.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.

Re: GenSchemaSpy

От
Daulat
Дата:
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.clarke@minerva.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

 

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@minerva.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.

Re: GenSchemaSpy

От
Tim Clarke
Дата:
On 28/12/2021 17:58, Daulat wrote:
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

Looks like graphviz isn't installed or can't be found - it can't run an executable called Dot: "Caused by: org.schemaspy.output.diagram.DiagramException: Dot missing or invalid version"

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

 

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@minerva.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.

Re: GenSchemaSpy

От
João Gaspar
Дата:
Hi Daulat,

Check documentation

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


Cheers


A terça, 28/12/2021, 17:58, Daulat <daulat.dba@gmail.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.clarke@minerva.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

 

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@minerva.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.

Re: GenSchemaSpy

От
Daulat
Дата:
OK Joao,

I am getting below errors now.

ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\diagram\diagrams\summary\relationships.real.large.dot
ERROR - RelationShipDiagramError
Failed to produce diagram for: D:\diagram\diagrams\summary\relationships.implied.large.dot
..


On Wed, Dec 29, 2021 at 12:03 AM João Gaspar <joao.f.r.gaspar@gmail.com> wrote:
Hi Daulat,

Check documentation

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


Cheers


A terça, 28/12/2021, 17:58, Daulat <daulat.dba@gmail.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.clarke@minerva.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

 

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@minerva.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.

Re: GenSchemaSpy

От
"Gogala, Mladen"
Дата:
On 12/28/2021 12:58 PM, Daulat wrote:
> Cannot run program "dot": CreateProcess error=2, The system cannot 
> find the file specified
> INFO  - Graphviz rendered set to ''

Did you install GraphViz?


-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com

Re: GenSchemaSpy

От
Daulat
Дата:
No.
I am using an option -vizjs to avoid the requirement of GraphViz. 

See Example here:

java -jar D:\schemaspy-6.1.0.jar  -t pgsql -s rpt -db testdb -u postgres -p 2WS -host 10.25.0.222 -o D:\rpt -dp D:\postgresql-42.3.1.jar -vizjs

On Thu, Dec 30, 2021 at 2:23 AM Gogala, Mladen <gogala.mladen@gmail.com> wrote:

On 12/28/2021 12:58 PM, Daulat wrote:
> Cannot run program "dot": CreateProcess error=2, The system cannot
> find the file specified
> INFO  - Graphviz rendered set to ''

Did you install GraphViz?


--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com


Re: GenSchemaSpy

От
"Gogala, Mladen"
Дата:

On 12/30/2021 4:15 AM, Daulat wrote:

No.
I am using an option -vizjs to avoid the requirement of GraphViz. 

See Example here:

java -jar D:\schemaspy-6.1.0.jar  -t pgsql -s rpt -db testdb -u postgres -p 2WS -host 10.25.0.222 -o D:\rpt -dp D:\postgresql-42.3.1.jar -vizjs


I see everything that I need to see here:

On 12/28/2021 12:58 PM, Daulat wrote:
> Cannot run program "dot": CreateProcess error=2, The system cannot
> find the file specified
> INFO  - Graphviz rendered set to ''

Your jar file is looking for the program called "dot" which is a part of the GraphViz package.  That's all I need to know. You will have to install GraphViz, a standard tool for directed graphs.

Regards

--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Blog: https://dbwhisperer.wordpress.com