topic Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype in Application Development and Automation Discussions

DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

ibrahim_u — Tue, 19 Dec 2006 09:44:08 GMT

Hi all,

I have a problem with generating a customer program in our 4.6C version and Patch Level 48.

I changed something in program in Development System and i transported to the test system. I tested the program in test system and i transported to Production(Live) system. But when i try to run program in SE38 it is taking long taime and never run only in Production System.

I goto SM50 to trace it, it is selecting from D020L table and doesnt change when i refresh the screen.

when i goto SE16 and execute D020L table with parameter program name there is no record with my program name. when i execute without any parameters it gives me

"DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype"

"DBIF_RSQL_SQL_ERROR"

"/1BCDWB/DBD020L " or "/1BCDWB/DBD020L "

"START-OF-SELECTION"

and when i try to generate program in SE38 it is taking infinity time.

I have looked in OSS Notes but i dont found anything.

Have you got any idea ?

Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

Former Member — Tue, 19 Dec 2006 09:51:09 GMT

Hello,

May be this is due to the Range overflow.

Check the range table, it should have only 5000 records.

If useful reward.

Vasanth

Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

Former Member — Tue, 19 Dec 2006 09:57:43 GMT

Hi ,

I also obseved the problem , the table gives a value only when we specify a value in the where clause of the select statement.

Would it be possible for you to check what is the value in the where clause of the select statement in production.

Regards

Arun

Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

Former Member — Tue, 19 Dec 2006 09:59:30 GMT

Check this note : 591600

Regards,

GSR.

Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

Former Member — Tue, 11 May 2010 09:52:22 GMT

hi friend,

Now I have the same question.

I don't know if you have deal with it.

Would you like to tell me how to do?

TKS.

Re: DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

Former Member — Tue, 11 May 2010 09:57:34 GMT

hi,

tks,I had check the note 591600, Mybe there is no answer for the question.