Profile

Florian Gehri

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 2 of 2 total

RE: Deadlock in Transformation Log Table (trans_log) by calculating change date capture

Posted By Florian Gehri 09-20-2019 05:46
Found In Community: Pentaho \ view thread
Additional Information: The deadlock-manager of MSSSQL says, that the deadlock occurs from this statement: (@P0 nvarchar(4000)) SELECT ENDDATE, DEPDATE, STARTDATE FROM PDI_TRANS_LOG WHERE ERRORS  = 0 AND  STATUS  = end AND  TRANSNAME = @P0 ORDER BY LOGDATE DESC, ENDDATE DESC   Had anyone the same pr ...

Deadlock in Transformation Log Table (trans_log) by calculating change date capture

Posted By Florian Gehri 09-19-2019 05:55
Found In Community: Pentaho \ view thread
We have a lot of transformations (the most are Dimension lookups and some are fact-lookups) that are running in parallel. Every transformation can run 4 times in parallel. We achieve that with a Job executor Task that start 4 parallel instances. In the JobExecutor are all the transformations. With this ...