Issue with Talend Open Studio Connecting and uploading
Hello all I am in need of some major help.
I've been running queries and uploads for at least 2 to 3 years now on the system, but lately the processes have been going slow and I checked a log file, and this is the error that it shows.
value used for ROWS parameter changed from 64 to 55
SQL*Loader-643: error executing INSERT statement for table TABLE_NAME
ORA-03113: end-of-file on communication channel
Process ID: 15816
Session ID: 341 Serial number: 13438
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Specify SKIP=5830 when continuing the load.
Any input would be greatly appreciated. This process I have set to run using windows task manager every 30 minutes everyday... and it was going fine.
This particular connection connects to an openedge database, runs a query and then uploads to an oracle server database using oracle apex.
I can understand your situation totally and have escalated your studio performance issue to our manager to see if there is a way to find out the root cause or a workaround for you.
You said earlier in this post "it was working for 2 to 3 years and now all of a sudden it is giving me a problem". Have you recently made any changes to your Talend installation or maybe the job?
Nothing is automatically pushed to your environment for Talend. As such, if you are noticing recent issues that you have not seen before and you have made absolutely no changes to Talend, the problem arguably lies elsewhere.
