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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0057008

closed

AugustoMauch

Wrong insert happening in some environments

Notes
(0175769) hgbot (developer) 2025-02-17 13:01	Merge request closed: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.module.aeat390.es/-/merge_requests/15 [^]

(0177148) AugustoMauch (administrator) 2025-03-23 23:24	@javi, I am not able to reproduce this one. I undid the original fix (https://issues.openbravo.com/view.php?id=57008 [^]), and then the original issue was reproducible. But then, after restarting Tomcat, the INSERT error did not happen. Can you check if that's the case for you as well?

(0177346) hgbot (developer) 2025-03-27 11:59	Issue exported to Jira: https://openbravo.atlassian.net/browse/RM-24078 [^]

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	OBNetwork customer	=> Gold
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
2025-03-23 23:24	AugustoMauch	Note Added: 0177148
2025-03-23 23:24	AugustoMauch	Assigned To	AugustoMauch => javietxe
2025-03-23 23:24	AugustoMauch	Status	new => feedback
2025-03-27 08:58	AugustoMauch	Assigned To	javietxe => AugustoMauch
2025-03-27 11:59	hgbot	Note Added: 0177346
2025-03-27 11:59	hgbot	Status	feedback => closed
2025-03-27 11:59	hgbot	Resolution	open => duplicate