Hola, este es el log que me tira…
Estuve viendo por el lado de impuestos… pero no sé como solucionarlo.
Tienen idea de que puede estar pasando?
Gracias!
———–> Msg.getMsg: NOT found: ERROR INESPERADO. No se pudo realizar el ticket [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: Se debe ingresar al menos un producto [11]
===========> Tax.getTax: Tax not Found [11]
——————————-
===========> Tax.getTax: Tax not Found [11]
——————————-
———–> Msg.getMsg: NOT found: Imprimiendo Ticket, Por favor espere [11]
===========> Tax.getTax: Tax not Found [934]
——————————-
===========> MOrderLine.setTax: No Tax found [934]
——————————-
===========> MOrderLine.saveNew: saveNew [934]
org.postgresql.util.PSQLException: ERROR: insert or update on table “c_orderline” violates foreign key constraint “ctax_corderline”
Detail: Key (c_tax_id)=(0) is not present in table “c_tax”.; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321)
at sun.reflect.GeneratedMethodAccessor36.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.executeUpdate(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:227)
at org.openXpertya.model.PO.saveNew(PO.java:2557)
at org.openXpertya.model.PO.save(PO.java:1783)
at org.openXpertya.pos.ctrl.PoSOnline.createOxpOrder(PoSOnline.java:841)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:241)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:67)
at org.openXpertya.pos.view.PoSMainForm$49.construct(PoSMainForm.java:4172)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:45)
at java.lang.Thread.run(Thread.java:619)
——————————-
===========> MOrderLine.saveError: Error – El registro está relacionado con uno o mas registros de otras entidades / documentos. Para eliminar el registro se deberán eliminar primero todos los registros que están relacionados, o marcar este registro como no Activo. [934]
——————————-
===========> MOrderLine.saveNew: [org.openXpertya.pos.ctrl.PoSOnline@13915092010-12-29 13:31:47.1871174] – Not inserted – INSERT INTO C_OrderLine (AD_Client_ID,AD_Org_ID,C_BPartner_ID,C_BPartner_Location_ID,C_Currency_ID,C_OrderLine_ID,C_Order_ID,C_Tax_ID,C_UOM_ID,Created,CreatedBy,DateOrdered,DatePromised,Discount,FreightAmt,IsActive,IsDescription,Line,LineBonusAmt,LineDiscountAmt,LineNetAmt,M_AttributeSetInstance_ID,M_Product_ID,M_Warehouse_ID,PriceActual,PriceEntered,PriceLimit,PriceList,Processed,QtyDelivered,QtyEntered,QtyInvoiced,QtyOrdered,QtyReserved,Updated,UpdatedBy) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [934]
——————————-
===========> MOrder.load: [org.openXpertya.pos.ctrl.PoSOnline@13915092010-12-29 13:31:47.1871174] – C_Order_ID=0, SQL=SELECT Pay_BPartner_ID,Ref_Order_ID,Pay_Location_ID,IsDelivered,Bill_User_ID,Processing,C_Payment_ID,IsSelected,AD_OrgTrx_ID,SendEMail,IsCreditApproved,IsInvoiced,C_Campaign_ID,IsTransferred,UpdatedBy,M_Warehouse_ID,IsApproved,FreightAmt,C_DocType_ID,TotalLines,GrandTotal,DeliveryViaRule,InvoiceRule,POReference,DateAcct,SalesRep_ID,IsPrinted,Description,IsActive,C_Charge_ID,IsDropShip,C_Project_ID,DeliveryRule,AD_Org_ID,C_PaymentTerm_ID,Created,PriorityRule,AD_User_ID,Updated,ChargeAmt,FreightCostRule,C_CashLine_ID,CreatedBy,C_Activity_ID,Posted,C_BPartner_Location_ID,IsSOTrx,AD_Client_ID,IsDiscountPrinted,DatePrinted,C_Order_ID,User2_ID,User1_ID,IsTaxIncluded,C_Currency_ID,Processed,IsSelfService,CopyFrom,Bill_Location_ID,C_ConversionType_ID,Bill_BPartner_ID,DocAction,program_invoice,repair_priority,repair_state,dateprod,daterealprod,Acceptance,M_Shipper_ID,C_DocTypeTarget_ID,C_Repair_Order_ID,CreateVendorProductLines,PaymentRule,M_PriceList_ID,DocumentNo,DateOrdered,DatePromised,DocStatus,C_BPartner_ID FROM C_Order WHERE C_Order_ID=? [934]
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.PO.load(PO.java:1222)
at org.openXpertya.model.PO.load(PO.java:1172)
at org.openXpertya.model.PO.initialize(PO.java:192)
at org.openXpertya.model.PO.
at org.openXpertya.model.PO.
at org.openXpertya.model.X_C_Order.
at org.openXpertya.model.MOrder.
at org.openXpertya.model.MMPCMRP.C_OrderLine(MMPCMRP.java:289)
at org.openXpertya.model.MOrderLine.afterSave(MOrderLine.java:852)
at org.openXpertya.model.PO.doAfterSave(PO.java:3890)
at org.openXpertya.plugin.handlersPO.PluginPOAfterSaveHandler.processActualAction(PluginPOAfterSaveHandler.java:22)
at org.openXpertya.plugin.handlersPO.PluginPOHandler.processPO(PluginPOHandler.java:72)
at org.openXpertya.model.PO.handlePersistence(PO.java:3879)
at org.openXpertya.model.PO.saveFinish(PO.java:1806)
at org.openXpertya.model.PO.saveNew(PO.java:2600)
at org.openXpertya.model.PO.save(PO.java:1783)
at org.openXpertya.pos.ctrl.PoSOnline.createOxpOrder(PoSOnline.java:841)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:241)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:67)
at org.openXpertya.pos.view.PoSMainForm$49.construct(PoSMainForm.java:4172)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:45)
——————————-
===========> MSequence.getNextID: MSequence – Error al obtener nextVal [934]
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.MSequence.getNextID(MSequence.java:1455)
at org.openXpertya.util.DB.getNextID(DB.java:1701)
at org.openXpertya.model.PO.saveNew(PO.java:2282)
at org.openXpertya.model.PO.save(PO.java:1783)
at org.openXpertya.model.PO.save(PO.java:1860)
at org.openXpertya.model.MMPCMRP.C_OrderLine(MMPCMRP.java:359)
at org.openXpertya.model.MOrderLine.afterSave(MOrderLine.java:852)
at org.openXpertya.model.PO.doAfterSave(PO.java:3890)
at org.openXpertya.plugin.handlersPO.PluginPOAfterSaveHandler.processActualAction(PluginPOAfterSaveHandler.java:22)
at org.openXpertya.plugin.handlersPO.PluginPOHandler.processPO(PluginPOHandler.java:72)
at org.openXpertya.model.PO.handlePersistence(PO.java:3879)
at org.openXpertya.model.PO.saveFinish(PO.java:1806)
at org.openXpertya.model.PO.saveNew(PO.java:2600)
at org.openXpertya.model.PO.save(PO.java:1783)
at org.openXpertya.pos.ctrl.PoSOnline.createOxpOrder(PoSOnline.java:841)
at org.openXpertya.pos.ctrl.PoSOnline.completeOrder(PoSOnline.java:241)
at org.openXpertya.pos.ctrl.PoSModel.completeOrder(PoSModel.java:67)
at org.openXpertya.pos.view.PoSMainForm$49.construct(PoSMainForm.java:4172)
at org.openXpertya.apps.SwingWorker$2.run(SwingWorker.java:45)
——————————-
===========> MMPCMRP.saveNew: No NextID (-1) [934]
Servidor = localhost : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = localhost : 5432 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Ventas
Compañía = Super
Organización = Supermercado
Fecha = 2010-12-29 00:00:00
Impresora =
Implementation-Vendor = SERVICIOS_DIGITALES
Implementation-Title = CCTools Libertya
Implementation-Version = Libertya 20101001-1654
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-Super]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 14.0-b16
Windows XP 5.1 Service Pack 3
=== Environment === -527602133
Libertya (r) Versión 10.09_24-09-2010 – Software Libre de Gestión- (c) 2009 DISYTEL; Implementación: Versión 10.09 20101228-2020 – ${env.CONSULTORA_OXP}
wolf/192.168.1.102
CConnection[name=localhost{localhost-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=localhost,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 8.4 JDBC4 (build 701) – via DataSource
DB_PostgreSQL[jdbc:postgresql://localhost:5432/libertya?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true
=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == Super
#AD_Language == es_AR
#AD_Org_ID == 1010067
#AD_Org_Name == Supermercado
#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 == 1027358
#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 == 1010018
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#Date == 2010-12-29 00:00:00
#GL_Category_ID == 1010098
#M_Locator_ID == 1010278
#M_PriceList_ID == 1010595
#M_ProductUPC_ID == 1010011
#M_Product_Category_ID == 1010146
#M_Warehouse_ID == 1010062
#SalesRep_ID == 1010717
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#User_Level == CO
#User_Org == 0,1010053,1010067
#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|AD_User_ID == 0
1113|1113|C_BPartner_ID == 1012142
1113|1113|C_BPartner_Location_ID == 1012157
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_PriceList_Version_ID == 1010525
1113|1113|M_Product_ID == 1015416
1113|1113|M_Warehouse_ID == 1010062
29|M_PriceList_ID == 1010596
29|M_PriceList_Version_ID == 1010525
29|M_Warehouse_ID == 1010062
29|TenderType == CA
29|WindowName == TPV
AutoCommit == Y
M_Warehouse_ID == 1010062
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=Cp1252
file.encoding.pkg=sun.io
file.separator=
jasper.reports.compile.keep.java.file=false
jasper.reports.compile.temp=C:DOCUME~1ADMINI~1CONFIG~1Temp
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.headless=true
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:DOCUME~1ADMINI~1CONFIG~1Temptemp2.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:Archivos de programaJavajdk1.6.0_14jrelibendorsed
java.ext.dirs=C:Archivos de programaJavajdk1.6.0_14jrelibext;C:WINDOWSSunJavalibext
java.home=C:Archivos de programaJavajdk1.6.0_14jre
java.io.tmpdir=C:DOCUME~1ADMINI~1CONFIG~1Temp
java.library.path=C:Archivos de programaJavajdk1.6.0_14bin;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Archivos de programaJavajdk1.6.0_14bin;C:Archivos de programaJavajdk1.6.0_14jrebin;C:Archivos de programaJavajdk1.6.0_14jrebinclient;C:Archivos de programaPostgreSQL8.3bin
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, 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.0-b16
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 programaJavajdk1.6.0_14jrelibresources.jar;C:Archivos de programaJavajdk1.6.0_14jrelibrt.jar;C:Archivos de programaJavajdk1.6.0_14jrelibsunrsasign.jar;C:Archivos de programaJavajdk1.6.0_14jrelibjsse.jar;C:Archivos de programaJavajdk1.6.0_14jrelibjce.jar;C:Archivos de programaJavajdk1.6.0_14jrelibcharsets.jar;C:Archivos de programaJavajdk1.6.0_14jreclasses
sun.boot.library.path=C:Archivos de programaJavajdk1.6.0_14jrebin
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 3
user.country=AR
user.dir=C:Documents and SettingsAdministradorMenú InicioProgramasLibertya
user.home=C:Documents and SettingsAdministrador
user.language=es
user.name=Administrador
user.timezone=America/Guyana
user.variant=
