Not able to execute SQL script ORACLE

Mike it look like an error during wrinting log file (only on this task).
I have unchecked the global options of log file and reject records then re-checked it and it looks it work now...

In this case, make sure that the log folder exists and the agent user has enough access rights to write into it.

I am glad you are making progress

Hi Mike,

I still have the problem on executing this task with the scheduler.

If I keep the log option it say file open error, I had not acces to file being written like if file are locked and are written with an error.
All other scheduled tast are working perfectly and log are written without any problem.

It looks like the output in the log of the Oracle query make an error in file wrinting process.

If I disable it the task keep running without being finished.

Can you please try on your side to schedule a query on oracle DB and execute it by agent.

We need a basic example so we can reproduce the problem in the office.

Screenshots scripts etc

Mike,

The script is a basic update of item table see it bellow:

UPDATE ARTICLE SET GEST_DLV=1,GEST_LOT_S=1,GEST_LOT_E=1,FENETRE_FIFO_PREPA=0,FENETRE_FIFO_RECEP=0,RGT_PICK=0 WHERE ID_FAM_STOCK=42

Execution go well in the SQL script tab.
When i use scheduler it keep running without finish the task (agent or vimpent appication) see attached captures.
All other scheduled scripts or package run smoothly only oracle query script are doing this.

Tried execute script with a package and I have same error : task is never finishing (see atached).
The pointed log file is blanck as long as task is running (never timeout) : I have to delete task then file is wiped too.