Page 1 of 1

impact of warning message on oracle table

Posted: Sat Sep 20, 2008 1:45 am
by pxraja
Hi all,


Warning message like
1) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
0 Rows affected.
2) MetaData mismatch
COLUMN.TYPE Expected = Decimal Actual = Double
3) Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated


Just want to know out of these which type of warning will affect the oracle table or which warning should be taken care with high priority and whether warnings will affect the running time of the job.

Whether If I am chaning the Outlink datatype of the transformer to avoid warnings will it affect the oracle table or data flowing to that table?

Can any one share your views

Thanks in Advance

Posted: Sat Sep 20, 2008 2:56 am
by ray.wurlod
1) No effect. Something failed, no rows were affected. The message itself tells you this.

2) Maybe but probably not. The Oracle table has one of these data types, your job has the other. Some Decimal values are compatible with Double (for sufficiently small Double and appropriate Decimal precision) while others are not - some Double numbers are just too large for Decimal to represent them.

3) Definitely. You have sent data values that are too large to go into their target columns so they have been truncated to fit. What's in the Oracle table is not what you sent. The Oracle table itself is intact (from a DBA perspective) but may contain incorrect data (from a business perpective).

Priority is, as always, a personal preference.
Generating thousands of warnings will necessarily extend the running time of your job, because each warning has to be returned to DataStage and logged.
Prevention is better than cure here.

Posted: Sat Sep 20, 2008 4:14 am
by pxraja
ray.wurlod wrote:1) No effect. Something failed, no rows were affected. The message itself tells you this.

2) Maybe but probably not. The Oracle table has one of these data types, your job has the other. Some ...
Thanks Ray, But how about the data truncated is not passed to the Outlink? so no warning is that much serious and does not have impact on job running time?

where can I see for more details about those warnings?

any suggestions are welcome

Thanks in Advance

Posted: Sat Sep 20, 2008 4:20 am
by ray.wurlod
All the answers are there. All you need to do is buy yourself a premium membership, or get your employer to buy it.

Premium membership is not expensive, at less than 30c (Rs12) per day. It gives you access to the entirety of premium posters' posts, as well as other benefits. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met.

Posted: Sat Sep 20, 2008 7:40 am
by chulett
What are you using to access Oracle? ODBC? These kind of 'BCI' messages are not logged by the native OCI stage, hence the question. Aslo note that #1 must be coming from an update or delete and is telling you that it updated or deleted nothing. Only you can know if that is a problem or not with the job in question.