Service Desk services stopped on its own.

Service Desk services stopped on its own.

The reason for the crash is becauss the SQL database connectivity was lost.

It's looks like this while checking the log file :

[15:54:58:066]|[10-11-2018]|[SYSERR]|[INFO]|[72]: 101603933 [ServiceDeskCommon-2] WARN tm.TransactionImpl  - XAException: tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=PIF-SDP-01//46129, BranchQual=] errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: Error trying to start local tx: ; - nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: I/O Error: Connection reset by peer: socket write error))
at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:654)
at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1196)

at java.lang.Thread.run(Unknown Source)
Caused by: org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: I/O Error: Connection reset by peer: socket write error)

Solution: 

We can enable the Read committed Snapshot in the MSSQL environment to increase the performance of the application.


Please follow the instructions:

1. Stop the service desk service.


2- Now execute the below queries one by one to enable the snapshot on the SQL server.


ALTER DATABASE  <db_name> SET ALLOW_SNAPSHOT_ISOLATION ON


ALTER DATABASE  <db_name>  SET READ_COMMITTED_SNAPSHOT ON


3. Start the service and observe the behaviour.


    • Related Articles

    • List of Services Template Report

      Tthe below Query to list all service catalog in the system Database : PostgreSQL Server - Version: 10.5 SELECT serd.Name "Service Category", reqtl.templatename "Service catalog", sla.slaname "SLA" , sdo.name "Site", array_to_string(array_agg(CASE ...

    • Migration Important Notes

      When migrating from server to another , please make sure deploy these notes: 1-After migration successfully done , disable the service in the old server do not make it automatic to avoid running again the old server and conflicts can be occurred like ...

    • Database Warning : Your database transaction log file size has crossed the threshold

      You are getting this email as a result of an enhancement that was made in the 11 version to notify administrators if the SQL Log File Size crossed the threshold. In Service Desk Plus, under Performance Settings in Admin/ESM Directory you have the ...

    • Unable to restore data after changing DBserver to SQL

      After changing the DB server to MSSQL, We tried to restore the data from the backup file, but the restore didn't take place successfully so we followed those steps and everything worked perfectly. Please follow the below steps and re-initiate the ...

    • Error while saving the email server details : Duplicate entry for key

      This Problem may happen when the application is holding to different mail server details. 1- So go to Reports > New query report and execute the following query : select * from IncomingMailServer 2- If you see multiple mail server configured in this, ...