Respuestas de foro creadas
-
AutorEntradas
-
24 agosto, 2016 a las 11:40 am #46248Jorge O. NegreteParticipante
Hola Carlos, muchas gracias por tu respuesta.
Me temo que el problema pasa por otro lado, ya que la tabla “m_pricelist”contiene registros, de echo ya tiene cargada mas de 300 entidades comerciales.Pego todo el contenido del archivo TraceInfo.txt
Desde ya mil gracias
——————————-
16:32:55.026 OpenXpertya.startup: Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 15.03 20160711-1657 – SERVICIOS_DIGITALES
16:32:55.026 OpenXpertya.startup: \ServidorOXP – Java HotSpot(TM) Client VM 20.4-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}
===========> MBPartner.saveNew: saveNew [11]
org.postgresql.util.PSQLException: ERROR: insert or update on table “c_bpartner” violates foreign key constraint “mpricelist_cbpartner”
Detail: Key (m_pricelist_id)=(-1) is not present in table “m_pricelist”.; State=23503; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:245)
at org.openXpertya.model.PO.saveNew(PO.java:2584)
at org.openXpertya.model.PO.save(PO.java:1813)
at org.openXpertya.model.MTable.dataSavePO(MTable.java:2299)
at org.openXpertya.model.MTable.dataSave(MTable.java:1539)
at org.openXpertya.model.MTab.dataSave(MTab.java:899)
at org.openXpertya.apps.APanel.cmd_save(APanel.java:1679)
at org.openXpertya.apps.APanel.actionPerformed(APanel.java:1509)
at org.openXpertya.apps.AppsAction.actionPerformed(AppsAction.java:292)——————————-
===========> MBPartner.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. – org.postgresql.util.PSQLException: ERROR: insert or update on table “c_bpartner” violates foreign key constraint “mpricelist_cbpartner”
Detail: Key (m_pricelist_id)=(-1) is not present in table “m_pricelist”. [11]
——————————-
===========> MBPartner.saveNew: Not inserted – INSERT INTO C_BPartner (AD_Client_ID,AD_Language,AD_Org_ID,AcqusitionCost,ActualLifeTimeValue,AutomaticCreditNotes,C_BP_Group_ID,C_BPartner_ID,C_Categoria_Iva_ID,C_PaymentTerm_ID,CopyFrom,Created,CreatedBy,CreditMinimumAmt,DUNS,DiscountContext,DocumentCopies,FlatDiscount,Goal,IsActive,IsCompoundtax,IsConvenioMultilateral,IsCustomer,IsDiscountPrinted,IsEmployee,IsGroupInvoices,IsMultiCUIT,IsOneTime,IsProspect,IsSalesRep,IsSummary,IsTaxExempt,IsVendor,M_PriceList_ID,MinimumPurchasedAmt,Name,NumberEmployees,PotentialLifeTimeValue,SOCreditStatus,SO_CreditLimit,SO_CreditUsed,SalesRep_ID,SalesVolume,SearchUnallocatedPayments,SecondaryCreditStatus,SendEMail,ShareOfCustomer,ShelfLifeMinPct,TaxID,TaxIdType,TotalOpenBalance,UpdateBalance,Updated,UpdatedBy,Value,isiso,min_order_qty,program_amt,program_amt_used) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [11]
——————————-
===========> MTable.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. – org.postgresql.util.PSQLException: ERROR: insert or update on table “c_bpartner” violates foreign key constraint “mpricelist_cbpartner”
Detail: Key (m_pricelist_id)=(-1) is not present in table “m_pricelist”. [11]Servidor = localhost : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = CX-PC : 5432 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Administración
Compañía = Seguridad Centro
Organización = Casa Central
Fecha = 2016-08-19 00:00:00
Impresora = Samsung M2020 Series (USB001)
OXPHome = \ServidorOXP
Language=[Español (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY,DecimalPoint=false]
MClient[1010016-SEG_CEN]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 20.4-b02
Windows 7 6.1 Service Pack 1
=== Environment === 403368704
Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 15.03 20160711-1657 – SERVICIOS_DIGITALES
CX-PC/192.168.0.101
CConnection[name=localhost{CX-PC-libertya-libertya},AppsHost=localhost,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=CX-PC,DBport=5432,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=12qwaszx]
Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
DB_PostgreSQL[jdbc:postgresql://CX-PC:5432/libertya?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true=== Context ===
#AD_Client_ID == 1010016
#AD_Client_Name == Seguridad Centro
#AD_Language == es_AR
#AD_Org_ID == 1010053
#AD_Org_Name == Casa Central
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010076
#AD_Role_Name == Administración
#AD_Session_ID == 1029451
#AD_User_ID == 1010717
#AD_User_Name == AdminLibertya
#C_BP_Group_ID == 1010045
#C_ConversionType_ID == 114
#C_Country_ID == 119
#C_DocTypeTarget_ID == 1010522
#C_Letra_Comprobante_ID == 1010055
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#CheckCuitControl == N
#Date == 2016-08-19 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
#POSJournalSupervisor == Y
#PasswordExpirationActive == N
#PrintPreview == N
#Printer == Samsung M2020 Series (USB001)
#SalesRep_ID == 1010717
#ShowAcct == Y
#ShowAdvanced == Y
#ShowTrl == N
#StdPrecision == 2
#UniqueKeyActive == N
#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ú
2|0|AD_Tab_ID == 220
2|0|AD_Table_ID == 291
2|0|AccessLevel == 3
2|0|IsActive == Y
2|0|Name == Entidad Comercial
2|0|SQL == SELECT C_BPartner_ID,IsOneTime,C_Greeting_ID,C_InvoiceSchedule_ID,C_PaymentTerm_ID,C_JobCategory_ID,C_Dunning_ID,C_POSPaymentMedium_ID,IsSalesRep,SendEMail,isiso,IsDiscountPrinted,IsCompoundtax,Rating,IsGroupInvoices,AutomaticCreditNotes,IsSummary,IsTaxExempt,C_Location_ID,FlatDiscount,UpdateBalance,AD_OrgBP_ID,program_amt_used,Goal,min_order_qty,program_amt,CreditSituation,SO_Description,ReferenceNo,POReference,NAICS,AD_ComponentObjectUID,ShareOfCustomer,NumberEmployees,ShelfLifeMinPct,DocumentCopies,ActualLifeTimeValue,TotalOpenBalance,SO_CreditUsed,CreditMinimumAmt,SO_CreditLimit,MinimumPurchasedAmt,StartHolidays,EndHolidays,EndHolidays2,StartHolidays2,PaymentRulePO,DeliveryViaRule,DeliveryRule,SOCreditStatus,PaymentRule,CustomerType,FreightCostRule,InvoiceRule,DiscountContext,SecondaryCreditStatus,PO_DiscountSchema_ID,BPartner_Parent_ID,PO_PriceList_ID,PO_PaymentTerm_ID,Invoice_PrintFormat_ID,M_DiscountSchema_ID,AD_Language,SalesRep_ID,M_Shipper_ID,M_PriceList_ID,AD_Client_ID,AD_Org_ID,Value,Name,Name2,Description,C_Categoria_Iva_ID,TaxID,TaxIdType,IIBB,IsActive,IsConvenioMultilateral,C_BP_Group_ID,URL,IsProspect,SearchUnallocatedPayments,PotentialLifeTimeValue,IsMultiCUIT,AcqusitionCost,SalesVolume,FirstSale,IsCustomer,IsVendor,IsEmployee,CopyFrom,Created,CreatedBy,Updated,UpdatedBy FROM C_BPartner WHERE C_BPartner.AD_Client_ID IN(0,1010016) AND C_BPartner.AD_Org_ID IN(0,1010053) ORDER BY Value
2|10|AD_Tab_ID == 1000163
2|10|AD_Table_ID == 1000143
2|10|AccessLevel == 3
2|10|LinkColumnName == C_BPartner_Retencion_ID
2|10|Name == Período de Excepción
2|11|AD_Tab_ID == 225
2|11|AD_Table_ID == 291
2|11|AccessLevel == 3
2|11|LinkColumnName == C_BPartner_ID
2|11|Name == Empleado
2|12|AD_Tab_ID == 226
2|12|AD_Table_ID == 298
2|12|AccessLevel == 3
2|12|LinkColumnName == C_BPartner_ID
2|12|Name == Cuenta Bancaria
2|13|AD_Tab_ID == 222
2|13|AD_Table_ID == 293
2|13|AccessLevel == 3
2|13|LinkColumnName == C_BPartner_ID
2|13|Name == Localización
2|14|AD_Tab_ID == 496
2|14|AD_Table_ID == 114
2|14|AccessLevel == 3
2|14|LinkColumnName == C_BPartner_ID
2|14|Name == Contacto (Usuario)
2|15|AD_Tab_ID == 439
2|15|AD_Table_ID == 528
2|15|AccessLevel == 3
2|15|LinkColumnName == AD_User_ID
2|15|Name == Area de Interés
2|1|AD_Tab_ID == 223
2|1|AD_Table_ID == 291
2|1|AccessLevel == 3
2|1|LinkColumnName == C_BPartner_ID
2|1|Name == Cliente
2|2|AD_Tab_ID == 1010250
2|2|AD_Table_ID == 1010246
2|2|AccessLevel == 3
2|2|LinkColumnName == C_BPartner_ID
2|2|Name == Excepciones de Crédito
2|3|AD_Tab_ID == 1010292
2|3|AD_Table_ID == 1010287
2|3|AccessLevel == 3
2|3|LinkColumnName == C_BPartner_ID
2|3|Name == Percepción
2|4|AD_Tab_ID == 1010293
2|4|AD_Table_ID == 1010288
2|4|AccessLevel == 3
2|4|LinkColumnName == C_BPartner_ID
2|4|Name == Exención de Percepciones
2|5|AD_Tab_ID == 212
2|5|AD_Table_ID == 183
2|5|AccessLevel == 3
2|5|LinkColumnName == C_BPartner_ID
2|5|Name == Contabilidad del Cliente
2|6|AD_Tab_ID == 224
2|6|AD_Table_ID == 291
2|6|AccessLevel == 3
2|6|LinkColumnName == C_BPartner_ID
2|6|Name == Proveedor
2|7|AD_Tab_ID == 1000101
2|7|AD_Table_ID == 210
2|7|AccessLevel == 3
2|7|LinkColumnName == C_BPartner_ID
2|7|Name == Artículos del proveedor
2|8|AD_Tab_ID == 213
2|8|AD_Table_ID == 185
2|8|AccessLevel == 3
2|8|LinkColumnName == C_BPartner_ID
2|8|Name == Contabilidad del Proveedor
2|9|AD_Tab_ID == 1000162
2|9|AD_Table_ID == 1000144
2|9|AccessLevel == 3
2|9|LinkColumnName == C_BPartner_ID
2|9|Name == Retenciones
2|AD_Client_ID == 1010016
2|AD_Language == es_AR
2|AD_Org_ID == 1010053
2|AcqusitionCost == 0
2|ActualLifeTimeValue == 0
2|AutoCommit == Y
2|AutomaticCreditNotes == N
2|BaseTable_ID == 291
2|C_BP_Group_ID == 1010045
2|C_Categoria_Iva_ID == 1010066
2|C_PaymentTerm_ID == 1010083
2|CopyFrom == Y
2|CreditMinimumAmt == 0
2|DiscountContext == B
2|DocumentCopies == 0
2|FlatDiscount == 0
2|Goal == 0
2|IsActive == Y
2|IsCompoundtax == N
2|IsConvenioMultilateral == N
2|IsCustomer == N
2|IsDiscountPrinted == N
2|IsEmployee == N
2|IsGroupInvoices == N
2|IsMultiCUIT == N
2|IsOneTime == N
2|IsProspect == Y
2|IsSOTrx == Y
2|IsSalesRep == N
2|IsSummary == N
2|IsTaxExempt == N
2|IsVendor == N
2|MinimumPurchasedAmt == 0
2|Name == molino mocona s.r.l.
2|NumberEmployees == 0
2|PotentialLifeTimeValue == 0
2|SO_CreditLimit == 0
2|SO_CreditUsed == 0
2|SalesRep_ID == 1010717
2|SalesVolume == 0
2|SearchUnallocatedPayments == N
2|SecondaryCreditStatus == OK
2|SendEMail == N
2|ShareOfCustomer == 0
2|ShelfLifeMinPct == 0
2|TaxID == 30-71167625-9
2|TaxIdType == 80
2|TotalOpenBalance == 0
2|UpdateBalance == N
2|WindowName == Entidades Comerciales
2|isiso == N
2|min_order_qty == 0
2|program_amt == 0
2|program_amt_used == 0
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P123|M_PriceList_ID == -1
P189|DataType == S
P338|C_BankAccount_ID == -1
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|C_Region_ID_FACTURA_ARCIBA == 1000082
P|ConversationSecurityPolicy == E
P|DIF_CAMBIO_ARTICULO == 10000001
P|DIF_CAMBIO_PTO_VENTA == 1
P|FiscalDescription_VoidedDocument == ANULADO
P|InfoMaxRowsAllowed == 1000
P|InfoRowCountMethod == C
P|LOCAL_AR == Y
P|L_AR_CFMontoMaximo == 1000
P|L_AR_LibroIVA_CFMontoMaximoAgrupacion == 1000
P|L_AR_MaxOrderLineQty == 999
P|LogTransactionEvents == N
P|LookupMaxRowsAllowed == 1000
P|Maintenance_Inventory == 6
P|MantenimientoPadron == 3
P|MultiOrgTransactionFilterRulesPropertiesFileLocation == /ServidorOXP/utils/replicacion/filters/MultiOrgTransactionFilterRules.properties
P|NCFiscal_ComprobanteOriginal_ClaveTiposDocumentoPedido == SOSOTD;SOSOTH
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|POSCashJounal_ValidDiff == 0.5
P|PathPadronCSV == C:\\Padron\\
P|PorcentajeDeAumentoDePrecio == 100
P|ReasonVoid == Anulación
P|ReplicationEventsActive == Y
P|SeparadorDeCampoEnCSVPadron == ;
P|TransferDueDateDays == 1
P|WAIT_FOR_WORKER_SECONDS == 0
P|WSFE == c:\\pyafipws\\
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:\Users\CX\AppData\Local\Temp\temp525.jar;C:\SEG_CEN\ClienteLBY\.\lib\batik-awt-util.jar;C:\SEG_CEN\ClienteLBY\.\lib\batik-dom.jar;C:\SEG_CEN\ClienteLBY\.\lib\batik-svggen.jar;C:\SEG_CEN\ClienteLBY\.\lib\batik-util.jar;C:\SEG_CEN\ClienteLBY\.\lib\batik-xml.jar;C:\SEG_CEN\ClienteLBY\.\lib\CMPCS.jar;C:\SEG_CEN\ClienteLBY\.\lib\JasperReports.jar;C:\SEG_CEN\ClienteLBY\.\lib\jboss.jar;C:\SEG_CEN\ClienteLBY\.\lib\jsp-api-2.0.jar;C:\SEG_CEN\ClienteLBY\.\lib\oracle.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXP.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXPApps.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXPInstall.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXPRoot.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXPSLib.jar;C:\SEG_CEN\ClienteLBY\.\lib\OXPXLib.jar;C:\SEG_CEN\ClienteLBY\.\lib\postgresql.jar;C:\SEG_CEN\ClienteLBY\.\lib\sqlj.jar;C:\SEG_CEN\ClienteLBY\.\lib\sqlServer.jar;C:\SEG_CEN\ClienteLBY\.\lib\sybase.jar;C:\SEG_CEN\ClienteLBY\.\lib\XOXPTools.jar;C:\SEG_CEN\ClienteLBY\.\lib\swing-layout-1.0.jar;C:\SEG_CEN\ClienteLBY\.\lib\PDFRenderer.jar;C:\SEG_CEN\ClienteLBY\.\lib\JasperReports.jar;
java.class.version=50.0
java.endorsed.dirs=C:\Program Files\Java\jdk1.6.0_29\jre\lib\endorsed
java.ext.dirs=C:\Program Files\Java\jdk1.6.0_29\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
java.home=C:\Program Files\Java\jdk1.6.0_29\jre
java.io.tmpdir=C:\Users\CX\AppData\Local\Temp\
java.library.path=C:\Program Files\Java\jdk1.6.0_29\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Java\jdk1.6.0_29\bin;C:\Program Files\Java\jdk1.6.0_29\jre\bin;C:\Program Files\Java\jdk1.6.0_29\jre\bin\client;C:\Program Files\PostgreSQL\8.3\bin;.
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_29-b11
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_29
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=20.4-b02
line.separator=os.arch=x86
os.name=Windows 7
os.version=6.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:\Program Files\Java\jdk1.6.0_29\jre\lib\resources.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\rt.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\jce.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.6.0_29\jre\lib\modules\jdk.boot.jar;C:\Program Files\Java\jdk1.6.0_29\jre\classes
sun.boot.library.path=C:\Program Files\Java\jdk1.6.0_29\jre\bin
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.command=org.openXpertya.OpenXpertya
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=Service Pack 1
suppressSwingDropSupport=true
user.country=AR
user.dir=C:\SEG_CEN\ClienteLBY
user.home=C:\Users\CX
user.language=es
user.name=CX
user.timezone=America/Buenos_Aires
user.variant=19 mayo, 2016 a las 10:25 pm #46107Jorge O. NegreteParticipanteYa resuelto, en la entidad comercial hay que tildar la opcion CUIT duplicado.
-
AutorEntradas