EXOR - TMA Error Message - HIG-0169 Database constraint violated TNSW_UK

When new user is trying to enter a Non streetworks activity the above message appears - can you advise what I need to do to resolve this?

 

Thank you

  • HI Fezan

    Have run this script and the issue is still there - get the following database error

    SQL statement in error
    INSERT INTO V_TMA_NON_SWAS(TNSW_ORG_REF,ORG_NAME,TNSW_DIST_REF,DIST_NAME,TNSW_NONSWA_REF,TNSW_NONSWA_TYPE,TNSW_START_DATE,TNSW_DURATION_VALUE,TNSW_DURATION_TYPE,TNSW_END_DATE,TCNT_NAME,TCNT_ADDRESS1,TCNT_ADDRESS2,TCNT_ADDRESS3,TCNT_ADDRESS4,TCNT_ADDRESS5,TCNT_POSTCODE,TCNT_TELEPHONE,TNSW_DESCRIPTION,TNSW_NONSWA_ID,TNSW_CONTACT_ID) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21)

    Error
    ORA-00001: unique constraint (HIGHWAYS.TNSW_UK) violated
    ORA-06512: at "HIGHWAYS.TMA_NONSWAS_API", line 207
    ORA-06512: at "HIGHWAYS.V_TMA_NON_SWAS_IIUD_TRG", line 25
    ORA-04088: error during execution of trigger 'HIGHWAYS.V_TMA_NON_SWAS_IIUD_TRG'