Oct 22, 2016 5:33:08 PM org.adempiere.webui.info.InfoWindow prepareTable
SEVERE: Failed to parsed sql. sql=SELECT mrp.PP_MRP_ID, mrp.M_Product_ID AS M_Product_ID, mrp.S_Resource_ID AS S_Resource_ID, pp.M_Warehouse_ID AS M_Warehouse_ID, mrp.DatePromised AS DatePromised, mrp.Qty AS Qty, pp.SafetyStock AS SafetyStock, bomQtyOnHand(p.M_Product_ID,@1113|M_Warehouse_ID@,0) AS QtyOnHand, mrp.typemrp AS TypeMRP, mrp.OrderType AS OrderType, mrp.DocStatus AS DocStatus, mrp.DateStartSchedule AS DateStartSchedule, documentno(mrp.PP_MRP_ID) AS DOCUMENTNO, mrp.DateFinishSchedule AS DateFinishSchedule, mrp.Planner_ID AS Planner_ID, mrp.Priority AS PlannedQty FROM PP_MRP mrp JOIN M_Product p ON (mrp.M_Product_ID=p.M_Product_ID) JOIN pp_product_planning pp
ON (pp.m_product_id = mrp.m_product_id AND mrp.m_warehouse_id = pp.m_warehouse_id) WHERE
Oct 22, 2016 5:33:09 PM org.compiere.util.Msg translate
WARNING: NOT found: 1113|M_Warehouse_ID
Oct 22, 2016 5:33:10 PM org.adempiere.webui.info.InfoWindow testCount
SEVERE: SELECT COUNT(*) FROM ( SELECT mrp.PP_MRP_ID, mrp.M_Product_ID AS M_Product_ID, mrp.S_Resource_ID AS S_Resource_ID, pp.M_Warehouse_ID AS M_Warehouse_ID, mrp.DatePromised AS DatePromised, mrp.Qty AS Qty, pp.SafetyStock AS SafetyStock, bomQtyOnHand(p.M_Product_ID,1113|M_Warehouse_ID,0) AS QtyOnHand, mrp.typemrp AS TypeMRP, mrp.OrderType AS OrderType, mrp.DocStatus AS DocStatus, mrp.DateStartSchedule AS DateStartSchedule, documentno(mrp.PP_MRP_ID) AS DOCUMENTNO, mrp.DateFinishSchedule AS DateFinishSchedule, mrp.Planner_ID AS Planner_ID, mrp.Priority AS PlannedQty FROM PP_MRP mrp JOIN M_Product p ON (mrp.M_Product_ID=p.M_Product_ID) JOIN pp_product_planning pp
ON (pp.m_product_id = mrp.m_product_id AND mrp.m_warehouse_id = pp.m_warehouse_id) WHERE mrp.IsActive='Y' AND mrp.S_Resource_ID = ? AND pp.M_Warehouse_ID = ? AND mrp.AD_Client_ID IN(0,11) AND mrp.AD_Org_ID IN(0,11,12,50000,50002,50001,50004,50006,50005,50007) AND (mrp.PP_MRP_ID IS NULL OR mrp.PP_MRP_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 53043 AND AD_User_ID <> 101 AND IsActive = 'Y' )) AND (p.M_Product_ID IS NULL OR p.M_Product_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 208 AND AD_User_ID <> 101 AND IsActive = 'Y' )) AND (pp.PP_Product_Planning_ID IS NULL OR pp.PP_Product_Planning_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 0 AND AD_User_ID <> 101 AND IsActive = 'Y' )) ) a
org.postgresql.util.PSQLException: ERROR: column reference "m_warehouse_id" is ambiguous
Position: 268
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:380)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
at sun.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.info.InfoWindow.testCount(InfoWindow.java:1718)
at org.adempiere.webui.info.InfoWindow.testCount(InfoWindow.java:1682)
at org.adempiere.webui.panel.InfoPanel.executeQuery(InfoPanel.java:539)
at org.adempiere.webui.info.InfoWindow.executeQuery(InfoWindow.java:1502)
at org.adempiere.webui.panel.InfoPanel.onQueryCallback(InfoPanel.java:1999)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2757)
at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2685)
at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1765)
at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1550)
at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1260)
at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:611)
at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:485)
at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:494)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)