on 09-16-2015 2:29 PM
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
May be some details?
Transformation/Conversion files
Advanced DM package script...
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
EXTERNAL | INTERNAL |
????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
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.