cancel
Showing results for 
Search instead for 
Did you mean: 

Datamart : not loading data?

Former Member
0 Kudos

Hello Experts,

Problem: Infopackage from ODS --> cube fails

I have already checked:

-- Request is green in ODS.

-- Activated the data in ODS.

-- No lock entries in the system.

-- sm37 is clean.

-- st22 No dumps whatsoever.

Are these the reasons:

-- Wondering if there are any known problems with the Datamart functionality of BW. Are you aware

of any settings or etc that can go wrong with the

datamart functionality?

-- Are there any basis settings that are required for the same?

Any suggestions are appreciated.

Thanks,

Sweatha

Accepted Solutions (1)

Accepted Solutions (1)

klaus_werner
Active Participant
0 Kudos

Hi Sweatha,

there is no special thing you need to make it work. Just like for any loading you need a working source system connection (MYSELF connection in this case), then everything should work. Your problem could be anything from lowest hardware to highest software problem. You should check the loading monitor to see where exactly it got stuck (extraction or transer or update rules....), like Siggi already suggested look for an error message in the monitor.

Regards, Klaus

Former Member
0 Kudos

In the monitor:

Request was sent succesfully but there is error during extraction 1052 records sent (0 records received ).

In the Analysis screen:

Green: data selection sucesfully done.

Grey: RFC to warehouse

Green: Error reported in Data warehouse

Red: processing succesfully finished

Red: all data packets completed

Red: Have all processing steps completed.

Does it suggest that the connection/source system is broken.?

Former Member
0 Kudos

Hi Sweatha !

take a look to the error message in the status page...the info you collected from the Analysis screen are not useful (and what does it mean 'Red: processing succesfully finished'...red, succesfully...it's a paradox !)

however, try to understand where the error occured..transfer rules, update rules, update...

...and (that won't do any harm) regenerate your export datasource (right-click on your sender ODS) and try to reload !

Bye,

Roberto

klaus_werner
Active Participant
0 Kudos

It may be a problem with source system. You can check e.g. by replicating DataSources (may be a good idea anyway) of the source system. It may have been an exceptional situation and the process has just timed out because it got stuck. Have you ever tried repeating the load?

Regards, Klaus

Former Member
0 Kudos

Sweatha,

problem solved ?

Former Member
0 Kudos

Thanks Siggi, Raj, Klaus, Roberto.

Repeating the laod solved the problem..

Answers (2)

Answers (2)

Former Member
0 Kudos

hi swetha ...

datmart is t/f of data from a cude of one bw sys to cube of other bw sys isn't it? where did u use ods here ?

Former Member
0 Kudos

Hi Sweatha,

what are the error messages coming up when you try to load the data?

Please let us know.

regards

Siggi