ORA-01455: converting column overflows integer datatype

[#1]

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 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