0FI_GL_4

[Former Member]

hi,

when i load data from R/3 into G/L Line items 0FI_GL_4, the data load seems to be completed but it is not activating the ODS automatically. I checked the setting for ODS which says Activate ODS object data automatically, but still it is not activating the ODS.Can anybody tell me what needs to be done in order to load the data into ODS from R/3 successfully?

Thanks in advance

[Former Member]

OK, then tell us 2 things:

1. Detailed description and sequence of your activities during enhancement of datasource and ODS.

2. Do you see data in PSA, particularly, for the added field?

Best regards,

Eugene

[Former Member]

Eugene,

1)I enhanced the 0FI_GL_4 with Asset field,wrote some code to populate this field, replicated in BW and added Main Asset Number in BW to Comm structure as well as ODS and mapped in Update rules.This is what i have done.

2)I could see the populated data in PSA particularly for added field.

Please let me know if i miss anything.

Thanks in advance.

[Former Member]

Check, which Infoobject is related to the field ANLN1 in your ODS. Then check the data model of the infoobject. Usually there are at least texts. If your data load allows to load data without master data verification (setting in infopackage), SIDs are generated during the activation of ODS Data. If your data load includes master data verification, the S-Table of the infoobject is checked. In that case, the activation should abort. I would also inspect the abap shortdumps for illegal characters in the semantic key of the infoobject. Typical cases are the hash sign (#). If this occurs in your data, you will need to code a character-replacement routine.

[Former Member]

Show dumps to your basis guys. It might be a tablespace issue.

Best regards,

Eugene

[Former Member]

hi Eugene,

I contacted Basis guys also and checked that it is not a tablespace issue.Untill yesterday it loaded fine but today morning i enhanced this extractor with Main Asset field and tried to extract the data into the ODS. From then onwards, it is not loading properly. The data packets are green but the subsequent ODS activation is not occuring. when i go to Manage of ODS , the request is green but when i go into monitor for that request it appears yellow and says subsequent ODS activation which is in yellow.So,why is not loading when i add field ANLN1 to ODS.Please let me know .

Thanks in advance.

[Former Member]

Hi APR;

Delete the data if you have any from ODS, and do the following setting, re-activate ODS and reload You can set this to do activation automatically;

1. Right click the ODS and click on manage.

2. Go to 'Environment' menu > automatic request processing

3. Make sure you have checked on 'Activate ODS object data'.

Hope it helps.

Buddhi

[Former Member]

Thanks a lot Eugene Khusainov, A.H.P, and Buddhi for your responses.

I checked the short dumps and found many short dumps in ST22 and they say Runtime Error : DBIF_RSQL_INVALID_RSQL and " An exception occurred. This exception is dealt with in more detail below . The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was neither

caught nor passed along using a RAISING clause, in the procedure "ACTIVATE_SIDS" "(FORM)".

Please let me know did anybody know what does this error mean and what should be done.

I have tried this as well:

I tried loading data into GL ODS by removing the setting activate ODS automatically, then it loaded but when i tried to activate the ODS it is not activating. I don't know why it is not getting activated.

Please let me know what needs to be done.

Thanks in advance.

[edwin_harpino]

hi,

"ACTIVATE_SIDS" seems invalid character, no master data, date format problem...

please go to monitoring tab 'details', expand the last node, processing (data packet) ... check for any red status for record and see what's the error message.

[Former Member]

hi AHP,

There are no red status records in data packets but at Transfer node, it is yellow and the message is "Data Package 1 : arrived in BW ; Processing : 2nd processing step not yet finished " and also "Subsequent Processing(messages):Missing messages" is yellow and message "ODS not yet activated".

I see again the same short dump which i mentioned earlier.

Thanks in advance.

[edwin_harpino]

hi,

the activation may be failed, try to check background job (sm37), job name bi_odsa*, check the job log.

also check sm21 and st22 if any error message.

[Former Member]

Hi,

First of all, goto detailed tab of monitor. Do you see red messages? Yellow messages?

Check ST22, SM21 & SLG1 for errors & dumps.

Best regards,

Eugene