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

KNIME Analytics Platform
1

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
    DB Connection Closer
2

knime pic
knime pic1052×334 127 KB

This is my Workflow

3

Have you tried adjusting the time outs?

image
image762×884 22.7 KB

Note: The above might not be the actual setting to adjust. DB timeouts can be cause by too ambiguous requests. Try narrowing down your query.

Best
Mike

4

@samantbl maybe put the connector outside the loop

5

Unfortunately, this setting does not solve the problem.

6

Hello @samantbl ,
did you already contact the Oracle support? The “ORA-10173 - Dynamic Sampling Time-Out Error” error seems to be a problem with the query optimizer. There is also a support document from Oracle about it but you need an Oracle support account to read it :frowning:
I’m afraid there is not much you can do on the KNIME site except wrapping the DB nodes that fail into a try catch nodes and re-execute it on error.
Bye
Tobias

3 Likes
7

Dear @samantbl,

Regarding @tobias.koetter’s suggestion to re-execute the DB nodes on failure, here you can find an example how to do so:

1 Like