Why do I see the following error message "UDF execution time limit exceeded by function SINGLE_VALUE_TRANSFORMATION" when I execute a Snowflake batch job?

Question

I see the following error messages when I am running a Snowflake batch job.

 

JOB : 4a9f157c-adef-4361-9174-a0be1f69903e for TENANT : <tenantId> is FAILED Task failed due to 
unexpected snowflake run time error, errorCode: 60, errorMessage:
JavaScript execution error: UDF execution time limit exceeded by function SINGLE_VALUE_TRANSFORMATION,
errorDescription: com.reltio.services.riviera.common.exception.RivieraServiceException: An error occurred while running Snowflake ingestion task. {0}

 

Answer

 This error (based on the below sub-message) occurs when you have a large entity or relations object and Snowflake timed out during the conversion process.  Please raise a Snowflake support ticket to increase the time limit.
 

UDF execution time limit exceeded by function SINGLE_VALUE_TRANSFORMATION

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.