When trying to declare my instance id in the License server, I get an error “A record with the same id already exists” : xDM Portal

Start a new topic

Answered

When trying to declare my instance id in the License server, I get an error “A record with the same id already exists”

started a topic 8 months ago

Best Answer

Subham Dixit said 8 months ago

The issue must occur because you copied a repository from one environment to another.

To fix this issue, update the repository UUID in the copied repository schema → mta_repository :

Oracle :

update MTA_REPOSITORY set UUID = SYS_GUID();

Postgres :

update mta_repository set uuid = uuid_generate_v1();

SQL Server :

update mta_repository set uuid = newid()

1 Comment

said 8 months ago

Answer

The issue must occur because you copied a repository from one environment to another.

To fix this issue, update the repository UUID in the copied repository schema → mta_repository :

Oracle :

update MTA_REPOSITORY set UUID = SYS_GUID();

Postgres :

update mta_repository set uuid = uuid_generate_v1();

SQL Server :

update mta_repository set uuid = newid()