Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0044885
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2020-08-25 14:352020-09-22 13:52
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0044885: External Order Loader synchronizedProcessing=true: Data Import Entries in Initial Status and no error info

DescriptionExternal Order Loader synchronizedProcessing=true: Data Import Entries in Initial Status http://wiki.openbravo.com/wiki/Retail:Order_Loading_WebService#Synchronized_processing [^]

Steps To ReproduceInsert via the External Order Loader a JSON with synchronizedProcessing=true

In Data Import Entries the register must register the JSON, the reponse message, and going to a Success or Error status, not keep in Initial

So there is no way to do a proper troubleshoot of the situation of external orders loaded.

Moreover, this record in Initial never goes to Data Import Entry Archive so it pollutes the Data Import Entry table/window.
Proposed SolutionIn Data Import Entries the register:
* The record should be External Order: OK
* The JSON received by the Data Import Entry should be registered in any case in JSOn Info
* If error, the Status = Error and the error message should be logged in Error Info
* If Success, the Status = Success and the response message should be logged in Response Info
TagsNOR
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0044887 newRetail External Order Loader synchronizedProcessing=false: Data Import Entries type should be External Order 

-  Notes
(0122443)
AugustoMauch (administrator)
2020-08-29 13:01

This issue also has performance implications. Because there is always import entries in Initial status, the import entry manager never sleeps. In less than 2 hours it has executed the query to get the pending import entries 153000 times.
(0122444)
AugustoMauch (administrator)
2020-08-29 13:03

If the proposed solution is not feasible (because with synchronizedProcess=true orders are not imported using the import entry manager), maybe another approach would be to create the import entries with Success status
(0122980)
marvintm (manager)
2020-09-14 06:33

We have been unable to reproduce this issue so far either in pi or in 20Q3. We are in contact with Rafa Roda to try to find a way to reproduce it, as it does seem it happened in the customer environment
(0123287)
marvintm (manager)
2020-09-22 13:52

After further analysis, we have realised that the problem was that provided message ids were not in upper case, which is a requirement to follow Openbravo convention of UUIDs. After this has been changed, the EOL correctly sets import entries to 'Processed' status.

- Issue History
Date Modified Username Field Change
2020-08-25 14:35 rafaroda New Issue
2020-08-25 14:35 rafaroda Assigned To => Retail
2020-08-25 14:35 rafaroda Resolution time => 1599429600
2020-08-25 14:35 rafaroda Triggers an Emergency Pack => No
2020-08-25 14:35 rafaroda Tag Attached: NOR
2020-08-25 14:39 rafaroda Steps to Reproduce Updated View Revisions
2020-08-25 14:39 rafaroda Relationship added related to 0044887
2020-08-26 06:50 rafaroda Steps to Reproduce Updated View Revisions
2020-08-29 13:01 AugustoMauch Note Added: 0122443
2020-08-29 13:03 AugustoMauch Note Added: 0122444
2020-09-04 04:55 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2020-09-10 10:43 ranjith_qualiantech_com Status new => scheduled
2020-09-14 06:33 marvintm Note Added: 0122980
2020-09-14 06:33 marvintm Assigned To ranjith_qualiantech_com => rafaroda
2020-09-14 06:33 marvintm Status scheduled => feedback
2020-09-22 13:52 marvintm Review Assigned To => marvintm
2020-09-22 13:52 marvintm Note Added: 0123287
2020-09-22 13:52 marvintm Status feedback => closed
2020-09-22 13:52 marvintm Resolution open => no change required


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker