Skip to Content

Infocube updation fails continuously

Hi Experts,

The infocube ZSDRC003 has been failing continuously for about a week. From the source system, SAP PRD, there's a record which has updated to SAP BW system, containing invalid data. The record from SAP PRD is due to some wrong invoice value created and pulled to BW system. Because of this record, the whole updation of data fails continuously. And the error message is:

"

Key figure <> 0 not allowed for unit ''; see long text

Diagnosis

The unit/currency ' Source unit 0SALES_UNIT ' with the value 'space' is

assigned to the key figure ' Source Key Fig. 0INV_QTY ' with the value '

1.000 '.

System Response

A key figure that is not equal to 0 and for which no unit/currency is

set has an inconsistent data state. The data record is not processed.

Procedure

Correct the source data.

Procedure for System Administration"

Further, I've edited the PSA for Sales unit, by assigning a unit. It works fine and before there are some 12 requests from Data source which is in red turned to green soon after this modification, data has been pulled successfully to the cubes, except for the cube ZSDRC003. But the Source from which the infocube gets data is updated properly, by doing DTP full upload pull for that particular record.

While after deleting the red request, through process chain, in the infocube, am getting the error message as:

"

Update terminated in accordance with error handling setting

An exception has occurred

Error in substep

Messages for 1 data records saved; request is red acc. to configuration

Data package 1 / 14.07.2012 12:10:06 / Status 'Processed with Errors'

"

I've attached a word file. Pleas find the attached copy.

Please suggest solution in the earliest as possible. Looking for your earliest reply ..

with Regards,

Antony Jerald

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 14, 2012 at 01:01 PM

    One option I could think of is that the DSO still contains invalid data (that might or might not still be present in the PSA).

    Try to search the contents of the source DSO for the record which is shown as invalid. filter according to its field values.

    If the invalid record was extracted recently, you can also narrow the results by finding the exact request.

    From the header of the monitor of the DTP process, you can see the DSO request number under "selection", and the name of the DSO under "source". Click the DSO twice and then find the row for the relevant request ID. for that row you can find the "PSA Request Number" (the value that begins with ODSR) and search for it in the change log under "Contents". Repeat this process further down until you find the source record in the PSA, fix it if relevant, and pull it into the DSO. Assuming the number of invalid records is low you'll eventually be able to load data successfully.

    I would also check the infopackage and the datasource to see whether the data is being transferred using PSA, or whether a new request of the PSA delivered more invalid records. The fact that other infocubes aren't affected does not necessarily mean there isn't an invalid record.

    Good Luck,

    Shai

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.