What causes the error message "Server: Msg 208, Level 16, Line 1 Invalid object name 'up_user_layout_aggr'"?
I am running the following against my MS SQL Sever database to clean up a single user account's layout.
DELETE FROM up_user_layout_aggr WHERE user_id = 2013; UPATE up_user_profile SET layout_id = null, structure_ss_id = null, theme_ss_id = null WHERE user_id = 2013; UPDATE up_user SET next_struct_id = null WHERE user_id = 2013; DELETE FROM up_layout_struct_aggr WHERE user_id = 2013; DELETE FROM up_layout_restrictions WHERE user_id = 2013; DELETE FROM up_ss_user_atts WHERE user_id = 2013;
and I'm seeing the following error:
Server: Msg 208, Level 16, Line 1 Invalid object name 'up_user_layout_aggr'.
I am running this directly on the server that houses the SQL database and have the Academus database selected. What's going on and how can i fix it?
The error indicates that SQL Server did not resolve the table name 'up_user_layout_aggr' to the table in the Academus database schema, typically because the account as which the query is being executed is not the main account associated with the schema. Namespacing the references, perhaps by prefacing each table name with "unicon.", may help SQL Server to understand your intentions.
