Data Loading Error

[Former Member]

Hi all,

I am loading data for Production planning and controlling module.I have already  loaded  data to DSO 0PP_DS01 from datasource  2LIS_04_P_MATNR. datas are coming properly in DSO..

But  while executing DTP from DSO to Cube ie, loading data from DSO 0PP_DS01 of datasource 2LIS_04_P_MATNR to cube 0pp_C10 there are  several  errors  coming and they are

1. data package processing is terminated (Message no. RSBK229) 
2. SQL Server Native Client 10.0][SQL Server]Operand data type nvarchar is invalid for sum operator.( RS_EXCEPTION000)
3. Error while extracting from source 0PP_DS01 (type Datastore)( RSBK242)
4. Data package 1  Status 'Processed with Errors(RSBK257)

I have already deleted datas from from DSO and reloaded it again in the Cube but even this is not working out. Same errors are coming. Please suggest me what else can be done for solving the errors.

Regards,

Nilay

[Former Member]

This solved the issue for me:

Please check if you have any keyfigurers of type TIMS that have SUM as standard aggegation. That will cause the error.

I've just set these to MAX and now it works fine, but if you need them to SUM you'll have to report it to SAP.

The error will only occur after an activation. So if you used DSO's in your load where you didn't have this issue, there probebly of type WriteOptimized.

Just thought i'd save people some time by posting this.

[roland_hoeller2]

Hi

Please note that you have posted into the wrong forum and I have therefore moved the thread.

The Business Intelligence Solution Architecture is for SAP BusinessObjects BI Platform and SAP BusinessObjects Enterprise XI products

Thanks and Regards
Roland Hoeller

Forum Moderator

[Former Member]

Hi Mehta,

  Check the tranformation mapping between DSO and Cube for each fields and also check the data types between them whether they are the same. If some discrepancy is data type and lenght you need to implement a proper field routine to make the data load smooth.

Thanks,

Umashankar

[manna_das]

Hello Nilay,

use these sap notes for

Error No.1

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1063541

Error No.2

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1709947

Error No.3

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1421239

Error No.4

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1148007

Best Regards

Manna Das

[Former Member]

Hi Nilay,

As discuss earlier, although there is one-one mapping between DSO and CUBE. Still you need to check the mapping Field with correct data type.

As per Error: SQL Server Native Client 10.0][SQL Server]Operand data type nvarchar is invalid for sum operator.( RS_EXCEPTION000).

It seems that one Field with char datatype exist and the resulted target is designed with another Field with different data type.

Check in transformation level. You will find it out.

Regards,
Deb

[Former Member]

Dear Nilay,

This error can be occur due to the following Issues:

Inactive :-  DTP, Transformations, Info Objects. Check for program to activate the stadard Infoobject if inactive.

Check weather Neccessary authorizations are present and 8* datasource (Export Datasource) is replicated properly and available.

check ST22 and SU53 for any dump.

These Error has been already addressed by Kiran Vasant.

Check below Link:

http://scn.sap.com/thread/2052310

[Former Member]

Hi Nilay,

Please check the transformation between DSO and Info Cube. There might be Sum (Add) operation on any of the DSO fields to derive field which is in Cube. And one of those fileds on which you are applying "Sum" is having data type Char or varchar which is invalid. Because we can not perform addition operation on characteristics but only on Key figures. Please modify them accordingly.

Regards,

Hari Prasad Balija

[Former Member]

Hi Hari,

Thanks for your response.I have already checked the transformation between DSO and CUBE

it is perfect.and their is no summation performed.all are directly assigned.so please let me know

what else can be done for the same.

Regards,

Nilay..

[Former Member]

Hi Nilay,

Did you check are there any START or END routines implemented?

[Former Member]

Hi Hari,

Yes I checked that too.their are no routines implemented.

Regards,

Nilay