SAP Knowledge Base Article - Preview

2415879 - OLAP errors after Upgrade to SAP Contact Center SP10

Symptom

  • You are using SAP Contact Center with custom reports 
  • When trying to upgrade the DTE process is failling to include new data into the OLAP cubes
  • Running a full process of the OLAP database gives the follwing errors 
    • Executed as user: XYX\BCMAdmin. <return xmlns="urn:schemas-microsoft-com:xml-analysis">
      <results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
      <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />
      <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
      <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Warning WarningCode="1092354050" Description="Server: Operation completed with 56 problems logged." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
      </Messages>
      </root>
      </results>
      </return>.  
      The step failed.

    • Executed as user: XYX\BCMAdmin. 
      <return xmlns="urn:schemas-microsoft-com:xml-analysis">
      <results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
      <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
      <Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
      <Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
      <Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
      <Warning WarningCode="2166292481" Description="Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_FactCEMQueue', Column: 'FK_Time_Default', Value: ''. The attribute is 'PK_Time'." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
      <Error ErrorCode="3240034310" Description="Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
      <Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine: An error occurred while processing the 'CubCSSQueues_INCR_UPDATE_TEMP_ighqb_' partition of the 'CubCSSQueues' measure group for the 'CubCSSQueues' cube from the ContactCenter_OLAP database." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" /><Error ErrorCode="3239837702" Description="Server: The current operation was cancelled because another operation in the transaction failed." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" />
      </Messages>
      </root>
      </results>
      </return>.  
      The step failed.

       DTE.png

 


Read more...

Environment

SAP Contact Center 7.0.10

Product

SAP Contact Center, on-premise edition all versions

Keywords

CCtr, SCC, CCI, CRM-CCI, SAP Business Communication Management 7, Reporting, OLAP, Upgrade All Software , KBA , CRM-CCI , Contact Center Infrastructure , 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.