Error: Invalid object name "Table name" when connecting to database
Issue: One database connects and executes with the same credentials when the other one throws an error with the same credentials when executing/selecting a table from the list.
Error: Invalid object name "Table name"
The issue was, The working DB's tables work when
Select * from databasename.dbo.tablename
while the one not working works only when you execute
Select * from databasename.common.tablename
Workaround: Asked customer to use custom query using "common"
New to ADSelfService Plus?
Related Articles
Query table throws error upon execute query - Linux - 4400 and above
Issue: Query table's 'execute query' will throw an error as shown below. Even when executing 'select 1', we might get this error. Build affected: 4400, 4410 and 4420 Only on Linux installations Cause: It is due to internal code changes and will be ...Invalid login name while adding a new user via AD import.
Currently, in Analytics Plus we do not support the special character '-' in login name while adding a new user. There will be error message saying 'Invalid Login Name' In order to avoid this, we have to follow the below steps. 1. Download the zip ...Unexpected error prompted for while accessing reports for Servicedesk Plus MSP integrated setup
Issue : Unexpected error prompt while accessing reports Analysis: The exception caused is due to a syntax problem faced in the query formed while the user filter drop down is used on the SLA deviation report. The logs shared helped us to find the ...FAILURE :Exception in creating table in Analytics. JSON Out of Range error
When synchronizing from Servicedesk Plus to Advanced Analytics fresh installation of build 3100 we get the error: FAILURE :Exception in creating table in Analytics. The issue seems with the synchronization of request additional fields. Here is the ...Unable to Connect to the Postgres SQL Database from Command Prompt
Issue : Unable to Connect to the Postgres SQL Database from Command Prompt Error : Analysis : IPv6 local connections are commented in <AnalyticsPlus home>\pgsql\data\pg_hba.conf file Solution : Open the file using notepad or wordpad as administrator ...