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", ...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 ...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", ...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 Asset state history ( MSSQL)
Tested in MSSQL build (14306) SELECT res.resourcename 'Asset Name', res.assettag 'Asset Tag',res.serialno 'Asset Serial No.', rs2.statedesc 'Previous State',rs1.statedesc 'Current State',DATEADD(s,DATEDIFF(s,GETUTCDATE() ,getdate()) + ...