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 ...
                    • Tickets created outside operational hours( MSSQL)

                      Tested in Build MSSQL (14306) MSSQL: SELECT "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "dpt"."DEPTNAME" AS "Department", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", ...
                    • 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", ...