Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0043067 | Openbravo ERP | A. Platform | public | 2020-01-30 13:41 | 2022-02-01 07:24 |
| Reporter | inaki_garcia | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | main | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0043067: The "c_import_entry_archive" table is missing the createdtimestamp column | ||||
| Description | As part of the JMeter performance tests conducted by the QA team, the ticket creation test known as "createTicket" makes use of the "c_import_entry" table in order to calculate the average queing, creation and processing times of the recorded Orders. More specifically, the columns in use are: c_import_entry_id, created, updated and createdtimestamp. When certain conditions are met, the records of the "c_import_entry" table are migrated to its sibling backup or archive table, "c_import_entry_archive". The fact that the necessary "createdtimestamp" column is missing in this table implies that if the data migration happens mid-test, the test is rendered useless due to loss of that specific information. Although that a workaround to this would be to calculate the timestamp using the "created" field in date format, it isn't good enough as rounding occurs when the data is treated in Google Sheets. The timestamps will always provide a more accurate and simpler way to calculate the time differences between them in the miliseconds range required by these ticket creation performance tests. | ||||
| Steps To Reproduce | N/A | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2020-01-30 13:41 | inaki_garcia | New Issue | |||
| 2020-01-30 13:41 | inaki_garcia | Assigned To | => platform | ||
| 2020-01-30 13:41 | inaki_garcia | Modules | => Core | ||
| 2020-01-30 13:41 | inaki_garcia | Triggers an Emergency Pack | => No | ||
| 2022-02-01 07:24 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |