SAP Knowledge Base Article - Preview

1848379 - 'Execute formulas: Failed in xx sec' reported in Data Manager Package Log - BPC MS

Symptom

When running a Planning and Consolidation Data Manager package the following message appears as part of the list of actions recorded in the Package Log:

"Execute formulas: Failed in [xx] sec"

The Data Manager package consists of at least two crucial elements:-

  1. The package includes some BPC logic execution (including default logic)
  2. Work Status settings are being checked

In the BPC tblLogs table, from the AppServer database, the following information may appear:-

"248132;WorkStatusService;WorkStatusService.SetWorkStatus;[DOMAIN\USER];0;2013-04-05 16:09:58.560;
==============[System Error Tracing]==============
[System  Name] : WorkStatusService
[Message Type] : ErrorMessage
[Job Name]     : WorkStatusService.SetWorkStatus
[DateTime]     : 4/5/2013 4:09:58 PM
[UserId]       : [DOMAIN\USER]
[SqlException]
    Type      : System.Data.SqlClient.SqlException
    Errors    : System.Data.SqlClient.SqlErrorCollection
    Class     : 16
    LineNumber: 1
    Message   : {Could not find stored procedure 'up_SetWorkstatus[Application Name]'.}
    Number    : 2812
    Procedure : up_SetWorkStatusConsolidation
    Server    : [SERVER]
    State     : 1
    Source    : .Net SqlClient Data Provider
    TargetSite: 
    HelpLink  :
==============[System Error Tracing  End ]=============="


Read more...

Environment

  • SAP Business Planning and Consolidation 7.5 version for the Microsoft platform
  • SAP Business Planning and Consolidation 10.0 version for the Microsoft platform
  • SAP Business Planning and Consolidation 10.1 version for the Microsoft platform

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 7.5, version for Microsoft

Keywords

EPM, BPC MS, Business Planning and Consolidation for Microsoft, SAP BPC FOR Microsoft, executeformulas,default, logic,fail,failure,DM,LGF,LGX,ignore,workstatus,WS,setting,script,IGNORE_STATUS,uspSetWorkStatus,work status , KBA , EPM-BPC-MS , Microsoft Version , 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.