Not-1c09 | [iDempiere5.1Daily] jenkins built #94 completed (success) http://ci.idempiere.org/job/iDempiere5.1Daily/94/ | 04:40 |
---|---|---|
Not-1c09 | [IDEMPIERE] ekurensky updated IDEMPIERE-3757 status set to "Closed" -resolution set to "Won't Fix" | 04:45 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3757 | 04:45 |
*** a42niem has joined #idempiere | 04:56 | |
*** nmicoud has joined #idempiere | 07:02 | |
*** CarlosRuiz has joined #idempiere | 07:16 | |
Not-1c09 | [IDEMPIERE] nmicoud created IDEMPIERE-3759 Env.getContextAsDate should not log warning | 07:19 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3759 | 07:19 |
Not-1c09 | [IDEMPIERE] nmicoud updated IDEMPIERE-3759 Attachment set to "IDEMPIERE-3759.patch" | 07:21 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3759 | 07:21 |
Not-1c09 | [IDEMPIERE] nmicoud updated IDEMPIERE-3759 status set to "Peer Review Queue" | 07:21 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3759 | 07:21 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3757 status set to "Reopened" -resolution set to "None" | 07:22 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3757 | 07:22 |
Not-1c09 | [IDEMPIERE] nmicoud updated IDEMPIERE-3759 assignee set to "Carlos Ruiz" -labels set to "+Patch" | 07:22 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3759 | 07:22 |
*** a42niem has quit IRC | 07:22 | |
Not-1c09 | [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-5.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ | 07:27 |
Not-1c09 | [iDempiere] nmicoud 71b7a58 - IDEMPIERE-3759 Env.getContextAsDate should not log warning | 07:27 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3759 status set to "Resolved" -assignee set to "Nicolas Micoud" -resolution set to "Fixed" | 07:27 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3759 | 07:27 |
Not-1c09 | [iDempiere5.1] jenkins built #180 completed (success) http://ci.idempiere.org/job/iDempiere5.1/180/ | 07:34 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3757 status set to "Resolved" -assignee set to "Carlos Ruiz" -resolution set to "Fixed" | 07:38 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3757 | 07:38 |
Not-1c09 | [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-5.1 [+2/-0/±0] https://bitbucket.org/idempiere/idempiere/commits/ | 07:38 |
Not-1c09 | [iDempiere] globalqss ef171cb - IDEMPIERE-3757 In form "Menu" for Client can not view and edit Menu tree. (Menu item is created successfully) | 07:38 |
Not-1c09 | [iDempiere5.1] jenkins built #181 completed (success) http://ci.idempiere.org/job/iDempiere5.1/181/ | 08:04 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3734 status set to "Reopened" -resolution set to "None" | 08:32 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3734 | 08:32 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-3760 Implement Virtual UI Column | 09:26 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3760 | 09:26 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 Attachment set to "None" | 11:51 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 11:51 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 Attachment set to "screen_1.PNG" | 11:51 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 11:51 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 Attachment set to "IDEMPIERE-3758.patch" | 11:53 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 11:53 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 description set to "If your role has multiple "AD_Record_Access", in some cases, the query for verification the availability of access is not created correctly. Before create this query, you must sort all available"AD_Record_Access" by AD_Table_ID. UPDATE: I tested in iDempiere 5.1 localhost. Test case: 1) Create user demo\demo 2) Create master role (Access 1, Access 2) | 11:55 |
Not-1c09 | (please take look a screen_1) 3) Create role demo. 3.1) Add role window access to "Warehouse Locators" 3.2) Add this role included role: Access 1, Access 2 4) Login at user demo\demo 5) Open window Warehouse Locators 6) Create debug breakpoint MRole[2077] {code:java} retSQL.append(orderBy); if (log.isLoggable(Level.FINEST)) log.finest(retSQL.toString()); return retSQL.toString(); } // addAccessSQL {code} 7) Click on | 11:55 |
Not-1c09 | button "Refresh" and debug variable "retSQL". My test result: 1) Failed query: {code:java} SELECT M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID | 11:55 |
Not-1c09 | IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID=50002 AND M_Locator_ID IN (50002,50001) AND M_Warehouse_ID IN (50002,50001,50007) AND M_Locator_ID IN (50002,50001,50007,50007) {code} 2) After fix: {code:java} SELECT | 11:55 |
Not-1c09 | M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50001) AND M_Locator.AD_Client_ID IN (0,11) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN (50001,50007)) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT | 11:55 |
Not-1c09 | Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50002,50007,50001,50007) {code} 3) New error. If you take a look on "AND M_Locator_ID IN (50002,50007,50001,50007)". Is error. I created AD_RecordAccess for table M_Locator only for 50001, 50007 (please take look a screen_1). Fix for this error (file patch | 11:55 |
Not-1c09 | is updated): After fix: {code:java} SELECT M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT | 11:55 |
Not-1c09 | Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50001,50007) {code} Best regards Palich.ru Development Team" | 11:55 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 11:55 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 description set to "If your role has multiple "AD_Record_Access", in some cases, the query for verification the availability of access is not created correctly. Before create this query, you must sort all available"AD_Record_Access" by AD_Table_ID. UPDATE: I tested in iDempiere 5.1 localhost. Test case: 1) Create user demo\demo 2) Create master role (Access 1, Access 2) | 11:56 |
Not-1c09 | (please take look a screen_1) 3) Create role demo. 3.1) Add role window access to "Warehouse Locators" 3.2) Add this role included role: Access 1, Access 2 4) Login at user demo\demo 5) Open window Warehouse Locators 6) Create debug breakpoint MRole[2077] {code:java} retSQL.append(orderBy); if (log.isLoggable(Level.FINEST)) log.finest(retSQL.toString()); return retSQL.toString(); } // addAccessSQL {code} 7) Click on | 11:56 |
Not-1c09 | button "Refresh" and debug variable "retSQL". My test result: 1) Failed query: {code:java} SELECT M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID | 11:56 |
Not-1c09 | IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID=50002 AND M_Locator_ID IN (50002,50001) AND M_Warehouse_ID IN (50002,50001,50007) AND M_Locator_ID IN (50002,50001,50007,50007) {code} 2) After fix: {code:java} SELECT | 11:56 |
Not-1c09 | M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50001) AND M_Locator.AD_Client_ID IN (0,11) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN (50001,50007)) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT | 11:56 |
Not-1c09 | Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50002,50007,50001,50007) {code} 3) New error. If you take a look on "AND M_Locator_ID IN (50002,50007,50001,50007)". Is error. I created AD_RecordAccess for table M_Locator only for 50001, 50007 (please take look a screen_1). Fix for this error (file patch | 11:56 |
Not-1c09 | is updated) MRole[2052-2057]: {code:java} if (AD_Table_ID != 0 && AD_Table_ID != m_recordDependentAccess[i].getAD_Table_ID()) { retSQL.append(getDependentAccess(whereColumnName, includes, excludes)); includes.clear(); excludes.clear(); } {code} After fix: {code:java} SELECT | 11:56 |
Not-1c09 | M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE | 11:56 |
Not-1c09 | AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50001,50007) {code} Best regards Palich.ru Development Team" | 11:56 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 11:56 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 description set to "If your role has multiple "AD_Record_Access", in some cases, the query for verification the availability of access is not created correctly. Before create this query, you must sort all available"AD_Record_Access" by AD_Table_ID. UPDATE: I tested in iDempiere 5.1 localhost. Test case: 1) Create user demo\demo 2) Create master role (Access 1, Access 2) | 12:03 |
Not-1c09 | (please take look a screen_1) 3) Create role demo. 3.1) Add role window access to "Warehouse Locators" 3.2) Add this role included role: Access 1, Access 2 4) Login at user demo\demo 5) Open window Warehouse Locators 6) Create debug breakpoint MRole[2077] {code:java} retSQL.append(orderBy); if (log.isLoggable(Level.FINEST)) log.finest(retSQL.toString()); return retSQL.toString(); } // addAccessSQL {code} 7) Click on | 12:03 |
Not-1c09 | button "Refresh" and debug variable "retSQL". My test result: 1) Failed query: {code:java} SELECT M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID | 12:03 |
Not-1c09 | IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID=50002 AND M_Locator_ID IN (50002,50001) AND M_Warehouse_ID IN (50002,50001,50007) AND M_Locator_ID IN (50002,50001,50007,50007) {code} 2) After fix: {code:java} SELECT | 12:03 |
Not-1c09 | M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50001) AND M_Locator.AD_Client_ID IN (0,11) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN (50001,50007)) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT | 12:03 |
Not-1c09 | Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50002,50007,50001,50007) {code} 3) New error. If you take a look on "AND M_Locator_ID IN (50002,50007,50001,50007)". Is error. I created AD_RecordAccess for table M_Locator only for 50001, 50007 (please take look a screen_1). Fix for this error (file patch | 12:03 |
Not-1c09 | is updated) MRole[2052-2057]: {code:java} if (AD_Table_ID != 0 && AD_Table_ID != m_recordDependentAccess[i].getAD_Table_ID()) { retSQL.append(getDependentAccess(whereColumnName, includes, excludes)); includes.clear(); excludes.clear(); } {code} After fix: {code:java} SELECT | 12:03 |
Not-1c09 | M_Locator_ID,M_Locator_UU,AD_Client_ID,AD_Org_ID,M_Warehouse_ID,Value,M_LocatorType_ID,IsActive,PriorityNo,IsDefault,X,Y,Z,Created,CreatedBy,Updated,UpdatedBy FROM M_Locator WHERE (M_Locator.M_Warehouse_ID=50002) AND M_Locator.AD_Client_ID IN (0,11) AND M_Locator.M_Locator_ID IN (50001,50007) AND (M_Locator.M_Locator_ID IS NULL OR M_Locator.M_Locator_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE | 12:03 |
Not-1c09 | AD_Table_ID = 207 AND AD_User_ID <> 1000000 AND IsActive = 'Y' )) AND M_Warehouse_ID IN (50002,50007) AND M_Locator_ID IN (50001,50007) {code} This error can prevent a user from accessing records. We could not understand the reason for the error for a long time. Best regards Palich.ru Development Team" | 12:03 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 12:03 |
Not-1c09 | [IDEMPIERE] Technic updated IDEMPIERE-3758 labels set to "+Patch" | 12:04 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3758 | 12:04 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3753 status set to "Resolved" -resolution set to "Fixed" | 12:45 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3753 | 12:45 |
Not-1c09 | [iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-5.1 [+0/-0/±1] https://bitbucket.org/idempiere/idempiere/commits/ | 12:50 |
Not-1c09 | [iDempiere] globalqss dd7498b - Backout 0feba6d / IDEMPIERE-2048 Simple find doesn't work on tabs with Account columns | 12:50 |
*** nmicoud_ has joined #idempiere | 13:02 | |
Not-1c09 | [iDempiere5.1] jenkins built #182 completed (success) http://ci.idempiere.org/job/iDempiere5.1/182/ | 13:04 |
*** nmicoud has quit IRC | 13:05 | |
*** pietervdr has joined #idempiere | 15:15 | |
*** pietervdr has left #idempiere | 15:16 | |
*** nmicoud_ has quit IRC | 15:18 | |
Not-1c09 | [iDempiere] CarlosRuiz_globalqss pushed 1 commit to default [+0/-0/±3] https://bitbucket.org/idempiere/idempiere/commits/ | 16:31 |
Not-1c09 | [iDempiere] globalqss 96de4df - IDEMPIERE-2310 Improve description field with inline Html editor and html rendering | 16:31 |
Not-1c09 | [IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3018 status set to "Resolved" -resolution set to "Won't Fix" | 16:35 |
Not-1c09 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3018 | 16:35 |
Not-1c09 | [iDempiere-mvn] jenkins built #26 completed (failure) http://ci.idempiere.org/job/iDempiere-mvn/26/ | 16:58 |
*** CarlosRuiz has quit IRC | 17:12 | |
*** a42niem has joined #idempiere | 18:05 | |
*** a42niem has quit IRC | 21:53 | |
*** StygianBlues has joined #idempiere | 23:40 | |
*** StygianBlues has quit IRC | 23:45 | |
*** StygianBlues has joined #idempiere | 23:47 | |
*** StygianBlues has quit IRC | 23:51 | |
*** StygianBlues has joined #idempiere | 23:52 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!