Skip to Content
-2

Transaction data load fails for selective time period

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.