Junk Character in Failed data

[Former Member]

Dear Team,

We have decimal data( weight ) stored in our oracle database. The data is displaying correct values when we run the
rules in Information steward.But it is showing junk character (NaN) in information steward UI when we clicked on View More failed data link.

We tried to change the client code page in failed data connection in CMC too. still the same junk characters only displaying.

Please advice us on how to get rid of this issue.

Any help would be sincerely appreciated.

Thanks in Advance!!

Best Regards,
Priya dharshini Siva.

[Former Member]

Hi Siva,

Which code page you are currently using, make the code page to default and then check. IT should work.

Thanks,

Ramakrishna Kamurthy

[Former Member]

Hello Ramakrishna,

Thank you verymuch for the quick response.

Intially we have created the connection with the codepage value as default only. At that time also we faced this issue.

In source the datatype is Number but while using that data in rule we are giving as Varchar in parameters and we are type casting the data into decimal in rule. This is also not working.

Please let me know if you have any other idea.

Thank you in Advance!!

[Former Member]

Hi Siva,

Have you checked in database level i.e., the database you configured in CMC as Rules Failed Data Database. Also check the default code page of the database too.

Thanks,

Ramakrishna Kamurthy