Job gets hung

[prasad111]

Hi,
The job design looks like

Code: Select all

                                          /--------> Transformer ---> ODBC
                                         |
external Source Stage --> XML -----> Transformer ---> ODBC
                                         |
                                         |\--------> Transformer ---> ODBC
                                         |\--------> Transformer ---> ODBC
                                         |\--------> Transformer ---> ODBC
                                         |\--------> Transformer ---> ODBC
                                         \--------> Transformer ---> ODBC

All the ODBC are connecting to SQL Server and they load around 100 -1000 records per file.....

The job finishes around 10 secs when run fines..... sometimes it gets hung up at after printing till
main_program:Echo:(....)
main_program:Explanation:(...)
and keeps on waiting......no error............

By searching in dsxchange... I have tried the following...
I tried to look at the process created in UNIX it looks running, in RT_SCTEMP there is a file created with the right process and no locks
files created under &PH&, mention the process running and no issues there also
The load on the CPU is also looks good
In database also there are no locks

Could any one please suggest what else I can check to find the root cause of the problem.

Your replies are highly appreciated.

Thanks & Regards
Prasad

[ray.wurlod]

Does each ODBC Enterprise stage refer to a separate table?

[prasad111]

Yes, each ODBC Enterprise stage refer to seperate tables.