- Este debate está vacío.
-
AutorEntradas
-
8 abril, 2013 a las 11:48 am #32337Ariel VechettiParticipante
Al importar la cuentas no me agrega ningún registro porque se produce el error del log ajunto. Alguna idea?
===========> DB.executeUpdate: Update=ALTER TABLE C_ValidCombination DISABLE TRIGGER ALL [null] [171]
org.postgresql.util.PSQLException: ERROR: permiso denegado: «RI_ConstraintTrigger_362369» es un trigger de sistema; State=42501; 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.util.DB.executeUpdate(DB.java:907)
at org.openXpertya.util.DB.executeUpdate(DB.java:892)
at org.openXpertya.util.DB.executeUpdate(DB.java:848)
at org.openXpertya.process.ImportAccount.doIt(ImportAccount.java:229)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:158)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:582)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:291)===========> DB.saveError: DBExecuteErrorrr – ERROR: permiso denegado: «RI_ConstraintTrigger_362369» es un trigger de sistema [171]
===========> DB.executeUpdate: Update=ALTER TABLE C_ValidCombination ENABLE TRIGGER ALL [ProcessCtl.startProcess_1365366545204] [171]
org.postgresql.util.PSQLException: ERROR: permiso denegado: «RI_ConstraintTrigger_362369» es un trigger de sistema; State=42501; 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.util.DB.executeUpdate(DB.java:907)
at org.openXpertya.util.DB.executeUpdate(DB.java:892)
at org.openXpertya.util.DB.executeUpdate(DB.java:862)
at org.openXpertya.process.ImportAccount.doIt(ImportAccount.java:376)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:158)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:582)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:291)===========> DB.saveError: DBExecuteErrorrr – ERROR: permiso denegado: «RI_ConstraintTrigger_362369» es un trigger de sistema [171]
===========> DB.executeUpdate: Update=UPDATE C_ValidCombination SET Updated=CURRENT_TIMESTAMP WHERE AD_Client_ID=1010016 [ProcessCtl.startProcess_1365366545204] [171]
org.postgresql.util.PSQLException: ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción; State=25P02; 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.util.DB.executeUpdate(DB.java:907)
at org.openXpertya.util.DB.executeUpdate(DB.java:892)
at org.openXpertya.util.DB.executeUpdate(DB.java:862)
at org.openXpertya.process.ImportAccount.doIt(ImportAccount.java:381)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:158)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:582)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:291)===========> DB.saveError: DBExecuteErrorrr – ERROR: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción [171]
===========> MPInstance.load: [ProcessCtl.startProcess_1365366545204] – AD_PInstance_ID=0, SQL=SELECT AD_Client_ID,AD_Org_ID,AD_PInstance_ID,AD_Process_ID,AD_User_ID,Created,CreatedBy,ErrorMsg,IsActive,IsProcessing,Record_ID,Result,Updated,UpdatedBy FROM AD_PInstance WHERE AD_PInstance_ID=? [171]
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:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.load(PO.java:1280)
at org.openXpertya.model.PO.load(PO.java:1236)
at org.openXpertya.model.PO.initialize(PO.java:218)
at org.openXpertya.model.PO.(PO.java:204)
at org.openXpertya.model.PO.(PO.java:155)
at org.openXpertya.model.X_AD_PInstance.(X_AD_PInstance.java:15)
at org.openXpertya.model.MPInstance.(MPInstance.java:110)
at org.openXpertya.process.SvrProcess.unlock(SvrProcess.java:475)
at org.openXpertya.process.SvrProcess.process(SvrProcess.java:180)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:582)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:291)===========> SvrProcess.unlock: Did not find PInstance 1092107 [171]
===========> MPInstance.load: [ProcessCtl.startProcess_1365366545204] – AD_PInstance_ID=0, SQL=SELECT AD_Client_ID,AD_Org_ID,AD_PInstance_ID,AD_Process_ID,AD_User_ID,Created,CreatedBy,ErrorMsg,IsActive,IsProcessing,Record_ID,Result,Updated,UpdatedBy FROM AD_PInstance WHERE AD_PInstance_ID=? [171]
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:178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:205)
at org.openXpertya.model.PO.load(PO.java:1280)
at org.openXpertya.model.PO.load(PO.java:1236)
at org.openXpertya.model.PO.initialize(PO.java:218)
at org.openXpertya.model.PO.(PO.java:204)
at org.openXpertya.model.PO.(PO.java:155)
at org.openXpertya.model.X_AD_PInstance.(X_AD_PInstance.java:15)
at org.openXpertya.model.MPInstance.(MPInstance.java:110)
at org.openXpertya.process.SvrProcess.unlock(SvrProcess.java:475)
at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:115)
at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:582)
at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:291)===========> SvrProcess.unlock: Did not find PInstance 1092107 [171]
> Msg.getMsg: NOT found: OXPSYS
> Msg.getMsg: NOT found: OXPSYSServidor = no001 : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = localhost : 5434 / libertya
Esquema = libertya
Usuario = AdminLibertya
Perfil = Administración
Compañía = Libertya
Organización = Default
Fecha = 2013-04-07 00:00:00
Impresora = HP_LaserJet_CP1025nw
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 20.14-b01
Linux 3.5.0-26-generic unknown
=== Environment === 403368704
Libertya (r) Versión 13.01_21-01-2013 – Software Libre de Gestión- (c) 2011 DISYTEL; Implementación: Versión 13.01 20130317-1820 – ${env.CONSULTORA_OXP}
NO001/127.0.1.1
CConnection[name=no001{localhost-libertya-libertya},AppsHost=no001,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=localhost,DBport=5434,DBname=libertya,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
Database=PostgreSQL – 8.4.8 – Driver =PostgreSQL Native Driver – PostgreSQL 9.0 JDBC4 (build 801) – via DataSource
DB_PostgreSQL[jdbc:postgresql://localhost:5434/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 == 1010076
#AD_Role_Name == Administración
#AD_Session_ID == 1028253
#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 == 1010039
#C_PaymentTerm_ID == 1010083
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010047
#C_Tax_ID == 1010084
#C_UOM_ID == 1000000
#CheckCuitControl == N
#Date == 2013-04-07 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 == HP_LaserJet_CP1025nw
#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ú
5|0|AD_Tab_ID == 443
5|0|AD_Table_ID == 534
5|0|AccessLevel == 6
5|0|IsActive == Y
5|0|Name == Importar Cuenta Contable
5|0|Processed == N
5|0|SQL == SELECT I_ElementValue_ID,IsActive,I_IsImported,C_ElementValue_ID,I_ErrorMsg,AD_Client_ID,AD_Org_ID,ElementName,C_Element_ID,Value,Name,Description,AccountType,AccountSign,IsSummary,ParentValue,ParentElementValue_ID,PostActual,PostBudget,PostStatistical,PostEncumbrance,IsDocControlled,Default_Account,AD_Column_ID,Processing,Processed,Created,CreatedBy,Updated,UpdatedBy FROM I_ElementValue WHERE I_ElementValue.AD_Client_ID IN(0,1010016) AND I_ElementValue.AD_Org_ID IN(0,1010053) ORDER BY I_ElementValue_ID
5|AD_Client_ID == 1010016
5|AD_Org_ID == 1010053
5|AutoCommit == Y
5|BaseTable_ID == 534
5|CreateNewCombination == Y
5|Created == 2013-04-07 14:12:58.0973
5|CreatedBy == 1010717
5|Default_Account == default_account
5|DeleteOldImported == N
5|Description == acct_descp
5|I_ElementValue_ID == 1013584
5|I_IsImported == N
5|IsActive == Y
5|IsDocControlled == N
5|IsSOTrx == Y
5|IsSummary == N
5|Name == acct_name
5|ParentValue == Nro Cta Superior
5|PostActual == Y
5|PostBudget == Y
5|PostEncumbrance == Y
5|PostStatistical == Y
5|Processed == N
5|UpdateDefaultAccounts == N
5|Updated == 2013-04-07 14:13:54.1
5|UpdatedBy == 1010717
5|Value == acct_value
5|WindowName == Importar Cuenta Contable
AutoCommit == Y
P1010098|InventoryKind == IO
P103|Type == S
P189|DataType == S
P|AD_FTDoc == 1002145
P|AllowExchangeDifference == 0.01
P|AuditReferenceCurrencyISOCode == USD
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|DIF_CAMBIO_ARTICULO == 10000001
P|DIF_CAMBIO_PTO_VENTA == 1
P|InfoMaxRowsAllowed == 1000
P|InfoRowCountMethod == C
P|LOCAL_AR == Y
P|L_AR_CFMontoMaximo == 1000
P|L_AR_MaxOrderLineQty == 999
P|LookupMaxRowsAllowed == 1000
P|MantenimientoPadron == 3
P|OpenTrxLowerLimit == 6
P|OpenTrxTimeOutMS == 3600000
P|OpenTrxUpperLimit == 10
P|POSCashJounal_ValidDiff == 0.5
P|ReplicationEventsActive == Y
P|TransferDueDateDays == 1
java.naming.provider.url == jnp://no001:1099=== System ===
OXP_HOME=
file.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/jdk1.6.0/jre/lib/endorsed
java.ext.dirs=/usr/lib/jvm/jdk1.6.0/jre/lib/ext:/usr/java/packages/lib/ext
java.home=/usr/lib/jvm/jdk1.6.0/jre
java.io.tmpdir=/tmp
java.library.path=/usr/lib/jvm/jdk1.6.0/jre/lib/i386/server:/usr/lib/jvm/jdk1.6.0/jre/lib/i386:/usr/lib/jvm/jdk1.6.0/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_39-b04
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_39
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=20.14-b01
line.separator=os.arch=i386
os.name=Linux
os.version=3.5.0-26-generic
path.separator=:
sun.arch.data.model=32
sun.boot.class.path=/usr/lib/jvm/jdk1.6.0/jre/lib/resources.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/rt.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/sunrsasign.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/jsse.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/jce.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/charsets.jar:/usr/lib/jvm/jdk1.6.0/jre/lib/modules/jdk.boot.jar:/usr/lib/jvm/jdk1.6.0/jre/classes
sun.boot.library.path=/usr/lib/jvm/jdk1.6.0/jre/lib/i386
sun.cpu.endian=little
sun.cpu.isalist=
sun.io.unicode.encoding=UnicodeLittle
sun.java.command=org.openXpertya.OpenXpertya
sun.java.launcher=SUN_STANDARD
sun.jnu.encoding=UTF-8
sun.management.compiler=HotSpot Tiered Compilers
sun.os.patch.level=unknown
suppressSwingDropSupport=true
user.country=AR
user.dir=/opt/ServidorOXP
user.home=/home/ariel
user.language=es
user.name=ariel
user.timezone=America/Argentina/Buenos_Aires -
AutorEntradas
- Debes estar registrado para responder a este debate.