Problema con articulos, clientes y proveedores.

Inicio Foros Foro principal Ayuda Problema con articulos, clientes y proveedores.

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

    Buenos dias. Tengo un inconveniente que no logro resolver.
    Lo que me sucede es que al crear por ejemplo un pedido a proveedor, al agregar las lineas del pedido y cuando quiero seleccionar un articulo, no me trae ningun articulo en la ventana, como si no hubiera cargado ninguno. He configurado los articulos con las versiones de tarifa, le he asignado los proveedores, y no se me ocurre que otro problema puede ser. Al realizar la busqueda en la ventana de articulo se generan excepciones. Adjunto estas excepciones en una respuesta a este mensaje para no encusiar mucho.
    Otro inconveniente que tengo es que al asignar un proveedor al articulo, por defecto trae los clientes, no los proveedores, igualmente puedo asignarle un proveedor desmarcando la casilla ‘Solo Clientes’. Esto es asi siempre o deberia traer los proveedores?

    Por favor, si no se comprende lo que explico avisen y trato de explicar mejor.
    Gracias.

    Hermann Schimpf

    #34075
    Code:
    ——————————-
    ———–> 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=

    #34076
    Code:
    ——————————-
    ———–> 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=

    #34078

    Ese error respecto a los artículos normalmente ocurre cuando tenes mal creado o cargado el esquema SQLJ, busca “SQLJ” en el foro y vas a ver varias soluciones.
    Respecto a las Entidades Comerciales, fijate que hay un tilde en el ángulo superior derecho (Cliente o Proveedor), si lo destildas te va a mostrar todo.

    #34077

    Bueno, 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 datos

    Hermann D. Schimpf

    #34085
    Federico Cristina
    Superadministrador

    Hermann,

    Gracias por tu aporte al foro!.

    Te comento que no podía ver correctamente este thread debido al texto de error que habías posteado. En esos casos conviene utilizar el tag [

    Code:
    [/b][b][

    , a fin de que se agreguen las barras de desplazamiento correspondientes en el texto.

    Saludos,
    Federico

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