Re:Re:Articulos en Factura y Pedido

Inicio Foros Foro principal Ayuda Articulos en Factura y Pedido Re:Re:Articulos en Factura y Pedido

#33279
Dario ParenteDario Parente
Miembro

Un error que me da y siempre es el mismo entrando en la pantalla de busqueda de articulo y refrescandola lo cual igual no me muestra nada.
Al volver de esa pantalla y ver los errores en herramientas-preferencia me pone esto.



> Msg.getMsg: NOT found: OXPSYS [11]


> Msg.getMsg: NOT found: OXPSYS [11]


> Msg.getMsg: NOT found: OXPSYS [11]


> Msg.getMsg: NOT found: OXPSYS [11]
===========> InfoProduct.run: SELECT DISTINCT(p.M_Product_ID), p.Value, p.Name, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHand, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product_ID,?,0) AS QtyOrdered FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive=’Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) WHERE p.IsActive=’Y’ AND p.IsSummary=’N’ AND pr.M_PriceList_Version_ID=? AND p.AD_Client_ID IN(0,1010016) AND p.AD_Org_ID IN(0,1010053) ORDER BY QtyAvailable ASC [410]
org.postgresql.util.PSQLException: No se ha especificado un valor para el parámetro 1.; State=22023; ErrorCode=0

at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:134)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:179)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy1.executeQuery(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
at org.openXpertya.apps.search.Info$Worker.run(Info.java:1269)

Servidor = Server1 : 1099 (15-03-2010)
Tunnel=false, Objects=false, Process=false
Base de datos = server1 : 5432 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Compras