Very happy to note that I finally cracked the puzzle on this bug. It's a simple case of readers=tenant that was missing in the build script. This bug was always there since the introduction of gradle. So I will fix it and backport to branch 16. You can check [1] for more.
However, given that this bug was discovered so late gives me an indication that very few people are interested in the multi-tenancy feature in OFBiz. [1] https://issues.apache.org/jira/browse/OFBIZ-9278 On Mon, Jul 17, 2017 at 2:59 PM, vivek.mi <vmvivek...@gmail.com> wrote: > I did try. I created two tenants with: > > 1. *./gradlew createTenant -PtenantId=mytenant -PtenantName="My Name" > -PdomainName=com.example -PtenantReaders=seed,seed-initial,ext > -PdbPlatform=M -PdbIp=127.0.0.1 -PdbUser=mydbuser -PdbPassword=mydbpass* > > Tenant1: CAD > Tenant 2: DDS > > 2. Used ./gradlew ofbiz > 3. Login with CAD-admin (first tenant), login successful > 4. Login with DDS-admin (second tenant), following error: > > Can't access entity of entityGroup = org.apache.ofbiz.tenant using tenant > delegator default#DDS, use base delegator instead > 2017-07-17 17:44:41,665 |OFBiz-batch-9 |GenericDelegator > |I| Delegator "default#DDS" NOT initializing helper for entity group > "org.apache.ofbiz.tenant" because the group is not associated to this > delegator. > 2017-07-17 17:44:41,666 |OFBiz-batch-8 |GenericDelegator > |I| Delegator "default#DDS" initializing helper "localpostgres" for entity > group "org.apache.ofbiz". > 2017-07-17 17:44:41,666 |OFBiz-batch-7 |GenericDelegator > |I| Delegator "default#DDS" initializing helper "localpostolap" for entity > group "org.apache.ofbiz.olap". > 2017-07-17 17:44:41,666 |OFBiz-batch-8 |GenericDelegator > |I| Doing database check as requested in entityengine.xml with > addMissing=true > 2017-07-17 17:44:41,666 |OFBiz-batch-7 |GenericDelegator > |I| Doing database check as requested in entityengine.xml with > addMissing=true > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Product Name is PostgreSQL > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Product Version is 9.3.17 > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Driver Name is PostgreSQL Native Driver > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201) > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Driver JDBC Version is 4.0 > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| Database Setting/Support Information (those with a * should be true): > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - supports transactions [true]* > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - isolation None [false] > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - isolation ReadCommitted [true] > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - isolation ReadUncommitted [true] > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - isolation RepeatableRead [true] > 2017-07-17 17:44:41,669 |OFBiz-batch-7 |DatabaseUtil > |I| - isolation Serializable [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - forward only type [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - scroll sensitive type [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - scroll insensitive type [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - is case sensitive [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - stores LowerCase [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - stores MixedCase [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - stores UpperCase [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Product Name is PostgreSQL > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Product Version is 9.3.17 > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Driver Name is PostgreSQL Native Driver > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Driver Version is PostgreSQL 9.4 JDBC4.1 (build 1201) > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Driver JDBC Version is 4.0 > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| Database Setting/Support Information (those with a * should be true): > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - supports transactions [true]* > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - isolation None [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - max table name length [63] > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - isolation ReadCommitted [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - max column name length [63] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - concurrent connections [8192] > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - isolation ReadUncommitted [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - concurrent statements [0] > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - isolation RepeatableRead [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - ANSI SQL92 Entry [true] > 2017-07-17 17:44:41,670 |OFBiz-batch-7 |DatabaseUtil > |I| - ANSI SQL92 Intermediate [false] > 2017-07-17 17:44:41,670 |OFBiz-batch-8 |DatabaseUtil > |I| - isolation Serializable [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - ANSI SQL92 Full [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - ODBC SQL Grammar Core [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - forward only type [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - ODBC SQL Grammar Extended [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - scroll sensitive type [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - ODBC SQL Grammar Minimum [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - scroll insensitive type [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - outer joins [true]* > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - limited outer joins [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - is case sensitive [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - full outer joins [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - stores LowerCase [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - group by [true]* > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - group by not in select [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - stores MixedCase [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - column aliasing [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - order by not in select [true] > 2017-07-17 17:44:41,671 |OFBiz-batch-8 |DatabaseUtil > |I| - stores UpperCase [false] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - alter table add column [true]* > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - non-nullable column [true]* > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - default fetchsize [0] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| - named parameters [ SKIPPED ] > 2017-07-17 17:44:41,671 |OFBiz-batch-7 |DatabaseUtil > |I| Getting Table Info From Database > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - max table name length [63] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - max column name length [63] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - concurrent connections [8192] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - concurrent statements [0] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ANSI SQL92 Entry [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ANSI SQL92 Intermediate [false] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ANSI SQL92 Full [false] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ODBC SQL Grammar Core [false] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ODBC SQL Grammar Extended [false] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - ODBC SQL Grammar Minimum [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - outer joins [true]* > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - limited outer joins [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - full outer joins [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - group by [true]* > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - group by not in select [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - column aliasing [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - order by not in select [true] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - alter table add column [true]* > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - non-nullable column [true]* > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - default fetchsize [0] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| - named parameters [ SKIPPED ] > 2017-07-17 17:44:41,672 |OFBiz-batch-8 |DatabaseUtil > |I| Getting Table Info From Database > 2017-07-17 17:44:41,672 |OFBiz-batch-7 |DatabaseUtil > |I| Getting Column Info From Database > 2017-07-17 17:44:41,678 |OFBiz-batch-7 |DatabaseUtil > |I| Reviewed 8 primary key fields from database. > 2017-07-17 17:44:41,688 |OFBiz-batch-8 |DatabaseUtil > |I| Getting Column Info From Database > 2017-07-17 17:44:41,878 |OFBiz-batch-8 |DatabaseUtil > |I| Reviewed 1704 primary key fields from database. > 2017-07-17 17:44:41,890 |OFBiz-batch-9 |ServiceGroupReader > |I| Loaded [1] Group definitions from > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml > 2017-07-17 17:44:41,892 |http-nio-8445-exec-6 |ServiceGroupReader > |I| Loaded [1] Group definitions from > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml > 2017-07-17 17:44:41,892 |OFBiz-batch-9 |ServiceGroupReader > |I| Loaded [4] Group definitions from > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml > 2017-07-17 17:44:41,894 |OFBiz-batch-9 |ServiceGroupReader > |I| Loaded [2] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml > 2017-07-17 17:44:41,894 |http-nio-8445-exec-6 |ServiceGroupReader > |I| Loaded [4] Group definitions from > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml > 2017-07-17 17:44:41,896 |OFBiz-batch-9 |ServiceGroupReader > |I| Loaded [1] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml > 2017-07-17 17:44:41,897 |http-nio-8445-exec-6 |ServiceGroupReader > |I| Loaded [2] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/servicedef/service_groups.xml > 2017-07-17 17:44:41,899 |http-nio-8445-exec-6 |ServiceGroupReader > |I| Loaded [1] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml > 2017-07-17 17:44:41,899 |OFBiz-batch-9 |ServiceGroupReader > |I| Loaded [4] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml > 2017-07-17 17:44:41,901 |OFBiz-batch-9 |ServiceDispatcher > |I| Registering dispatcher: entity-default#DDS#DDS > 2017-07-17 17:44:41,901 |OFBiz-batch-9 |ServiceContainer > |I| Created new dispatcher: entity-default#DDS#DDS > 2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceGroupReader > |I| Loaded [4] Group definitions from > file:/home/nicsi/Ofbiz_tenant/applications/accounting/servicedef/groups.xml > 2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceDispatcher > |I| Registering dispatcher: Humanres#DDS > 2017-07-17 17:44:41,903 |http-nio-8445-exec-6 |ServiceContainer > |I| Created new dispatcher: Humanres#DDS > 2017-07-17 17:44:41,904 |http-nio-8445-exec-6 |ControlServlet > |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]- > total:0.0,since last(Begin):0.0]] > 2017-07-17 17:44:41,991 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.073s, 280 requests, 124 views in > file:/home/nicsi/Ofbiz_tenant/applications/humanres/webapp/humanres/WEB-INF/controller.xml > 2017-07-17 17:44:42,010 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.014s, 45 requests, 22 views in > file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/common-controller.xml > 2017-07-17 17:44:42,017 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.0s, 0 requests, 0 views in > file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/handlers-controller.xml > 2017-07-17 17:44:42,088 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.065s, 255 requests, 104 views in > file:/home/nicsi/Ofbiz_tenant/applications/party/webapp/partymgr/WEB-INF/controller.xml > 2017-07-17 17:44:42,100 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.007s, 30 requests, 13 views in > file:/home/nicsi/Ofbiz_tenant/framework/common/webcommon/WEB-INF/security-controller.xml > 2017-07-17 17:44:42,105 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.001s, 4 requests, 0 views in > file:/home/nicsi/Ofbiz_tenant/applications/commonext/webapp/WEB-INF/controller.xml > 2017-07-17 17:44:42,210 |http-nio-8445-exec-6 |ConfigXMLReader > |I| controller loaded: 0.097s, 379 requests, 154 views in > file:/home/nicsi/Ofbiz_tenant/applications/content/webapp/content/WEB-INF/controller.xml > JJJJJJJJJJJDDS-admin > 2017-07-17 17:44:42,218 |http-nio-8445-exec-6 |LoginServices > |I| [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found. > 2017-07-17 17:44:42,218 |http-nio-8445-exec-6 |ServiceDispatcher > |W| Service Failure [userLogin]: User not found. > 2017-07-17 17:44:42,219 |http-nio-8445-exec-6 |ServiceDispatcher > |T| Sync service [Humanres#CAD/userLogin] finished in [3] milliseconds > 2017-07-17 17:44:42,219 |http-nio-8445-exec-6 |RequestHandler > |I| Ran Event [java:org.apache.ofbiz.webapp.control.LoginWorker#login] from > [request], result is [error] > 2017-07-17 17:44:42,223 |http-nio-8445-exec-6 |RequestHandler > |E| Request login caused an error with the following message: following > error occurred during login: User not found. > 2017-07-17 17:44:42,224 |http-nio-8445-exec-6 |RequestHandler > |I| Rendering View [login]. Hidden sessionId by default. > 2017-07-17 17:44:42,227 |http-nio-8445-exec-6 |ServiceDispatcher > |T| Sync service [Humanres#CAD/getUserPreferenceGroup] finished in [1] > milliseconds > 2017-07-17 17:44:42,263 |http-nio-8445-exec-6 |ServiceDispatcher > |T| Sync service [Humanres#CAD/getVisualThemeResources] finished in [34] > milliseconds > 2017-07-17 17:44:42,271 |http-nio-8445-exec-6 |ScreenFactory > |I| Got 26 screens in 0.006s from: > file:/home/nicsi/Ofbiz_tenant/framework/common/widget/CommonScreens.xml > 2017-07-17 17:44:42,277 |http-nio-8445-exec-6 |UtilXml > |E| XmlFileLoader: File > file:/home/nicsi/Ofbiz_tenant/applications/humanres/widget/CommonScreens.xml > process error. Line: 561. Error message: cvc-complex-type.2.3: Element > 'screens' cannot have character [children], because the type's content type > is element-only. > 2017-07-17 17:44:42,277 |http-nio-8445-exec-6 |ScreenFactory > |I| Got 14 screens in 0.005s from: > file:/home/nicsi/Ofbiz_tenant/applications/humanres/widget/CommonScreens.xml > 2017-07-17 17:44:42,282 |http-nio-8445-exec-6 |ScreenFactory > |I| Got 1 screens in 0.004s from: > file:/home/nicsi/Ofbiz_tenant/applications/commonext/widget/CommonScreens.xml > 2017-07-17 17:44:42,282 |http-nio-8445-exec-6 |PrimaryKeyFinder > |I| Returning null because found incomplete primary key in find: > [GenericEntity:PartyNameView][partyId,null()] > 2017-07-17 17:44:42,352 |http-nio-8445-exec-6 |ServiceDispatcher > |T| Sync service [Humanres#CAD/getLastSystemInfoNote] finished in [18] > milliseconds > 2017-07-17 17:44:42,356 |http-nio-8445-exec-6 |ServiceDispatcher > |T| Sync service [Humanres#CAD/getVisualThemeResources] finished in [1] > milliseconds > 2017-07-17 17:44:42,392 |http-nio-8445-exec-6 |ServerHitBin > |I| The Visit GenericValue stored in the client session does not exist in > the database, not storing server hit. > 2017-07-17 17:44:42,395 |http-nio-8445-exec-6 |ControlServlet > |T| [[[login(Domain:https://localhost)] Request Done- total:0.491,since > last([login(Domain:htt...):0.491]] > > > > > > > ----- > Vivek Mishra > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Tenant-Login-Issue-in-OFBiz-16-11-tp4708208p4708222.html > Sent from the OFBiz - User mailing list archive at Nabble.com.
