cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_SQL_ERROR - Create Index error

former_member591247
Discoverer
0 Kudos

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?

matt
Active Contributor
0 Kudos

You should probably have a look at support.sap.com and raise a message if you find no solutions there.

Accepted Solutions (0)

Answers (2)

Answers (2)

In my experience, adding the step "Delete Index" before loading data to Infocube has fixed this issue before running "Create Index". Hope this helps you.

ImtiazKaredia
Active Contributor

Check

2114836 - ORA-01455: converting column overflows integer datatype in BW

or

2009902 - Error ORA-01455 when creating an index for a huge BW table