Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0057008 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] Z. Others | minor | always | 2024-11-06 10:51 | 2024-11-28 13:59 | |||||||
| Reporter | inaki_azkonobieta | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | feedback | 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 | main | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0057008: Wrong insert happening in some environments | |||||||||||
| Description | Every 5 minutes we have the following error in the log: 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 | Automatically after deleting the client | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0171732) AugustoMauch (administrator) 2024-11-10 22:55 |
Iñaki, can you elaborate the steps to reproduce, please? |
|
(0172721) alostale (manager) 2024-11-28 13:59 |
Lowering severity to minor as it doesn't have other known impact than error messages in logs. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-11-06 10:51 | inaki_azkonobieta | New Issue | |
| 2024-11-06 10:51 | inaki_azkonobieta | Assigned To | => Triage Omni OMS |
| 2024-11-06 10:51 | inaki_azkonobieta | Modules | => Core |
| 2024-11-06 10:51 | inaki_azkonobieta | Triggers an Emergency Pack | => No |
| 2024-11-06 10:51 | inaki_azkonobieta | Assigned To | Triage Omni OMS => Triage Platform Base |
| 2024-11-06 10:52 | javietxe | Issue Monitored: javietxe | |
| 2024-11-10 22:55 | AugustoMauch | Note Added: 0171732 | |
| 2024-11-10 22:55 | AugustoMauch | Status | new => feedback |
| 2024-11-28 13:59 | alostale | Note Added: 0172721 | |
| 2024-11-28 13:59 | alostale | Severity | major => minor |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |