Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052654Retail ModulesRetail APIpublic2023-06-02 12:062023-09-07 15:33
Reporterazzeddine_meftoh 
Assigned Tocaristu 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052654: push API "Stock Transactions: Inventory" missing some goods transactions in the exported data
Descriptionexample seen :
- the process request that should have extracted the goods transaction :
2023-06-01 16:47:00.071 - Event API_StockTransactionI successfully triggered. Parameters: {lastUpdated=2023-05-29 17:54:17.0, nextLastUpdated=Mon May 29 17:57:17}

- the goods transaction that has not been extracted
created "2023-05-29 17:57:11.647177"
updated "2023-05-29 17:57:11.647177"
processed "2023-05-29 17:57:19"



is this the same issue a described in the Mantis 51906,
the trxprocessdatehapening after the updated timestamp has impact on the extraction?
Steps To Reproduce- the process request that should have extracted the goods transaction :
2023-06-01 16:47:00.071 - Event API_StockTransactionI successfully triggered. Parameters: {lastUpdated=2023-05-29 17:54:17.0, nextLastUpdated=Mon May 29 17:57:17}

- the goods transaction that has not been extracted
created "2023-05-29 17:57:11.647177"
updated "2023-05-29 17:57:11.647177"
processed "2023-05-29 17:57:19"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0051906 closed AtulOpenbravo Modules RM-5506 Missing goods transaction in the push API sent by "Multiple Record Event Triggering Process" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-06-02 12:06azzeddine_meftohNew Issue
2023-06-02 12:06azzeddine_meftohAssigned To => Triage Platform Conn
2023-06-02 12:06azzeddine_meftohOBNetwork customer => No
2023-06-02 12:06azzeddine_meftohTriggers an Emergency Pack => No
2023-06-14 17:42rafarodaOBNetwork customerNo => Gold
2023-06-19 09:36guillermogilAssigned ToTriage Platform Conn => guillermogil
2023-06-19 09:36guillermogilAssigned Toguillermogil => Triage Omni OMS
2023-06-19 09:45aferrazAssigned ToTriage Omni OMS => Triage Omni WMS
2023-06-23 11:32rafarodaRelationship addedrelated to 0051906
2023-06-26 08:41mtaalAssigned ToTriage Omni WMS => Triage Platform Base
2023-06-26 09:14AugustoMauchAssigned ToTriage Platform Base => Triage Platform Conn
2023-06-27 10:09adrianromeroAssigned ToTriage Platform Conn => Retail
2023-06-27 10:12adrianromeroAssigned ToRetail => Triage Platform Conn
2023-06-27 10:19adrianromeroAssigned ToTriage Platform Conn => caristu
2023-07-24 12:31alostaleTypedefect => design defect
2023-08-17 13:16hgbotMerge Request Status => open
2023-08-17 13:16hgbotNote Added: 0153588
2023-09-07 14:01hgbotMerge Request Statusopen => approved
2023-09-07 15:33hgbotResolutionopen => fixed
2023-09-07 15:33hgbotStatusnew => closed
2023-09-07 15:33hgbotNote Added: 0154592
2023-09-07 15:33hgbotNote Added: 0154593

Notes
(0153588)
hgbot   
2023-08-17 13:16   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/172 [^]
(0154592)
hgbot   
2023-09-07 15:33   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: ca229b691979f3536a0890676db745efcde457b1
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 07-09-2023 14:42:59
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/ca229b691979f3536a0890676db745efcde457b1 [^]

fixes BUG-52654: add configurable last updated offset

  Add a configurable offset to be applied to the time range of the
records exported by the ApiMultiRecordEventTriggeringProcess to avoid
losing those records that are part of a transaction commited out of that
time range.

  This offset if subtracted to the end date ("nextLastUpdated"
parameter) of the filter used in the current process execution and to
the start date ("lastUpdated" parameter) of the filter used in the next
process execution.

  The offset can be configured both at process level (Process Request
header) or at a specific event level (Events to Integrate) subtab. The
configuration at event level takes precedence over the one at process
level. If the offset is null or zero, then no amount of time is
subtracted to the time range, so the process keeps behaving like so far.

---
A src-test/org/openbravo/api/process/ApiMultiRecordEventTriggeringProcessTest.java
M src-db/database/model/modifiedTables/AD_PROCESS_REQUEST.xml
M src-db/database/model/tables/API_PROCESS_EVENT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-test/org/openbravo/api/StandaloneTestSuite.java
M src/org/openbravo/api/process/ApiMultiRecordEventTriggeringProcess.java
---
(0154593)
hgbot   
2023-09-07 15:33   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/172 [^]