Why does the diagramming functionality pile all objects on top of each other?

Louis_Tominack

When I diagram my database all the objects are layered on top of each other.  I tried multiple diagramming options and get the same results.  I pressed the Reapply Layout and nothing happens.  Is there a setting I am missing?

Jon_Kirkwood

Hi @Louis_Tominack

 

Thank you for reaching out on the Redgate forums regarding your SQL Dependency Tracker issue.

 

We have seen similar behavior from some other users where the objects are all laid on-top of each other and not re-arranging using the different layout styles.

The most common reason is due to a FIPS-compliant encryption policy blocking a component of the installer.

 

To test this fix we would recommend uninstalling SQL Dependency Tracker, searching for an active FIPS-compliant encryption policy and disabling it. 

Then conducting a fresh install of Dependency Tracker and verify the issue has been resolved.

 

Some links which may be of reference:

Disable via Local Security Policy:

https://knowledge.civilgeo.com/knowledge-base/disabling-fips-complaint-encryption-on-windows/

Disable via registry:

https://www.lucid8.com/documentation/DSWebHelp/TRO/Unable_to_Start_DigiScope_with_FIPS_Cryptography_Enabled.htm

 

 A link to our latest version of SQL Dependency Tracker can be accessed here:

https://download.red-gate.com/checkforupdates/SQLDependencyTracker/SQLDependencyTracker_3.3.7.2917.exe

 

Louis_Tominack

Jon -- I am working in an environment where my laptop is controlled by the group policy and organizational security profiles.  I can't disable security protocols on my laptop.  Do you have any other ideas?

Jon_Kirkwood

I have escalated this within our development team for possible workarounds, unfortunately there is a third-party library, utilised within SQL Dependency Tracker, that is what is conflicting with FIPS. 

Until this library is updated this issue will continue. I am not able to ascertain a timeframe on when this may be resolved.

 

My understanding is the issue occurs when installing the software as a component of the library is not installed with FIPS enabled. 
It may constitute a conversation within your IT/security team to disable FIPS, install the software and then re-enable FIPS to see if this resolves the layout issues.

Louis_Tominack

Thanks Jon -- I'll just deal with it until an update is made available.

Jon_Kirkwood

Apologies it wasn't a more concrete solution at this stage.

Please track the Releases & Updates page for future releases:
https://documentation.red-gate.com/sdt/release-notes-and-other-versions/sql-dependency-tracker-3-3-release-notes