Re:Re: Tarifas de Venta

Inicio Foros Foro principal Instalación y Configuración Tarifas de Venta Re:Re: Tarifas de Venta

#36132
perez pepe
Participante

Bueno, si hay un problema. En el pedido me voy a herramientas/Preferencias/Errores y tengo 2.
Aqui el log por si alguien lo entiende.


20:45:27.556 OpenXpertya.startup: Libertya (r) Versión 11.05_31-05-2011 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 11.05 20111014-2306 – ${env.CONSULTORA_OXP}
20:45:27.556 OpenXpertya.startup: ServidorOXP – Java HotSpot(TM) 64-Bit Server VM 20.1-b02 – Windows 7 6.1 Service Pack 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}
===========> MProductPricing.calculatePL: SELECT bomPriceStd(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceStd, bomPriceList(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceList, bomPriceLimit(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceLimit, p.C_UOM_ID,pv.ValidFrom,pl.C_Currency_ID,p.M_Product_Category_ID,pl.EnforcePriceLimit FROM M_Product p INNER JOIN M_ProductPrice pp ON (p.M_Product_ID=pp.M_Product_ID) INNER JOIN M_PriceList_Version pv ON (pp.M_PriceList_Version_ID=pv.M_PriceList_Version_ID) INNER JOIN M_Pricelist pl ON (pv.M_PriceList_ID=pl.M_PriceList_ID) WHERE pv.IsActive=’Y’ AND p.M_Product_ID=? AND pv.M_PriceList_ID=? ORDER BY pv.ValidFrom DESC [11]
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:174)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
at $Proxy1.executeQuery(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
at org.openXpertya.model.MProductPricing.calculatePL(MProductPricing.java:340)
at org.openXpertya.model.MProductPricing.calculatePrice(MProductPricing.java:183)
at org.openXpertya.model.MProductPricing.getPriceList(MProductPricing.java:732)
at org.openXpertya.model.CalloutOrder.product(CalloutOrder.java:1043)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.openXpertya.model.CalloutEngine.start(CalloutEngine.java:116)
at org.openXpertya.model.MTab.processCallout(MTab.java:2767)
at org.openXpertya.model.MTab.processFieldChange(MTab.java:2632)
at org.openXpertya.grid.GridController.dataStatusChanged(GridController.java:753)
at org.openXpertya.model.MTab.fireDataStatusChanged(MTab.java:2252)
at org.openXpertya.model.MTab.dataStatusChanged(MTab.java:2196)
at org.openXpertya.model.MTable.fireDataStatusChanged(MTable.java:3437)
at org.openXpertya.model.MTable.setValueAt(MTable.java:1275)
at org.openXpertya.model.MTable.setValueAt(MTable.java:1168)
at org.openXpertya.grid.GridController.vetoableChange(GridController.java:1084)


===========> MProductPricing.calculatePL: SELECT bomPriceStd(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceStd, bomPriceList(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceList, bomPriceLimit(p.M_Product_ID,pv.M_PriceList_Version_ID,?) AS PriceLimit, p.C_UOM_ID,pv.ValidFrom,pl.C_Currency_ID,p.M_Product_Category_ID,pl.EnforcePriceLimit FROM M_Product p INNER JOIN M_ProductPrice pp ON (p.M_Product_ID=pp.M_Product_ID) INNER JOIN M_PriceList_Version pv ON (pp.M_PriceList_Version_ID=pv.M_PriceList_Version_ID) INNER JOIN M_Pricelist pl ON (pv.M_PriceList_ID=pl.M_PriceList_ID) WHERE pv.IsActive=’Y’ AND p.M_Product_ID=? AND pv.M_PriceList_ID=? ORDER BY pv.ValidFrom DESC [11]
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:174)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
at $Proxy1.executeQuery(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
at org.openXpertya.model.MProductPricing.calculatePL(MProductPricing.java:340)
at org.openXpertya.model.MProductPricing.calculatePrice(MProductPricing.java:183)
at org.openXpertya.model.MProductPricing.getPriceList(MProductPricing.java:732)
at org.openXpertya.model.CalloutOrder.product(CalloutOrder.java:1043)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.openXpertya.model.CalloutEngine.start(CalloutEngine.java:116)
at org.openXpertya.model.MTab.processCallout(MTab.java:2767)
at org.openXpertya.model.MTab.processFieldChange(MTab.java:2632)
at org.openXpertya.grid.GridController.dataStatusChanged(GridController.java:753)
at org.openXpertya.model.MTab.fireDataStatusChanged(MTab.java:2252)
at org.openXpertya.model.MTab.dataStatusChanged(MTab.java:2196)
at org.openXpertya.model.MTable.fireDataStatusChanged(MTable.java:3437)
at org.openXpertya.model.MTable.setValueAt(MTable.java:1275)
at org.openXpertya.model.MTable.setValueAt(MTable.java:1168)
at org.openXpertya.grid.GridController.vetoableChange(GridController.java:1084)

Servidor = localhost : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = Goitos : 5432 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Ventas
Compañía = Libertya
Organización = Default
Fecha = 2011-10-15 00:00:00
Impresora = Adobe PDF
Implementation-Vendor = SERVICIOS_DIGITALES
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20110714-0938
Specification-Vendor = (C) 2005-2006 FUNDESLE.
Specification-Title = Herramientas de Cliente oxp
Implementation-URL = http://www.openxpertya.org
Specification-Version = Libertya
OXPHome = ServidorOXP
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) 64-Bit Server VM 20.1-b02
Windows 7 6.1 Service Pack 1
=== Environment === -67774778
Libertya (r) Versión 11.05_31-05-2011 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 11.05 20111014-2306 – ${env.CONSULTORA_OXP}
Goitos/10.0.0.3
CConnection[name=localhost{Goitos-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=Goitos,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=josi79]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 8.4 JDBC4 (build 701) – via DataSource
DB_PostgreSQL[jdbc:postgresql://Goitos:5432/libertya?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 == 1010071
#AD_Role_Name == Ventas
#AD_Session_ID == 1027652
#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 == 1010020
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#Date == 2011-10-15 00:00:00
#GL_Category_ID == 1010098
#IsPOSJournalActive == N
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1010146
#M_Warehouse_ID == 1010048
#Printer == Adobe PDF
#SalesRep_ID == 1010717
#ShowAcct == N
#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ú
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_Product_ID == 0
5|0|AD_Tab_ID == 186
5|0|AD_Table_ID == 259
5|0|AccessLevel == 1
5|0|IsActive == Y
5|0|Name == Pedido
5|0|Processed == N
5|0|SQL == SELECT DateAcct,IsApproved,CreateVendorProductLines,IsCreditApproved,C_Repair_Order_ID,Bill_Location_ID,IsSelfService,Bill_BPartner_ID,Pay_BPartner_ID,IsDelivered,SendEMail,M_Shipper_ID,IsDropShip,repair_state,program_invoice,IsInvoiced,C_Payment_ID,DatePrinted,dateprod,daterealprod,FreightAmt,IsPrinted,IsDiscountPrinted,IsTaxIncluded,C_CashLine_ID,POReference,Ref_Order_ID,C_Order_ID,PriorityRule,repair_priority,Processed,Processing,FreightCostRule,IsSelected,IsSOTrx,IsTransferred,Pay_Location_ID,DeliveryViaRule,IsActive,AD_Client_ID,AD_Org_ID,DocumentNo,Description,C_DocTypeTarget_ID,Acceptance,DateOrdered,ValidTo,DatePromised,C_BPartner_ID,C_BPartner_Location_ID,AD_User_ID,Bill_User_ID,DeliveryRule,M_Warehouse_ID,InvoiceRule,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID,SalesRep_ID,C_Charge_ID,ChargeAmt,PaymentRule,C_PaymentTerm_ID,C_Project_ID,C_Activity_ID,C_Campaign_ID,AD_OrgTrx_ID,User1_ID,User2_ID,TotalLines,GrandTotal,DocStatus,C_DocType_ID,CopyFrom,DocAction,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_Order WHERE IsSOTrx=’Y’ 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
5|1|AD_Tab_ID == 187
5|1|AD_Table_ID == 260
5|1|AccessLevel == 1
5|1|IsActive == Y
5|1|LinkColumnName == C_Order_ID
5|1|Name == Línea del Pedido
5|1|Processed == N
5|1|SQL == SELECT LineDiscountAmt,M_Warehouse_ID,S_ResourceAssignment_ID,LineBonusAmt,QtyDelivered,QtyInvoiced,C_Charge_ID,AD_Client_ID,Discount,DocumentDiscountAmt,IsActive,C_BPartner_Location_ID,M_Shipper_ID,DateInvoiced,DateDelivered,DateOrdered,DatePromised,FreightAmt,C_OrderLine_ID,C_Currency_ID,Line,OpenMatrix,AD_Org_ID,QtyOrdered,PriceActual,PriceLimit,PriceList,Processed,Ref_OrderLine_ID,IsDescription,C_Order_ID,C_BPartner_ID,M_Product_ID,M_AttributeSetInstance_ID,QtyEntered,PriceEntered,C_UOM_ID,QtyReserved,Description,C_Tax_ID,LineNetAmt,LineTotalAmt,C_Project_ID,Created,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE C_Order_ID=1013984 AND C_OrderLine.AD_Client_ID IN(0,1010016) AND C_OrderLine.AD_Org_ID IN(0,1010053) ORDER BY Line
5|2|AD_Tab_ID == 1010234
5|2|Name == Descuentos / Recargos
5|AD_Client_ID == 1010016
5|AD_Org_ID == 1010053
5|Acceptance == 0
5|AutoCommit == Y
5|BaseTable_ID == 259
5|Bill_BPartner_ID == 1012162
5|Bill_Location_ID == 1012174
5|C_BPartner_ID == 1012162
5|C_ConversionType_ID == 114
5|C_Currency_ID == 118
5|C_DocTypeTarget_ID == 1010532
5|C_DocType_ID == 0
5|C_Order_ID == 1013984
5|C_PaymentTerm_ID == 1010083
5|C_Tax_ID == 1010084
5|ChargeAmt == 0.00
5|CopyFrom == N
5|CreateVendorProductLines == N
5|DateAcct == 2011-10-15 00:00:00
5|DateOrdered == 2011-10-15 00:00:00
5|DatePromised == 2011-10-15 00:00:00
5|DeliveryRule == A
5|DeliveryViaRule == P
5|Discount == 0
5|DocAction == CO
5|DocStatus == DR
5|DocTypeKey == SOSO
5|DocumentDiscountAmt == 0
5|DocumentNo == 50002
5|FreightAmt == 0
5|FreightCostRule == I
5|GrandTotal == 0.00
5|InvoiceRule == D
5|IsActive == Y
5|IsApproved == N
5|IsCreditApproved == N
5|IsDelivered == N
5|IsDescription == N
5|IsDiscountPrinted == N
5|IsDropShip == N
5|IsInvoiced == N
5|IsPrinted == N
5|IsSOTrx == Y
5|IsSelected == N
5|IsSelfService == N
5|IsTaxIncluded == N
5|IsTransferred == N
5|Line == 10
5|LineBonusAmt == 0
5|LineDiscountAmt == 0
5|LineNetAmt == 0
5|LineTotalAmt == 0
5|M_PriceList_ID == 1010595
5|M_Warehouse_ID == 1010048
5|OpenMatrix == N
5|OrderType == SO
5|PaymentRule == P
5|Posted == N
5|PriceActual == 0
5|PriceEntered == 0
5|PriceLimit == 0
5|PriceList == 0
5|PriorityRule == 5
5|Processed == N
5|Processing == N
5|QtyDelivered == 0
5|QtyEntered == 1
5|QtyInvoiced == 0
5|QtyOrdered == 1
5|QtyReserved == 0
5|SalesRep_ID == 1010717
5|SendEMail == N
5|TotalLines == 0.00
5|WindowName == Pedido de Clientes
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P189|DataType == S
P|AD_FTDoc == 1002145
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|LOCAL_AR == Y
java.naming.provider.url == jnp://localhost:1099

=== System ===
awt.toolkit=sun.awt.windows.WToolkit
file.encoding=UTF-8
file.encoding.pkg=sun.io
file.separator=
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:UsersJosiAppDataLocalTemptemp1.jar;C:ServidorOXP.libbatik-awt-util.jar;C:ServidorOXP.libbatik-dom.jar;C:ServidorOXP.libbatik-svggen.jar;C:ServidorOXP.libbatik-util.jar;C:ServidorOXP.libbatik-xml.jar;C:ServidorOXP.libCMPCS.jar;C:ServidorOXP.libJasperReports.jar;C:ServidorOXP.libjboss.jar;C:ServidorOXP.libjsp-api-2.0.jar;C:ServidorOXP.liboracle.jar;C:ServidorOXP.libOXP.jar;C:ServidorOXP.libOXPApps.jar;C:ServidorOXP.libOXPInstall.jar;C:ServidorOXP.libOXPRoot.jar;C:ServidorOXP.libOXPSLib.jar;C:ServidorOXP.libOXPXLib.jar;C:ServidorOXP.libpostgresql.jar;C:ServidorOXP.libsqlj.jar;C:ServidorOXP.libsqlServer.jar;C:ServidorOXP.libsybase.jar;C:ServidorOXP.libXOXPTools.jar;C:ServidorOXP.libswing-layout-1.0.jar;C:ServidorOXP.libPDFRenderer.jar;C:ServidorOXP.libJasperReports.jar;
java.class.version=50.0
java.endorsed.dirs=C:Program FilesJavajdk1.6.0_26jrelibendorsed
java.ext.dirs=C:Program FilesJavajdk1.6.0_26jrelibext;C:WindowsSunJavalibext
java.home=C:Program FilesJavajdk1.6.0_26jre
java.io.tmpdir=C:UsersJosiAppDataLocalTemp
java.library.path=C:Program FilesJavajdk1.6.0_26bin;C:WindowsSunJavabin;C:Windowssystem32;C:Windows;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:Program Files (x86)ATI TechnologiesATI.ACECore-Static;C:Program FilesJavajdk1.6.0_26src.zip;C:Program FilesJavajdk1.6.0_26libtools.jar;C:Program FilesJavajdk1.6.0_26src.zip;C:Program FilesJavajdk1.6.0_26libtools.jar;C:Program Files (x86)PostgreSQL8.3bin;C:Program FilesJavajdk1.6.0_26bin;C:Program FilesJavajdk1.6.0_26jrebin;C:Program FilesJavajdk1.6.0_26jrebinclient;bin;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_26-b03
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_26
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) 64-Bit 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=20.1-b02
line.separator=

os.arch=amd64
os.name=Windows 7
os.version=6.1
path.separator=;
sun.arch.data.model=64
sun.boot.class.path=C:Program FilesJavajdk1.6.0_26jrelibresources.jar;C:Program FilesJavajdk1.6.0_26jrelibrt.jar;C:Program FilesJavajdk1.6.0_26jrelibsunrsasign.jar;C:Program FilesJavajdk1.6.0_26jrelibjsse.jar;C:Program FilesJavajdk1.6.0_26jrelibjce.jar;C:Program FilesJavajdk1.6.0_26jrelibcharsets.jar;C:Program FilesJavajdk1.6.0_26jrelibmodulesjdk.boot.jar;C:Program FilesJavajdk1.6.0_26jreclasses
sun.boot.library.path=C:Program FilesJavajdk1.6.0_26jrebin
sun.cpu.endian=little
sun.cpu.isalist=amd64
sun.desktop=windows
sun.io.unicode.encoding=UnicodeLittle
sun.java.command=org.openXpertya.OpenXpertya
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot 64-Bit Tiered Compilers
sun.os.patch.level=Service Pack 1
suppressSwingDropSupport=true
user.country=AR
user.dir=C:UsersJosiAppDataRoamingMicrosoftWindowsStart MenuProgramsLibertya
user.home=C:UsersJosi
user.language=es
user.name=Josi
user.timezone=GMT-03:00
user.variant=