Datamart App Error: “Error encountered during data structure validation”

Error: “Error encountered during data structure validation. Object reference not set to an instance of an object.”

Receiving this this error when opening the Datamart App is most likely due to a table that was created using the Datamart’s table creator, but was deleted or dropped by script or through SQL Server Management Studio (SSMS). The error occurs when the Datamart App is looking a table that no longer exists in the database.

To clear the error you will need to remove the orphan records associated with the deleted table in tables dbo.dmColumns and dbo.dmTables. If you are unfamiliar with deleting rows in a SQL Server table contact informXL support for assistance.

To avoid this moving forward, if you create a table using the Datamart App’s table creator feature that table will need to be deleted using the app as well.
in informXL Datamart