MSSQL error 'Invalid Object name'

MSSQL error 'Invalid Object name'


When you get a similar error as mentioned below 


java.sql.BatchUpdateException: Invalid object name 'TABLE NAME'




please change the COLLATION in the MSSQL server for the database 'servicedesk' as CASE-INSENSITIVE.

You can get this error at the time of restore or backup or you can also find this in the serverout file if it is a runtime error.


If you are running MSSQL 2000 then run the below query to alter the collation:


​

ALTER DATABASE servicedesk COLLATE SQL_Latin1_General_CP1_CI_AS 


          • Related Articles

          • License is Expired / License is invalid

            The application will not start if the license is expired / Corrupted. If the error is, Registration period is expired Open the command prompt with Admin privileges (Run it as Administrator) and point to the bin directory of ManageEngine ServiceDesk ...

          • How to find the MSSQL Lock on the database directly?

            Connect to the MSSQL database and open the query editor for service desk database(any database should work) 1. Execute the query  sp_who2 2. Above command will show the list of database query process which is currently in execution that causes the ...

          • How to change the database from MySQL/PostgreSQL to MSSQL

            The below steps will illustrate how to do database migration: 1. Stop ManageEngine ServiceDesk Plus service  2. Take a backup of the existing data and configuration under MySQL/PostgreSQL database by invoking the backupdata.bat in the location ...

          • List of mail fetching issues and solutions

            Scenario 1 : Mail fetching issue due to Invalid or No PKIX certificate .   Log traces for Mail Fetching  issues Exception when connecting to store.|javax.mail.MessagingException: sun.security.validator.ValidatorException: PKIX path building failed: ...

          • Request based on SLA name

            This report is used to get the name of the sla applied in the request.  To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT ...