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-03-05 13:29 |
| Reporter | fermin_ostivar | ||||
| Assigned To | meriem_azaf | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | approved | ||||
| Review Assigned To | |||||
| OBNetwork customer | Gold | ||||
| 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 | OBNetwork customer | => Gold | ||
| 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 | ||
| 2025-02-21 10:09 | AugustoMauch | Assigned To | Triage Platform Base => meriem_azaf | ||
| 2025-02-24 09:43 | AugustoMauch | Status | acknowledged => scheduled | ||
| 2025-03-04 13:05 | hgbot | Merge Request Status | => open | ||
| 2025-03-04 13:05 | hgbot | Note Added: 0176425 | |||
| 2025-03-05 10:12 | hgbot | Merge Request Status | open => approved | ||
| 2025-03-05 13:29 | hgbot | Note Added: 0176476 | |||
| 2025-03-05 13:29 | hgbot | Resolution | open => fixed | ||
| 2025-03-05 13:29 | hgbot | Status | scheduled => closed | ||
| 2025-03-05 13:29 | hgbot | Fixed in Version | => PR25Q2 | ||
| 2025-03-05 13:29 | hgbot | Note Added: 0176477 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||