cancel
Showing results for 
Search instead for 
Did you mean: 

Fail when create index

former_member199630
Contributor
0 Kudos

Hi all,

I am re-creating BIA thru RSDDV T-CODE. I have deleted and created again but when i try to fill it, the job finish succesfully in 20 seconds, and if I go to the log thru SM37 this is the log that I get. at the end it says "FILLING FAILED -> CHECK LOG" ?

Where can I see this "log" ? Do you have any idea what could be happen?

Regards, Federico

Job started

Step 001 started (program RSDDTREX_AGGREGATES_FILL, variant &0000000000646, user ID 10333810)

ZAV_C_01 OFF

ZAV_C_01 OFF

ZAV_C_01 OFF

INFOCUBE: ZAV_C_01

Statistics UID of indexing job: 'D74NPBHCNU9LD6AAYRHYGXE99' (RSDDSTATTREX/RSDDSTATTREXSERV)

ZRV_C100 ACT

ZRV_C100 ACT

ZAV_C_01 OFF

ZAV_C_01 OFF

Loading data to index BA8_BIC:SZ_CONTRCT (records '0000625000', job '1' )

Loading data to index BA8_BIC:SZ_CONTRCT (records '0001250000', job '2' )

Loading data to index BA8_BIC:SZ_CONTRCT (records '0001875000', job '3' )

Loading data to index BA8_BIC:SZ_CONTRCT (records '0001930942', job '0' )

FILLING_FAILED >CHECK LOG!!!!!

Job finished

Accepted Solutions (1)

Accepted Solutions (1)

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi Federico,

Yeah, I agree that the error control is sometimes hilarious - it happenes that job is green while there is a failure... It is causing lots of concerns in customer community with regards of reliability of automation of the processing in BW...

Log is written in application log (transaction SLG1). The eseair way to find it is once you are in the BWA index creation wizard for your InfoCube, there should be like "Log" button, and then you can chose an option for "Initial filling".

Regards,

-Vitaliy

former_member199630
Contributor
0 Kudos

Hi Vitaliy,

Thanks for your quick answer. In the SLG1 t-code this is what it says:

Filling of the index 'BA8_BIC:SZ_CONTRCT' terminated. Error text:

2994

Creation of the BIA index for InfoCube 'ZAV_C_01' terminated while filling

Creation of the BIA index for InfoCube 'ZAV_C_01' terminated while filling

Do you have any idea, about what could be happened? We restarted the BIA Server and BIA index server, but the issue insist.

Regards, Federico

Former Member
0 Kudos

Hi Federico,

I am not sure if you have tried this program. Sometimes these tricky BWA programs do the magic.

Run the program RSDDTREX_SINGLE_TABLE_INDEX for you cube by giving the reason field as free text and table name as

/BIC/SZ_CONTRCT following the below approach.

Step1: Delete the BWA Indexes of the cube.

Step 2: Recreate the Indexes of the cube ( DO NOT FILL INDEXES) from RSDDV

Step 3:Run the program RSDDTREX_SINGLE_TABLE_INDEX by giving your cube name and table name as /BIC/SZ_CONTRCT.

Step4: Fill BIA index of this cube from RSDDV.

This program will recreate the index for the selective table (in your case /BIC/SZ_CONTRCT) unlike the RSRV check.

Hope this helps.

-Vikram

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi Federico,

This error message does not say much. I hope that you opened an OSS message to SAP Support already to look at that.

In the meantime, could you please share the details of data type of SZ_CONTRCT infoobject? I assume you have already other infocubes indexed, but it is only this indexing job that failed? You mentioned that you are re-creating BWA. Does it mean that this cube was indexed before?

Thanks,

-Vitaliy

Former Member
0 Kudos

Hi Fedirico,

Where you able to solve your issue? If so, how was it resolved? We're also experiencing similar issue when re-accelerating an infocube.

Thanks,

Pedro

Former Member
0 Kudos

Hi Pedro,

You can try the steps below:

Step1: Delete the BWA Indexes of the cube.

Step 2: Recreate the Indexes of the cube ( DO NOT FILL INDEXES) from RSDDV

Step 3:Run the program RSDDTREX_SINGLE_TABLE_INDEX by giving your cube name and table name as /BIC/SZ_CONTRCT.

Step4: Fill BIA index of this cube from RSDDV.

This program will recreate the index for the selective table (in your case /BIC/SZ_CONTRCT) unlike the RSRV check.

-Vikram

former_member199630
Contributor
0 Kudos

Hi Pedro,

