Error: F_JD0AD7: Timeout: NetWeaver/BAPI Background Job Failed To Start Within the Max Wait Time of 900 Seconds
Issue
While executing a query on High-Volume Agent (HVA) SAP ECC on Oracle with NetWeaver, a timeout occurs, and the following log error appears:
F_JD0AD7: Timeout: NetWeaver/BAPI background job failed to start within the max wait time of 900 seconds. fivetran-r1-ftsource-ftsink: F_JD0ADA: DBMS error [Error during SQL execution]. DBMS error number [999]
Environment
High-Volume Agent SAP ECC on Oracle with NetWeaver
Resolution
There are two ways to resolve this issue:
- Set the NetWeaver job start timeout to
0:- If you manually start the HVA service, run the following command:
- Windows:
hvragentlistener -E HVR_NW_JOB_START_TIMEOUT=0 -acs 4343 - Linux:
hvragentlistener -E HVR_NW_JOB_START_TIMEOUT=0 -d 4343
- Windows:
- If you start the HVA service using an autostart configuration, add
HVR_NW_JOB_START_TIMEOUT=0to your configuration and then restart the autostart service.
- If you manually start the HVA service, run the following command:
- Reduce the
Max size uncompressed, bytesetting on SAP to a smaller byte value than currently configured.
Cause
This issue occurs when a query on SAP encounters memory limitations or takes too long to execute.