Invalid Object Name In SQL Database While Using Enterprise Analyzer
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.