DM-DBM-0400 UDA driver reported the following on connection Staging_db:
UDA-SQL-0115 Inappropriate SQL request.
UDA-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Cannot drop the index 'dmcuser.tbl_Output_financials_Grouped.ix0tbl_Output_financials_Grouped', because it does not exist in the system catalog. (SQLSTATE=42S12, SQLERRORCODE=3703)
Solution - index should be created first - right click on the build and 'view DDL'. Under create index there will be SQL that you can run in your rdbms to create the required index .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment