Data Stream out - intermittent Error -

[JohnBell]

Hi,

We have a workflow that runs on the server, and every now and then, it errors out with the following message:

 Data Stream Out (49) Error SQLExecute: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR:  1023¶DETAIL:  Serializable isolation violation on table - 339181, transactions forming the cycle are: 89032765, 89032809, 89032906 (pid:35566)¶

Has anybody else received the message above?  What did you do to help correct it?

Thanks,

[RishiK]

Are any processes or workflows running at the same time when you get this error?

This error will occur when 2 jobs are writing to the same table concurrently.

To avoid this you can organise your jobs to avoid the conflict with multiple workflows, or you can use the Block Until Done tool in the workflow itself.

[JohnBell]

@RishiK 

Thank you!

It is running on the server...and yes, there is a possibility that it is writing to a table that another workflow is writing into.  (I will investigate).

And thanks for the tip on the Block Until Done tool...

Thank you so much!