3646660 - Building project failed in BAS/WebIDE with error " unique constraint violation on pos=x for table <SID>:_SYS_BI:BIMC_ALL_SOURCESen"

When building a project in BAS or WebIDE, it failed with below error shown in the Console log.

Error: com.sap.hana.di.calculationview: Database error 129: :
    transaction rolled back by an internal Error: column store Error: fail to drop scenario: [2585] dependent views exist. cannot drop or alter scenario [8201003] at "src/<Object Path and Name>"

Error: com.sap.hana.di.calculationview: Database error 129:
    : transaction rolled back by an internal Error: 
        unique constraint violated: Table(BIMC_ALL_SOURCES), Index(_SYS_TREE_CS_#146569_#0_#P0) with Error: unique constraint violation on pos=X for table <SID>::_SYS_BI:BIMC_ALL_SOURCESen, key: $trexexternalkey$=3,<Project name>;XX,<Object Name> already exists as udiv=xxx, indexname=_SYS_TREE_CS_#xxxxx_#0_#P0 [8201003] at "src/<Object Path and Name>" (0:0)

• SAP Business Application Studio
• SAP Web IDE
• SAP HANA HDI
• SAP HANA Platform Edition 2.0

dependent views exist, cannot drop or alter scenario, unique constraint violated, BIMC_ALL_SOURCES, _SYS_BI:BIMC_ALL_SOURCESen, Generate technical MDX hierarchies, , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , Problem