[Bug] "Tenant already exists" when creating an organization after first-time login as superadmin

[rahilparsana]

When I log in as superadmin for the first time and attempt to create an organization, I encounter the following error:
Tenant already exists.

This issue prevents the creation of the organization, even though no tenant has been previously created.

Steps to Reproduce:

Log in as superadmin for the first time.
Go to the "Create Organization" section.
Fill in the required details and attempt to create an organization.
Observe the error message: Tenant already exists.

[rahul-rocket]

@rahilparsana This check fails if the superadmin already has a Tenant/Role, which seems to be assigned automatically when the first superadmin account is created. However, we are still unsure how this happens in your specific case.

Need More Information

To investigate further, could you please provide more details on the environment where this issue is occurring? Specifically:

1. Which API server are you using to connect API?

• Local
• Integrated (Staging/QA)
• Live (Production)

2. Is this a fresh installation, or was the database pre-populated?

This will help us reproduce the issue and determine the exact cause.

Note: Don't forget to add some short video for better understanding.

[rahilparsana]

• Environment Details:
  • API Server: Live (Production)
  • Installation Type: Fresh install with a fresh database
  • Command Used to Start API:

    pm2 start yarn --name "gauzyapi" -- run start:api:prod

I have attached a video demonstrating the issue for better understanding. Please let me know if any additional details are required.

https://drive.google.com/file/d/1Wzg6c7ay7RfNaCYygNCTxcfiqK1nJvXY/view?usp=sharing

Looking forward to your insights on this. Thanks!