Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0057981 | Openbravo ERP | Z. Others | public | 2025-02-13 13:06 | 2025-02-17 13:01 | |||||||
| Reporter | javietxe | |||||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |||||||
| Status | new | Resolution | open | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0057981: Avoid logs of wrong insert happening in some environments | |||||||||||
| Description | In some environments, it is already showing the error of the wrong insert and the fix provided in the related mantis doesn't clean up the logs. 2024-11-06 10:02:07,008 [DefaultQuartzScheduler_Worker-3] 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: insert or update on table "ad_process_run" violates foreign key constraint "ad_process_run_ad_client" Detail: Key (ad_client_id)=(4028E6C72959682B01295A070852010D) is not present in table "ad_client". 2024-11-06 10:02:07,008 [DefaultQuartzScheduler_Worker-3] ERROR org.openbravo.scheduling.ProcessMonitor - @CODE=0@ERROR: insert or update on table "ad_process_run" violates foreign key constraint "ad_process_run_ad_client" Detail: Key (ad_client_id)=(4028E6C72959682B01295A070852010D) is not present in table "ad_client". javax.servlet.ServletException: @CODE=0@ERROR: insert or update on table "ad_process_run" violates foreign key constraint "ad_process_run_ad_client" Detail: Key (ad_client_id)=(4028E6C72959682B01295A070852010D) is not present in table "ad_client". at org.openbravo.scheduling.ProcessRunData.insert(ProcessRunData.java:112) ~[classes/:?] at org.openbravo.scheduling.ProcessMonitor.jobToBeExecuted(ProcessMonitor.java:139) [classes/:?] at org.quartz.core.QuartzScheduler.notifyJobListenersToBeExecuted(QuartzScheduler.java:1927) [quartz-2.3.2.jar:?] at org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:324) [quartz-2.3.2.jar:?] at org.quartz.core.JobRunShell.run(JobRunShell.java:173) [quartz-2.3.2.jar:?] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?] 2024-11-06 10:02:07,008 [DefaultQuartzScheduler_Worker-3] ERROR org.openbravo.scheduling.DefaultJob - Error executing process org.openbravo.erpCommon.ad_process.AcctServerProcess java.lang.NullPointerException: null 2024-11-06 10:02:07,008 [DefaultQuartzScheduler_Worker-3] INFO org.quartz.core.JobRunShell - Job OB_QUARTZ_GROUP.3CD8A7A68DFE4FDAAD20D2570D78DE3B threw a JobExecutionException: org.quartz.JobExecutionException: java.lang.NullPointerException at org.openbravo.scheduling.DefaultJob.execute(DefaultJob.java:72) ~[classes/:?] at org.quartz.core.JobRunShell.run(JobRunShell.java:202) [quartz-2.3.2.jar:?] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?] Caused by: java.lang.NullPointerException 2024-11-06 10:02:07,013 [DefaultQuartzScheduler_Worker-3] ERROR org.openbravo.dal.core.OBContext - The query 'select r from ADRole r where r.id=:roleId' returned 0 results while only 1 result was expected 2024-11-06 10:02:07,013 [DefaultQuartzScheduler_Worker-3] ERROR org.openbravo.scheduling.ProcessMonitor - null java.lang.NullPointerException: null SOlutions tried that didn't work: - Redeployed the instance for checking that there is not a problem of the context - No records in the ad_process_request has this ad_client_id in his record - No records in the ad_process_request have this ad_client_id in the context select * from ad_process_request where ob_context like '%4028E6C72959682B01295A070852010D%'; The client is related to the QA Testing and the process launched is org.openbravo.erpCommon.ad_process.AcctServerProcess | |||||||||||
| Steps To Reproduce | N/A | |||||||||||
| Proposed Solution | ||||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2025-02-13 13:06 | javietxe | New Issue | ||||||||||
| 2025-02-13 13:06 | javietxe | Assigned To | => Triage Omni OMS | |||||||||
| 2025-02-13 13:06 | javietxe | Modules | => Core | |||||||||
| 2025-02-13 13:06 | javietxe | Triggers an Emergency Pack | => No | |||||||||
| 2025-02-13 13:06 | javietxe | Relationship added | related to 0057008 | |||||||||
| 2025-02-13 13:07 | javietxe | Assigned To | Triage Omni OMS => AugustoMauch | |||||||||
| 2025-02-13 13:10 | inaki_azkonobieta | Issue Monitored: inaki_azkonobieta | ||||||||||
| 2025-02-17 13:01 | hgbot | Note Added: 0175769 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||