AnsweredAssumed Answered

question about transformation [Execute SQL script]

Question asked by Joey Lu on Dec 19, 2018

PDI version : pdi-ce-8.1.0.0

 

when I use cronjob to run kitchen every 5 min, I found sometimes my job will false (most of time is success), and I use debug level to check error, error like this:009.png

the error always occur in [Execute SQL script] step in sub transformation, is it PDI error ? or is destination (Oracle) error ?

 

here is SQL in [Execute SQL script] to Oracle

010.png

Outcomes