[Walter Hernan Minha]

No se encuentran los articulos en la linea de cualquier documento.
Este error se produce en la base y la compañia que viene por default. Estoy utilizando todos los productos estandares que trae el sistema; sin hacer modificacion alguna.
No puedo seguir avanzando porque me trabo al llegar a la linea de detalle de cualquier documento. Ya sea al generar un Pedido, una factura o una Entrega/ Recibo.
Muchas gracias

---

---

> 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 [227]
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.GeneratedMethodAccessor6.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)
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 = Servidor_Aplicaciones : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = adempiere-desktop : 5432 / libertya_AR
Esquema = libertya
Usuario = AdminLibertya
Perfil = Compras
Compañía = Libertya
Organización = Default
Fecha = 2010-10-08 00:00:00
Impresora = HP-LaserJet-P2015-Series
OXPHome =
Language=[Español
(Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY
,DecimalPoint=false]
MClient[1010016-Libertya]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Server VM 14.0-b16
Linux 2.6.27-15-generic unknown
=== Environment === -2002318939
Libertya (r) Versión 10.03_15-03-2010 – Software Libre de
Gestión- (c) 2009 DISYTEL; Implementación: Libertya
20100315-1136 – SERVICIOS_DIGITALES
adempiere-desktop/127.0.0.1
CConnection[name=Servidor_Aplicaciones{adempiere-desktop-libertya_AR-libertya}
,AppsHost=Servidor_Aplicaciones,AppsPort=1099,RMIoverHTTP=false
,type=PostgreSQL,DBhost=adempiere-desktop,DBport=5432,DBname=libertya_AR
,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
Database=PostgreSQL – 8.3.9 – Driver =PostgreSQL Native
Driver – PostgreSQL 8.1 JDBC3 with SSL (build 405) – via
DataSource
DB_PostgreSQL[jdbc:postgresql://adempiere-desktop:5432/libertya_AR?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true

=== Context ==#AD_Client_ID == 1010016
#AD_Client_Name == Libertya
#AD_Language == es_AR
#AD_Org_ID == 1010053
#AD_Org_Name == Default
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010075
#AD_Role_Name == Compras
#AD_Session_ID == 1027096
#AD_User_ID == 1010717
#AD_User_Name == AdminLibertya
#C_BP_Group_ID == 1010045
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_Letra_Comprobante_ID == 1010010
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#Date == 2010-10-08 00:00:00
#GL_Category_ID == 1010098
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010601
#M_Product_Category_ID == 1010146
#M_Warehouse_ID == 1010048
#Printer == HP-LaserJet-P2015-Series
#SalesRep_ID == 1010717
#ShowAcct == Y
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#User_Level == CO
#User_Org == 0,1010053
#YYYY == Y
$C_AcctSchema_ID == 1010016
$C_Currency_ID == 118
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$Element_SR == Y
$HasAlias == Y
0|WindowName == Menú
1110|Find_Table_ID == 1000117
1113|1113|AD_User_ID == 1010721
1113|1113|C_BPartner_ID == 1012149
1113|1113|C_BPartner_Location_ID == 1012162
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_Product_ID == 0
7|0|AD_Tab_ID == 294
7|0|AD_Table_ID == 259
7|0|AccessLevel == 1
7|0|Name == Pedido a Proveedor
7|0|SQL == SELECT
C_Repair_Order_ID,C_CashLine_ID,C_Payment_ID,Acceptance,Processing
,IsSOTrx,C_Order_ID,IsInvoiced,DatePrinted,IsCreditApproved,IsSelfService
,DateAcct,Processed,IsDelivered,DeliveryRule,SendEMail,IsTransferred
,IsActive,repair_priority,IsPrinted,IsSelected,repair_state,InvoiceRule
,Pay_Location_ID,Pay_BPartner_ID,Bill_BPartner_ID,Bill_Location_ID
,Ref_Order_ID,program_invoice,Bill_User_ID,IsApproved,IsTaxIncluded
,AD_Client_ID,AD_Org_ID,DocumentNo,POReference,Description,C_DocTypeTarget_ID
,DateOrdered,DatePromised,dateprod,daterealprod,C_BPartner_ID
,CreateVendorProductLines,C_BPartner_Location_ID,AD_User_ID,M_Warehouse_ID
,IsDropShip,DeliveryViaRule,M_Shipper_ID,FreightCostRule,FreightAmt
,PriorityRule,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID
,SalesRep_ID,IsDiscountPrinted,C_Charge_ID,ChargeAmt,PaymentRule
,C_PaymentTerm_ID,C_Project_ID,C_Activity_ID,C_Campaign_ID,AD_OrgTrx_ID
,User1_ID,User2_ID,DocStatus,C_DocType_ID,TotalLines,GrandTotal
,CopyFrom,DocAction,Posted,Created,CreatedBy,Updated,UpdatedBy
FROM C_Order WHERE IsSOTrx=’N’ AND (Processed=’N’ OR
Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as
interval))) AND C_Order.AD_Client_ID IN(0,1010016) AND
C_Order.AD_Org_ID IN(0,1010053) ORDER BY DocumentNo DESC
7|1|AD_Tab_ID == 293
7|1|AD_Table_ID == 260
7|1|AccessLevel == 1
7|1|LinkColumnName == C_Order_ID
7|1|Name == Línea Ped. Proveedor
7|1|SQL == SELECT
OpenMatrix,M_Warehouse_ID,S_ResourceAssignment_ID,QtyDelivered
,QtyInvoiced,C_BPartner_Location_ID,M_Shipper_ID,DateInvoiced
,DateDelivered,DatePromised,C_OrderLine_ID,C_Currency_ID,Line
,PriceLimit,Processed,QtyReserved,Ref_OrderLine_ID,IsDescription
,IsActive,AD_Client_ID,AD_Org_ID,C_Order_ID,C_BPartner_ID,DateOrdered
,M_Product_ID,M_AttributeSetInstance_ID,C_Charge_ID,QtyEntered
,C_UOM_ID,PriceActual,QtyOrdered,PriceEntered,Description,PriceList
,FreightAmt,C_Tax_ID,Discount,LineNetAmt,C_Project_ID,Created
,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE
C_Order_ID=1013973 AND C_OrderLine.AD_Client_ID
IN(0,1010016) AND C_OrderLine.AD_Org_ID IN(0,1010053) ORDER
BY Line
7|2|AD_Tab_ID == 692
7|2|AD_Table_ID == 473
7|2|AccessLevel == 3
7|2|LinkColumnName == C_OrderLine_ID
7|2|Name == Correspondencias
7|AD_Client_ID == 1010016
7|AD_Org_ID == 1010053
7|AD_User_ID == 1010721
7|Acceptance == 0
7|AutoCommit == Y
7|BaseTable_ID == 259
7|Bill_BPartner_ID == 1012149
7|Bill_Location_ID == 1012162
7|Bill_User_ID == 1010721
7|C_BPartner_ID == 1012149
7|C_ConversionType_ID == 114
7|C_Currency_ID == 118
7|C_DocTypeTarget_ID == 1010524
7|C_DocType_ID == 0
7|C_Order_ID == 1013973
7|C_PaymentTerm_ID == 1010083
7|C_Tax_ID == 1010084
7|ChargeAmt == 0.00
7|CopyFrom == N
7|CreateVendorProductLines == N
7|DateAcct == 2010-10-08 00:00:00
7|DateOrdered == 2010-10-08 00:00:00
7|DatePromised == 2010-10-08 00:00:00
7|DeliveryRule == A
7|DeliveryViaRule == P
7|Discount == 0
7|DocAction == CO
7|DocStatus == DR
7|DocTypeKey == POO
7|DocumentNo == 800003
7|FreightAmt == 0
7|FreightCostRule == I
7|GrandTotal == 0.00
7|InvoiceRule == D
7|IsActive == Y
7|IsApproved == N
7|IsCreditApproved == N
7|IsDelivered == N
7|IsDescription == N
7|IsDiscountPrinted == N
7|IsDropShip == N
7|IsInvoiced == N
7|IsPrinted == N
7|IsSOTrx == N
7|IsSelected == N
7|IsSelfService == N
7|IsTaxIncluded == N
7|IsTransferred == N
7|Line == 10
7|LineNetAmt == 0
7|M_PriceList_ID == 1010596
7|M_PriceList_Version_ID == 1010525
7|M_Warehouse_ID == 1010048
7|OpenMatrix == N
7|PaymentRule == P
7|Posted == N
7|PriceActual == 0
7|PriceEntered == 0
7|PriceLimit == 0
7|PriceList == 0
7|PriorityRule == 5
7|Processed == N
7|Processing == N
7|QtyDelivered == 0
7|QtyEntered == 1
7|QtyInvoiced == 0
7|QtyOrdered == 1
7|QtyReserved == 0
7|SalesRep_ID == 1010717
7|SendEMail == N
7|TotalLines == 0.00
7|WindowName == Pedido a Proveedor
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P143|C_BPartner_ID == 1012142
P189|DataType == S
P|AD_FTDoc == 1002145
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|LOCAL_AR == Y
java.naming.provider.url =jnp://Servidor_Aplicaciones:1099

=== System ==OXP_HOMEfile.encoding=UTF-8
file.encoding.pkg=sun.io
file.separator=/
java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
java.awt.printerjob=sun.print.PSPrinterJob
java.class.path=lib/OXP.jar:lib/OXPXLib.jar:lib/CMPCS.jar:lib/JasperReports.jar:
java.class.version=50.0
java.endorsed.dirs=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/endorsed
java.ext.dirs=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/ext:/usr/java/packages/lib/ext

java.home=/usr/lib/jvm/java-6-sun-1.6.0.14/jre
java.io.tmpdir=/tmp
java.library.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386/server:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib

java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_14-b08
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.6
java.vendor=Sun Microsystems Inc.
java.vendor.url=http://java.sun.com/
java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.6.0_14
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) Server VM
java.vm.specification.name=Java Virtual Machine
Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=14.0-b16
line.separator
os.arch=i386
os.name=Linux
os.version=2.6.27-15-generic
path.separator=:
sun.arch.data.model=32
sun.boot.class.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/resources.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/rt.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/jsse.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/jce.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/charsets.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/classes

