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.