requestingNode.log is not a function

[akhiljakka]

I am having an issue while using this node (version 0.6.3).
My project is to collect the data from one oracle database and post it in another oracle database, in normal conditions it is working fine but if my internet disconnects, my node red stops and throws the following exception ( requestingNode.log is not a function) as shown in the screenshot. Also in debug node I get ( Oracle query error: DPI-1010: not connected, errorCode:DPI-1010: )

Please check this. I hope even my internet disconnects and reconnects after sometime, the oracle DB should resume without a fault.

Thank you
Akhil

[RobbeM1991]

I'm having the same error and don't really have a clue where to look...
The only difference is, it's caused by another Oracle query error: DPI-1080 instead of DPI-1010.

Below the logs:

1 Jul 10:34:23 - [info] [oracledb:Query the XXX stappen status from YYY database] Oracle query start execution
1 Jul 10:34:23 - [info] [oracledb:Query the XXX stappen status from YYY database] Oracle query execution started
1 Jul 10:34:23 - [error] [oracledb:Query the XXX stappen status from YYY database] Oracle query error: DPI-1080: connection was closed by ORA-3135, errorCode:DPI-1080:
1 Jul 10:34:23 - [info] [oracledb:Query the XXX stappen status from YYY database] Checking errors for retry
1 Jul 10:34:23 - [info] [oracledb:Query the XXX stappen status from YYY database] Oracle server connection lost, retry in 5000 ms
1 Jul 10:34:28 - [red] Uncaught Exception:
1 Jul 10:34:28 - [error] TypeError: requestingNode.log is not a function
    at Timeout.OracleServer.node.query [as _onTimeout] (/usr/src/node-red/node_modules/node-red-contrib-oracledb-mod/lib/oracledb.js:202:28)
    at listOnTimeout (node:internal/timers:561:11)
    at processTimers (node:internal/timers:502:7)
1 Jul 10:34:45 - [info]

Welcome to Node-RED
===================

1 Jul 10:34:45 - [info] Node-RED version: v3.0.1
1 Jul 10:34:45 - [info] Node.js  version: v16.20.0
1 Jul 10:34:45 - [info] Linux 3.10.0-957.el7.x86_64 x64 LE
1 Jul 10:34:46 - [info] Loading palette nodes

This issue only happens once in a while.

Any who has a clue on what's the issue here or how to solve? Thanks!

[akhiljakka]

Hi Robbe, I reverted back the oracle node's version to a previous one. This solved the issue.

[TeruyukiMatsuzaki]

I'm having the same error too.
Is this fixing is right? thx.
node-red-contrib-oracledb-mod/lib/oracledb.js : 226 version 0.6.3
node.reconnecting = setTimeout(node.query, node.reconnectTimeout, requestingNode, query, values, resultAction, resultSetLimit);
↓
node.reconnecting = setTimeout(node.query, node.reconnectTimeout, msg, requestingNode, query, values, resultAction, resultSetLimit);