Skip to Content
-2
Aug 19, 2020 at 01:43 PM

Transaction data load fails for selective time period

55 Views Last edit Aug 19, 2020 at 05:30 PM 2 rev

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