[Cognitiva Consultores]

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.

[Cognitiva Consultores]

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

[Autor]

Entradas