SAP Knowledge Base Article - Preview

2273195 - EVDRE report fails to retrieve data with measure

Symptom

  • On EPM BPC-MS 10.1 SP04, with EPM-Addin, when refreshing any EVDRE report having MEASURES (YTD or PERIODIC) on Columns or Rows, there is no data retreived.
  • No error is raised from EPM-Addin, but when checking from BPC side, the following error is shown in the BPC log:

    ==============[System Exception Tracing]============== [System Name] : SQE [Message Type] : ErrorMessage [Job Name] : clsDataQuery::SetResultTuplePosition [DateTime] : 01/19/2016 15:14:24 [UserId] : UserXXXX
    [Exception] DetailMsg :
    {Error: System.InvalidOperationException: Object waarvoor null is toegestaan, moet een waarde hebben. bij System.Nullable`1.get_Value () bij
    DataService.OSoft.Services.Webservice.SharedQueryEngine.clsDataQuery.SetResultTuplePosition(List`1& m_tuples, CResultAxis& m_axis, Hashtable&hashValidPosition)}
    ==============[System Exception Tracing End ]
    ==============


Read more...

Environment

  • SAP Business Planning and Consolidation for the Microsoft platform version 10.1 SP04 (EPM BPC-MS)
  • EPM Excel Add-in version 10 onwards including Support Packages

Product

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

Keywords

No data returned, Tuple, SQE engine, Refresh EVDRE, SetResultTuplePosition, SharedQueryEngine, clsDataQuery , 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.