DBIF_RSQL_SQL_ERROR ORA-01455: converting column overflows integer datatype

[ibrahim_u]

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 ?

[Former Member]

Hello,

May be this is due to the Range overflow.

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

If useful reward.

Vasanth

[Former Member]

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

[Former Member]

Hi

Check this note : 591600

Regards,

GSR.

[Former Member]

hi,

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

[Former Member]

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.