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 ...Debug for #8840146: Invalid to address error
Issue: 1. In some scenarios, mails aren't sent to few users 2. Upon checking the traces in syslog viewer, we could find the below traces To address : karsee. Cc address : null Subject : 【ASSIGN】ID:25999／KSK／不要会社DBの削除と検証用会社DBの作成 SystemNotification : ...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 ...