Database Software

Hi to all,


I have created a workflow (I have exported the diagram in jgp, please have a look to the image)


[http://marcoverga86.netsons.org/fp-content/images/flow.jpg]


When i try to execute the flow i get this ERROR:



Name Status Log

KCI3_FLO Success



KCI3_FLO:POPOLAMENTO_LOG_PROCESS Error



ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-29400: data cartridge error

KUP-04040: file KCI3.txt in STAGING_AREA_LOCATION not found

ORA-06512: at "SYS.ORACLE_LOADER", line 19

ORA-06512: at "OWBOWN.POPOLAMENTO_LOG_PROCESS", line 162

ORA-06512: at line 1



KCI3_FLO:P_GET_DIRECTORY Success



KCI3_FLO:P_CONCATENA_STRING_1 Success



I don't understand why the flow does not respect the order of execution given by the sequence of defined transition. I will explain better the problem, as you can see from the image the first thing that should be executed is the transformer P_GET_DIRECTORY but for some reason it does not work. It executes the POPOLAMENTO_LOG_PROCESS (as you can see from the log above) as the first activity. Due of this, the error is shown because it's necessary that P_GET_DIRECTORY is the first activity to be executed.

As shown by the image, there aren't any unconditional transition, so no warning are shown validating the flow. Previously, the occurrence of at least one unconditional transition gave us the same problem about strange execution order of activities. So we dropped all the unconditional transitions, possible cause of execution order problems.

Could anyone help me to fix the problem?

Thanks in advance.