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

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

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

SAP BCM, Reporting Error, Reporting DTE job fails, Subquery returned more than 1, , KBA , CRM-BCM-CMR , Please use CRM-CCI , Problem