Skip to Content
0
Sep 09, 2018 at 07:43 AM

DBIF_RSQL_SQL_ERROR - Create Index error

169 Views

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?