That's right, I followed the steps given by Vikram and it was solved.

Step1: Delete the BWA Indexes of the cube.

Step 2: Recreate the Indexes of the cube ( DO NOT FILL INDEXES) from RSDDV

Step 3:Run the program RSDDTREX_SINGLE_TABLE_INDEX by giving your cube name and table name as /BIC/SZ_CONTRCT.

Step4: Fill BIA index of this cube from RSDDV.

If you see, the infObject that had problem in my case was the Z_CONTRCT. You have to check the field that are having problems in your case. You should see the LOG in the JOB that run the index.

Hope it helps. Regards, Fede

Former Member
0 Kudos

Hi Fede,

What do you put in the REASON parameter of the program RSDDTREX_SINGLE_TABLE_INDEX?

Thanks,

Pedro

Former Member
0 Kudos

Hi ,

In REASON parameter you can give any free text.

-Vikram

Former Member
0 Kudos

Vikram and Fede,

It fixed our re-accelerate issue... thanks so much, I appreciate your help.

Pedro

Former Member
0 Kudos

Hi ,

I am facing with the similar issue

Job started

Step 001 started (program RSDDTREX_AGGREGATES_FILL, variant &0000000000887, user ID VEENAS)

ZFINC072 OFF

ZFINC072 OFF

ZFINC072 OFF

INFOCUBE: ZFINC072

Statistics UID of indexing job: '4GOP1Q7QH9MJQO3I7JP12TBW2' (RSDDSTATTREX/RSDDSTATTREXSERV)

Parameter BATCHPARA during indexing: '3'

'41' different values in column 'DIMID' of table '/BIC/DZFINC072T'

WHERE clause: OPT ='BT', LOW = '', HIGH = '0000001028' (field: 'DIMID')

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BITRP_4GOP2AHGIKWVW5F5LVVFLZXWY with ID 01330200

WHERE clause: OPT ='BT', LOW = '', HIGH = '0000002019' (field: 'DIMID')

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BITRP_4GOP2AHGIKWVW5F5LVVFLZXWY with ID 01330300

FILLING_FAILED >CHECK LOG!!!!!

Job finished

When i am trying to run the steps given by you,i am giving the table name as /BIC/FZFINC072,by which the program is terminating and giving short dump.

Could you pls let me know how to resolve this.

Thanks in Advance,

veena.

former_member199630
Contributor
0 Kudos

Hi Veena,

Have you seen the SLG1 t-code what it says?

Lets try the steps given by Vikram,

Step1: Delete the BWA Indexes of the cube.

Step 2: Recreate the Indexes of the cube ( DO NOT FILL INDEXES) from RSDDV

Step 3:Run the program RSDDTREX_SINGLE_TABLE_INDEX *by giving your cube name and table name as the DIM table in your case '/BIC/DZFINC072T', not the Fact table as you say*.

Step4: Fill BIA index of this cube from RSDDV.

Regards, Fede

Former Member
0 Kudos

Hi ,

I am facing with the similar issue

Job started

Step 001 started (program RSDDTREX_AGGREGATES_FILL, variant &0000000000887, user ID VEENAS)

ZFINC072 OFF

ZFINC072 OFF

ZFINC072 OFF

INFOCUBE: ZFINC072

Statistics UID of indexing job: '4GOP1Q7QH9MJQO3I7JP12TBW2' (RSDDSTATTREX/RSDDSTATTREXSERV)

Parameter BATCHPARA during indexing: '3'

'41' different values in column 'DIMID' of table '/BIC/DZFINC072T'

WHERE clause: OPT ='BT', LOW = '', HIGH = '0000001028' (field: 'DIMID')

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BITRP_4GOP2AHGIKWVW5F5LVVFLZXWY with ID 01330200

WHERE clause: OPT ='BT', LOW = '', HIGH = '0000002019' (field: 'DIMID')

Program RSBATCH_EXECUTE_PROZESS successfully scheduled as job BITRP_4GOP2AHGIKWVW5F5LVVFLZXWY with ID 01330300

FILLING_FAILED >CHECK LOG!!!!!

Job finished

When i am trying to run the steps given by you,i am giving the table name as /BIC/FZFINC072,by which the program is terminating and giving short dump.

Could you pls let me know how to resolve this.

Thanks in Advance,

veena.

Former Member
0 Kudos

Hi Fede,

Thank you very much for the reply,

Actually at first I tried by giving the dim table only, it is throwing short dump with the following error.

Error analysis

Short text of error message:

