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 


                  New to ADSelfService Plus?

                    • Related Articles

                    • Query to list technician name, site, email and login name (MSSQL & PGSQL)

                      The below PGSQL query doesnt work in builds below PGSQL (14000) ERROR: missing FROM-clause entry for table "helpdeskcrew" Pgsql: SELECT HelpDeskCrew.TECHNICIANID "Technician ID", AaaUser.FIRST_NAME "Technician Name",AaaContactInfo.EMAILID "Email", ...
                    • Contact name is shown as System instead of actual name

                      In certain cases , users will see this error in the request details page. As per design of SCP 11.0, Support Rep of one Portal cannot be a Contact in another portal. If a support rep in portal A , sends email to Portal B , (where he is associated or ...
                    • Subject Alternative Name missing Error under Browser (SAN Missing)

                      Error : Solution: Please find below the commands that can be used to create the keystore and corresponding CSR request with SAN included: Keystore creation:  keytool -genkey -alias <your_alias_name> or [Domain Name] -keyalg RSA -keysize 2048 -sigalg ...
                    • 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 ...
                    • Query to show tickets older than 30 days ( MSSQL )

                      Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wo.TITLE "Subject",aau.FIRST_NAME AS "Requester Name", pd.PRIORITYNAME as "Priority", adef.ORG_NAME as "Account", ...