Symptom
-
DTE "Data Transformation Execution" process is failing which causes Data Statistics not loading in the Standard Reports
- DTE logs capture similar errors:
- Appl=CEM REPORTING Err=System.Data.SqlClient.SqlException (0x80131904)
- Cannot insert the value NULL into column 'FK_Time', table '**.dbo.FactCEMQueue'; column does not allow nulls. INSERT fails.
- Error occurred during data collection for interval
Read more...
Environment
SAP Contact Center 7.0
Product
SAP Contact Center, on-premise edition 7.0
Keywords
Business Communication Management, CCtr, SCC, CCI, CRM-CCI, Support Pack 7.0, 7.0.1, 7.0.2, 7.0.3, 7.0.3.100, 7.0.4, 7.0.4.100, 7.0.5, 7.0.6, 7.0.6.100, 7.0.7,7.0.8.100,7.0.8,7.0.9,7.0.10,7.0.11, CEM REPORTING, Error occurred during data collection for interval, CreateAnnualTimeDimensionData, DimTime,SQL error, BCM_DTE, Insert_CEM_Queue_Fact, FK_Time , 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.