DSXchange

Posted: **Mon Feb 08, 2010 1:00 pm**

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:

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?

Posted: **Mon Feb 08, 2010 2:37 pm**

I think table is locked in the database.

Posted: **Mon Feb 08, 2010 2:52 pm**

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

Posted: **Tue Feb 09, 2010 7:23 am**

Hours after,

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

The problem???
I dont know,

anyway, thks for replies

Posted: **Tue Feb 09, 2010 7:24 am**

Locks.

DSXchange

Simple Job run forever

Simple Job run forever

Re: Simple Job run forever