Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0057611 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] POS | minor | always | 2025-01-10 12:34 | 2025-03-05 13:29 | |||
| Reporter | fermin_ostivar | View Status | public | |||||
| Assigned To | meriem_azaf | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0176425) hgbot (developer) 2025-03-04 13:05 |
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1567 [^] |
|
(0176476) hgbot (developer) 2025-03-05 13:29 |
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1567 [^] |
|
(0176477) hgbot (developer) 2025-03-05 13:29 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo [^] Changeset: 574db30a6b39e56fd5533a28e1e4f0ac4a927705 Author: Augusto Mauch <amauch@orisha.com> Date: 05-03-2025 09:38:44 URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/commit/574db30a6b39e56fd5533a28e1e4f0ac4a927705 [^] Fixes ISSUE-57611: Trigger misfire is now properly inserted The problem was that the process request id was being set to the process bundle, because the ProcessBundle constructor use did not set it (it is not available yet, the process request has not yet been created). It has been fixed by setting the process request id to the bundle in OBScheduler.schedule, when the process request is created. --- M src/org/openbravo/scheduling/OBScheduler.java M src/org/openbravo/scheduling/ProcessBundle.java --- |
|
Notes |
|
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 | View Revisions |
| 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |