2415879 - OLAP errors after Upgrade to SAP Contact Center SP10 | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.