Description

These has been seen at times with Wiley and Taylor and Francis electronic holdings upload, as per the attached example screenshot.

In events, the information will state a message of the type (this error message example screenshot)

JOB_ID=xxxxxxxxxxx, ERROR_MESSAGE=job xxxxxxxxxxxx was failed during the process: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired , DESCRIPTION=system job has completed with failure

The message "completed with failure" means the job was aborted and it did not process any record.

Resolution

We cannot get to the cause of the failure generally but the data will be processed in the next run of the job that successfully process the records.

As soon as you seen a job run successfully, then your records will have been uploaded, including the ones that were processed by the failed jobs.

• Article last edited: 19-12-2023