Changing the RequestID to start from a particular number
To change the RequestID to an number of you choice follow steps below.
1. Connect to SupportCenterPluss MySql database
eg)
eg)
C:\\SupportCenter\\mysql\\bin>mysql.exe -u root -P 33356 supportcenter
2. Insert a dummy request with requestid and requesterid
eg)
mysql> insert into workorder (WORKORDERID,REQUESTERID,DEPARTMENTID) values (4999,2,1);
where request ID is 4999, Requesterid is 2 and Department ID is 1
3.Shutdown SupportCenterPlus and restart it.
4.The next new request that you will create will have the requestid 5000.
For MSSQL database
insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For Postgres database:
postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For MSSQL database
insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
For Postgres database:
postgres# insert into workorder (WORKORDERID,REQUESTERID,CREATEDTIME,DUEBYTIME,DEPARTMENTID) values (4999,2,0,0,1);
New to ADSelfService Plus?
Related Articles
Set Request Id to start from a particular number - Version 11.0.
Regarding the First Portal (General), you can use the below steps to change the Request Id to start from 136000. 1.The below Select Query will give the last active ticket ID. Select * from SeqGenState where seqname='WorkOrder.WORKORDERID'; 2.Then, ...Upgrade failure - Trying to start PostgresSQL server failed
Traces within the logs: [SYSERR] [INFO] : java.lang.Exception: java.net.ConnectException: Trying to start PostgresSQL server failed Please follow the steps below to address the same : 1. Stop the ServiceDesk Plus MSP service. 2. Open the command ...Ubuntu 18.04 LTS - Start as service issue
After following the steps for running the application as service in linux the following errors may occur to start the service. Aug 17 06:56:07 ip-172-31-14-254 systemd[1]: Started ServiceDesk. Aug 17 06:56:07 ip-172-31-14-254 systemd[14138]: ...Failed to start the database
For the error "Failed to start the database", Check what database being used and, execute changeDBServer.bat. For Pgsql, Start PGSQL from the command link, execute StartDB.bat 65432 under C:\Manageengine\ServiceDesk\bin 65432 is the default port ...Unable to start the application after power failure
Issue: In certain cases, after a power failure, when the server restarts, the application fails to start and we could see indexoutofboundsexception in the log traces. Cause: This error occurs because the license file gets corrupted which may be due ...