Skip to Content
0
Former Member
Mar 10, 2010 at 07:21 AM

Data Load Request is Yellow (How to debug)

193 Views

Hi,

I have created a source system based on Microsoft SQL Server 2005 (MSS) in BW 3.5. The connection check is working fine.

We have created a view in SQL Server 2005 using an id 'bwremote'. This ID is also used to connect BW to MSS.

The default schema for both is dbo

When we create a dataosurce and see table entries we can see the data in the view. We are folkowing all the steps mentioned in note 512739. Everything works fine till this stage.

But when we execute an infopackage to load data the request always stays yellow for days on and never even throws an error.

It just shows Missing Messages in detail.

My question is how to resolve the issue?

Also how do we know if after executing infopackage BW has connected to MSS?

Is there any way to debug infopackage request to see where exactly its getting stuck?

Are there any additional settings to be created on BW/MSS side.