on 08-19-2020 2:43 PM
Hello
I recently came across an issue where a data manager package (Loading transaction data /CPMB/LOAD_INFOPROV_UI - with default logic) that was running fine, suddenly starts failing for few time periods and runs successfully for few time periods.
SAP BPC 10.1 for SAP NW Standard Model
SAP BW 7.5 SP 12
SAP Analysis for Microsoft Office 2.7.502.89393
Default Logic
// This script contains the logic which is executed whenever data is entered and sent
*INCLUDE CYNI.LGF
*INCLUDE FXTRANS.LGF
*INCLUDE COPY_COUNT_ACTBUDGET.LGF
CYNI.LGF
//Copy Current Year Net Income (CYNI) to Retained Earnings
*FOR %EACH_CATEGORY% = %CATEGORY_SET%
*RUN_PROGRAM CALC_ACCOUNT
CATEGORY = %EACH_CATEGORY%
CURRENCY = LC,USD
TID_RA = %TIME_SET%
OTHER = [ENTITY=%ENTITY_SET%;AUDIT_TRAIL=%AUDIT_TRAIL_SET%]
CALC = CYNI
*ENDRUN_PROGRAM
*NEXT
FXTRANS.LGF
// Copy LC to USD for historical overrides in USD currency entities.
// This logic copies rate type HIS so excludes rate type HIS_RE (Retained Earnings)
*SELECT(%HIS%,ID,ACCOUNT,[RATETYPE]="HIS")
*XDIM_MEMBERSET ACCOUNT=%HIS%
*XDIM_MEMBERSET RPTCURRENCY=LC
*XDIM_MEMBERSET AUDIT_TRAIL=%AUDIT_TRAIL_SET%
*WHEN ENTITY.CURRENCY
*IS USD
*REC(RPTCURRENCY=USD)
*ENDWHEN
*COMMIT
*SELECT(%RF%,ID,ACCOUNT,[RATETYPE]="RF")
*XDIM_MEMBERSET ACCOUNT=%RF%
*XDIM_MEMBERSET RPTCURRENCY=LC
*XDIM_MEMBERSET AUDIT_TRAIL=%AUDIT_TRAIL_SET%
*WHEN ENTITY.CURRENCY
*IS USD
*REC(RPTCURRENCY=USD)
*ENDWHEN
*COMMIT
// Standard business rule for currency translation of LC to USD
*FOR %TIME% = %TIME_SET%
*FOR %EACH_CATEGORY% = %CATEGORY_SET%
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %EACH_CATEGORY%
CURRENCY = USD
TID_RA = %TIME%
OTHER = [ENTITY=%ENTITY_SET%;AUDIT_TRAIL=%AUDIT_TRAIL_SET%]
RATEENTITY = GLOBAL
*ENDRUN_PROGRAM
*NEXT
*NEXT
COPY_COUNT_ACTBUDGET.LGF
//Copy Actual Claim/Colleague Count to Actual Budget Rate
*SELECT(%COPYLC%,ID,ACCOUNT,[RATETYPE]="COPYLC")
*XDIM_MEMBERSET RPTCURRENCY=LC
*XDIM_MEMBERSET ACCOUNT=%COPYLC%
*WHEN CATEGORY
*IS ACTUAL
*REC(CATEGORY=ACTUAL_BUDGETRATE,RPTCURRENCY=USD)
*ENDWHEN
*COMMIT
Example: When the DMP is run for 2019.05, the package completes with Warning whereas for 2020.02, the package fails with message "Error while running default logic"
Package fails with “Error while running default logic” for 2020.05
/CPMB/MODIFY completed in 0 seconds
/CPMB/INFOPROVIDER_CONVERT completed in 247 seconds
/CPMB/LOAD_IP completed in 13 seconds
/CPMB/CLEAR completed in 0 seconds
[Selection]
--------------------------------------------------------------
InforProvide = ZGL_DS02
SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>ZBPCTIME</ID><Operator>1</Operator><LowValue>2020.05</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0AC_DOC_LN</FieldID><FieldID>0AC_DOC_NR</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CURKEY_TC</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CUSTOMER</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FI_RACTIV</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0MOVE_TYPE</FieldID><FieldID>0UNIT</FieldID><FieldID>BPTNR_TXT</FieldID><FieldID>ZAUDIT</FieldID><FieldID>ZBPCACCT</FieldID><FieldID>ZBPCTIME</FieldID><FieldID>ZCATEGORY</FieldID><FieldID>ZCSTMETH</FieldID><FieldID>ZCSTMTHD</FieldID><FieldID>ZDEPT</FieldID><FieldID>ZENTITY</FieldID><FieldID>ZFUNC</FieldID><FieldID>ZGEO</FieldID><FieldID>ZINFOPROV</FieldID><FieldID>ZINTCO</FieldID><FieldID>ZINTORD</FieldID><FieldID>ZLOB</FieldID><FieldID>ZREVCLAS</FieldID><FieldID>ZRPTCURR</FieldID></Selection></Selections>
TRANSFORMATION = \ROOT\WEBFOLDERS\ABCD\PLANNING\DATAMANAGER\TRANSFORMATIONFILES\ABCD_SAP_PLAN_TRANS.xls
[Message]
--------------------------------------------------------------
Task name CONVERT:
No 1 Round:
Reject count: 583
Record count: 99965
Skip count: 441
Accept count: 98941
Task name LOAD INFOPROVIDER:
Suppressed zero-value records: 6.621
Replace and Clear Submit count: 14499
Replace and Clear Reject count: 0
Error while running default logic
Aggregate count: 95985
Submit count: 2956
Reject count: 0
model: PLANNING. Package status: ERROR
Same Package runs with Warning for 2019.07:
/CPMB/MODIFY completed in 0 seconds
/CPMB/INFOPROVIDER_CONVERT completed in 5 seconds
/CPMB/LOAD_IP completed in 27 seconds
/CPMB/CLEAR completed in 0 seconds
[Selection]
--------------------------------------------------------------
InforProvide = ZGL_DS02
SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>ZBPCTIME</ID><Operator>1</Operator><LowValue>2019.07</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0AC_DOC_LN</FieldID><FieldID>0AC_DOC_NR</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CURKEY_TC</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CUSTOMER</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCPER3</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FI_RACTIV</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0MOVE_TYPE</FieldID><FieldID>0UNIT</FieldID><FieldID>BPTNR_TXT</FieldID><FieldID>ZAUDIT</FieldID><FieldID>ZBPCACCT</FieldID><FieldID>ZBPCTIME</FieldID><FieldID>ZCATEGORY</FieldID><FieldID>ZCSTMETH</FieldID><FieldID>ZCSTMTHD</FieldID><FieldID>ZDEPT</FieldID><FieldID>ZENTITY</FieldID><FieldID>ZFUNC</FieldID><FieldID>ZGEO</FieldID><FieldID>ZINFOPROV</FieldID><FieldID>ZINTCO</FieldID><FieldID>ZINTORD</FieldID><FieldID>ZLOB</FieldID><FieldID>ZREVCLAS</FieldID><FieldID>ZRPTCURR</FieldID></Selection></Selections>
TRANSFORMATION = \ROOT\WEBFOLDERS\ABCD\PLANNING\DATAMANAGER\TRANSFORMATIONFILES\ABCD_SAP_PLAN_TRANS.xls
[Message]
--------------------------------------------------------------
Task name CONVERT:
No 1 Round:
Reject count: 58
Record count: 313
Skip count: 0
Accept count: 255
Task name LOAD INFOPROVIDER:
SuppresABCD zero-value records: 375
Replace and Clear Submit count: 49885
Replace and Clear Reject count: 0
Aggregate count: 171
Submit count: 84
Reject count: 0
model: PLANNING. Package status: WARNING
Thanks
BSV
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.