ORA-01455: converting column overflows integer datatype

[Former Member]

Hi All

I'm getting the below error while executing a report.

ORA-01455: converting column overflows integer datatype

SQL Error: 1455

Error while reading data; navigation is possible

>> Row: 71 Inc: NEXT_PACKAGE Prog: CL_SQL_RESULT_SET

The report is created on a cube.

The report executes fine for below selections

Sales Org: 1111

Day Interval: 01.01.2011 - 01.01.2011

but gives the error if I increase the Day Interval for more than 1 day.

Ex:

Day Interval: 01.01.2011 - 02.01.2011

Day Interval: 01.01.2011 - 31.01.2011

Please help.

Regards

Murthy Gunuputi

[former_member182226]

Hi Murthy,

1 of the cause of this particular error is inappropriate date value in data provider, Bex does not recognize blank value for date field. if date is not populating for any of records then it should have atleast unassigned value or '00000000'(yyyymmdd).

check Bex query after removing date field from display, if query works fine then check data value for date fields should not be blank, if present then update it as "00000000".

Regards,

Avinash

[Former Member]

Hi,

Where are you executing this report? BEx or any portal.

I'm thinking its most probably BEX.

If so its due to a numeric overflow.

Check these notes:

SAP Note 1557321 - Numeric Overflow during standard BW processes

SAP Note 1050329 - BR*Tools fails with ORA-01455 when database exceeds 16 TB

SAP Note 591600 - Error due to inappropriate column values

Hope this helps

Regards,

Joe

[Former Member]

Hi,

check this thread:

In this case , SAP Note 591600 - Error due to inappropriate column values is suggested.

Regards,

Arpit

[Former Member]

refer this,similar issue is discussed here.....