Details
-
Type:
Bug
-
Status:
Rejected
(View Workflow)
-
Priority:
Urgent
-
Resolution: Cancelled
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: FN
-
Labels:None Labels
-
Customer:OMAN-Tel
Description
getProcessVariableValue is having Performance issue 0.06s versus 2.3s
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
<soapenv:Header/>
<soapenv:Body>
<ser:getProcessVariableValue>
<!-Optional:->
<woNo>4444000164</woNo>
<!-Optional:->
<variableName>AppType</variableName>
</ser:getProcessVariableValue>
</soapenv:Body>
</soapenv:Envelope>
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2026-02-23 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2026-02-23 24:00 (milestone: set planned end date to due date) |
| Assignee | Hassan Abdine [ habdine ] | Zein Trabelsi [ ztrabelsi ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Rejected [ 10100 ] |
| Assignee | Zein Trabelsi [ ztrabelsi ] | Mbaye Lo [ mbayel ] |
| Resolution | Cancelled [ 10100 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
14h 15m | 1 | Zein Trabelsi | 27/Feb/26 4:51 AM | |||||
|
6m 26s | 1 | Zein Trabelsi | 27/Feb/26 4:57 AM |
|
Links Hierarchy |
 Documentation
|
same code executed in both systems.
difference in performance due to flowable database size difference .
in staging platform we made flowable database cleanup (FN_80)
while in flowable database of 84 platform we didn't .
find below comparaison between just 2 tables used when retrieving process variable both systems :
old : ACT_RU_EXECUTION (35583) | ACT_RU_VARIABLE (475868)
new : ACT_RU_EXECUTION (1113420) | ACT_RU_VARIABLE (12192874)