sun.boot.library.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386
sun.cpu.endian=little
sun.cpu.isalistsun.desktop=gnome
sun.io.unicode.encoding=UnicodeLittle
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=UTF-8
sun.management.compiler=HotSpot Tiered Compilers
sun.os.patch.level=unknown
user.country=AR
user.dir=/ServidorOXP
user.home=/home/adempiere
user.language=es
user.name=adempiere
user.timezone=America/Argentina/Buenos_Aires

Ver encabezados Fuente grande Mostrar imágenes aparte

[Antonio Calviño]

El mensaje:

Quote:

org.postgresql.util.PSQLException: No se ha especificado un
valor para el parámetro 1

Indica que el PL/Java de tu instalación no está funcionando bien.

Como veo que tu equipo se llama adempiere-desktop, supongo que lo has estado usando para instalar también adempiere y es muy probable que el Java configurado a nivel de postgres (si es que lo está) no esté con la version del jdk 1.6 . La versión de java del postgres debe ser 1.6 y se configura para la base de datos independientemente de lo que se esté ejecutando en el servidor de aplicaciones o el cliente.

Si ejecutas la misma consulta con PGAdmin (cambiando el ? por un cero o cualquier otro numero):

Quote:

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

Te va a mostrar el mensaje de error exacto. Probablemente te indique o bien que el PLJava no existe o bien que la JDK tiene una versión diferente del Jar que se ejecuta en la base de datos.

Lo primero es determinar cual de los dos problemas tenes. Luego hay que solucionarlo revisando la wiki de instalación paso a paso o bien, instalando un postgres en otro equipo (si no querés cambiar el que tenes) y apuntando a la base de datos con el configurar.exe/sh

Saludos
Antonio.

[Autor]

Entradas