Job got stuck- process completed but still in running status

[Hema.k]

Hi Everyone,

We have below design as below in a single job.

oracle ---> odbc
oracle ---> odbc
oracle ---> odbc

It is running fine but at sometime it got stuck. i.e job extraction & Loading process completed but then it is in running status.
while monitoring the job it shows finished in all stages but the job is not finishing.

Could anyone let me know the cause for this issue & also a solution to resolve this.

Thanks in advance.

Regards,
Hema

[ray.wurlod]

Are there any warnings in the DataStage log or in the Oracle logs?

Search DSXchange for DSJS.RUNNING - worst case you can clear the job status file using administrative menu option in Director.

[pandeesh]

And also trace the session with the help of your dba.
Check whether the session is active or becomes inactive.

[Hema.k]

Thanks for the reponse ...

@Ray: There are some datatype conversion warnings.
Below is the last message obtained after which the job got stuck.

main_program: Step execution finished with status = OK.


@Pandeesh: There were no active sessions available in the db.


Regards,
Hema K