Data Services Error log

[Former Member]

Hi,

While loading the csv data to BPC 10.0 using FIM 10.0 (Data services is in the below layer)

The error message got is,

(14.0) 02-02-12 01:21:24 (E) (9204:8844) RUN-050802: |Data flow DF_LOAD_Job104|Transform RejectedRows

Cannot convert data <2010.JAN> into type <DECIMAL>. Context: Column <Project Column AMOUNT>.

(14.0) 02-02-12 01:21:24 (E) (9204:8844) RUN-050304: |Data flow DF_LOAD_Job104|Transform RejectedRows

Function call <to_decimal_ext ( 2010.JAN, ., , 38, 10 ) > failed, due to error <50802>: <Cannot convert data <2010.JAN> into

type <DECIMAL>. Context: Column <Project Column AMOUNT>.>.

(14.0) 02-02-12 01:21:24 (E) (9204:8844) RUN-053008: |Data flow DF_LOAD_Job104|Transform RejectedRows

INFO: The above error occurs in the context <|Data flow DF_LOAD_Job104|Transform RejectedRows|Project Column AMOUNT|nvl(...)

Function Parameter-1|to_decimal_ext(...) Function Body|>.

(14.0) 02-02-12 01:21:34 (E) (8372:7208) RUN-050316: |Session Job104

Cannot convert data <2010.JAN> into type <DECIMAL>. Context: Column <Project Column AMOUNT>.

(14.0) 02-02-12 01:21:34 (E) (8372:7208) RUN-050304: |Session Job104

Function call <raise_exception ( Cannot convert data <2010.JAN> into type <DECIMAL>. Context: Column <Project Column AMOUNT>. )

> failed, due to error <50316>: <Cannot convert data <2010.JAN> into type <DECIMAL>. Context: Column <Project Column AMOUNT>.>.

(14.0) 02-02-12 01:21:34 (E) (8372:7208) RUN-050316: |Session Job104

Cannot convert data <2010.JAN> into type <DECIMAL>. Context: Column <Project Column AMOUNT>.

Any one has seen this type of error before?

Any thoughts??

[Former Member · Accepted solution]

Hi,

This error is saying that the data value ("2010.JAN") that you are trying to load into the AMOUNT column is incompatible with the DECIMAL data type of this column.

The likely causes for this are either:

1) The AMOUNT column has been mapped incorrectly - check that you have mapped the correct source column to this.

2) Data quality issues in the source data - the column which contains amounts in the source also contains other data e.g. month as above. This would either need to be resolved in the source or Data Services could be used to validate the data and only pass the valid records to BPC.

Regards

Nigel

[Former Member]

Hi,

You are having an unexpected value in column AMOUNT - 2010.JAN. The function call to_decimal_ext() used inside the transformation is not able to convert the same into a decimal. That's why you get this error.

You can try this in the Query transform where you are using to_decimal_ext() to convert the value

decode(is_valid_decimal(RejectedRows.AMOUNT,'9999.99')=1,to_decimal_ext( RejectedRows.AMOUNT,'.',',',38,10),0)

Regards,

Suneer