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
Reading error but job finished successfully
Moderators: chulett, rschirm, roy
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
hi thanks for reply
actually there is a record in the dataset and im able to view also..........
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
DPRAKASH
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.
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.
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------