Error: F_JD02D6 Operation Timeout. Timed Out Polling the Job

Issue

The integrate job fails while polling the database status, resulting in failed integration attempts, with the following error:

F_JD02D6: DBMS error [(115) Operation timeout. Timed out polling the job]. DBMS error number [115].

Environment

• HVR 6
• Target: BigQuery
• Environment variable: HVR_BIGQUERY_ENABLE_SESSIONS=1

For more information about this environment variable, see Google BigQuery as Target.

Resolution

To resolve this issue, upgrade to HVR version 6.3.0/18 or later. This release modifies the integrate query that identifies orphan sessions to include the service account email, project ID, and job creation time in the WHERE clause.

Cause

This issue occurs when the query we use to identify orphan sessions during integrate recovery takes longer than the our configured polling timeout. In affected HVR versions, the query doesn't filter by the service account email, project ID, or job creation time, which may result in a longer execution time.