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 ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • 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 ...
                      • 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 : ...
                      • Fix for 8514270 - Attachments from a particular sender is getting dropped due to invalid file name

                        Issue: 1. When mails sent from a particular tool (AV tool in this case), the attachments are getting dropped. 2. The name of the attachment after processing is "=?utf-8?Q?=31=64=39=35=66=33=34=33=2D=39=31=39=34=2D=34=61?= ...
                      • Fix: Mail fetching stops due to invalid characters in the attachment name

                        Issue: Mail fetching being stopped due to invalid characters "?" , ":" in the filename. In this case, the eml file's subject contains ":" character and so, while uploading the .eml as attachment, error is thrown (Only in windows server) Trace: ...
                      • How to change the database from MySQL/PostgreSQL to MSSQL

                        The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...