Estimado, te paso el error que genera cuando abro la ventana de “Ver informacion de articulo”
——————————-
10:56:29.425 OpenXpertya.startup: Libertya (r) Versión 19.07_31-07-2019 – Software Libre de Gestión- (c) 2019 DISYTEL; Implementación: Versión 19.07 20210611-1253 – ${env.CONSULTORA_OXP} [1]
10:56:29.425 OpenXpertya.startup: XP – Java HotSpot(TM) 64-Bit Server VM 25.291-b10 – Windows 10 10.0 [1]
———–> CConnection.setAppsServerInfo: jnp://localhost:1099
– javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
– {java.naming.provider.url=jnp://localhost:1099, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, jnp.discoveryTimeout=5000, jnp.timeout=5000, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, jnp.sotimeout=5000} [1]
===========> InfoProductAttribute.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, pr.M_PriceList_Version_ID 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_ProductUpc pu ON (p.M_Product_ID=pu.M_Product_ID AND pu.IsActive=’Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) LEFT OUTER JOIN M_Product_Upc_Instance pui ON (p.M_Product_ID=pui.M_Product_ID AND pui.IsActive=’Y’) 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 Value ASC [39]
org.postgresql.util.PSQLException: ERROR: no existe la función bomqtyavailable(integer, character varying, integer)
Hint: Ninguna función coincide en el nombre y tipos de argumentos. Puede ser necesario agregar conversión explícita de tipos.
Position: 51; State=42883; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:162)
at org.openXpertya.apps.search.Info$Worker.run(Info.java:1517)
