Problem:
I am unable to reverse engineer from a SQL server database. That gives me errors like,
<Level=1><Warning> REDB-1022: Database error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.
<Level=1><Warning> REDB-1022: Database error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.table_types'.
<Level=1><Warning> REDB-1009: Error 113 for Objects on 'Entity' at Location DAXConnection_SQLServer2005_ODBC.cpp;SELECT 1075838979, 1073742126, name, 1075838979, 1075849133, type_table_object_id, 1075838979, 1075850737, SCHEMA_NAME(schema_id), 1075838979, 1075852373, cast (1 as bit) FROM sys.table_types WHERE is_table_type = 1 and is_user_defined = 1 UNION SELECT 1075838979, 1073742126, name, 1075838979, 1075849133, object_id, 1075838979, 1075850737, SCHEMA_NAME(schema_id), 1075838979, 1075852373, cast (0 as bit) FROM sys.tables WHERE type in ('U', 'S', 'IT') AND is_ms_shipped = 0;
Solution:
The database user you are logging in as lacks read permissions to the master database.
For example, if you log in to SQL server using a query tool, is your user able to execute,
USE [master]
SELECT * FROM sys.Tables
SELECT * FROM sys.table_types
go
We have also attached a SQL trace file we used with a minimum option set of just Table name.
The master database views within like sys.tables and sys.table_types are what you specifically need read privileges for in erwin DM r9.8.
The reason is erwin dm must be able to read the metadata for the SQL server DBMS that is stored in the resource database that is a hidden system database. erwin DM queries that database to then form the model.
Please discuss adding those privileges to your user with your DBA.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center