IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
User receives Invalid Object Name when working with Enterprise Analyzer workspace built on SQL database. Log files show several DBERR messages which can include some of the following:
Error [4884,1] - DBERR : Invalid object name 'Workspacesettings'.
Error [4884,1] - DBERR : Invalid object name 'dgrScopeRels'.
Issue related to the case sensitivity of the table names in the SQL database. In some cases, EA is looking for dgrScopeRels when the table is called DgrScopeRels. The same could also apply for Workspacesettings and WorkspaceSettings.
The solution is to disable case sensitivity for the SQL database and make the entire instance case insensitive. This operation would need to be performed by the database administrator.