Data Loading Issues

[Former Member]

Hello expets.

I am loading delta to 0pur_c04 from the data source 2LIS_02_HDR. the data is loaded sucessfully and the both the Technical and the total status of the request is green in the monitor screen. But the request QM status is Yellow in the 0pur_c04 where as the technical status is green for the same request . And the create indices process for the same data source 2LIS_02_HDR. fails every time in the process chain i had tried and schedule the job as different time but all in vein.When i repeat the process it will run successfully.

Please provide ur suggestion on the same.

Regards

[Former Member · Accepted solution]

Maybe you must setup the automatic QM to green setup for that infocube....

Regards

[Former Member]

We have the same issue. Could you tell me how you resolve this issue.

Thanks,

Abby

[Former Member]

Hi KK,

Use Function Module RSS2_SET_QMACTION

Give the Data target, Request number and I_STATUS as G

Regards

Raj

[Former Member]

We have the same issue. Could you tell me how you resolve this issue.

Thanks,

Abby

[Former Member]

In the InfoCube Manage screen, Go to Environment Menu - > Automatic Request process and set "Set Quality status to OK and save.

This will fix your first problem.

I dont think I understood your question about creating indices on a dataSource in a process chain. If you meant creating indices on a cube step fails in a process chain, try doing in manually and report back if errors.

[Former Member]

Helo guys,

yes automatic request was the problem. when i check it n save the request became green atomatically, but the thing is reporting sign is not appear for that request pls help me this regards.

2. yes the indices for the cubes is getting fail daily n i will repeat the process then the indices will b created sucessfully. is der any permanent solution for this issue.

Regards

Edited by: KK on May 4, 2009 8:39 AM

[Former Member]

right click on the process chain step and submit the message here why the indexes fail on the cube.so we can investigate and help you.

as you have already done autmatically activate the cube then you should be good on that part.

[Former Member]

If you are on 3.5, go to DB02 , Missing tables and Indexes and create missing indexes manually if your find your InfoCube tables there.

If you are on 7.0, go to DB02 , Missing tables and Indexes (Under Diagnostics folder on left side) and create missing indexes manually if your find your InfoCube tables there.

[Former Member]

hello guys

pls find the below log for the indices which are fail in process chain . when i repeat the process then it will be created succesfully.

ALTER INDEX "/BI0/F0PUR_C01~130" NOPARALLEL

SQL-END: 29.04.2009 06:09:27 00:00:00

Indexes for InfoCube 0PUR_C01 have been constructed successfully

Deleting/reconstructing indexes for InfoCube 0PUR_C04 is not permitted

Deleting/reconstructing indexes for InfoCube 0PUR_C04 is not permitted

Job finished

regards

Edited by: KK on May 5, 2009 12:20 AM

[Former Member]

Hi

If you have aggregates defined on the infocube then you will not get the reporting symbol unless untill you do the roll-up to the aggregates.

Hope it helps.

Regards

Sadeesh

[Former Member]

Deleting/reconstructing indexes for InfoCube 0PUR_C04 is not permitted

Deleting/reconstructing indexes for InfoCube 0PUR_C04 is not permitted

when i look at these 2 lines, i want you to right click on the process chain and display schedule jobs find out which user id ha sthe job scehdule, as you are only loading in the cube not aggregates( i think), it seems authorization issue. Like you stated when you do it manually it works, but when done automatically it fails.

try that.