Error loading data from DSO to InfoCube

73 Views

Hi guys,

I have created a process chain for transfering data. The loading to the DSO works fine. But the loading to the InfoCube has problems. An error like "insert into database ... Oracle ..." occurs (don´t have the whole message here, will check it later).

The process chain has a step "delete conten of data target" (for the used infocube) and then the data is loaded from the DSO to the InfoCube.

Is it maybe neccessary to insert one more process step called "delete index of data target"?

It would be then (the last part of the process chain:

Delete content of data target > delete index of data target > load from DSO to InfoCube.

But I´m thinking if the step "delete index of data target" is neccessary if NO step "create index" is available in the process chain. Is it possible or does it make sense to insert an "delete index of data target" in the process chain when no "creat index" step is available?

Does somebody has similar problems?

Is this more a problem for the SAP basis / database team?

Edited by: saplaz on Dec 22, 2010 10:56 PM