The Schema Visulatisation is returning blank when selecting DB

[seppu]

I installed this extension with much hope. But I am not able to see any visualisation.its returning blank on clicking on the Visulatisation tab. Please see the screen shot below

[R0tenur]

Are your db located on a server or on localhost? What kind of authentication are used?

[seppu]

The DB is located on a server. Uses windows authentication as it's connected to the corporate AD

[MikaTas]

Yes.. the schema visualizer is blank. No loading indicator, no nothing. Using Azure SQL Server and administrative access account.

[R0tenur]

I'm getting the schema by querying sys.objects and information_schema. Cold you please try the following query: https://github.com/R0tenur/visualization/blob/4be706d15b112b22eaee4b09d8a10790a6a770f0/src/repositories/mssql.repository.ts#L43 and attach the error in this issue?

[fede1608]

Msg 208, Level 16, State 1, Line 1 Invalid object name 'SYS.FOREIGN_KEY_COLUMNS'.

[holajoyce]

This is currently only available in sql server and not on postgres yet, right? Really looking forward to using this as well. But am only on PG.

[R0tenur]

Msg 208, Level 16, State 1, Line 1 Invalid object name 'SYS.FOREIGN_KEY_COLUMNS'.

Thank you! I have created a new query for getting the tables that is not dependent on the SYS objects. I would appriciate if you could try the follwing query: https://github.com/R0tenur/visualization/blob/a4421ea1b1b179035c302d2c88d3dfca183511b7/src/repositories/mssql.repository.ts#L165

[fede1608]

Msg 208, Level 16, State 1, Line 1 Invalid object name 'SYS.FOREIGN_KEY_COLUMNS'.

Thank you! I have created a new query for getting the tables that is not dependent on the SYS objects. I would appriciate if you could try the follwing query: https://github.com/R0tenur/visualization/blob/a4421ea1b1b179035c302d2c88d3dfca183511b7/src/repositories/mssql.repository.ts#L165

That actually worked!

[R0tenur]

Msg 208, Level 16, State 1, Line 1 Invalid object name 'SYS.FOREIGN_KEY_COLUMNS'.

Thank you! I have created a new query for getting the tables that is not dependent on the SYS objects. I would appriciate if you could try the follwing query: https://github.com/R0tenur/visualization/blob/a4421ea1b1b179035c302d2c88d3dfca183511b7/src/repositories/mssql.repository.ts#L165

That actually worked!

Great, that fix is included in the latest version: https://github.com/R0tenur/visualization/releases/tag/v0.3.0

[R0tenur]

With the latest version errors are displayed in the UI