cancel
Showing results for 
Search instead for 
Did you mean: 

Error in SAP BPC NW Data Manager package while loading from SAP BI

Former Member
0 Kudos

Hi Experts,

Am facing an issue while loading data via " Load data from BW infoprovider - UI" in SAP BPC NW. Please see the error below;

Task name CONVERT:

No 1 Round:

Start routine is called in convert

Reject count: 160

Record count: 511

Skip count: 0

Accept count: 3928

My selections are;

0COMP_CODE

0FISCPER

ZBPCVERSN

All the above selections were correctly filled.

Please see the error screen shot below.

Task name LOAD INFOPROVIDER:

Inconsistent input parameter (parameter: I_PDIMID, value 4)

please let me know if anyone has faced this issue before?

Thanks in advance,

Venkata

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

May be some details?

Transformation/Conversion files

Advanced DM package script...

Vadim

Former Member
0 Kudos

Hi Vadim,

Sorry for the late reply. I could fix the reject records issue. The members were not existing. Therefore, i created and tried to load again but the error remains the same. Please see screen shot below.

Please see content in Transformation below

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

STARTROUTINE=ZUJ_XXX_VAR

*MAPPING

ASSEMBLY=*NEWCOL(N)

INGREDIENT=*IF(ZING=*STR() THEN *NEWCOL(NO_ING); 0COMP_CODE + ZING)

COMPONENT=*IF(ZCOMP=*STR() THEN *NEWCOL(NO_COMP); 0COMP_CODE + ZCOMP)

DATASRC=*NEWCOL(VARIANCES)

KEYFIGURE=*MVAL(ZVAR_RVPL|*NEWCOL(REVAL)||ZVAR_FXPL|*NEWCOL(FOREX)||ZFREVARPL|*NEWCOL(PPV_FREIGHT)||ZCSTVARPL|*NEWCOL(PPV_DUTY)||ZBRKVARPL|*NEWCOL(PPV_BROK)||ZRLTVARPL|*NEWCOL(PPV_ROYAL)||ZMATPPVPL|*NEWCOL(PPV_MAT)||ZVAR_UYPL|*NEWCOL(UY))

KIT=*IF(ZKIT=*STR() THEN *NEWCOL(NO_KIT); ZKIT)

LOCATION=0COMP_CODE

TIME= 0FISCPER

M_P=ZBPC_M_P

BRAND=*NEWCOL(NO_BRAND)

RPTCURRENCY=*NEWCOL(LC)

SALESDIST=*NEWCOL(NO_SD)

SALESOFFICE=*NEWCOL(NO_SO)

VERSION=*NEWCOL(ACTUAL)

*CONVERSION

TIME=FISCPER_TO_CALMONTH_CONV.xls

Conversion file settings

EXTERNALINTERNAL
????013????.P13
????012????.DEC
????011????.NOV
????010????.OCT
????009????.SEP
????008????.AUG
????007????.JUL
????006????.JUN
????005????.MAY
????004????.APR
????003????.MAR
????002????.FEB
????001????.JAN

Advance DM script

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",0,{"Append","Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"0","1","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Regards,

Venkata

former_member186338
Active Contributor
0 Kudos

Hi Venkata,

To my mind the issue is in this line: STARTROUTINE=ZUJ_XXX_VAR

Please, talk with badi author!

Vadim

Former Member
0 Kudos

Ok, Thanks Vadim, I will check with the BADI author.

Thanks for your support.

Regards,

Venkata

Former Member
0 Kudos

Hello Vadim,

The issue is not only with this load but all loads from BI to BPC. This is in Q enviroment. Recently, we backedup the envioronment via UJBR and restored in Q system. Should something to do with that? I checked the Start Routine, it looks fine. Same as in Production system.

Thanks and Best Regards,

Venkata

former_member186338
Active Contributor
0 Kudos

"I checked the Start Routine, it looks fine." - you have to debug it!

P.S. Can you test an import without start routine badi?