SAP Knowledge Base Article - Preview

1795936 - Reporting DTE job fails - System.Data.SqlClient.SqlException: Subquery returned more than 1 value

Symptom

When executing the DTE jobs these fail with the following errors:

Err=System.Data.SqlClient.SqlException: Subquery returned more than 1
value. This is not permitted when the subquery follows =, !=, <, <= , >,
>= or when the subquery is used as an expression.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception
,
Boolean breakConnection)
   at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateO
bject
stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String
methodName, Boolean async)
   at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at BCM_DTE.modBulkCopyCSS.BulkInsertCEMContactFact(String STime,
String ETime) in
C:\bcm_70_sp2_source\bcm_7\source\source\Reporting\DataTransformationEng
ine\BCM_DTE\modBulkCopyCSS.vb:line
338
   at BCM_DTE.modBulkCopyCSS.MainBulkCopyCSS() in
C:\bcm_70_sp2_source\bcm_7\source\source\Reporting\DataTransformationEng
ine\BCM_DTE\modBulkCopyCSS.vb:line
97
10:05:06.009 EXC> SQL error


Read more...

Environment

Issue could in SAP BCM versions 5.5 R1, 6.0 and 7.0. that run BCM Online Reporting.

Product

SAP Business Communications Management 5.5 ; SAP Business Communications Management 6.0 ; SAP Contact Center, on-premise edition 7.0

Keywords

SAP BCM, Reporting Error, Reporting DTE job fails, Subquery returned more than 1, , KBA , CRM-BCM-CMR , Please use CRM-CCI , 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.