DB Query: error ORA-12592

#1

Hello,

We have a wf with some DB nodes that works perfectly in local machines. But in the server it fails when:

  • It has to read a file (table reader) in the server. This node reports some timeout errors, but file is in the same folder and path is ok. But what makes this situation more crazy is that you can open the job manually and re-execute it until the server success in reading the file ¿¿WTF??

  • Also, we have a DB query that reports an error ORA-12592

image

and we cannot view/modify its config (although it is ok, works perfectly in local) in jobs viewer:

image

Any idea?

0 Likes

#2

Hi,
Regarding the timeout when reading the file. Can you provide us with some more information regarding who is the workflow executed e.g. scheduling, manual or via REST?

ORA-12592 seems to be a problem with the network communication between the db machine and the machine the KNIME Executor is running on.

The job view does not support all node dialogs and outport types yet. We are working on it to support more and more dialogs and port types.
Bye
Tobias

1 Like

Switching credentials automatically between local/server
#3

Hi Tobias,

The workflow is both executed scheduling (everyday at 7am) and manually (using server’s jobs view). When scheduling, for example this morning, it always stops without errors in the File reader node:

image

If I then open its job with the jobs view, I’m able to execute this File Reader node and complete the workflow execution.

Regards.

0 Likes

#4

Hello again,

How can we get more details about what is the cause of this problem? We are sure about this error appears in both local and server execution. Is there any log we can see for details?

Regards.

0 Likes

#5

Will follow up via support mail.
Bye
Tobias

0 Likes