I have a KNIME workflow that deletes from and then writes data to a table in an on-premise Oracle database. It runs successfully on my local machine.
When I publish on the server and run the workflow, I am getting the below error.
The column mentioned in the error message contains the year and therefore it has always 4 characters. I even used the string manipulation node to ensure 4 characters substr(strip($KPIYEAR$), 0, 4) but I’m still getting that error. The workflow runs fine on the platform and inserts that data to Oracle.
Any help would be appreciated. Thanks!