SAP Knowledge Base Article - Preview

2524745 - Reporting Data Transformation Process is failing with 'QUOTED_IDENTIFIER' errors

Symptom

  • You are running SAP Contact Center and have implemented the Standard Reports
  • Data is not populating the OLAP database anymore and the Standard Reports are empty for the specific date/time frame
  • The MSSQL server logs as well as the DTE logs are showing the following error: "INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations."

Read more...

Environment

  • SAP Contact Center 7.0
  • Support Packs prior to SP10

Product

SAP Contact Center, on-premise edition 7.0

Keywords

CCtr, SCC, CCI, CRM-CCI, SAP Business Communication Management 7, recollecting data, missing data, standard reports, history reports, copylogdata, copy data, process full, Data Transformation Execution, DSArea, VWU, rollback, analysis services, reporting services, OLAP, Cubes, reprocess data,  re-collect statisticts data , 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.