on 12-21-2009 3:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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.
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
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.
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.
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
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.