cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction data load fails for selective time period

bharathviswanathan
Discoverer
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Sorry, but is it a joke to ask question about the issues with default logic script and not provide the text of default.lgf?

bharathviswanathan
Discoverer
0 Kudos

My apologies Vadim

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

former_member186338
Active Contributor
0 Kudos

Then next step - comment some steps and check to find the step generating error!

 *INCLUDE CYNI.LGF
// *INCLUDE FXTRANS.LGF 
// *INCLUDE COPY_COUNT_ACTBUDGET.LGF
*INCLUDE CYNI.LGF
*INCLUDE FXTRANS.LGF 
// *INCLUDE COPY_COUNT_ACTBUDGET.LGF

...

bharathviswanathan
Discoverer
0 Kudos

But Vadim, this default logic has always been working fine with the same three scripts included. It still works for other time periods. I will try commenting and run the DMP as suggested.

former_member186338
Active Contributor
0 Kudos

"this default logic has always been working fine" - bad argument in general!

Now you have an issue and you have to find the reason!

Accepted Solutions (0)

Answers (0)