Respuestas de foro creadas
-
AutorEntradas
-
17 febrero, 2010 a las 11:45 pm en respuesta a: IniDialog.cmd_reject: Licencia rehusada o no encontrada #34092
Hermann D. Schimpf
MiembroOtro dato recien obtenido:
Si copiamos el fichero Libertya.properties desde la PC2 la cual funciona correctamente sobre el sistema a otra PC donde no funciona, el cliente accede al sistema.
Porque sucede esto?16 febrero, 2010 a las 7:34 pm en respuesta a: Problema con articulos, clientes y proveedores. #34077Hermann D. Schimpf
MiembroBueno, respondo mi mismo tema con la solucion al problema.
El inconveniente era configuracion del pljava. La instalacion del mismo esta funcionando correctamente, solo que lo que sucedio es lo siguiente.
Se instalaron dos servidores con libertya con la misma configuracion sobre servidores ubuntu. Luego de ello se instalo un sistema de replica, y en la instalacion de este se solicitaba el servidor y el nombre de la base de datos a replicar. El problema es que el sistema utiliza el nombre de la base de datos como clave primaria de la db a replicar. Entonces en uno de los servidores se modifico el nombre de la base de datos.
El pljava cuando se configura se le especifica el nombre de la base de datos y al modificar este quedo buscando un esquema que no existia. Se resolvio sencillamente ejecutando nuevamente la consulta:
psql -d libertya -U libertya -c “select sqlj.install_jar(‘file:///ServidorOXP/lib/sqlj.jar’, ‘libertya’, true); select sqlj.set_classpath(‘libertya’, ‘libertya’);”
especificando el nuevo nombre de la base de datosHermann D. Schimpf
15 febrero, 2010 a las 2:23 pm en respuesta a: Problema con articulos, clientes y proveedores. #34076Hermann D. Schimpf
MiembroCode:——————————-
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
===========> MTab.getTrxInfo: OrderSummary={0} Línea(s) – {1,NUMERIC,#,##0.00} – Total: {2,NUMERIC,#,##0.00} {3} = {4,NUMERIC,#,##0.00} [11]
java.lang.IllegalArgumentException: unknown format type at
at java.text.MessageFormat.makeFormat(Unknown Source)
at java.text.MessageFormat.applyPattern(Unknown Source)
at java.text.MessageFormat.(Unknown Source)
at org.openXpertya.model.MTab.getTrxInfo(MTab.java:1722)
at org.openXpertya.apps.APanel.dataStatusChanged(APanel.java:1064)
at org.openXpertya.model.MTab.fireDataStatusChanged(MTab.java:2215)
at org.openXpertya.model.MTab.dataStatusChanged(MTab.java:2159)
at org.openXpertya.model.MTable.fireDataStatusChanged(MTable.java:3416)
at org.openXpertya.model.MTable.fireDataStatusIEvent(MTable.java:3454)
at org.openXpertya.model.MTable.dataIgnore(MTable.java:2940)
at org.openXpertya.model.MTab.dataIgnore(MTab.java:938)
at org.openXpertya.apps.APanel.cmd_ignore(APanel.java:1691)
at org.openXpertya.apps.APanel.actionPerformed(APanel.java:1498)
at org.openXpertya.apps.AppsAction.actionPerformed(AppsAction.java:292)——————————-
===========> InfoProduct.run: SELECT DISTINCT(p.M_Product_ID), p.Value, p.Name, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHand, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product_ID,?,0) AS QtyOrdered FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive=’Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) WHERE p.IsActive=’Y’ AND p.IsSummary=’N’ AND pr.M_PriceList_Version_ID=? AND p.AD_Client_ID IN(0,1000010) AND p.AD_Org_ID IN(0,1000047,1010047) ORDER BY QtyAvailable ASC [62]
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.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy1.executeQuery(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:183)
at org.openXpertya.apps.search.Info$Worker.run(Info.java:1222)Servidor = 192.168.0.6 : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = 192.168.0.6 : 5432 / libertyaAsu
Esquema = libertya
Usuario = jpetrik
Perfil = Compras
Compañía = Multipartes S.R.L.
Organización = Casa Central
Fecha = 2010-02-15 00:00:00
Impresora = Microsoft XPS Document Writer
OXPHome = ServidorOXP
Language=[es_PY,Locale=es_PY,AD_Language=es_PY,DatePattern=DD/MM/YYYY,DecimalPoint=false]
MClient[1000010-Multipartes]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 14.2-b01
Windows XP 5.1 Service Pack 2
=== Environment === -1095885033
Libertya (r) Versión 09.10_26-10-2009 – Software Libre de Gestión- (c) 2009 DISYTEL; Implementación: Libertya 20100202-1238 – SERVICIOS_DIGITALES
DG3HQLB1/192.168.0.10
CConnection[name=192.168.0.6{192.168.0.6-libertyaAsu-libertya},AppsHost=192.168.0.6,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=192.168.0.6,DBport=5432,DBname=libertyaAsu,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://192.168.0.6:5432/libertyaAsu?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true=== Context ===
#AD_Client_ID == 1000010
#AD_Client_Name == Multipartes S.R.L.
#AD_Language == es_PY
#AD_Org_ID == 1000047
#AD_Org_Name == Casa Central
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010068
#AD_Role_Name == Compras
#AD_Session_ID == 1027183
#AD_User_ID == 1010711
#AD_User_Name == jpetrik
#C_ConversionType_ID == 201
#C_Country_ID == 276
#C_PaymentTerm_ID == 1000077
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010044
#C_Tax_ID == 1000078
#C_UOM_ID == 1000000
#Date == 2010-02-15 00:00:00
#GL_Category_ID == 1000092
#M_Locator_ID == 1000272
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1000140
#M_Warehouse_ID == 1000042
#Printer == Microsoft XPS Document Writer
#SalesRep_ID == 1010711
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == Y
#StdPrecision == 2
#User_Level == CO
#User_Org == 1000047,1010047,0
#YYYY == Y
$C_AcctSchema_ID == 1000010
$C_Currency_ID == 344
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$HasAlias == Y
0|WindowName == Menú
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_Product_ID == 0
2|0|AD_Tab_ID == 294
2|0|AD_Table_ID == 259
2|0|AccessLevel == 1
2|0|Name == Pedido a Proveedor
2|0|SQL == SELECT Bill_User_ID,C_Payment_ID,C_Repair_Order_ID,C_CashLine_ID,Acceptance,Processing,IsTaxIncluded,C_Order_ID,Pay_BPartner_ID,Pay_Location_ID,Ref_Order_ID,IsCreditApproved,IsPrinted,IsTransferred,DatePrinted,Processed,DateAcct,IsInvoiced,IsDelivered,IsActive,DeliveryRule,repair_priority,InvoiceRule,repair_state,IsApproved,IsSelfService,IsSelected,Bill_Location_ID,IsSOTrx,Bill_BPartner_ID,SendEMail,program_invoice,AD_Client_ID,AD_Org_ID,DocumentNo,POReference,Description,C_DocTypeTarget_ID,DateOrdered,DatePromised,dateprod,daterealprod,C_BPartner_ID,CreateVendorProductLines,C_BPartner_Location_ID,M_Warehouse_ID,IsDropShip,DeliveryViaRule,M_Shipper_ID,FreightCostRule,FreightAmt,PriorityRule,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID,SalesRep_ID,IsDiscountPrinted,C_Charge_ID,ChargeAmt,PaymentRule,C_PaymentTerm_ID,C_Activity_ID,AD_OrgTrx_ID,User1_ID,User2_ID,DocStatus,C_DocType_ID,TotalLines,GrandTotal,CopyFrom,DocAction,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_Order WHERE IsSOTrx=’N’ AND (Processed=’N’ OR Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as interval))) AND C_Order.AD_Client_ID IN(0,1000010) AND C_Order.AD_Org_ID IN(0,1000047,1010047) ORDER BY DocumentNo DESC
2|1|AD_Tab_ID == 293
2|1|AD_Table_ID == 260
2|1|AccessLevel == 1
2|1|LinkColumnName == C_Order_ID
2|1|Name == Línea Ped. Proveedor
2|1|SQL == SELECT IsActive,OpenMatrix,PriceLimit,Processed,QtyReserved,Ref_OrderLine_ID,IsDescription,M_Warehouse_ID,S_ResourceAssignment_ID,QtyDelivered,QtyInvoiced,C_BPartner_Location_ID,M_Shipper_ID,DateInvoiced,DateDelivered,DatePromised,C_OrderLine_ID,C_Currency_ID,Line,AD_Client_ID,AD_Org_ID,C_Order_ID,C_BPartner_ID,DateOrdered,M_Product_ID,M_AttributeSetInstance_ID,C_Charge_ID,QtyEntered,C_UOM_ID,PriceActual,QtyOrdered,PriceEntered,Description,PriceList,FreightAmt,C_Tax_ID,Discount,LineNetAmt,Created,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE C_Order_ID=1013971 AND C_OrderLine.AD_Client_ID IN(0,1000010) AND C_OrderLine.AD_Org_ID IN(0,1000047,1010047) ORDER BY Line
2|2|AD_Tab_ID == 692
2|2|AD_Table_ID == 473
2|2|AccessLevel == 3
2|2|LinkColumnName == C_OrderLine_ID
2|2|Name == Correspondencias
2|AD_Client_ID == 1000010
2|AD_Org_ID == 1000047
2|Acceptance == 0
2|AutoCommit == Y
2|BaseTable_ID == 259
2|Bill_BPartner_ID == 1012145
2|Bill_Location_ID == 1012156
2|C_BPartner_ID == 1012145
2|C_ConversionType_ID == 201
2|C_Currency_ID == 344
2|C_DocTypeTarget_ID == 1010516
2|C_DocType_ID == 0
2|C_Order_ID == 1013971
2|C_PaymentTerm_ID == 1010078
2|C_Tax_ID == 1000078
2|ChargeAmt == 0.00
2|CopyFrom == N
2|CreateVendorProductLines == N
2|DateAcct == 2010-02-15 00:00:00
2|DateOrdered == 2010-02-15 00:00:00
2|DatePromised == 2010-02-15 00:00:00
2|DeliveryRule == A
2|DeliveryViaRule == P
2|Discount == 0
2|DocAction == CO
2|DocStatus == DR
2|DocTypeKey == POO
2|DocumentNo == 800009
2|FreightAmt == 0
2|FreightCostRule == I
2|GrandTotal == 0.00
2|InvoiceRule == D
2|IsActive == Y
2|IsApproved == N
2|IsCreditApproved == N
2|IsDelivered == N
2|IsDescription == N
2|IsDiscountPrinted == N
2|IsDropShip == N
2|IsInvoiced == N
2|IsPrinted == N
2|IsSOTrx == N
2|IsSelected == N
2|IsSelfService == N
2|IsTaxIncluded == N
2|IsTransferred == N
2|Line == 10
2|LineNetAmt == 0
2|M_PriceList_ID == 1010590
2|M_PriceList_Version_ID == 1010519
2|M_Warehouse_ID == 1000042
2|OpenMatrix == N
2|PaymentRule == P
2|Posted == N
2|PriceActual == 0
2|PriceEntered == 0
2|PriceLimit == 0
2|PriceList == 0
2|PriorityRule == 5
2|Processed == N
2|Processing == N
2|QtyDelivered == 0
2|QtyEntered == 1
2|QtyInvoiced == 0
2|QtyOrdered == 1
2|QtyReserved == 0
2|SalesRep_ID == 1010711
2|SendEMail == N
2|TotalLines == 0.00
2|WindowName == Pedido a Proveedor
AutoCommit == Y
P103|Type == S
P123|AD_User_ID == -1
P138|C_Region_ID == -1
P140|C_TaxCategory_ID == 1010044
P140|C_UOM_ID == 100
P143|C_BPartner_ID == 1002136
P189|DataType == S
P192|AD_Org_ID == 0
P|AD_FTDoc == 1002145
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|LOCAL_AR == N
java.naming.provider.url == jnp://192.168.0.6:1099=== System ===
awt.toolkit=sun.awt.windows.WToolkit
deployment.browser.path=C:Archivos de programaInternet ExplorerIEXPLORE.EXE
deployment.browser.vm.iexplorer=true
deployment.browser.vm.mozilla=true
deployment.cache.enabled=true
deployment.cache.jarcompression=0
deployment.cache.max.size=-1
deployment.capture.mime.types=false
deployment.console.startup.mode=HIDE
deployment.control.panel.log=false
deployment.javapi.cache.update=false
deployment.javapi.lifecycle.exception=false
deployment.javapi.log.filename=
deployment.javapi.runtime.type=0
deployment.javapi.trace.filename=
deployment.javaws.associations=ASK_USER
deployment.javaws.autodownload=ALWAYS
deployment.javaws.cache.update=false
deployment.javaws.home.jnlp.url=http://java.sun.com/products/javawebstart
deployment.javaws.installURL=http://java.sun.com/products/autodl/j2se
deployment.javaws.logFileName=
deployment.javaws.muffin.max=256
deployment.javaws.shortcut=ASK_IF_HINTED
deployment.javaws.splash.index=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache6.0splashsplash.xml
deployment.javaws.ssv.enabled=true
deployment.javaws.traceFileName=
deployment.javaws.uninstall.shortcut=false
deployment.javaws.update.timeout=1500
deployment.javaws.version=javaws-1.4.2_03
deployment.jpi.mode.new=true
deployment.log=false
deployment.max.output.file.size=10
deployment.max.output.files=5
deployment.mime.types.use.default=true
deployment.proxy.bypass.local=false
deployment.proxy.override.hosts=
deployment.proxy.same=false
deployment.proxy.type=3
deployment.repository.askdownloaddialog.show=true
deployment.repository.enabled=true
deployment.security.SSLv2Hello=false
deployment.security.SSLv3=true
deployment.security.TLSv1=true
deployment.security.askgrantdialog.notinca=true
deployment.security.askgrantdialog.show=true
deployment.security.authenticator=true
deployment.security.blacklist.check=true
deployment.security.browser.keystore.use=true
deployment.security.clientauth.keystore.auto=true
deployment.security.expired.warning=true
deployment.security.https.warning.show=false
deployment.security.jsse.hostmismatch.warning=true
deployment.security.notinca.warning=true
deployment.security.password.cache=true
deployment.security.pretrust.list=true
deployment.security.sandbox.awtwarningwindow=true
deployment.security.sandbox.jnlp.enhanced=true
deployment.security.trusted.policy=
deployment.security.validation.crl=false
deployment.security.validation.ocsp=false
deployment.system.security.blacklist=C:Archivos de programaJavajre6libsecurityblacklist
deployment.system.security.cacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.jssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.oldcacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.oldjssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.trusted.certs=C:Archivos de programaJavajre6libsecuritytrusted.certs
deployment.system.security.trusted.clientauthcerts=C:Archivos de programaJavajre6libsecuritytrusted.clientcerts
deployment.system.security.trusted.jssecerts=C:Archivos de programaJavajre6libsecuritytrusted.jssecerts
deployment.system.security.trusted.publishers=C:Archivos de programaJavajre6libsecuritytrusted.publishers
deployment.system.tray.icon=true
deployment.trace=false
deployment.update.mime.types=true
deployment.user.cachedir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache
deployment.user.extdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentext
deployment.user.logdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentlog
deployment.user.security.blacklist=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityblacklist
deployment.user.security.policy=file://C:/Documents%20and%20Settings/user/Datos%20de%20programa/Sun/Java/Deployment/security/java.policy
deployment.user.security.saved.credentials=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityauth.dat
deployment.user.security.trusted.cacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.cacerts
deployment.user.security.trusted.certs=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.certs
deployment.user.security.trusted.clientauthcerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.clientcerts
deployment.user.security.trusted.jssecacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecacerts
deployment.user.security.trusted.jssecerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecerts
deployment.user.security.trusted.publishers=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.publishers
deployment.user.tmp=C:Documents and SettingsuserDatos de programaSunJavaDeploymenttmp
deployment.version=6.0
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=
http.auth.serializeRequests=true
https.protocols=TLSv1,SSLv3
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:Archivos de programaJavajre6libdeploy.jar
java.class.version=50.0
java.endorsed.dirs=C:Archivos de programaJavajre6libendorsed
java.ext.dirs=C:Archivos de programaJavajre6libext;C:WINDOWSSunJavalibext
java.home=C:Archivos de programaJavajre6
java.io.tmpdir=C:DOCUME~1userCONFIG~1Temp
java.library.path=C:Archivos de programaJavajre6bin;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:Archivos de programaJavajre6bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;”C:Archivos de programaJavajre6bin”
java.protocol.handler.pkgs=com.sun.javaws.net.protocol|com.sun.deploy.net.protocol
java.quick.starter=true
java.rmi.server.RMIClassLoaderSpi=com.sun.jnlp.JNLPRMIClassLoaderSpi
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_16-b01
java.security.policy=file:C:Archivos de programaJavajre6libsecurityjavaws.policy
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_16
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=14.2-b01
javaplugin.proxy.config.type=direct
javawebstart.version=javaws-1.6.0_16
jnlpx.heapsize=33554432,536870912
jnlpx.home=C:Archivos de programaJavajre6bin
jnlpx.jvm=C:Archivos de programaJavajre6binjavaw.exe
jnlpx.offline=false
jnlpx.relaunch=true
jnlpx.remove=false
jnlpx.splashport=1568
jnlpx.vmargs=-Xmx512m -Xms32m
line.separator=os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Archivos de programaJavajre6libresources.jar;C:Archivos de programaJavajre6librt.jar;C:Archivos de programaJavajre6libsunrsasign.jar;C:Archivos de programaJavajre6libjsse.jar;C:Archivos de programaJavajre6libjce.jar;C:Archivos de programaJavajre6libcharsets.jar;C:Archivos de programaJavajre6classes;C:Archivos de programaJavajre6libjavaws.jar;C:Archivos de programaJavajre6libdeploy.jar;C:Archivos de programaJavajre6libplugin.jar
sun.boot.library.path=C:Archivos de programaJavajre6bin
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.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=Service Pack 2
trustProxy=true
user.country=PY
user.dir=C:Documents and SettingsuserEscritorio
user.home=C:Documents and Settingsuser
user.language=es
user.name=user
user.timezone=America/Guyana
user.variant=15 febrero, 2010 a las 2:22 pm en respuesta a: Problema con articulos, clientes y proveedores. #34075Hermann D. Schimpf
MiembroCode:——————————-
———–> Msg.getMsg: NOT found: OXPSYS [11]
———–> Msg.getMsg: NOT found: OXPSYS [11]
===========> MTab.getTrxInfo: OrderSummary={0} Línea(s) – {1,NUMERIC,#,##0.00} – Total: {2,NUMERIC,#,##0.00} {3} = {4,NUMERIC,#,##0.00} [11]
java.lang.IllegalArgumentException: unknown format type at
at java.text.MessageFormat.makeFormat(Unknown Source)
at java.text.MessageFormat.applyPattern(Unknown Source)
at java.text.MessageFormat.(Unknown Source)
at org.openXpertya.model.MTab.getTrxInfo(MTab.java:1722)
at org.openXpertya.apps.APanel.dataStatusChanged(APanel.java:1064)
at org.openXpertya.model.MTab.fireDataStatusChanged(MTab.java:2215)
at org.openXpertya.model.MTab.dataStatusChanged(MTab.java:2159)
at org.openXpertya.model.MTable.fireDataStatusChanged(MTable.java:3416)
at org.openXpertya.model.MTable.fireDataStatusIEvent(MTable.java:3454)
at org.openXpertya.model.MTable.dataIgnore(MTable.java:2940)
at org.openXpertya.model.MTab.dataIgnore(MTab.java:938)
at org.openXpertya.apps.APanel.cmd_ignore(APanel.java:1691)
at org.openXpertya.apps.APanel.actionPerformed(APanel.java:1498)
at org.openXpertya.apps.AppsAction.actionPerformed(AppsAction.java:292)——————————-
===========> InfoProduct.run: SELECT DISTINCT(p.M_Product_ID), p.Value, p.Name, bomQtyAvailable(p.M_Product_ID,?,0) AS QtyAvailable, bomPriceList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomPriceStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, bomQtyOnHand(p.M_Product_ID,?,0) AS QtyOnHand, bomQtyReserved(p.M_Product_ID,?,0) AS QtyReserved, bomQtyOrdered(p.M_Product_ID,?,0) AS QtyOrdered FROM M_Product p LEFT OUTER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID AND pr.IsActive=’Y’) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) WHERE p.IsActive=’Y’ AND p.IsSummary=’N’ AND pr.M_PriceList_Version_ID=? AND p.AD_Client_ID IN(0,1000010) AND p.AD_Org_ID IN(0,1000047,1010047) ORDER BY QtyAvailable ASC [62]
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.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
at $Proxy1.executeQuery(Unknown Source)
at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:183)
at org.openXpertya.apps.search.Info$Worker.run(Info.java:1222)Servidor = 192.168.0.6 : 1099 (No Activo)
Tunnel=false, Objects=false, Process=false
Base de datos = 192.168.0.6 : 5432 / libertyaAsu
Esquema = libertya
Usuario = jpetrik
Perfil = Compras
Compañía = Multipartes S.R.L.
Organización = Casa Central
Fecha = 2010-02-15 00:00:00
Impresora = Microsoft XPS Document Writer
OXPHome = ServidorOXP
Language=[es_PY,Locale=es_PY,AD_Language=es_PY,DatePattern=DD/MM/YYYY,DecimalPoint=false]
MClient[1000010-Multipartes]
Documentos Multi-idioma = false
BaseLanguage = false/false
PDF License=true
Java HotSpot(TM) Client VM 14.2-b01
Windows XP 5.1 Service Pack 2
=== Environment === -1095885033
Libertya (r) Versión 09.10_26-10-2009 – Software Libre de Gestión- (c) 2009 DISYTEL; Implementación: Libertya 20100202-1238 – SERVICIOS_DIGITALES
DG3HQLB1/192.168.0.10
CConnection[name=192.168.0.6{192.168.0.6-libertyaAsu-libertya},AppsHost=192.168.0.6,AppsPort=1099,RMIoverHTTP=false,type=PostgreSQL,DBhost=192.168.0.6,DBport=5432,DBname=libertyaAsu,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://192.168.0.6:5432/libertyaAsu?encoding=UTF-8]
AppsServerOK=false, DatabaseOK=true=== Context ===
#AD_Client_ID == 1000010
#AD_Client_Name == Multipartes S.R.L.
#AD_Language == es_PY
#AD_Org_ID == 1000047
#AD_Org_Name == Casa Central
#AD_PrintColor_ID == 100
#AD_PrintFont_ID == 130
#AD_PrintPaper_ID == 103
#AD_PrintTableFormat_ID == 1000006
#AD_Role_ID == 1010068
#AD_Role_Name == Compras
#AD_Session_ID == 1027183
#AD_User_ID == 1010711
#AD_User_Name == jpetrik
#C_ConversionType_ID == 201
#C_Country_ID == 276
#C_PaymentTerm_ID == 1000077
#C_Region_ID == 1000027
#C_TaxCategory_ID == 1010044
#C_Tax_ID == 1000078
#C_UOM_ID == 1000000
#Date == 2010-02-15 00:00:00
#GL_Category_ID == 1000092
#M_Locator_ID == 1000272
#M_PriceList_ID == 1010595
#M_Product_Category_ID == 1000140
#M_Warehouse_ID == 1000042
#Printer == Microsoft XPS Document Writer
#SalesRep_ID == 1010711
#ShowAcct == N
#ShowAdvanced == Y
#ShowTrl == Y
#StdPrecision == 2
#User_Level == CO
#User_Org == 1000047,1010047,0
#YYYY == Y
$C_AcctSchema_ID == 1000010
$C_Currency_ID == 344
$Element_AC == Y
$Element_BP == Y
$Element_MC == Y
$Element_OO == Y
$Element_PJ == Y
$Element_PR == Y
$HasAlias == Y
0|WindowName == Menú
1113|1113|M_AttributeSetInstance_ID == 0
1113|1113|M_Product_ID == 0
2|0|AD_Tab_ID == 294
2|0|AD_Table_ID == 259
2|0|AccessLevel == 1
2|0|Name == Pedido a Proveedor
2|0|SQL == SELECT Bill_User_ID,C_Payment_ID,C_Repair_Order_ID,C_CashLine_ID,Acceptance,Processing,IsTaxIncluded,C_Order_ID,Pay_BPartner_ID,Pay_Location_ID,Ref_Order_ID,IsCreditApproved,IsPrinted,IsTransferred,DatePrinted,Processed,DateAcct,IsInvoiced,IsDelivered,IsActive,DeliveryRule,repair_priority,InvoiceRule,repair_state,IsApproved,IsSelfService,IsSelected,Bill_Location_ID,IsSOTrx,Bill_BPartner_ID,SendEMail,program_invoice,AD_Client_ID,AD_Org_ID,DocumentNo,POReference,Description,C_DocTypeTarget_ID,DateOrdered,DatePromised,dateprod,daterealprod,C_BPartner_ID,CreateVendorProductLines,C_BPartner_Location_ID,M_Warehouse_ID,IsDropShip,DeliveryViaRule,M_Shipper_ID,FreightCostRule,FreightAmt,PriorityRule,M_PriceList_ID,C_Currency_ID,C_ConversionType_ID,SalesRep_ID,IsDiscountPrinted,C_Charge_ID,ChargeAmt,PaymentRule,C_PaymentTerm_ID,C_Activity_ID,AD_OrgTrx_ID,User1_ID,User2_ID,DocStatus,C_DocType_ID,TotalLines,GrandTotal,CopyFrom,DocAction,Posted,Created,CreatedBy,Updated,UpdatedBy FROM C_Order WHERE IsSOTrx=’N’ AND (Processed=’N’ OR Updated>(current_timestamp-cast(cast(7 as text)|| ‘days’ as interval))) AND C_Order.AD_Client_ID IN(0,1000010) AND C_Order.AD_Org_ID IN(0,1000047,1010047) ORDER BY DocumentNo DESC
2|1|AD_Tab_ID == 293
2|1|AD_Table_ID == 260
2|1|AccessLevel == 1
2|1|LinkColumnName == C_Order_ID
2|1|Name == Línea Ped. Proveedor
2|1|SQL == SELECT IsActive,OpenMatrix,PriceLimit,Processed,QtyReserved,Ref_OrderLine_ID,IsDescription,M_Warehouse_ID,S_ResourceAssignment_ID,QtyDelivered,QtyInvoiced,C_BPartner_Location_ID,M_Shipper_ID,DateInvoiced,DateDelivered,DatePromised,C_OrderLine_ID,C_Currency_ID,Line,AD_Client_ID,AD_Org_ID,C_Order_ID,C_BPartner_ID,DateOrdered,M_Product_ID,M_AttributeSetInstance_ID,C_Charge_ID,QtyEntered,C_UOM_ID,PriceActual,QtyOrdered,PriceEntered,Description,PriceList,FreightAmt,C_Tax_ID,Discount,LineNetAmt,Created,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE C_Order_ID=1013971 AND C_OrderLine.AD_Client_ID IN(0,1000010) AND C_OrderLine.AD_Org_ID IN(0,1000047,1010047) ORDER BY Line
2|2|AD_Tab_ID == 692
2|2|AD_Table_ID == 473
2|2|AccessLevel == 3
2|2|LinkColumnName == C_OrderLine_ID
2|2|Name == Correspondencias
2|AD_Client_ID == 1000010
2|AD_Org_ID == 1000047
2|Acceptance == 0
2|AutoCommit == Y
2|BaseTable_ID == 259
2|Bill_BPartner_ID == 1012145
2|Bill_Location_ID == 1012156
2|C_BPartner_ID == 1012145
2|C_ConversionType_ID == 201
2|C_Currency_ID == 344
2|C_DocTypeTarget_ID == 1010516
2|C_DocType_ID == 0
2|C_Order_ID == 1013971
2|C_PaymentTerm_ID == 1010078
2|C_Tax_ID == 1000078
2|ChargeAmt == 0.00
2|CopyFrom == N
2|CreateVendorProductLines == N
2|DateAcct == 2010-02-15 00:00:00
2|DateOrdered == 2010-02-15 00:00:00
2|DatePromised == 2010-02-15 00:00:00
2|DeliveryRule == A
2|DeliveryViaRule == P
2|Discount == 0
2|DocAction == CO
2|DocStatus == DR
2|DocTypeKey == POO
2|DocumentNo == 800009
2|FreightAmt == 0
2|FreightCostRule == I
2|GrandTotal == 0.00
2|InvoiceRule == D
2|IsActive == Y
2|IsApproved == N
2|IsCreditApproved == N
2|IsDelivered == N
2|IsDescription == N
2|IsDiscountPrinted == N
2|IsDropShip == N
2|IsInvoiced == N
2|IsPrinted == N
2|IsSOTrx == N
2|IsSelected == N
2|IsSelfService == N
2|IsTaxIncluded == N
2|IsTransferred == N
2|Line == 10
2|LineNetAmt == 0
2|M_PriceList_ID == 1010590
2|M_PriceList_Version_ID == 1010519
2|M_Warehouse_ID == 1000042
2|OpenMatrix == N
2|PaymentRule == P
2|Posted == N
2|PriceActual == 0
2|PriceEntered == 0
2|PriceLimit == 0
2|PriceList == 0
2|PriorityRule == 5
2|Processed == N
2|Processing == N
2|QtyDelivered == 0
2|QtyEntered == 1
2|QtyInvoiced == 0
2|QtyOrdered == 1
2|QtyReserved == 0
2|SalesRep_ID == 1010711
2|SendEMail == N
2|TotalLines == 0.00
2|WindowName == Pedido a Proveedor
AutoCommit == Y
P103|Type == S
P123|AD_User_ID == -1
P138|C_Region_ID == -1
P140|C_TaxCategory_ID == 1010044
P140|C_UOM_ID == 100
P143|C_BPartner_ID == 1002136
P189|DataType == S
P192|AD_Org_ID == 0
P|AD_FTDoc == 1002145
P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
P|LOCAL_AR == N
java.naming.provider.url == jnp://192.168.0.6:1099=== System ===
awt.toolkit=sun.awt.windows.WToolkit
deployment.browser.path=C:Archivos de programaInternet ExplorerIEXPLORE.EXE
deployment.browser.vm.iexplorer=true
deployment.browser.vm.mozilla=true
deployment.cache.enabled=true
deployment.cache.jarcompression=0
deployment.cache.max.size=-1
deployment.capture.mime.types=false
deployment.console.startup.mode=HIDE
deployment.control.panel.log=false
deployment.javapi.cache.update=false
deployment.javapi.lifecycle.exception=false
deployment.javapi.log.filename=
deployment.javapi.runtime.type=0
deployment.javapi.trace.filename=
deployment.javaws.associations=ASK_USER
deployment.javaws.autodownload=ALWAYS
deployment.javaws.cache.update=false
deployment.javaws.home.jnlp.url=http://java.sun.com/products/javawebstart
deployment.javaws.installURL=http://java.sun.com/products/autodl/j2se
deployment.javaws.logFileName=
deployment.javaws.muffin.max=256
deployment.javaws.shortcut=ASK_IF_HINTED
deployment.javaws.splash.index=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache6.0splashsplash.xml
deployment.javaws.ssv.enabled=true
deployment.javaws.traceFileName=
deployment.javaws.uninstall.shortcut=false
deployment.javaws.update.timeout=1500
deployment.javaws.version=javaws-1.4.2_03
deployment.jpi.mode.new=true
deployment.log=false
deployment.max.output.file.size=10
deployment.max.output.files=5
deployment.mime.types.use.default=true
deployment.proxy.bypass.local=false
deployment.proxy.override.hosts=
deployment.proxy.same=false
deployment.proxy.type=3
deployment.repository.askdownloaddialog.show=true
deployment.repository.enabled=true
deployment.security.SSLv2Hello=false
deployment.security.SSLv3=true
deployment.security.TLSv1=true
deployment.security.askgrantdialog.notinca=true
deployment.security.askgrantdialog.show=true
deployment.security.authenticator=true
deployment.security.blacklist.check=true
deployment.security.browser.keystore.use=true
deployment.security.clientauth.keystore.auto=true
deployment.security.expired.warning=true
deployment.security.https.warning.show=false
deployment.security.jsse.hostmismatch.warning=true
deployment.security.notinca.warning=true
deployment.security.password.cache=true
deployment.security.pretrust.list=true
deployment.security.sandbox.awtwarningwindow=true
deployment.security.sandbox.jnlp.enhanced=true
deployment.security.trusted.policy=
deployment.security.validation.crl=false
deployment.security.validation.ocsp=false
deployment.system.security.blacklist=C:Archivos de programaJavajre6libsecurityblacklist
deployment.system.security.cacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.jssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.oldcacerts=C:Archivos de programaJavajre6libsecuritycacerts
deployment.system.security.oldjssecacerts=C:Archivos de programaJavajre6libsecurityjssecacerts
deployment.system.security.trusted.certs=C:Archivos de programaJavajre6libsecuritytrusted.certs
deployment.system.security.trusted.clientauthcerts=C:Archivos de programaJavajre6libsecuritytrusted.clientcerts
deployment.system.security.trusted.jssecerts=C:Archivos de programaJavajre6libsecuritytrusted.jssecerts
deployment.system.security.trusted.publishers=C:Archivos de programaJavajre6libsecuritytrusted.publishers
deployment.system.tray.icon=true
deployment.trace=false
deployment.update.mime.types=true
deployment.user.cachedir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentcache
deployment.user.extdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentext
deployment.user.logdir=C:Documents and SettingsuserDatos de programaSunJavaDeploymentlog
deployment.user.security.blacklist=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityblacklist
deployment.user.security.policy=file://C:/Documents%20and%20Settings/user/Datos%20de%20programa/Sun/Java/Deployment/security/java.policy
deployment.user.security.saved.credentials=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecurityauth.dat
deployment.user.security.trusted.cacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.cacerts
deployment.user.security.trusted.certs=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.certs
deployment.user.security.trusted.clientauthcerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.clientcerts
deployment.user.security.trusted.jssecacerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecacerts
deployment.user.security.trusted.jssecerts=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.jssecerts
deployment.user.security.trusted.publishers=C:Documents and SettingsuserDatos de programaSunJavaDeploymentsecuritytrusted.publishers
deployment.user.tmp=C:Documents and SettingsuserDatos de programaSunJavaDeploymenttmp
deployment.version=6.0
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=
http.auth.serializeRequests=true
https.protocols=TLSv1,SSLv3
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:Archivos de programaJavajre6libdeploy.jar
java.class.version=50.0
java.endorsed.dirs=C:Archivos de programaJavajre6libendorsed
java.ext.dirs=C:Archivos de programaJavajre6libext;C:WINDOWSSunJavalibext
java.home=C:Archivos de programaJavajre6
java.io.tmpdir=C:DOCUME~1userCONFIG~1Temp
java.library.path=C:Archivos de programaJavajre6bin;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:Archivos de programaJavajre6bin;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;”C:Archivos de programaJavajre6bin”
java.protocol.handler.pkgs=com.sun.javaws.net.protocol|com.sun.deploy.net.protocol
java.quick.starter=true
java.rmi.server.RMIClassLoaderSpi=com.sun.jnlp.JNLPRMIClassLoaderSpi
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_16-b01
java.security.policy=file:C:Archivos de programaJavajre6libsecurityjavaws.policy
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_16
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=14.2-b01
javaplugin.proxy.config.type=direct
javawebstart.version=javaws-1.6.0_16
jnlpx.heapsize=33554432,536870912
jnlpx.home=C:Archivos de programaJavajre6bin
jnlpx.jvm=C:Archivos de programaJavajre6binjavaw.exe
jnlpx.offline=false
jnlpx.relaunch=true
jnlpx.remove=false
jnlpx.splashport=1568
jnlpx.vmargs=-Xmx512m -Xms32m
line.separator=os.arch=x86
os.name=Windows XP
os.version=5.1
path.separator=;
sun.arch.data.model=32
sun.boot.class.path=C:Archivos de programaJavajre6libresources.jar;C:Archivos de programaJavajre6librt.jar;C:Archivos de programaJavajre6libsunrsasign.jar;C:Archivos de programaJavajre6libjsse.jar;C:Archivos de programaJavajre6libjce.jar;C:Archivos de programaJavajre6libcharsets.jar;C:Archivos de programaJavajre6classes;C:Archivos de programaJavajre6libjavaws.jar;C:Archivos de programaJavajre6libdeploy.jar;C:Archivos de programaJavajre6libplugin.jar
sun.boot.library.path=C:Archivos de programaJavajre6bin
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.launcher=SUN_STANDARD
sun.jnu.encoding=Cp1252
sun.management.compiler=HotSpot Client Compiler
sun.os.patch.level=Service Pack 2
trustProxy=true
user.country=PY
user.dir=C:Documents and SettingsuserEscritorio
user.home=C:Documents and Settingsuser
user.language=es
user.name=user
user.timezone=America/Guyana
user.variant=Hermann D. Schimpf
MiembroGracias Antonio,
verificando el Java Build Path encontre que tenia instaladas dos versiones de Java, y Eclipse tenia configurada la version GCJ y no la Sun.
Ya quedo todo funcionandoMuchas Gracias
Hermann D. SchimpfHermann D. Schimpf
MiembroAntonio, gracias por la respuesta!
La primera opcion no me es valida porque necesito las Entidades Comerciales en todas las organizaciones.
La segunda opcion la veo como mas valida para lo que necesito. Si podrias detallarme como deberia realizar la segunda opcion, con mas datos, voy a intentar realizar esa configuracion.Trato de explicate mejor lo que necesitamos:
Necesitamos poder filtrar el acceso segun el perfil o el usuario, al los Grupos de Entidades Comerciales a fin de que un usuario y/o perfil XX no pueda realizar transacciones con determinadas Entidades Comerciales. Esta configuracion la necesitamos tanto para compras como para ventas.Gracias
Hermann D. Schimpf3 diciembre, 2009 a las 1:15 pm en respuesta a: Instalacion de Libertya 9.10 en Ubuntu Server 9.10 #33871Hermann D. Schimpf
MiembroOk, pero ya quedo funcionando. Lo que podrias hacer es un drop de la base de datos y crearla nuevamente para evitar datos incorrectos producidos durante la instalacion actual.
Hermann Schimpf
3 diciembre, 2009 a las 12:58 pm en respuesta a: Instalacion de Libertya 9.10 en Ubuntu Server 9.10 #33869Hermann D. Schimpf
MiembroSi, tiene que ser el usuario Libertya porque este es el que se asigno como propietario de la DB Libertya en postgresql.
Hermann Schimpf
3 diciembre, 2009 a las 12:55 pm en respuesta a: Instalacion de Libertya 9.10 en Ubuntu Server 9.10 #33867Hermann D. Schimpf
MiembroHas reiniciado el servicio postgresql luego de modificar el fichero? Ese error es problema de permisos de acceso al servicio postgresql. Deberia funcionar modificando el fichero pg_hbs.conf y reiniciando el servicio.
Reinicia el servicio de postgres mediante el comandoCode:sudo /etc/init.d/postgresql restartDeberia funcionar si ya modificaste el fichero de configuracion.
Hermann Schimpf
3 diciembre, 2009 a las 12:41 pm en respuesta a: Instalacion de Libertya 9.10 en Ubuntu Server 9.10 #33865Hermann D. Schimpf
MiembroOk, te da el mismo error que a Gustavo? Podrias pasar el mensaje de error que te retorna el comando?
Gracias
Hermann Schimpf3 diciembre, 2009 a las 12:17 pm en respuesta a: Instalacion de Libertya 9.10 en Ubuntu Server 9.10 #33863Hermann D. Schimpf
Miembroromisc, has verificado que el fichero pg_hba.conf este correctamente configurado?
En el mensaje anterior al tuyo esta la configuracion que deberia tener.Hermann Schimpf
Hermann D. Schimpf
MiembroVoy a probar las dos opciones. Me parece que el query me va a funcionar bien ya que no se guardaron registros de esas tablas todavia.
Muchas Gracias Antonio
Hermann SchimpfHermann D. Schimpf
MiembroGracias Antonio por la respuesta.
El unico drama que tengo es que esos datos ya estan cargados en un servidor funcionando, y quiero pasar esos mismos datos a otro servidor pero un dump completo no me sirve ya que tengo diferentes configuraciones.
Copiando las tablas tendria que obtener solo los datos nuevos o modificados porque al cargar la copia intenta crear indices ya existentes.
Como seria la opcion del informe exportable? La veo como una salida posible.Gracias
Hermann SchimpfHermann D. Schimpf
MiembroDisculpame Hector, pero los instructivos de la wiki de Libertya estan muy bien explicados. Si los has seguido paso a paso es poco probable que tengas algun inconveniente durante la instalacion.
Si estas utilizando windows en la wiki hay instructivos para la instalacion en windows y si la version que utilizas es Vista te recomiendo que le des una mirada a esta wiki donde explica posibles inconvenientes de configuracion que pueden surgir durante la instalacion y como solucionarlos.
Si continuas teniendo problemas, por favor, comenta con detalles cual es el inconveniente que tienes asi podemos ayudarte a solucionarlos.Gracias
Hermann SchimpfHermann D. Schimpf
MiembroDe lujo!
Muchas gracias Federico!Hermann Schimpf
-
AutorEntradas