CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - PL SQL - SQL Error ORA - 00001 unique constraint KB Name

Following error encountered while running analysis: 

SQL Error: ORA-00001: unique constraint (<KB name>.COL_IDOBJCOLNAM) violated.
SQL Error: ORA-06512: at "<KB name>.TR_I_COL", line 64.
Error in Cwmm_import_table( lpszObjectName='TQ_CALC2', Operation=CWMMOP_ALL, lpszOwner=NULL, lpszSchemaName='CTR', &o_nRootCwmmId, szImportMessage ): Incorrect parameters / Internal error 

This error had been encountered in CAST version 7.0.4 & 7.0.6

1. Activate the SHOWSQL log

2. In the log, locate the call function :
          <kb_name>. TR_I_Col (...
            ColNam = <column_name>,
           IdObj = <id_object>,
           IdDtp = <id_datatype>,

3. Get the <id_column> by the following request:
   select idCol from <KB_name>.Col where idObj = <id_object>, and ColNam = <column_name>;
4. update the column datatype :update the column datatype :
   update <kb_name>.Col set IdDtp = <id_datatype> where IdCol =<id_column>
5. Run analysis
   

Following error was raised in the log:

 call function FR_DPI_CTR_KB.TR_I_Col ( IdCol = 0 (OUT),
ColNam = "USER_PROP",
IdObj = 3535624,
IdDtp = 6310695,
ColKeyNum = 0,
ColNum = 29,
ColLen = 3748,
ColPrc = 0,
ColScl = 0,
ColNul = 1,
SprOutCol = 0,
ColIdt = 0,
ColClass = 1250,
ColProp = 1114112,
ObjTyp = 24,
IdPro = 3534559 )
..
SQL Error: ORA-00001: unique constraint (FR_DPI_CTR_KB.COL_IDOBJCOLNAM) violated.

Here the column that violate unique constraint has:

ColNam = "USER_PROP",
IdObj = 3535624 and
IdDtp = 6310695.

So use the following query and run it on KB:

UPDATE <KB Name>.Col
SET IdDtp = 6310695
WHERE IdCol =
                                                (
                                                                SELECT idCol
                                                                FROM FR_DPI_CTR_KB.Col
                                                                WHERE idObj = 3535624
                                                                AND ColNam = 'USER_PROP'
                                                );