2643287 - CCDB Task Housekeeping status in red "Admin Task Returncode: 18" - SAP Solution Manager 7.2

CCDB Adminstration task Housekeeping finished with error:

Admin Task Returncode: 18
Problem at housekeeping detected

And in the spool log of DIAGST_ADMIN_TASKS job, the following error is observed.

----------------------------------
Store-ID XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Target date YY.YYM.MDD.000.326 exception
An exception occurred [CX_DIAGST_RETRIEVE_EXCEPTION]
CX_ELEMENT_GET_DETAIL_FAILED: No detailed element data. Element ID '001
'. Date 'YYYYMMDDHHMMSS '. [CX_DIAGST_RETRIEVE_EXCEPTION]

Caused by
Program: CL_DIAGST_STORE===============CP
Include: CL_DIAGST_STORE===============CM038
Source line: 420
----------------------------------

• SAP Solution Manager 7.2 SP04 or higher

Return code 18 , KBA , SV-SMG-DIA-APP-CA , Change Analysis + Reporting, Configuration Validation, CCDB , Problem