Error Encountered While Executing Query (ORA-10173 - Dynamic Sampling Time-Out Error)

After migrating from Knime 4.xx to 5.3, I sometimes encounter the error: “ORA-10173 - Dynamic Sampling Time-Out Error” while executing any query.

I have tried to fix the issue with the following actions, but it hasn’t been resolved yet:

• Since my database is Oracle, I tested other OJDBC drivers.

• I checked other executed nodes, such as ‘DB Query Reader’ and ‘DB SQL Executor.’

• I removed the parallel execution statement from my query because the IT department has limited parallel executions to 5 per user.

SELECT /*+ PARALLEL(your_table, 5) */ *
FROM your_table;

I marked the checkbox for ‘Restore Database Connection’ in the Oracle connector in the advanced tab.

@armingrudd