Fix jar to avoid orphan entries in APPROVALSTAGE Table during change deletion
The fix jar is given to delete the orphan entries in APPROVALSTAGE table during the deletion of change
Ticket:
Files Modified :
<SDP>\helpdesk\src\library\com\manageengine\servicedesk\change\db\CMQueryUtil.java
Jar Compatibility :
11120 - SDP Build Version
New to ADSelfService Plus?
Resources
Related Articles
Change approval
SELECT chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", orgaaa.FIRST_NAME AS "Change Requester", qd.QUEUENAME AS "Group", ownaaa.FIRST_NAME AS "Change Owner", catadef.CATEGORYNAME AS "Category", priodef1.PRIORITYNAME AS "Priority", ...Fix for SD-89148 (11126)
The jar has a fix for SD-89148 which is already released in 11129. NOTE: Please ask the cx to upgrade which is the first most preferable option, if not go for this temporary patch Files Modified : ...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 ...Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175.
Email with .wav attachment is not getting extracted during mail processing due to the issue fix of SD-65175. The content-type of the attachment is APPLICATION/OCTET-STREAM. Since it is in Upper case the following condition - ...Change roles
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", ...