SAP Knowledge Base Article - Preview

2450883 - Run-time error '-1073479167 (c0040201)' Error in refresh sheet - BPC NW

Symptom

  • There is a very simple VBA in AFTER_WORKBOOK_OPEN(), which triggers EPM API RefreshActiveSheet when the report is opened. 
  • After the workbook refreshes for a little while, the error "Run-time error '-1073479167 (c0040201)' Error in refresh sheet" occurs.
  • If the report is refreshed manually by clicking the EPM Refresh button, you will see error "MDX statement eror: Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'".


Read more...

Environment

SAP Business Planning and Consolidation 10.x, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

AFTER_WORKBOOK_OPEN, EPM add-in, refresh sheet, Run-time error, '-1073479167 (c0040201)', Error in refresh sheet, MDX statement eror, timeout during allocate , KBA , 0xc0040201 , EPM-BPC-NW , NetWeaver Version , EPM-XLS , EPM Excel Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.