Error SPRUNCONVERSION

[former_member349977]

Dear Guru's,

I have a this problem:

I run the RunBoth package, than execute SPRUNCONVERSION and SPRUNCONSO stored procedures and it finished with errors. I check Rate and Ownership and all is correct.

I review microsoft log and it said than finished successfully.

I create a new category with the same properties (FX_SOURCE_CATEGORY,RATE_CATEGORY, RATE_YEAR) and ownership and the package finish successfully.

I have this problemn with 2 categories and they was working successfully. Do you think they are corrupt categories now?

Thanks

[former_member186498]

Hi Nieves,

have you verified "Check If you have valid information in the OWNERSHIP cube for the selected Category Time"? as per sap note 1827841 - Error return codes for the SPRUNCONVERSION stored procedure

Regards

     Roberto

[Former Member]

Hi Nieves,

as Roberto said, you are converting in the group type dimension which means the system will check the OWNERSHIP cube. Only companies with a valid consolidation method will be converted.

So please check that cube.

BR,
Arnold

[former_member349977]

Dear,

To be sure that the category had not incorrect data, I ran Clear package and then copied the data from another category that consolidates successfully.

I ran the RunBoth package (conversion and consolidation) and concludes with mistake again.

Have you got other idea?

Thanks.

[Former Member]

Hi,

what happens when you run the conversion and consolidation individually? So what happens when you run just this line

*RUN_STORED_PROCEDURE=SPRUNCONVERSION([Atento],[%CATEGORY_SET%],[%GROUPS_SET%],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])

and then just this line

*RUN_STORED_PROCEDURE=SPRUNCONSO([Atento],[%CATEGORY_SET%],[%GROUPS_SET%],[%SCOPETABLE%],[%LOGTABLE%])

BR,
Arnold

[Former Member]

Hi,

please post the script that leads to the problem.

BR,
Arnold

[former_member349977]

// include constants (dimension mapping)

*include Constants.lgf

*process_each_member=time

*IGNORE_STATUS

// Convert Historical LC to currency group

*Select(%currency%,"id","Groups","[Group]='Currency'")

*Select(%HISTORICAL%,"ID","Account","[Ratetype] IN ('HISFLOW','GWFLOW') AND [CALC]='N'")

*Select(%HISTFLOW%,"ID","Flows","[HISTEQ]='Y'")

*select(%JRNDATASRC%,"ID","DataSrc","DATASRC_TYPE='M'")

*xdim_memberset Datasrc = INPUTCLO,INPUTMOV,INPUTHIS,%JRNDATASRC%

*xdim_memberset Account =%HISTORICAL%

*xdim_memberset Flows = %HISTFLOW%

*xdim_memberset Category = %Category_Set%

*xdim_memberset Time = %Time_Set%

*xdim_memberset Intco = <all>

*xdim_memberset Entity = <all>

*xdim_memberset Groups = LC,%currency%

*calculate_difference=1

*when groups

*is "LC"

   *when DataSrc

   *is %JRNDATASRC%

      *rec(groups=Entity.currency)

   *else

      *rec(groups=Entity.currency,datasrc="INPUTHIS")

   *endwhen

*endwhen

*commit

//LOGICA PARA INPUTHIS

// Calculation of Other Movement Flow for the Balance Sheet Accounts

*Select(%othermovement%,"id","Flows","[othmovement]='Y'")

*Select(%BSmovement%,"id","Account","[group]='BS'")

*Select(%currency%,"id","Groups","[Group]='Currency'")

*xdim_memberset Flows = CLO,OPE,OTH,%OTHERMOVEMENT%

*xdim_memberset datasrc= INPUTHIS

*xdim_memberset Account = %BSmovement%

*xdim_memberset Groups = LC,%currency%

*xdim_memberset Intco = <all>

*calculate_difference=1

*when Account.ratetype

*is "HISFLOW","GWFLOW"

  *when Flows

  *is "CLO"

        *rec(Flows="OTH")

  *is "OPE"

        *rec(factor=-1,Flows="OTH")

  *is %othermovement%

        *rec(factor=-1,Flows="OTH")

  *is "OTH"

           *rec(expression=0,Flows="OTH")

  *endwhen

*else

  *when Groups

    *is "LC"

  *when Flows

  *is "CLO"

           *rec(Flows="OTH")

  *is "OPE"

           *rec(factor=-1,Flows="OTH")

  *is %othermovement%

           *rec(factor=-1,Flows="OTH")

  *is "OTH"

           *rec(expression=0,Flows="OTH")

  *endwhen

  *endwhen

*endwhen

//====================================================

*commit

//====================================================

// Run the Currency Conversion

*RUN_STORED_PROCEDURE=SPRUNCONVERSION([Atento],[%CATEGORY_SET%],[%GROUPS_SET%],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])

*COMMIT

// Run the Automatic Adjustments

*RUN_STORED_PROCEDURE=SPRUNCONSO([Atento],[%CATEGORY_SET%],[%GROUPS_SET%],[%SCOPETABLE%],[%LOGTABLE%]) ON_ERROR_CONTINUE

*COMMIT

*Select(%CONSOL%,"id","Groups","[currency_type]='G'")

*select(%AUTODATASRC%,"ID","DataSrc","DATASRC_TYPE='A' OR DATASRC_TYPE='L'")

*xdim_memberset Datasrc =%AUTODATASRC%

*xdim_memberset Account =221510,221250G,221510G,221510PROVG

*xdim_memberset Flows = OPE,SCS

*xdim_memberset Category = %Category_Set%

*xdim_memberset Time = %Time_Set%

*xdim_memberset GROUPS = %CONSOL%

*calculate_difference=1

*when account

*is "221510"

  *rec(account="221250G")

  *rec(expression=0)

*is "221510G"

  *rec(account="221250G

  *rec(expression=0)

*is "221510PROVG"

   *rec(account="221250G")

   *rec(expression=0)

*is "221250G"

   *rec(factor=1)

*endwhen

*commit