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
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.