Skip to Content
avatar image
Former Member

Data Loading Error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 21, 2012 at 12:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 26, 2012 at 06:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2012 at 12:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 27, 2012 at 06:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 28, 2012 at 09:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 03, 2012 at 08:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2014 at 03:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded