Infocube updation fails continuously

[Former Member]

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

[shai_greenberg · Accepted solution]

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

[Former Member · Accepted solution]

Have resolved the issue by finding incorrect records from PSA, edited and pushed data again.  Also, this I did through error stack dtp.

Regards,

Antony Jerald.