1. Please shutdown your application server.

2. Please do a full database backup before proceeding to the following steps.

1.检查XPDL的现有数量

1. ตรวจสอบจำนวน XPDL ที่มีอยู่

 select count(*) from SHKXPDLS

2.检查未使用的XPDL的数量

2.ตรวจสอบจำนวน XPDL ที่ไม่ได้ใช้

select * from SHKXPDLS x
where concat(x.XPDLId, x.XPDLVersion) not in (
    select concat(packageId,packageVersion) as id from (
        select def.PackageId as packageId, TO_CHAR(def.ProcessDefinitionVersion) as packageVersion 
        from SHKActivities act 
        join SHKProcesses pro on act.Process = pro.oid 
        left join SHKProcessDefinitions def on pro.ProcessDefinition = def.oid 
        group by def.PackageId, def.ProcessDefinitionVersion 
        union 
        select packageId, TO_CHAR(packageVersion) from app_package
    ) group by packageId, packageVersion
);

3.删除已完成的流程实例数据以清除缓存中的更多XPDL

delete from SHKAssignmentsTable;
delete from SHKAndJoinTable;
delete from SHKDeadlines;
delete from SHKActivityData;
delete from SHKActivities;
delete from SHKProcessData;
delete from SHKProcessRequesters;
delete from SHKProcesses;

4.删除未使用的XDPL

4.ลบ XDPL ที่ไม่ได้ใช้