Invalid Object Name or Table or View does not exist error on commit of an Edit Set.
When committing an Edit Set modifying any table, user receives the following error and the Edit Set terminates:
"Invalid Object Name HEATTbl"
"Table or View Does not Exist" error referencing an insert to the HEATTbl table.
The Edit Set process drops tables and recreates them. No matter which table is altered through the edit set, all of the following tables are dropped in this order and recreated. If the ODBC user does not have Create Table rights, then they will receive one of these two errors.
Grant “Drop Table” and “Create Table” rights to the database user whose credentials are being used in the ODBC connection.