When trying to declare my instance id in the License server, I get an error “A record with the same id already exists”
S
Subham Dixit
started a topic
over 1 year ago
Best Answer
S
Subham Dixit
said
over 1 year 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 :
-- to generate a new UUID for a new instance
update mta_repository set uuid = uuid_generate_v1();
-- or to reset the UUID that was already declared in the license server (copy/paste the UUID from the license server)
update mta_repository set uuid = '292a485f-a56a-4938-8f1a-bbbbbbbbbbb1'::UUID;
SQL Server :
update mta_repository set uuid = newid()
1 Comment
S
Subham Dixit
said
over 1 year 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 :
-- to generate a new UUID for a new instance
update mta_repository set uuid = uuid_generate_v1();
-- or to reset the UUID that was already declared in the license server (copy/paste the UUID from the license server)
update mta_repository set uuid = '292a485f-a56a-4938-8f1a-bbbbbbbbbbb1'::UUID;
Subham Dixit
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 :
Postgres :
SQL Server :
Subham Dixit
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 :
Postgres :
SQL Server :
-
Deployment History Date
-
Username in Tomcat Access Logs
-
Is It Possible to Perform Automatic Authentication with The User's Windows Account?
-
Where is the documentation for Version 5.2.5?
-
On Prem Semarchy Authentication using Azure AD?
-
Delete old models
-
Sync production model version with dev
-
Recreate a dev environment. Any side effect?
-
Indexes on xDM database tables
-
What logging technology is used in the Semarchy xDM platform?
See all 60 topics