Simple Job run forever

[dancristian]

Hi everybody!!

I'm developing a simple server job.
Sequencial File -> Transform -> DataBase



Initially, DataBase stage i use OCI, but, to test, i change to ODBC.

Below sql in ODBC:

Code: Select all

UPDATE PCB_TABLE SET DATE_FINAL = ? WHERE (COD_UNIT = ? AND COD_CTO = ? AND COD_SCTO = ? AND COD_PL = ?);

I set ODBC for only update (Business Rule).

The Sequencial File Input have a one record.

SF content - "1","00000042","00000000","398"

Transform stage create the column DATE_FINAL, carry "@NULL".

Conclusion, this "simple job" run forever.

Last line in log (Director):
"JOB_SEQ..ODBC_7: Using project default NLS map MS1252"

Anybody have a idea?

[kondeti]

I think table is locked in the database.

[chulett]

Probably the record but yes, sounds like some kind of a locking issue. Have your DBA check.

[dancristian]

Hours after,

i tried execute job, again..
and finished successfully.

The problem???
I dont know,

anyway, thks for replies

[chulett]

Locks.