Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0043067 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] A. Platform | minor | have not tried | 2020-01-30 13:41 | 2022-02-01 07:24 | |||||||
Reporter | inaki_garcia | View Status | public | |||||||||
Assigned To | Triage Platform Base | |||||||||||
Priority | high | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | PostgreSQL | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | main | SCM revision | ||||||||||
Review Assigned To | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
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 | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
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 |
Copyright © 2000 - 2009 MantisBT Group |