Hi Experts,
Kindly assist on the below Runtime error I am facing, in Create Index step of local PC where the job has been cancelled.
In st22, I got the below details.
Database error text........: "ORA-01455: converting column overflows integer datatype" Internal call code.........: "[RSQL/COUN//BIC/FNAWF_C01 ]" Please check the entries in the system log (Transaction SM21).
The procedure is in program "SAPLRSDU_INDEX_ORA "; its source code begins in line 1 of the (Include program "LRSDU_INDEX_ORAU02 ".
ATA: l_count TYPE int4,
l_batch_chk TYPE rs_bool.
>>>>> SELECT COUNT(*) FROM (l_s_dta-facttab) INTO l_count.
IF sy-batch <> 'X' AND l_count > 100000.
sy-batch = 'X'.
l_batch_chk = 'X'.
ENDIF.
How to solve this? Is this an issue with large records when SELECT statement is executing?