INVALID_INPUT TABLE NOT FOUND /BIC/DZFINC072T ZFINC072

Long text of error message:

Technical information about the message:

Message class....... "RSD_TREX"

Number.............. 100

Variable 1.......... "INVALID_INPUT"

Variable 2.......... "TABLE NOT FOUND"

Variable 3.......... "/BIC/DZFINC072T"

Variable 4.......... "ZFINC072"

Could you pls help me out in this

Thanks,

Veena.

former_member199630
Contributor
0 Kudos

Hi Veena,

Have you tied some test of the tables of the cube from t-code RSRV? The dimension that seems to have problems is the time dimension, Tests in Transaction RSRV -> All Elementary Tests -> Transaction Data -> Consistency of the Time Dimension for an InfoCube. And try other test also.

Lets see what kind of error you have, maybe you have to repair them first.

Regards, Federico

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

Hi Veena,

Please note that:

1/ You need to carefuly check SLG1 log for your original indexing problem.

2/ Solution with using single index rebuild is not universal for all issues.

3/ Before running that solution make sure you executed the first step of BWA indexes creation without the second step of filling that index.

Cheers,

-Vitaliy

Former Member
0 Kudos

Hi Fede n Vitaliy

When i have checked with SLG1,this is the error log detail i found.

Reading from table '/BIC/FZFINC072' terminated. Error:

I::000

Creation of the BIA index for InfoCube 'ZFINC072' terminated while filling

I have tested the data consistency thru the T.Code RSRV,It is giving the error taht

Time Char 0FISCPER value doen not fit with the time char Value

Record with the DIMID conatins non fitting time characteristics.

Do you want me to delete the content and reload the same,then rebuild the index.

Pls do let me know.

Thanks in Advance,

Veena

former_member199630
Contributor
0 Kudos

Hey Veena,

Try to fix it from RSRV, there is a botton after executing the test.

Do you see ok the Time Dimension in the cube with the 0FISCPER? If you go to SE11 and try to see the time Dimension, the Fiscal Period is included rigth?

All the fields in time dimension are time fields?

Regards, Federico

Former Member
0 Kudos

Hi Veena,

Righly said.. first option always should be to Rebuid Indexes.

-Vikram

Former Member
0 Kudos

Hi ,

When I run this progream I get the following error/dump :

Short text of error message:

ERROR IN DATASTATE <cube_name> 0

Long desc :

Technical information about the message:

Message class....... "RSD_TREX"

Number.............. 100

Variable 1.......... "ERROR IN DATASTATE"

Please let me know if you have any information on the same.

Regards,

Adarsh Mhatre

Former Member
0 Kudos

Hi Adarsh,

Did you use this program after your cube structure was changed?

Also please let us know what was the the mail issue you had?

-Vikram

Answers (2)

Answers (2)

former_member189845
Active Participant
0 Kudos

Hi Vikram,

We'd tried with the program, but still its not working.

Info cube name given is NH1234567

Table name given: FN1234567

Job started

Step 001 started (program RSDDB_BIAINDEX_FILL, variant &0000000000652, user ID 310084846)

Statistics UID of indexing job: 'CU4A95TSIGB0HL6G7YFM5DHW7' (RSDDSTATTREX/RSDDSTATTREXSER

INFOCUBE: NH1234567

Loading data to index 0BW:BIA:WPC:BIC_FN1234567 (records '0000183824', job '1' )

Loading data to index 0BW:BIA:WPC:BIC_FN1234567 (records '0000367648', job '2' )

Loading data to index 0BW:BIA:WPC:BIC_FN1234567 (records '0000551472', job '3' )

Loading data to index 0BW:BIA:WPC:BIC_FN1234567 (records '0000716558', job '0' )

FILLING_FAILED-->CHECK LOG!!!!!

Job finished

Kindly suggest

Former Member
0 Kudos

Hi ,

Please find the details :

SAP Note Number: 1102652

Symptom

During filling of a BIA index the indexing of an s-table fails with error "connection failed http://<hostname>:<port>/indexCellTable";

Other terms

BIA, BI Accelerator

Reason and Prerequisites

ICM is used to fill s tables and temporary BIA indexes; ICM is not configured properly

Solution

Please make sure that the ICM connection test in transaction TREXADMIN in tab "Abap client customizing" works fine for connection to each BIA blade.

This needs to be checked for each application server.

If you get an error for this connection test please check for known errors like:

HTTP is not configured at all

Every hostname of every blade must be known (pingable) to every application server and vice versa

-Vikram