Script error handling

Perus_Pena — Tue, 28 Dec 2021 19:45:34 GMT

I have an issue that sometimes snowflake connector does not work and it gives Error 6, howerver without changing anything and just rerunning the code it works. So earlier I made a Do Loop while ScriptError = 6 to just run the code again if the error occurs. However reading through the error log from last night the error happened and looks like it didn't loop.

Any pointers what might be wrong here?

-Pena

2020-09-14 22:29:53 0027 LIB CONNECT TO 'Snowflake-prod'
2020-09-14 22:29:57 0029 Do
2020-09-14 22:29:57 0030 TABLE:
2020-09-14 22:29:57 0031 LOAD
2020-09-14 22:29:57 0032 *
2020-09-14 22:29:57 0034 SQL SELECT
2020-09-14 22:29:57 0035 *
2020-09-14 22:29:57 0036 FROM "XXXXXX"."PUBLIC"."TABLE"
2020-09-14 22:30:01 Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 6, ErrorMsg: [Snowflake][Snowflake] (6)
2020-09-14 22:30:01 Assertion failure: json_type_mismatch
2020-09-14 22:30:01
2020-09-14 22:30:01 0037 Loop while ScriptError = 6

topic Script error handling in Connectivity & Data Prep

Script error handling