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-01-21 18:34 | ||||||
| Reporter | fermin_ostivar | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | 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 | ||||||||||
| Review Assigned To | |||||||||||
| 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 |
|
| There are no notes attached to this issue. |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |