——————————-
===========> 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,1000010) AND p.AD_Org_ID IN(0,1000047,1010047) ORDER BY QtyAvailable ASC [62]
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(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:183)
at org.openXpertya.apps.search.Info$Worker.run(Info.java:1222)

Servidor = 192.168.0.6 : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = 192.168.0.6 : 5432 / libertyaAsu
Esquema = libertya
Usuario = jpetrik
Perfil = Compras
Compañía = Multipartes S.R.L.
Organización = Casa Central
Fecha = 2010-02-15 00:00:00
Impresora = Microsoft XPS Document Writer
OXPHome = ServidorOXP
Language=[es_PY,Locale=es_PY,AD_Language=es_PY,DatePattern=DD/MM/YYYY,DecimalPoint=false]
MClient[1000010-Multipartes]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 14.2-b01
Windows XP 5.1 Service Pack 2
=== Environment === -1095885033
Libertya (r) Versión 09.10_26-10-2009 – Software Libre de Gestión- (c) 2009 DISYTEL; Implementación: Libertya 20100202-1238 – SERVICIOS_DIGITALES
DG3HQLB1/192.168.0.10
CConnection[name=192.168.0.6{192.168.0.6-libertyaAsu-libertya},AppsHost=192.168.0.6,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=192.168.0.6,DBport=5432,DBname=libertyaAsu,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 8.1 JDBC3 with SSL (build 405) – via DataSource
DB_PostgreSQL[jdbc:postgresql://192.168.0.6:5432/libertyaAsu?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true

=== Context ===
#AD_Client_ID == 1000010
#AD_Client_Name == Multipartes S.R.L.
#AD_Language == es_PY
#AD_Org_ID == 1000047
#AD_Org_Name == Casa Central
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010068
#AD_Role_Name == Compras
#AD_Session_ID == 1027183
#AD_User_ID == 1010711
#AD_User_Name == jpetrik
#C_ConversionType_ID == 201
#C_Country_ID == 276
#C_PaymentTerm_ID == 1000077
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010044
#C_Tax_ID == 1000078
#C_UOM_ID == 1000000
#Date == 2010-02-15 00:00:00
#GL_Category_ID == 1000092
#M_Locator_ID == 1000272
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1000140
#M_Warehouse_ID == 1000042
#Printer == Microsoft XPS Document Writer
#SalesRep_ID == 1010711
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == Y
#StdPrecision == 2
#User_Level == CO
#User_Org == 1000047,1010047,0
#YYYY == Y
$C_AcctSchema_ID == 1000010
$C_Currency_ID == 344
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$HasAlias == Y
0|WindowName == Menú
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_Product_ID == 0
2|0|AD_Tab_ID == 294
2|0|AD_Table_ID == 259
2|0|AccessLevel == 1
2|0|Name == Pedido a Proveedor
2|0|SQL == SELECT Bill_User_ID,C_Payment_ID,C_Repair_Order_ID,C_CashLine_ID,Acceptance,Processing,IsTaxIncluded,C_Order_ID,Pay_BPartner_ID,Pay_Location_ID,Ref_Order_ID,IsCreditApproved,IsPrinted,IsTransferred,DatePrinted,Processed,DateAcct,IsInvoiced,IsDelivered,IsActive,DeliveryRule,repair_priority,InvoiceRule,repair_state,IsApproved,IsSelfService,IsSelected,Bill_Location_ID,IsSOTrx,Bill_BPartner_ID,SendEMail,program_invoice,AD_Client_ID,AD_Org_ID,DocumentNo,POReference,Description,C_DocTypeTarget_ID,DateOrdered,DatePromised,dateprod,daterealprod,C_BPartner_ID,CreateVendorProductLines,C_BPartner_Location_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_Activity_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,1000010) AND C_Order.AD_Org_ID IN(0,1000047,1010047) ORDER BY DocumentNo DESC
2|1|AD_Tab_ID == 293
2|1|AD_Table_ID == 260
2|1|AccessLevel == 1
2|1|LinkColumnName == C_Order_ID
2|1|Name == Línea Ped. Proveedor
2|1|SQL == SELECT IsActive,OpenMatrix,PriceLimit,Processed,QtyReserved,Ref_OrderLine_ID,IsDescription,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,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,Created,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE C_Order_ID=1013971 AND C_OrderLine.AD_Client_ID IN(0,1000010) AND C_OrderLine.AD_Org_ID IN(0,1000047,1010047) ORDER BY Line
2|2|AD_Tab_ID == 692
2|2|AD_Table_ID == 473
2|2|AccessLevel == 3
2|2|LinkColumnName == C_OrderLine_ID
2|2|Name == Correspondencias
2|AD_Client_ID == 1000010
2|AD_Org_ID == 1000047
2|Acceptance == 0
2|AutoCommit == Y
2|BaseTable_ID == 259
2|Bill_BPartner_ID == 1012145
2|Bill_Location_ID == 1012156
2|C_BPartner_ID == 1012145
2|C_ConversionType_ID == 201
2|C_Currency_ID == 344
2|C_DocTypeTarget_ID == 1010516
2|C_DocType_ID == 0
2|C_Order_ID == 1013971
2|C_PaymentTerm_ID == 1010078
2|C_Tax_ID == 1000078
2|ChargeAmt == 0.00
2|CopyFrom == N
2|CreateVendorProductLines == N
2|DateAcct == 2010-02-15 00:00:00
2|DateOrdered == 2010-02-15 00:00:00
2|DatePromised == 2010-02-15 00:00:00
2|DeliveryRule == A
2|DeliveryViaRule == P
2|Discount == 0
2|DocAction == CO
2|DocStatus == DR
2|DocTypeKey == POO
2|DocumentNo == 800009
2|FreightAmt == 0
2|FreightCostRule == I
2|GrandTotal == 0.00
2|InvoiceRule == D
2|IsActive == Y
2|IsApproved == N
2|IsCreditApproved == N
2|IsDelivered == N
2|IsDescription == N
2|IsDiscountPrinted == N
2|IsDropShip == N
2|IsInvoiced == N
2|IsPrinted == N
2|IsSOTrx == N
2|IsSelected == N
2|IsSelfService == N
2|IsTaxIncluded == N
2|IsTransferred == N
2|Line == 10
2|LineNetAmt == 0
2|M_PriceList_ID == 1010590
2|M_PriceList_Version_ID == 1010519
2|M_Warehouse_ID == 1000042
2|OpenMatrix == N
2|PaymentRule == P
2|Posted == N
2|PriceActual == 0
2|PriceEntered == 0
2|PriceLimit == 0
2|PriceList == 0
2|PriorityRule == 5
2|Processed == N
2|Processing == N
2|QtyDelivered == 0
2|QtyEntered == 1
2|QtyInvoiced == 0
2|QtyOrdered == 1
2|QtyReserved == 0
2|SalesRep_ID == 1010711
2|SendEMail == N
2|TotalLines == 0.00
2|WindowName == Pedido a Proveedor
AutoCommit == Y
P103|Type == S
P123|AD_User_ID == -1
P138|C_Region_ID == -1
P140|C_TaxCategory_ID == 1010044
P140|C_UOM_ID == 100
P143|C_BPartner_ID == 1002136
P189|DataType == S
P192|AD_Org_ID == 0
P|AD_FTDoc == 1002145
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|LOCAL_AR == N
java.naming.provider.url == jnp://192.168.0.6:1099

=== System ===
awt.toolkit=sun.awt.windows.WToolkit
deployment.browser.path=C:Archivos de programaInternet ExplorerIEXPLORE.EXE
deployment.browser.vm.iexplorer=true
deployment.browser.vm.mozilla=true
deployment.cache.enabled=true
deployment.cache.jarcompression=0
deployment.cache.max.size=-1
deployment.capture.mime.types=false
deployment.console.startup.mode=HIDE
deployment.control.panel.log=false
deployment.javapi.cache.update=false
deployment.javapi.lifecycle.exception=false
deployment.javapi.log.filename=
deployment.javapi.runtime.type=0
deployment.javapi.trace.filename=
deployment.javaws.associations=ASK_USER
deployment.javaws.autodownload=ALWAYS
deployment.javaws.cache.update=false
deployment.javaws.home.jnlp.url=http://java.sun.com/products/javawebstart
deployment.javaws.installURL=http://java.sun.com/products/autodl/j2se
deployment.javaws.logFileName=
deployment.javaws.muffin.max=256
deployment.javaws.shortcut=ASK_IF_HINTED
deployment.javaws.splash.index=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache6.0splashsplash.xml
deployment.javaws.ssv.enabled=true
deployment.javaws.traceFileName=
deployment.javaws.uninstall.shortcut=false
deployment.javaws.update.timeout=1500
deployment.javaws.version=javaws-1.4.2_03
deployment.jpi.mode.new=true
deployment.log=false
deployment.max.output.file.size=10
deployment.max.output.files=5
deployment.mime.types.use.default=true
deployment.proxy.bypass.local=false
deployment.proxy.override.hosts=
deployment.proxy.same=false
deployment.proxy.type=3
deployment.repository.askdownloaddialog.show=true
deployment.repository.enabled=true
deployment.security.SSLv2Hello=false
deployment.security.SSLv3=true
deployment.security.TLSv1=true
deployment.security.askgrantdialog.notinca=true
deployment.security.askgrantdialog.show=true
deployment.security.authenticator=true
deployment.security.blacklist.check=true
deployment.security.browser.keystore.use=true
deployment.security.clientauth.keystore.auto=true
deployment.security.expired.warning=true
deployment.security.https.warning.show=false
deployment.security.jsse.hostmismatch.warning=true
deployment.security.notinca.warning=true
deployment.security.password.cache=true
deployment.security.pretrust.list=true
deployment.security.sandbox.awtwarningwindow=true
deployment.security.sandbox.jnlp.enhanced=true
deployment.security.trusted.policy=
deployment.security.validation.crl=false
deployment.security.validation.ocsp=false
deployment.system.security.blacklist=C:Archivos de programaJavajre6libsecurityblacklist
deployment.system.security.cacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.jssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.oldcacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.oldjssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.trusted.certs=C:Archivos de programaJavajre6libsecuritytrusted.certs
deployment.system.security.trusted.clientauthcerts=C:Archivos de programaJavajre6libsecuritytrusted.clientcerts
deployment.system.security.trusted.jssecerts=C:Archivos de programaJavajre6libsecuritytrusted.jssecerts
deployment.system.security.trusted.publishers=C:Archivos de programaJavajre6libsecuritytrusted.publishers
deployment.system.tray.icon=true
deployment.trace=false
deployment.update.mime.types=true
deployment.user.cachedir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache
deployment.user.extdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentext
deployment.user.logdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentlog
deployment.user.security.blacklist=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityblacklist
deployment.user.security.policy=file://C:/Documents%20and%20Settings/user/Datos%20de%20programa/Sun/Java/Deployment/security/java.policy
deployment.user.security.saved.credentials=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityauth.dat
deployment.user.security.trusted.cacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.cacerts
deployment.user.security.trusted.certs=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.certs
deployment.user.security.trusted.clientauthcerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.clientcerts
deployment.user.security.trusted.jssecacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecacerts
deployment.user.security.trusted.jssecerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecerts
deployment.user.security.trusted.publishers=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.publishers
deployment.user.tmp=C:Documents and SettingsuserDatos de programaSunJavaDeploymenttmp
deployment.version=6.0
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=
http.auth.serializeRequests=true
https.protocols=TLSv1,SSLv3
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:Archivos de programaJavajre6libdeploy.jar
java.class.version=50.0
java.endorsed.dirs=C:Archivos de programaJavajre6libendorsed
java.ext.dirs=C:Archivos de programaJavajre6libext;C:WINDOWSSunJavalibext
java.home=C:Archivos de programaJavajre6
java.io.tmpdir=C:DOCUME~1userCONFIG~1Temp
java.library.path=C:Archivos de programaJavajre6bin;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:Archivos de programaJavajre6bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;”C:Archivos de programaJavajre6bin”
java.protocol.handler.pkgs=com.sun.javaws.net.protocol|com.sun.deploy.net.protocol
java.quick.starter=true
java.rmi.server.RMIClassLoaderSpi=com.sun.jnlp.JNLPRMIClassLoaderSpi
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_16-b01
java.security.policy=file:C:Archivos de programaJavajre6libsecurityjavaws.policy
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_16
java.vm.info=mixed mode, sharing
java.vm.name=Java HotSpot(TM) Client 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.2-b01
javaplugin.proxy.config.type=direct
javawebstart.version=javaws-1.6.0_16
jnlpx.heapsize=33554432,536870912
jnlpx.home=C:Archivos de programaJavajre6bin
jnlpx.jvm=C:Archivos de programaJavajre6binjavaw.exe
jnlpx.offline=false
jnlpx.relaunch=true
jnlpx.remove=false
jnlpx.splashport=1568
jnlpx.vmargs=-Xmx512m -Xms32m
line.separator=

os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Archivos de programaJavajre6libresources.jar;C:Archivos de programaJavajre6librt.jar;C:Archivos de programaJavajre6libsunrsasign.jar;C:Archivos de programaJavajre6libjsse.jar;C:Archivos de programaJavajre6libjce.jar;C:Archivos de programaJavajre6libcharsets.jar;C:Archivos de programaJavajre6classes;C:Archivos de programaJavajre6libjavaws.jar;C:Archivos de programaJavajre6libdeploy.jar;C:Archivos de programaJavajre6libplugin.jar
sun.boot.library.path=C:Archivos de programaJavajre6bin
sun.cpu.endian=little
sun.cpu.isalist=pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=Service Pack 2
trustProxy=true
user.country=PY
user.dir=C:Documents and SettingsuserEscritorio
user.home=C:Documents and Settingsuser
user.language=es
user.name=user
user.timezone=America/Guyana
user.variant=