Openbravo Issue Tracking System - POS2 | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0057611 | POS2 | POS | public | 2025-01-10 12:34 | 2025-01-21 18:34 |
| Reporter | fermin_ostivar | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0057611: Misfired Process Request not saved if channel direct | ||||
| Description | If a Process Request with channel Direct is misfired, it is not saved in Process Monitor due to an error in the insert query | ||||
| Steps To Reproduce | Set quartz properties to force the scenario: org.quartz.threadPool.threadCount = 1 org.quartz.jobStore.misfireThreshold = 1 Add a sleep in the VariantChDescUpdateProcess doExecute() to force to take time Open Product Characteristic tab in backoffice Modify the name of any product characteristic value two times Log example: 2025-01-10 12:20:24,890 [DefaultQuartzScheduler_QuartzSchedulerThread] ERROR org.openbravo.scheduling.ProcessRunData - SQL error in query: INSERT INTO AD_Process_Run (AD_Org_ID, AD_Client_ID, Isactive, Created, Createdby, Updated, UpdatedBy, AD_Process_Run_ID, Status, Start_Time, Runtime, Log, AD_Process_Request_ID, Scheduler_Instance) VALUES (?, ?, 'Y', NOW(), ?, NOW(), ?, ?, ?, NOW(), ?, ?, ?, ?) :org.postgresql.util.PSQLException: ERROR: null value in column "ad_process_request_id" violates not-null constraint Detail: Failing row contains (D44FDE1FF4114400B0E5D335C051A6A6, 39363B0921BB4293B48383844325E84C, 0, Y, 2025-01-10 12:20:24.884879, 100, 2025-01-10 12:20:24.884879, 100, MIS, 2025-01-10 12:20:24.884879, null, null, null, null, null, null, null, null, null). | ||||
| Proposed Solution | To save the misfired process in the Process Monitor tab | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2025-01-10 12:34 | fermin_ostivar | New Issue | |||
| 2025-01-10 12:34 | fermin_ostivar | Assigned To | => Retail | ||
| 2025-01-10 12:34 | fermin_ostivar | Triggers an Emergency Pack | => No | ||
| 2025-01-10 12:41 | guillermogil | Assigned To | Retail => Triage Platform Base | ||
| 2025-01-21 09:48 | AugustoMauch | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=29085#r29085 | ||
| 2025-01-21 18:34 | AugustoMauch | Status | new => acknowledged | ||
| 2025-02-04 10:40 | javietxe | Relationship added | duplicate of 0057008 | ||
| 2025-02-04 10:41 | javietxe | Relationship deleted | 0057008 | ||
| There are no notes attached to this issue. |