SAP Knowledge Base Article - Preview

2544238 - DTE Failure - Cannot insert the value NULL into 'CountOfConsultedContacts'


  • You are facing an issue with reporting services, and notice the following Data Transformation Engine (DTE) error:
    • ERR> Appl=CEM REPORTING Err=System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'CountOfConsultedContacts', table 'CompanyX_DSArea.dbo.FactCEMContacts'; column does not allow nulls.
    • INSERT fails.



SAP Contact Center 7.0


SAP Contact Center, on-premise edition 7.0


Business Communication Management, BCM, CCtr, SCC, Contact Center, CCI, CRM-CCI, ConsTo, ConsEnd, DTE, Data Transformation Engine, contactlogdetail, null, CountOfConsultedContacts, Insert fails, BCM_DTE, report, ConsConnected, FactCEMContact, SQL, NULL , 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.