Numeric Value Out Of Range

[Former Member]

Hi All,

I am loading the data from Oracle DB to BODS Temp Table.

I just used Query Transform.

But job is failing with Error: Numeric Value Out of Range. SQLState = 22003..

Could you please help me on this.

Regards.

[Former Member]

Hi,

Please share the filed details like data type and etc.....

[Former Member]

Hi,

I have Used Varchar 255, decimal, int data types.

After getting this error, I have deleted all data types and mapped only one varchar field still I am facing same error.

Regards.

[Former Member]

What is the source data type? and share the example data which you are getting in source table.

[Former Member]

HI

Decimal, Varchar, Int are 3 data types coming into Data Services.

Regards

[Former Member]

Hi Srinivas,

Could you please help me on this..We are facing this Issue in Production so it is highly critical..

Regards.

[Former Member]

Hi,

May be the below link help you, if you are using temp table in the sql server.

https://support2.microsoft.com/kb/313352/en-us

I think you can also try this as below:

If you are using the ms sql server as a target, instated of ms sql server use orcle DB to load the data for this particular table. let see you are getting this error or not.

If you are not getting the error in orcle DB, so there is a problem with your ms sql server db.

[Former Member]

Hi,

You can also try convert function also, may be it will help you.

Convert function in BODS :

Cast(expression, data_type)

[former_member211387]

Hi,

Can you send a screenshot of the error log message?

When you say you are mapping only one varchar field to the target template table, does it mean that you have one query transform connecting the source oracle table to the ms-sql server template table with this varchar field as the output schema mapping?

kind regards

Raghu