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

Hello Ray,

The error suggests that the Non SWA reference already exists.  Please could check and confirm?

Kind Regards

Fezan

Hello Ray,

Please could you run the following SQL statements and provide the output:

select tma_tnsw_nonswa_id_seq.nextval from dual;
select tma_tnsw_nonswa_id_seq.currval from dual;

Kind Regards

Fezan

Hello Ray,

Please could you run the following SQL statements and provide the output:

select tma_tnsw_nonswa_id_seq.nextval from dual;
select tma_tnsw_nonswa_id_seq.currval from dual;

Kind Regards

Fezan

Hi Fezan

The answer is 13929

Kind Regards

Ray

Hello Ray,

Please could you run the following SQL and provide the output:

select max (TNSW_NONSWA_REF) from tma_non_swas;

Kind Regards

Fezan

Dear Fezan

The output was:

UK9997110

Thanks

Ray

Hi Ray,

The issue sounds like a problem with sequencing, however, before I provide you with SQL to reset sequences, could you check if there are any Organisations/Districts which have a prefix of UK99? This can be found under Street Gazetteer Manager->Data->Organisation and Districts.

Kind Regards

Fezan

Hi Fezan

Have checked this and there are no Organisations/Districts with a prefix of UK99. This issue is only affecting one user and not all users.

Kind Regards

Ray