Fix jar to avoid orphan entries in APPROVALSTAGE Table during change deletion

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

                    New to ADSelfService Plus?

                      • 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", ...
                      • Temporary fix jar for the attachment filename related problem in Mail fetching for CX ticket #9178069.

                        Root Cause: When retrieving an email with an attachment whose filename includes non-Latin characters, the filename extension is altered from .docx to .doc x (This issue is orginates from Microsoft side) Fix: We will change the received extension to ...
                      • Fix jar for Random Logout issue

                        Root Cause: When Sub Context Sessions expire, they result in the termination of the Root session, leading to a logout issue. Fix: We will verify whether it is Root context while session destroying to proceed logout. ISSUE ID : SD-113692 Check the ...
                      • 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 ...
                      • 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 : ...