#idempiere IRC log for Wednesday, 2017-03-01

*** CarlosRuiz has quit IRC00:48
*** a42niem has joined #idempiere04:55
Not-5196[iDempiere4.1Daily] jenkins built #43 completed (success) http://ci.idempiere.org/job/iDempiere4.1Daily/43/05:44
*** CarlosRuiz has joined #idempiere07:11
*** jdpaniagua has joined #idempiere07:56
*** andhika has joined #idempiere07:58
andhikahello07:58
andhikakrik krik krik07:58
*** andhika has quit IRC08:03
Not-5196[IDEMPIERE] freepath created IDEMPIERE-3307 New extension point to allow Role based data access rules08:21
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-330708:21
Not-5196[IDEMPIERE] freepath created IDEMPIERE-3308 Extension point to allow ui behavior customization08:29
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-330808:29
*** a42niem has quit IRC08:49
Not-5196[IDEMPIERE] norbert.bede created IDEMPIERE-3309 Info Window C_Bpartner_Location.C_Location_ID sIdentifier='Y' break sorting10:23
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-330910:23
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3283 status set to "Closed"10:26
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-328310:26
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3282 status set to "Closed"10:26
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-328210:26
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3147 status set to "Closed"10:26
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-314710:26
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3277 status set to "Closed"10:26
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-327710:26
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3280 status set to "Closed"10:26
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-328010:26
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3279 status set to "Closed"10:27
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-327910:27
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3220 status set to "Closed"10:27
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-322010:27
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3285 status set to "Closed"10:27
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-328510:27
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-1367 status set to "Closed"10:27
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-136710:27
Not-5196[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3039 status set to "Closed"10:27
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-303910:27
Not-5196[IDEMPIERE] norbert.bede updated IDEMPIERE-3309 description set to "*issue*: when change c_bpartner_location.c_location_id as identifier, then sorting doesn't works by Partner Location. Steps to reproduce: 1. login as system to client system 2. open table c_bpartner_location, open column, c_location_id 3. change c_location_id column from isIdentifier='N' to isIdentifier='Y' 4. new sales order zoom into business10:28
Not-5196partners, search all partners, order by Partner Location>>BUG (see log) *REMARK*: we also found in database some Bpartners without Locations... error log: {code:java} 11:16:28.353===========> InfoBPartnerWindow.readLine: SELECT bp.C_BPartner_ID, bp.Value AS Value, bp.Name AS Name, NVL(c.Name,'-1'),c.AD_User_ID, bp.SO_CreditLimit-bp.SO_CreditUsed AS SO_CreditAvailable, bp.SO_CreditUsed AS SO_CreditUsed, c.Phone AS10:28
Not-5196Phone, a.Postal AS Postal, a.City AS City, bp.TotalOpenBalance AS TotalOpenBalance, bp.ActualLifetimeValue AS Revenue, a.Address1 AS Address1, l.IsShipTo AS IsShipTo, l.IsBillTo AS IsBillTo, NVL(l.Name,'-1') ||'_'|| NVL(CAST (l.C_Location_ID AS Text),'-1'),l.C_BPartner_Location_ID FROM C_BPartner bp LEFT OUTER JOIN C_BPartner_Location l ON (bp.C_BPartner_ID=l.C_BPartner_ID AND l.IsActive='Y') LEFT OUTER JOIN AD_User10:28
Not-5196c ON (bp.C_BPartner_ID=c.C_BPartner_ID AND (c.C_BPartner_Location_ID IS NULL OR c.C_BPartner_Location_ID=l.C_BPartner_Location_ID) AND c.IsActive='Y') LEFT OUTER JOIN C_Location a ON (l.C_Location_ID=a.C_Location_ID) WHERE bp.IsActive='Y' AND bp.IsSummary='N' AND bp.IsActive='Y' AND bp.IsCustomer = ? AND bp.AD_Client_ID IN(0,11) AND bp.AD_Org_ID IN(0,11,12,50000,50002,50001,50004,50006,50005,50007) AND10:28
Not-5196(bp.C_BPartner_ID IS NULL OR bp.C_BPartner_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 291 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (l.C_BPartner_Location_ID IS NULL OR l.C_BPartner_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 293 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (c.AD_User_ID IS NULL OR c.AD_User_ID NOT IN ( SELECT Record_ID FROM10:28
Not-5196AD_Private_Access WHERE AD_Table_ID = 114 AND AD_User_ID <> 100 AND IsActive = 'Y' )) AND (a.C_Location_ID IS NULL OR a.C_Location_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 162 AND AD_User_ID <> 100 AND IsActive = 'Y' )) ORDER BY Text),'-1') [248] org.postgresql.util.PSQLException: ERROR: syntax error at or near ")" Position: 1721; State=42601; ErrorCode=0 at10:28
Not-5196org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) at10:28
Not-5196org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353) at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source) at10:29
Not-5196sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128) at com.sun.proxy.$Proxy4.executeQuery(Unknown Source) at org.adempiere.webui.panel.InfoPanel.readLine(InfoPanel.java:855) at org.adempiere.webui.panel.InfoPanel.renderItems(InfoPanel.java:760) at10:29
Not-5196org.adempiere.webui.panel.InfoPanel.sort(InfoPanel.java:2177) at org.adempiere.webui.component.ListModelTable.sort(ListModelTable.java:337) at org.zkoss.zul.Listheader.sortListModel(Listheader.java:589) at org.zkoss.zul.Listheader.doSort(Listheader.java:434) at org.zkoss.zul.Listheader.sort(Listheader.java:412) at org.zkoss.zul.Listheader.onSort(Listheader.java:625) {code} "10:29
Not-5196[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-330910:29
*** futurebob has joined #idempiere13:10
*** aguerra has joined #idempiere13:11
*** CarlosRuiz has quit IRC13:24
*** AlbinGMB has joined #idempiere14:05
*** futurebob has quit IRC15:16
*** AlbinGMB has quit IRC15:54
*** CarlosRuiz has joined #idempiere18:50
*** ram___ has joined #idempiere19:26
*** ram___ has quit IRC20:37
*** CarlosRuiz has quit IRC23:42

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!