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