Re: Multitenancy issue OFBiz 16.11

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Re: Multitenancy issue OFBiz 16.11

Rishi Solanki
Vivek,

Did not tried it myself, but you can try setting mentioned here in web.xml
and entityengine.xml -
https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support

Your logs also says, to use correct delegator for the tenant group.
====
 Delegator "default#DDS" NOT initializing
helper for entity group "org.apache.ofbiz.tenant" because the group is not
associated to this delegator.
====

HTH!


Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Tue, Sep 12, 2017 at 11:58 PM, vivek.mi <[hidden email]> wrote:

> Hello All, I have created two tenants in the application.1. Tenant ID:
> CAD2.
> Tenant ID: DDSWhen i am logging in, the first tenant is logging in
> successfully, but second one is not successful. Can't access entity of
> entityGroup = org.apache.ofbiz.tenant using tenant delegator default#DDS,
> use base delegator instead2017-07-17 15:05:27,143 |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 15:05:27,143 |OFBiz-batch-7
> |GenericDelegator              |I| Delegator "default#DDS" initializing
> helper "localpostolap" for entity group "org.apache.ofbiz.olap". 2017-07-17
> 15:05:27,143 |OFBiz-batch-7        |GenericDelegator              |I| Doing
> database check as requested in entityengine.xml with addMissing=true
> 2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator
> |I| Delegator "default#DDS" initializing helper "localpostgres" for entity
> group "org.apache.ofbiz". 2017-07-17 15:05:27,144 |OFBiz-batch-8
> |GenericDelegator              |I| Doing database check as requested in
> entityengine.xml with addMissing=true 2017-07-17 15:05:27,266
> |OFBiz-batch-7
> |DatabaseUtil                  |I| Database Product Name is PostgreSQL
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Product Version is 9.3.17 2017-07-17 15:05:27,266
> |OFBiz-batch-7        |DatabaseUtil                  |I| Database Driver
> Name is PostgreSQL Native Driver 2017-07-17 15:05:27,266 |OFBiz-batch-7
> |DatabaseUtil                  |I| Database Driver Version is PostgreSQL
> 9.4
> JDBC4.1 (build 1201) 2017-07-17 15:05:27,266 |OFBiz-batch-7
> |DatabaseUtil                  |I| Database Driver JDBC Version is 4.0
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| Database Setting/Support Information (those with a * should be true):
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - supports transactions     [true]* 2017-07-17 15:05:27,266
> |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation None
> [false] 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation ReadCommitted   [true] 2017-07-17 15:05:27,266
> |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation
> ReadUncommitted [true] 2017-07-17 15:05:27,266 |OFBiz-batch-7
> |DatabaseUtil                  |I| - isolation RepeatableRead  [true]
> 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> |I| - isolation Serializable    [true] 2017-07-17 15:05:27,267
> |OFBiz-batch-7        |DatabaseUtil                  |I| - forward only
> type
> [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,267
> |OFBiz-batch-7        |DatabaseUtil                  |I| - scroll
> insensitive type   [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7
> |DatabaseUtil                  |I| - is case sensitive         [false]
> 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - stores LowerCase          [true] 2017-07-17 15:05:27,267
> |OFBiz-batch-7        |DatabaseUtil                  |I| - stores MixedCase
> [false] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> |I| - stores UpperCase          [false] 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| Database Product
> Name is PostgreSQL 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| Database Product Version is 9.3.17
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| Database Driver Name is PostgreSQL Native Driver 2017-07-17
> 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver
> Version is PostgreSQL 9.4 JDBC4.1 (build 1201) 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver
> JDBC Version is 4.0 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| Database Setting/Support Information
> (those with a * should be true): 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| - supports transactions     [true]*
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation None            [false] 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> ReadCommitted   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| - isolation ReadUncommitted [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - isolation RepeatableRead  [true] 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> Serializable    [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| - forward only type         [true]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| - scroll
> insensitive type   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> |DatabaseUtil                  |I| - is case sensitive         [false]
> 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - stores LowerCase          [true] 2017-07-17 15:05:27,321
> |OFBiz-batch-8        |DatabaseUtil                  |I| - stores MixedCase
> [false] 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> |I| - stores UpperCase          [false] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - max table name
> length     [63] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - max column name length    [63] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil                  |I| - concurrent connections    [8192]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - concurrent statements     [0] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92 Full
> [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL Grammar
> Extended [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - outer joins
> [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - limited outer joins       [true] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - full outer joins
> [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> |I| - group by                  [true]* 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - group by not in
> select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil
> |I| - column aliasing           [true] 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - order by not in
> select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil
> |I| - alter table add column    [true]* 2017-07-17 15:05:27,536
> |OFBiz-batch-7        |DatabaseUtil                  |I| - non-nullable
> column       [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil                  |I| - default fetchsize        [0]
> 2017-07-17
> 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| -
> named parameters         [ SKIPPED ] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil                  |I| Getting Table Info From Database
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - max table name length     [63] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil                  |I| - max column name length    [63]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - concurrent connections    [8192] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - concurrent
> statements     [0] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92 Full
> [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL Grammar
> Extended [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil
> |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - outer joins
> [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - limited outer joins       [true] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - full outer joins
> [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> |I| - group by                  [true]* 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - group by not in
> select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil
> |I| - column aliasing           [true] 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - order by not in
> select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil
> |I| - alter table add column    [true]* 2017-07-17 15:05:27,544
> |OFBiz-batch-8        |DatabaseUtil                  |I| - non-nullable
> column       [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil                  |I| - default fetchsize        [0]
> 2017-07-17
> 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| -
> named parameters         [ SKIPPED ] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> |DatabaseUtil                  |I| Getting Table Info From Database
> 2017-07-17 15:05:27,675 |OFBiz-batch-8        |DatabaseUtil
> |I| Getting Column Info From Database 2017-07-17 15:05:27,706
> |OFBiz-batch-7
> |DatabaseUtil                  |I| Getting Column Info From Database
> 2017-07-17 15:05:27,759 |OFBiz-batch-7        |DatabaseUtil
> |I| Reviewed 8 primary key fields from database. 2017-07-17 15:05:28,077
> |OFBiz-batch-8        |DatabaseUtil                  |I| Reviewed 1704
> primary key fields from database. 2017-07-17 15:05:28,089 |OFBiz-batch-7
> |ServiceGroupReader            |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
> 2017-07-17 15:05:28,090 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/groups_test.xml
> 2017-07-17 15:05:28,092 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> 2017-07-17 15:05:28,092 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> 2017-07-17 15:05:28,095 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [2] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> servicedef/service_groups.xml
> 2017-07-17 15:05:28,095 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [2] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> servicedef/service_groups.xml
> 2017-07-17 15:05:28,098 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> 2017-07-17 15:05:28,098 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [1] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> 2017-07-17 15:05:28,101 |OFBiz-batch-7        |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> servicedef/groups.xml
> 2017-07-17 15:05:28,101 |http-nio-8445-exec-1 |ServiceGroupReader
> |I| Loaded [4] Group definitions from
> file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> servicedef/groups.xml
> 2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceDispatcher
> |I| Registering dispatcher: entity-default#DDS#DDS 2017-07-17 15:05:28,215
> |OFBiz-batch-7        |ServiceContainer              |I| Created new
> dispatcher: entity-default#DDS#DDS 2017-07-17 15:05:28,215
> |http-nio-8445-exec-1 |ServiceDispatcher             |I| Registering
> dispatcher: Humanres#DDS 2017-07-17 15:05:28,215 |http-nio-8445-exec-1
> |ServiceContainer              |I| Created new dispatcher: Humanres#DDS
> 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet
> |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]-
> total:0.0,since last(Begin):0.0]] 2017-07-17 15:05:28,291
> |http-nio-8445-exec-1 |UtilProperties                |I| ResourceBundle
> SecurityextUiLabels (en_US) created in 0.019s with 69 properties 2017-07-17
> 15:05:28,291 |http-nio-8445-exec-1 |LoginServices                 |I|
> [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
> 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> |W| Service Failure [userLogin]: User not found. 2017-07-17 15:05:28,292
> |http-nio-8445-exec-1 |ServiceDispatcher             |T| Sync service
> [Humanres#CAD/userLogin] finished in [22] milliseconds I tried to search
> for
> it, but not getting anything useful. Can someone please suggest something
> as
> i am struck on it now.Regards, Vivek Mishra
>
>
>
> -----
> Vivek Mishra
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Reply | Threaded
Open this post in threaded view
|

Re: Multitenancy issue OFBiz 16.11

Deepak Dixit-3
Hi Vivek,

You can't access org.apache.ofbiz.tenant group from tenant.

Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

On Thu, Sep 14, 2017 at 6:36 PM, Rishi Solanki <[hidden email]>
wrote:

> Vivek,
>
> Did not tried it myself, but you can try setting mentioned here in web.xml
> and entityengine.xml -
> https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
>
> Your logs also says, to use correct delegator for the tenant group.
> ====
>  Delegator "default#DDS" NOT initializing
> helper for entity group "org.apache.ofbiz.tenant" because the group is not
> associated to this delegator.
> ====
>
> HTH!
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Tue, Sep 12, 2017 at 11:58 PM, vivek.mi <[hidden email]> wrote:
>
> > Hello All, I have created two tenants in the application.1. Tenant ID:
> > CAD2.
> > Tenant ID: DDSWhen i am logging in, the first tenant is logging in
> > successfully, but second one is not successful. Can't access entity of
> > entityGroup = org.apache.ofbiz.tenant using tenant delegator default#DDS,
> > use base delegator instead2017-07-17 15:05:27,143 |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 15:05:27,143 |OFBiz-batch-7
> > |GenericDelegator              |I| Delegator "default#DDS" initializing
> > helper "localpostolap" for entity group "org.apache.ofbiz.olap".
> 2017-07-17
> > 15:05:27,143 |OFBiz-batch-7        |GenericDelegator              |I|
> Doing
> > database check as requested in entityengine.xml with addMissing=true
> > 2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator
> > |I| Delegator "default#DDS" initializing helper "localpostgres" for
> entity
> > group "org.apache.ofbiz". 2017-07-17 15:05:27,144 |OFBiz-batch-8
> > |GenericDelegator              |I| Doing database check as requested in
> > entityengine.xml with addMissing=true 2017-07-17 15:05:27,266
> > |OFBiz-batch-7
> > |DatabaseUtil                  |I| Database Product Name is PostgreSQL
> > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > |I| Database Product Version is 9.3.17 2017-07-17 15:05:27,266
> > |OFBiz-batch-7        |DatabaseUtil                  |I| Database Driver
> > Name is PostgreSQL Native Driver 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > |DatabaseUtil                  |I| Database Driver Version is PostgreSQL
> > 9.4
> > JDBC4.1 (build 1201) 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > |DatabaseUtil                  |I| Database Driver JDBC Version is 4.0
> > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > |I| Database Setting/Support Information (those with a * should be true):
> > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > |I| - supports transactions     [true]* 2017-07-17 15:05:27,266
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation None
> > [false] 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > |I| - isolation ReadCommitted   [true] 2017-07-17 15:05:27,266
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation
> > ReadUncommitted [true] 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > |DatabaseUtil                  |I| - isolation RepeatableRead  [true]
> > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > |I| - isolation Serializable    [true] 2017-07-17 15:05:27,267
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - forward only
> > type
> > [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,267
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - scroll
> > insensitive type   [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7
> > |DatabaseUtil                  |I| - is case sensitive         [false]
> > 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > |I| - stores LowerCase          [true] 2017-07-17 15:05:27,267
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - stores
> MixedCase
> > [false] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > |I| - stores UpperCase          [false] 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| Database Product
> > Name is PostgreSQL 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| Database Product Version is 9.3.17
> > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| Database Driver Name is PostgreSQL Native Driver 2017-07-17
> > 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver
> > Version is PostgreSQL 9.4 JDBC4.1 (build 1201) 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| Database Driver
> > JDBC Version is 4.0 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| Database Setting/Support Information
> > (those with a * should be true): 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - supports transactions     [true]*
> > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| - isolation None            [false] 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> > ReadCommitted   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - isolation ReadUncommitted [true]
> > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| - isolation RepeatableRead  [true] 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> > Serializable    [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - forward only type         [true]
> > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - scroll
> > insensitive type   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - is case sensitive         [false]
> > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| - stores LowerCase          [true] 2017-07-17 15:05:27,321
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - stores
> MixedCase
> > [false] 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > |I| - stores UpperCase          [false] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - max table name
> > length     [63] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> |DatabaseUtil
> > |I| - max column name length    [63] 2017-07-17 15:05:27,536
> |OFBiz-batch-7
> > |DatabaseUtil                  |I| - concurrent connections    [8192]
> > 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > |I| - concurrent statements     [0] 2017-07-17 15:05:27,536
> |OFBiz-batch-7
> > |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> > 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92
> Full
> > [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL
> Grammar
> > Extended [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - outer joins
> > [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > |I| - limited outer joins       [true] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - full outer
> joins
> > [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > |I| - group by                  [true]* 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - group by not
> in
> > select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > |DatabaseUtil
> > |I| - column aliasing           [true] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - order by not
> in
> > select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > |DatabaseUtil
> > |I| - alter table add column    [true]* 2017-07-17 15:05:27,536
> > |OFBiz-batch-7        |DatabaseUtil                  |I| - non-nullable
> > column       [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > |DatabaseUtil                  |I| - default fetchsize        [0]
> > 2017-07-17
> > 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| -
> > named parameters         [ SKIPPED ] 2017-07-17 15:05:27,536
> |OFBiz-batch-7
> > |DatabaseUtil                  |I| Getting Table Info From Database
> > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - max table name length     [63] 2017-07-17 15:05:27,544
> |OFBiz-batch-8
> > |DatabaseUtil                  |I| - max column name length    [63]
> > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - concurrent connections    [8192] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - concurrent
> > statements     [0] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92
> Full
> > [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL
> Grammar
> > Extended [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > |DatabaseUtil
> > |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - outer joins
> > [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - limited outer joins       [true] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - full outer
> joins
> > [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > |I| - group by                  [true]* 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - group by not
> in
> > select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > |DatabaseUtil
> > |I| - column aliasing           [true] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - order by not
> in
> > select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > |DatabaseUtil
> > |I| - alter table add column    [true]* 2017-07-17 15:05:27,544
> > |OFBiz-batch-8        |DatabaseUtil                  |I| - non-nullable
> > column       [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > |DatabaseUtil                  |I| - default fetchsize        [0]
> > 2017-07-17
> > 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| -
> > named parameters         [ SKIPPED ] 2017-07-17 15:05:27,544
> |OFBiz-batch-8
> > |DatabaseUtil                  |I| Getting Table Info From Database
> > 2017-07-17 15:05:27,675 |OFBiz-batch-8        |DatabaseUtil
> > |I| Getting Column Info From Database 2017-07-17 15:05:27,706
> > |OFBiz-batch-7
> > |DatabaseUtil                  |I| Getting Column Info From Database
> > 2017-07-17 15:05:27,759 |OFBiz-batch-7        |DatabaseUtil
> > |I| Reviewed 8 primary key fields from database. 2017-07-17 15:05:28,077
> > |OFBiz-batch-8        |DatabaseUtil                  |I| Reviewed 1704
> > primary key fields from database. 2017-07-17 15:05:28,089 |OFBiz-batch-7
> > |ServiceGroupReader            |I| Loaded [1] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/
> groups_test.xml
> > 2017-07-17 15:05:28,090 |http-nio-8445-exec-1 |ServiceGroupReader
> > |I| Loaded [1] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/
> groups_test.xml
> > 2017-07-17 15:05:28,092 |OFBiz-batch-7        |ServiceGroupReader
> > |I| Loaded [4] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> > 2017-07-17 15:05:28,092 |http-nio-8445-exec-1 |ServiceGroupReader
> > |I| Loaded [4] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef/groups.xml
> > 2017-07-17 15:05:28,095 |OFBiz-batch-7        |ServiceGroupReader
> > |I| Loaded [2] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> > servicedef/service_groups.xml
> > 2017-07-17 15:05:28,095 |http-nio-8445-exec-1 |ServiceGroupReader
> > |I| Loaded [2] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> > servicedef/service_groups.xml
> > 2017-07-17 15:05:28,098 |http-nio-8445-exec-1 |ServiceGroupReader
> > |I| Loaded [1] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> > 2017-07-17 15:05:28,098 |OFBiz-batch-7        |ServiceGroupReader
> > |I| Loaded [1] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/product/servicedef/groups.xml
> > 2017-07-17 15:05:28,101 |OFBiz-batch-7        |ServiceGroupReader
> > |I| Loaded [4] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> > servicedef/groups.xml
> > 2017-07-17 15:05:28,101 |http-nio-8445-exec-1 |ServiceGroupReader
> > |I| Loaded [4] Group definitions from
> > file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> > servicedef/groups.xml
> > 2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceDispatcher
> > |I| Registering dispatcher: entity-default#DDS#DDS 2017-07-17
> 15:05:28,215
> > |OFBiz-batch-7        |ServiceContainer              |I| Created new
> > dispatcher: entity-default#DDS#DDS 2017-07-17 15:05:28,215
> > |http-nio-8445-exec-1 |ServiceDispatcher             |I| Registering
> > dispatcher: Humanres#DDS 2017-07-17 15:05:28,215 |http-nio-8445-exec-1
> > |ServiceContainer              |I| Created new dispatcher: Humanres#DDS
> > 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet
> > |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]-
> > total:0.0,since last(Begin):0.0]] 2017-07-17 15:05:28,291
> > |http-nio-8445-exec-1 |UtilProperties                |I| ResourceBundle
> > SecurityextUiLabels (en_US) created in 0.019s with 69 properties
> 2017-07-17
> > 15:05:28,291 |http-nio-8445-exec-1 |LoginServices                 |I|
> > [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
> > 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> > |W| Service Failure [userLogin]: User not found. 2017-07-17 15:05:28,292
> > |http-nio-8445-exec-1 |ServiceDispatcher             |T| Sync service
> > [Humanres#CAD/userLogin] finished in [22] milliseconds I tried to search
> > for
> > it, but not getting anything useful. Can someone please suggest something
> > as
> > i am struck on it now.Regards, Vivek Mishra
> >
> >
> >
> > -----
> > Vivek Mishra
> > --
> > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>
Reply | Threaded
Open this post in threaded view
|

Re: Multitenancy issue OFBiz 16.11

taher
Folks if you can help it would be great, there might be a bug in the
createTenant gradle task (not sure!). The JIRA is below [1]

[1] https://issues.apache.org/jira/browse/OFBIZ-9278

On Sep 14, 2017 8:38 PM, "Deepak Dixit" <[hidden email]>
wrote:

> Hi Vivek,
>
> You can't access org.apache.ofbiz.tenant group from tenant.
>
> Thanks & Regards
> --
> Deepak Dixit
> www.hotwaxsystems.com
> www.hotwax.co
>
> On Thu, Sep 14, 2017 at 6:36 PM, Rishi Solanki <[hidden email]>
> wrote:
>
> > Vivek,
> >
> > Did not tried it myself, but you can try setting mentioned here in
> web.xml
> > and entityengine.xml -
> > https://cwiki.apache.org/confluence/display/OFBIZ/Multitenancy+support
> >
> > Your logs also says, to use correct delegator for the tenant group.
> > ====
> >  Delegator "default#DDS" NOT initializing
> > helper for entity group "org.apache.ofbiz.tenant" because the group is
> not
> > associated to this delegator.
> > ====
> >
> > HTH!
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Tue, Sep 12, 2017 at 11:58 PM, vivek.mi <[hidden email]> wrote:
> >
> > > Hello All, I have created two tenants in the application.1. Tenant ID:
> > > CAD2.
> > > Tenant ID: DDSWhen i am logging in, the first tenant is logging in
> > > successfully, but second one is not successful. Can't access entity of
> > > entityGroup = org.apache.ofbiz.tenant using tenant delegator
> default#DDS,
> > > use base delegator instead2017-07-17 15:05:27,143 |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 15:05:27,143 |OFBiz-batch-7
> > > |GenericDelegator              |I| Delegator "default#DDS" initializing
> > > helper "localpostolap" for entity group "org.apache.ofbiz.olap".
> > 2017-07-17
> > > 15:05:27,143 |OFBiz-batch-7        |GenericDelegator              |I|
> > Doing
> > > database check as requested in entityengine.xml with addMissing=true
> > > 2017-07-17 15:05:27,144 |OFBiz-batch-8        |GenericDelegator
> > > |I| Delegator "default#DDS" initializing helper "localpostgres" for
> > entity
> > > group "org.apache.ofbiz". 2017-07-17 15:05:27,144 |OFBiz-batch-8
> > > |GenericDelegator              |I| Doing database check as requested in
> > > entityengine.xml with addMissing=true 2017-07-17 15:05:27,266
> > > |OFBiz-batch-7
> > > |DatabaseUtil                  |I| Database Product Name is PostgreSQL
> > > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > > |I| Database Product Version is 9.3.17 2017-07-17 15:05:27,266
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| Database
> Driver
> > > Name is PostgreSQL Native Driver 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > > |DatabaseUtil                  |I| Database Driver Version is
> PostgreSQL
> > > 9.4
> > > JDBC4.1 (build 1201) 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > > |DatabaseUtil                  |I| Database Driver JDBC Version is 4.0
> > > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > > |I| Database Setting/Support Information (those with a * should be
> true):
> > > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - supports transactions     [true]* 2017-07-17 15:05:27,266
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation
> None
> > > [false] 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - isolation ReadCommitted   [true] 2017-07-17 15:05:27,266
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - isolation
> > > ReadUncommitted [true] 2017-07-17 15:05:27,266 |OFBiz-batch-7
> > > |DatabaseUtil                  |I| - isolation RepeatableRead  [true]
> > > 2017-07-17 15:05:27,266 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - isolation Serializable    [true] 2017-07-17 15:05:27,267
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - forward only
> > > type
> > > [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,267
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - scroll
> > > insensitive type   [true] 2017-07-17 15:05:27,267 |OFBiz-batch-7
> > > |DatabaseUtil                  |I| - is case sensitive         [false]
> > > 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - stores LowerCase          [true] 2017-07-17 15:05:27,267
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - stores
> > MixedCase
> > > [false] 2017-07-17 15:05:27,267 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - stores UpperCase          [false] 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| Database
> Product
> > > Name is PostgreSQL 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| Database Product Version is 9.3.17
> > > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| Database Driver Name is PostgreSQL Native Driver 2017-07-17
> > > 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| Database
> Driver
> > > Version is PostgreSQL 9.4 JDBC4.1 (build 1201) 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| Database
> Driver
> > > JDBC Version is 4.0 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| Database Setting/Support Information
> > > (those with a * should be true): 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - supports transactions     [true]*
> > > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - isolation None            [false] 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> > > ReadCommitted   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - isolation ReadUncommitted [true]
> > > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - isolation RepeatableRead  [true] 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - isolation
> > > Serializable    [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - forward only type         [true]
> > > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - scroll sensitive type     [false] 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - scroll
> > > insensitive type   [true] 2017-07-17 15:05:27,321 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - is case sensitive         [false]
> > > 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - stores LowerCase          [true] 2017-07-17 15:05:27,321
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - stores
> > MixedCase
> > > [false] 2017-07-17 15:05:27,321 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - stores UpperCase          [false] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - max table
> name
> > > length     [63] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > |DatabaseUtil
> > > |I| - max column name length    [63] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7
> > > |DatabaseUtil                  |I| - concurrent connections    [8192]
> > > 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - concurrent statements     [0] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7
> > > |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> > > 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - ANSI SQL92
> > Full
> > > [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - ODBC SQL
> > Grammar
> > > Extended [false] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > > |DatabaseUtil
> > > |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - outer joins
> > > [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - limited outer joins       [true] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - full outer
> > joins
> > > [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil
> > > |I| - group by                  [true]* 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - group by not
> > in
> > > select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > > |DatabaseUtil
> > > |I| - column aliasing           [true] 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - order by not
> > in
> > > select    [true] 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > > |DatabaseUtil
> > > |I| - alter table add column    [true]* 2017-07-17 15:05:27,536
> > > |OFBiz-batch-7        |DatabaseUtil                  |I| - non-nullable
> > > column       [true]* 2017-07-17 15:05:27,536 |OFBiz-batch-7
> > > |DatabaseUtil                  |I| - default fetchsize        [0]
> > > 2017-07-17
> > > 15:05:27,536 |OFBiz-batch-7        |DatabaseUtil                  |I| -
> > > named parameters         [ SKIPPED ] 2017-07-17 15:05:27,536
> > |OFBiz-batch-7
> > > |DatabaseUtil                  |I| Getting Table Info From Database
> > > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - max table name length     [63] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - max column name length    [63]
> > > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - concurrent connections    [8192] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - concurrent
> > > statements     [0] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - ANSI SQL92 Entry          [true]
> > > 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - ANSI SQL92 Intermediate   [false] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - ANSI SQL92
> > Full
> > > [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - ODBC SQL Grammar Core     [false] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - ODBC SQL
> > Grammar
> > > Extended [false] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > > |DatabaseUtil
> > > |I| - ODBC SQL Grammar Minimum  [true] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - outer joins
> > > [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - limited outer joins       [true] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - full outer
> > joins
> > > [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil
> > > |I| - group by                  [true]* 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - group by not
> > in
> > > select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > > |DatabaseUtil
> > > |I| - column aliasing           [true] 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - order by not
> > in
> > > select    [true] 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > > |DatabaseUtil
> > > |I| - alter table add column    [true]* 2017-07-17 15:05:27,544
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| - non-nullable
> > > column       [true]* 2017-07-17 15:05:27,544 |OFBiz-batch-8
> > > |DatabaseUtil                  |I| - default fetchsize        [0]
> > > 2017-07-17
> > > 15:05:27,544 |OFBiz-batch-8        |DatabaseUtil                  |I| -
> > > named parameters         [ SKIPPED ] 2017-07-17 15:05:27,544
> > |OFBiz-batch-8
> > > |DatabaseUtil                  |I| Getting Table Info From Database
> > > 2017-07-17 15:05:27,675 |OFBiz-batch-8        |DatabaseUtil
> > > |I| Getting Column Info From Database 2017-07-17 15:05:27,706
> > > |OFBiz-batch-7
> > > |DatabaseUtil                  |I| Getting Column Info From Database
> > > 2017-07-17 15:05:27,759 |OFBiz-batch-7        |DatabaseUtil
> > > |I| Reviewed 8 primary key fields from database. 2017-07-17
> 15:05:28,077
> > > |OFBiz-batch-8        |DatabaseUtil                  |I| Reviewed 1704
> > > primary key fields from database. 2017-07-17 15:05:28,089
> |OFBiz-batch-7
> > > |ServiceGroupReader            |I| Loaded [1] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/
> > groups_test.xml
> > > 2017-07-17 15:05:28,090 |http-nio-8445-exec-1 |ServiceGroupReader
> > > |I| Loaded [1] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/framework/common/servicedef/
> > groups_test.xml
> > > 2017-07-17 15:05:28,092 |OFBiz-batch-7        |ServiceGroupReader
> > > |I| Loaded [4] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef
> /groups.xml
> > > 2017-07-17 15:05:28,092 |http-nio-8445-exec-1 |ServiceGroupReader
> > > |I| Loaded [4] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/framework/entityext/servicedef
> /groups.xml
> > > 2017-07-17 15:05:28,095 |OFBiz-batch-7        |ServiceGroupReader
> > > |I| Loaded [2] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> > > servicedef/service_groups.xml
> > > 2017-07-17 15:05:28,095 |http-nio-8445-exec-1 |ServiceGroupReader
> > > |I| Loaded [2] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/workeffort/
> > > servicedef/service_groups.xml
> > > 2017-07-17 15:05:28,098 |http-nio-8445-exec-1 |ServiceGroupReader
> > > |I| Loaded [1] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/product/servicede
> f/groups.xml
> > > 2017-07-17 15:05:28,098 |OFBiz-batch-7        |ServiceGroupReader
> > > |I| Loaded [1] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/product/servicede
> f/groups.xml
> > > 2017-07-17 15:05:28,101 |OFBiz-batch-7        |ServiceGroupReader
> > > |I| Loaded [4] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> > > servicedef/groups.xml
> > > 2017-07-17 15:05:28,101 |http-nio-8445-exec-1 |ServiceGroupReader
> > > |I| Loaded [4] Group definitions from
> > > file:/home/nicsi/Ofbiz_tenant/applications/accounting/
> > > servicedef/groups.xml
> > > 2017-07-17 15:05:28,215 |OFBiz-batch-7        |ServiceDispatcher
> > > |I| Registering dispatcher: entity-default#DDS#DDS 2017-07-17
> > 15:05:28,215
> > > |OFBiz-batch-7        |ServiceContainer              |I| Created new
> > > dispatcher: entity-default#DDS#DDS 2017-07-17 15:05:28,215
> > > |http-nio-8445-exec-1 |ServiceDispatcher             |I| Registering
> > > dispatcher: Humanres#DDS 2017-07-17 15:05:28,215 |http-nio-8445-exec-1
> > > |ServiceContainer              |I| Created new dispatcher: Humanres#DDS
> > > 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet
> > > |T| [[[login(Domain:https://localhost)] Request Begun,
> encoding=[UTF-8]-
> > > total:0.0,since last(Begin):0.0]] 2017-07-17 15:05:28,291
> > > |http-nio-8445-exec-1 |UtilProperties                |I| ResourceBundle
> > > SecurityextUiLabels (en_US) created in 0.019s with 69 properties
> > 2017-07-17
> > > 15:05:28,291 |http-nio-8445-exec-1 |LoginServices                 |I|
> > > [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
> > > 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> > > |W| Service Failure [userLogin]: User not found. 2017-07-17
> 15:05:28,292
> > > |http-nio-8445-exec-1 |ServiceDispatcher             |T| Sync service
> > > [Humanres#CAD/userLogin] finished in [22] milliseconds I tried to
> search
> > > for
> > > it, but not getting anything useful. Can someone please suggest
> something
> > > as
> > > i am struck on it now.Regards, Vivek Mishra
> > >
> > >
> > >
> > > -----
> > > Vivek Mishra
> > > --
> > > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Multitenancy issue OFBiz 16.11

vivek.mi
In reply to this post by Deepak Dixit-3
Thanks Deepak.

Actually it's true and the tenant is not connected to that datasource
anyway.
If you see log below, when i am logging in from DDS tenant, delegator value
is fine in LoginServices before userlogin method. But after that on runtime
the value is changing to Humanres#CAD, which is the previous delegator.

And if i restart the application, login now from DDS tenant is successful,
but again user with tenant Id CAD is not able to login.

The same thing is working fine in 13.07.

Created new dispatcher: Humanres#DDS

> 2017-07-17 15:05:28,215 |http-nio-8445-exec-1 |ControlServlet
> |T| [[[login(Domain:https://localhost)] Request Begun, encoding=[UTF-8]-
> total:0.0,since last(Begin):0.0]] 2017-07-17 15:05:28,291
> |http-nio-8445-exec-1 |UtilProperties                |I| ResourceBundle
> SecurityextUiLabels (en_US) created in 0.019s with 69 properties
> 2017-07-17
> 15:05:28,291 |http-nio-8445-exec-1 |LoginServices                 |I|
> [LoginServices.userLogin] Invalid User : 'DDS-admin'; User not found.
> 2017-07-17 15:05:28,292 |http-nio-8445-exec-1 |ServiceDispatcher
> |W| Service Failure [userLogin]: User not found. 2017-07-17 15:05:28,292
> |http-nio-8445-exec-1 |ServiceDispatcher             |T| Sync service
> [Humanres#CAD/userLogin] finished in [22] milliseconds





-----
Vivek Mishra
--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Vivek Mishra