Alguien puede decirme porq revienta la importacion

Inicio Foros Foro principal Desarrolladores Alguien puede decirme porq revienta la importacion

  • Este debate está vacío.
Viendo 2 entradas - de la 1 a la 2 (de un total de 2)
  • Autor
    Entradas
  • #31523

    Va de nuevo el post con los tag CODE…a ver si esta vezse lee algo.
    Una linea en el archivo de importación de un plan de cuentas personalizado me hace reventar la importación. Alguien se da cuenta de porque?

    Nota: Es otro tema, pero viene al caso. El importador de Plan de Cuenta no controla loops en la estructura de arbol ni duplicidades en las claves de cuenta.

    La linea es:


    4.1.4.01.001,4.1.4.01.001 Otros Ingresos Financieros , Otros Ingresos Financieros ,Revenue,Natural,,No,CH_REVENUE_ACCT,4.0.0.00.000

    El error que da es:

    Acounttype invalide value – Reference_ID=-A-L-R-E-O-M

    Adjunto el traceLog para mayor detalle…

    Code:
    ——————————-
    ———–> Msg.getMsg: NOT found: OXPSYS
    ———–> Msg.getMsg: NOT found: OXPSYS
    ———–> Msg.getMsg: NOT found: OXPSYS
    ———–> Msg.getMsg: NOT found: OXPSYS
    ===========> DB.executeUpdate: Update=UPDATE I_ElementValue SET C_ElementValue_ID=(SELECT C_ElementValue_ID FROM C_ElementValue ev INNER JOIN C_Element e ON (ev.C_Element_ID=e.C_Element_ID) WHERE I_ElementValue.C_Element_ID=e.C_Element_ID AND I_ElementValue.AD_Client_ID=e.AD_Client_ID AND I_ElementValue.Value=ev.Value) WHERE C_ElementValue_ID IS NULL AND I_IsImported=’N’ AND AD_Client_ID=1010016 [ProcessCtl.startProcess_1283906053899] [106]
    org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression; State=21000; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:307)
    at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
    at $Proxy1.executeUpdate(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:227)
    at org.openXpertya.util.DB.executeUpdate(DB.java:839)
    at org.openXpertya.util.DB.executeUpdate(DB.java:800)
    at org.openXpertya.process.ImportAccount.doIt(ImportAccount.java:224)
    at org.openXpertya.process.SvrProcess.process(SvrProcess.java:154)
    at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
    at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:527)
    at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:282)

    ——————————-
    ===========> DB.saveError: DBExecuteErrorrr – ERROR: more than one row returned by a subquery used as an expression [106]
    ——————————-
    ———–> SvrProcess.process: AccountType Invalid value – Reference_ID=117 – A – L – R – E – O – M [106]
    ===========> MPInstance.load: [ProcessCtl.startProcess_1283906053899] – 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=? [106]
    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:134)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:179)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257)
    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.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
    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.(PO.java:177)
    at org.openXpertya.model.PO.
    (PO.java:138)
    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:471)
    at org.openXpertya.process.SvrProcess.process(SvrProcess.java:176)
    at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:114)
    at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:527)
    at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:282)

    ——————————-
    ===========> SvrProcess.unlock: Did not find PInstance 1091257 [106]
    ——————————-
    ===========> MPInstance.load: [ProcessCtl.startProcess_1283906053899] – 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=? [106]
    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:134)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:179)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:437)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:257)
    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.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
    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.(PO.java:177)
    at org.openXpertya.model.PO.
    (PO.java:138)
    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:471)
    at org.openXpertya.process.SvrProcess.startProcess(SvrProcess.java:115)
    at org.openXpertya.apps.ProcessCtl.startProcess(ProcessCtl.java:527)
    at org.openXpertya.apps.ProcessCtl.run(ProcessCtl.java:282)

    ——————————-
    ===========> SvrProcess.unlock: Did not find PInstance 1091257 [106]

    Servidor = servidor : 1099 (No Activo)
    Tunnel=false, Objects=false, Process=false
    Base de datos = SERVIDOR : 5432 / CGNTV
    Esquema = libertya
    Usuario = Supervisor
    Perfil = Administración
    Compañía = Libertya
    Organización = Default
    Fecha = 2010-09-07 00:00:00
    Impresora = Bullzip PDF Printer
    Implementation-Vendor = SERVICIOS_DIGITALES
    Implementation-Title = CCTools Libertya
    Implementation-Version = Libertya 20100315-1119
    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) Client VM 14.0-b16
    Windows 7 6.1
    === Environment === -2002318939
    Libertya (r) Versión 10.03_15-03-2010 – Software Libre de Gestión- (c) 2009 DISYTEL; Implementación: Libertya 20100315-1125 – SERVICIOS_DIGITALES
    servidor/192.168.1.33
    CConnection[name=servidor{SERVIDOR-CGNTV-libertya},AppsHost=servidor,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=SERVIDOR,DBport=5432,DBname=CGNTV,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
    Database=PostgreSQL – 8.3.8 – Driver =PostgreSQL Native Driver – PostgreSQL 8.1 JDBC3 with SSL (build 405) – via DataSource
    DB_PostgreSQL[jdbc:postgresql://SERVIDOR:5432/CGNTV?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 == 1027123
    #AD_User_ID == 100
    #AD_User_Name == Supervisor
    #C_BP_Group_ID == 1010045
    #C_ConversionType_ID == 114
    #C_Country_ID == 119
    #C_Letra_Comprobante_ID == 1010010
    #C_PaymentTerm_ID == 1010083
    #C_Region_ID == 1000027
    #C_TaxCategory_ID == 1010047
    #C_Tax_ID == 1010084
    #C_UOM_ID == 1000000
    #Date == 2010-09-07 00:00:00
    #GL_Category_ID == 1010098
    #M_Locator_ID == 1010278
    #M_PriceList_ID == 1010595
    #M_Product_Category_ID == 1010151
    #M_Warehouse_ID == 1010048
    #Printer == Bullzip PDF Printer
    #SalesRep_ID == 100
    #ShowAcct == Y
    #ShowAdvanced == Y
    #ShowTrl == N
    #StdPrecision == 2
    #SysAdmin == Y
    #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ú
    14|0|AD_Tab_ID == 443
    14|0|AD_Table_ID == 534
    14|0|AccessLevel == 6
    14|0|Name == Importar Cuenta Contable
    14|0|SQL == SELECT IsActive,I_ElementValue_ID,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
    14|AD_Client_ID == 1010016
    14|AD_Org_ID == 1010053
    14|AutoCommit == N
    14|BaseTable_ID == 534
    14|CreateNewCombination == Y
    14|Created == 2010-09-08 00:33:53.6
    14|CreatedBy == 100
    14|Default_Account == default_account
    14|DeleteOldImported == true
    14|Description == acct_descp
    14|I_ElementValue_ID == 1022447
    14|I_IsImported == N
    14|IsActive == Y
    14|IsDocControlled == N
    14|IsSOTrx == Y
    14|IsSummary == N
    14|Name == acct_name
    14|ParentValue == Nro Cta Superior
    14|PostActual == Y
    14|PostBudget == Y
    14|PostEncumbrance == Y
    14|PostStatistical == Y
    14|Processed == N
    14|UpdateDefaultAccounts == true
    14|Updated == 2010-09-08 00:33:53.
    14|UpdatedBy == 100
    14|Value == acct_value
    14|WindowName == Importar Cuenta Contable
    AutoCommit == N
    P1010098|InventoryKind == IO
    P103|Type == S
    P140|C_UOM_ID == 100
    P143|C_BPartner_ID == 1012142
    P143|SalesRep_ID == 1010717
    P189|DataType == S
    P|AD_FTDoc == 1002145
    P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
    P|LOCAL_AR == Y
    java.naming.provider.url == jnp://servidor:1099

    === System ===
    awt.toolkit=sun.awt.windows.WToolkit
    file.encoding=Cp1252
    file.encoding.pkg=sun.io
    file.separator=
    java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
    java.awt.printerjob=sun.awt.windows.WPrinterJob
    java.class.path=C:UsersCOGNIT~1AppDataLocalTemptemp149.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_14jrelibendorsed
    java.ext.dirs=C:Program FilesJavajdk1.6.0_14jrelibext;C:WindowsSunJavalibext
    java.home=C:Program FilesJavajdk1.6.0_14jre
    java.io.tmpdir=C:UsersCOGNIT~1AppDataLocalTemp
    java.library.path=C:Program FilesJavajdk1.6.0_14bin;.;C:WindowsSunJavabin;C:Windowssystem32;C:Windows;C:Windowssystem32;C:Windows;C:WindowsSystem32Wbem;C:WindowsSystem32WindowsPowerShellv1.0;C:Program FilesATI TechnologiesATI.ACECore-Static;C:Program FilesPostgreSQL8.3bin;C:Program FilesJavajdk1.6.0_14bin;C:Program FilesJavajdk1.6.0_14jrebin;C:Program FilesJavajdk1.6.0_14jrebinclient;bin;C:Program FilesIDM Computer SolutionsUltraEdit
    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
    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 7
    os.version=6.1
    path.separator=;
    sun.arch.data.model=32
    sun.boot.class.path=C:Program FilesJavajdk1.6.0_14jrelibresources.jar;C:Program FilesJavajdk1.6.0_14jrelibrt.jar;C:Program FilesJavajdk1.6.0_14jrelibsunrsasign.jar;C:Program FilesJavajdk1.6.0_14jrelibjsse.jar;C:Program FilesJavajdk1.6.0_14jrelibjce.jar;C:Program FilesJavajdk1.6.0_14jrelibcharsets.jar;C:Program FilesJavajdk1.6.0_14jreclasses
    sun.boot.library.path=C:Program FilesJavajdk1.6.0_14jrebin
    sun.cpu.endian=little
    sun.cpu.isalist=
    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=
    user.country=AR
    user.dir=C:UserscognitivaAppDataRoamingMicrosoftWindowsStart MenuProgramsLibertya
    user.home=C:Userscognitiva
    user.language=es
    user.name=cognitiva
    user.timezone=America/Buenos_Aires
    user.variant=

    EDITADO: El foro requiere tags code con corchetes en lugar de simbolos menor y mayor.

    #34955

    Bueno, ignoro porque pinchaba pero de todas formas lo resolví de otra manera. De todas formas no se puede importar cuentas por defecto.

Viendo 2 entradas - de la 1 a la 2 (de un total de 2)
  • Debes estar registrado para responder a este debate.