- ABP Framework version: v5.1.4
- UI type: Angular
- DB provider: EF Core
- Tiered (MVC) or Identity Server Separated (Angular): yes
- Exception message and stack trace:
- Steps to reproduce the issue:"
- Configure multi-tenant sepearte db:
- Host DB
- Tenant DB
- Create new business entity
- follow all process with data seeder as per https://docs.abp.io/en/commercial/latest/tutorials/book-store/part-1?UI=NG&DB=EF
- run db migrator
- tables get created in
- host db
- tenant db
- data seeder populate only host db table but not the tenant db table
Please let me know how to get this fixed
10 Answer(s)
-
0
hi
Can you provide a simple project? liming.ma@volosoft.com
-
0
hi
I added a tenant and the database is created, the data are seeder in the database.
-
0
Hello @maliming, Yes you are correct, tables are getting created in seperate databases for host and tenant. no issue. My concern is data seeder is filling data in host db only. it should have data in tenant db table also; i am not sure about user tables but my custom tables are not working as per shared code.
-
0
There is no tenant exists. so no data are added in tenant db.
-
0
Hello @maliming, i am not sure how you have mention that there is no tenant exist. i have created 1 tenant and seperate DB for tenant. Please refer the attached screen shot. I have not shared the tenant and host db credentials in code due to security.
as per attached screen shot:
- dev_aztute is host db
- dev_identity is tenant db
Tenant db has only following tables (higlited one is custom table. this is the same table which is not getting populated with data):
-
0
hi
I change your code to add a tenant then the seeder is working.
https://support.abp.io/QA/Questions/2731#answer-803b7a5c-d367-44c0-8537-3a02acf0f7a7
-
0
Hello @maliming, Can you please confirm where exactly you have made changes i.e. class and method. will follow in future.
-
0
hi
I added a tenant with a custom connections string.
-
0
Similarly tenant conneciton string is available in host db --> SaasTenantConnectionStrings table. My assumption is ABP framework should take care of connection string from this table instead of hardcoding in the applicaiotn. we will have multiple tenant so we cannot keep adding connection string in code.
-
0
Yes,
Can you set a breakpoint for the check if there are any tenants? and its connection strings.
