ERROR (Datamart App): “Error encountered during data structure validation”

Receiving this error when opening the Datamart ‘Admin Console’ 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 ‘Admin Console’ is looking for a table that no longer exists in the database.

To clear the error:

  • 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 please contact our informXL Support team at support@informXL.com.

To avoid this moving forward:
  • Create a table using Datamart’s ‘Table Creator’
in informXL Datamart