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", ...