Databasis (requests) : Errors occurred

[Former Member]

I have been loading data from DSO to Cube. Upto DSO it is through DTP and from DSO to be it is 3.5 data flow. I have over 1 million records in QA. The data loading though init from DSO to Cube is ending with Red status displaying "Databasis (requests) : Errors occurred ". No matter how much packet size(20000, 40000) I have been loading it is sitting in that status.

I have checked with DBA guy but no luck. Please show me way out of this problem.

Thanks

[Former Member]

Can you check all the requests status in DSO , If there any bad requests ? delete them and reload to dso and then to cube

[Former Member]

No bad requests,,, If there is one I would have mentioned or delete and reloaded.

[Former Member]

Did you check all the requests for DSO in Monitor - expand all the data packages ? make sure all the requests are green and their overall status/QM status is green .. please do recheck and turn them to green again

[Former Member]

Every request is green. Earlier one or two requests are in yellow, after packet size increase all the requests are in green.

But overall status is in red, displaying "Overall status: errors occured or missing messages". All the subsequent delta requests are also having overall status Red.

I am having two dimensions more data, I mean fact to diemsnion ratio near to 100%. Is that a problem ???

[Former Member]

This is not related to Dim for cubes, is related to "But overall status is in red, displaying "Overall status: errors occured or missing messages". All the subsequent delta requests are also having overall status Red. "

Check If you can delete them by making red and reload

[Former Member]

Pls no wild guesses, I have already mentioned, I tried that option. I have tried doing this five times.

[Former Member]

Hi,

If the requests are in RED, what about the DSO activation step? Is that successful?

--

rgds,

[Former Member]

Mr Krishna Rao,

If a request is succesfully activated in DSO then only it can be updated to cube, For your question, Yes it succesfully activated. what else could be the problem.

I have exhausted looking at forums and notes can somebody help me,

[Former Member]

HI,

I got ur point....pls explain in detail about this said by you before...

Every request is green. Earlier one or two requests are in yellow, after packet size increase all the requests are in green.

But overall status is in red, displaying "Overall status: errors occured or missing messages". All the subsequent delta requests are also having overall status Red.

Here overall status in RED means wht in DSO only, was that issue cleared?

--

rgds,

[Former Member]

Nope I am talking about loading the cube. And these reuests in the cube when you see in the monitor.

In DSO everything is absolutely fine.

[former_member209032]

Hi,

See in ST22 if there in any dump. Did u drop the index of the cube before loading?

Regards,

Raghavendra.

[Former Member]

Raghavendra

No Dump , I tried loading it without indexes,

After all the packets are upates, the overall status is saying "Databasis (requests) : Not yet finished ". At this time my SM50 is not using any process DIA/BGD.

Now the status is yellow, I am sure after some time it will go red.

[Former Member]

Hi,

If I am correct your data packets in RED belongs to cube....

Now you please check in SM58 with correct input variables, if you find any TRFC's struck there please manually process them,

Incase you find no idocs, then come back to your load monitor and right click on each yellow data packet and manual update. Prior to this step the total status should be in RED, then only you can manually update the packets.

--

rgds,