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:-
- The package includes some BPC logic execution (including default logic)
- 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
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.
SAP Knowledge Base Article - Preview