Skip to main content
Pentaho Documentation

Database Locks When Reading and Updating From A Single Table

If you create read and updated steps to or from a single table within a transformation you will likely experience database locking or slowed processing speeds.

For example, if you have a step which reads from a row within a table--a Table Input step--and need to update the step (with the Update step) this could cause locking issues.

Note: This is known to often cause difficulty with MS SQL databases in particular.