• Este debate está vacío.
Viendo 1 entrada (de un total de 1)
  • Autor
    Entradas
  • #32337
    Ariel Vechetti
    Participante

    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: OXPSYS

    Servidor = 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

Viendo 1 entrada (de un total de 1)
  • Debes estar registrado para responder a este debate.