Exceptions handling for Google BigQuery as a target

[vdna101]

Hi

currently Qlik Replicate doesn't support exceptions table error handling option for BigQuery.
See https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Main/Google%20Cloud%20BigQuery/...

- Are there any plans to support the exceptions table error handling option for BigQuery in Qlik Replicate?

- Are there some aletrnative methods to handle and track exceptions? 

- Will error-related information (incl. SQL-Statement) be stored in the log file with the log level set to "trace"?

For example: when error on insert due to the wrong timestamp format occurs?

- Any Other ideas?

[sureshkumar]

Hello @vdna101 

If the option "Apply changes using SQL MERGE" in Change Processing Tuning is unchecked, then log exception table option will be enabled in Apply Conflicts.

Regards,
Suresh

[vdna101]

Hi Suresh
attrep_apply_exceptions is currently not supported for the Big Query as a target according to Qlik Replicate Documentation.

[sureshkumar]

Hello @vdna101 

I agree with you, but when we uncheck the option "Apply changes using SQL MERGE", we can set the exception table in Apply conflicts settings. Kindly test it once.

Regards,

Suresh

[DesmondWOO · Accepted solution]

Hi @vdna101 ,

Let's say, cannot find a record to update (0 rows affected), the update statement will be logged into the attrep_apply_exception table. 

Regarding "The Log record to the exceptions table error handling option for Apply Conflicts and Data Errors is not supported.", I think it may be a limitation with using SQL MERGE. I would suggest to create a support ticket to verify with R&D.

Regards,
Desmond

[vdna101]

Hello Suresh and Desmond

thank you very much for your support.

Our test with Qlik Replicate applying changes to Big Query target shows, that the attrep_apply_exception table gets a new error log record (0 rows affected) when an update on a non existing record in the target table occurs.

The real system behavior in that case differs from the documented limitation:
"The Log record to the exceptions table error handling option for Apply Conflicts and Data Errors is not supported."

Best Regards, Vadim 

[DesmondWOO]

Hi @vdna101 ,

As the behavior differs from the documentation, I would suggest to create a support ticket to clarify the behavior.

Regards,
Desmond

[vdna101]

thank you, support ticket created