DSXchange

HI all

im getting error while reading source dataset and updating record in a table. job shows finished status but there is no records showing in the designer and also not updating in the table.

in the director log there are no warning or fatal error.....

some info it is showing like below
Contents of phantom output file =>
DataStage Job 95 Phantom 23520
ABAJBFEEDBK08.Cdc_PRVD not found in RT_CONFIG (2).
ABAJBFEEDBK08.Fnl_BARCODE not found in RT_CONFIG (2).
ABAJBFEEDBK08.Cgen_DUMMY not found in RT_CONFIG (2).
ABAJBFEEDBK08.Tran_SEQ not found in RT_CONFIG (2).
ABAJBFEEDBK08.TRANS_ASSIGN not found in RT_CONFIG (2).
ABAJBFEEDBK08.Lkp_XDR_ITEM_I not found in RT_CONFIG (2).
ABAJBFEEDBK08.Fnl_BARCODE not found in RT_CONFIG (2).
ABAJBFEEDBK08.DB2_XDR_ITEM_BAR_CODE1 not found in RT_CONFIG (2).
ABAJBFEEDBK08.Lkp_XDR_ITEM_I not found in RT_CONFIG (2).
ABAJBFEEDBK08.Cdc_PRVD not found in RT_CONFIG (2).
ABAJBFEEDBK08.DB2_XDR_ITEM_BAR_CODE not found in RT_CONFIG (2).
ABAJBFEEDBK08.Tran_SEQ not found in RT_CONFIG (2).
ABAJBFEEDBK08.Cgen_DUMMY not found in RT_CONFIG (2).
ABAJBFEEDBK08.TRANS_ASSIGN not found in RT_CONFIG (2).
ABAJBFEEDBK08.XDR_ITEM_BAR_CODE_MAX not found in RT_CONFIG (2).

Please hele me regarding this

thanks

Hi..

There was a issue with the ds 7x versions for which it doenst aborts the job whenever there is a warning for update statments.

If row is not present in the database and there is update statement to update such non existing record, there is fatal error message for that in the log, however job is not aborted with this error..

However I am not sure why it is working, if you are saying that data is not readable in input..

Can you check and view the data in the input dataset ?

--------------------

Hope this helps

---------------------

MK

If column definitions are not found in RT_CONFIGnnn this usually means that the compilation was not entirely successful. Try re-compiling.

hi thanks for reply

actually there is a record in the dataset and im able to view also..........

mk_ds09 wrote:Hi..

There was a issue with the ds 7x versions for which it doenst aborts the job whenever there is a warning for update statments.

If row is not present in the database and there is update statement to update such non existing record, there is fatal error message for that in the log, however job is not aborted with this error..

However I am not sure why it is working, if you are saying that data is not readable in input..

Can you check and view the data in the input dataset ?

--------------------

Hope this helps

---------------------

MK

You can find out the error which might have caused the phantom error..
Go to the director and reset the job. It will give what exactly the error is..
Depending upon that error, you can take the preventive action..

Are you using transformer stage before loading the data into the database?
When there is any unintialized stage variable, that can cause the phantom error.