No se encuentra articulo en el detalle de pedido

Inicio Foros Foro principal Discusión General No se encuentra articulo en el detalle de pedido

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

    No se encuentran los articulos en la linea de cualquier documento.
    Este error se produce en la base y la compañia que viene por default. Estoy utilizando todos los productos estandares que trae el sistema; sin hacer modificacion alguna.
    No puedo seguir avanzando porque me trabo al llegar a la linea de detalle de cualquier documento. Ya sea al generar un Pedido, una factura o una Entrega/ Recibo.
    Muchas gracias



    > Msg.getMsg: NOT found: OXPSYS [11]


    > Msg.getMsg: NOT found: OXPSYS [11]
    ===========> 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,1010016) AND p.AD_Org_ID IN(0,1010053) ORDER BY
    QtyAvailable ASC [227]
    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(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.apps.search.Info$Worker.run(Info.java:1269)

    Servidor = Servidor_Aplicaciones : 1099 (No Activo)
    Tunnel=false, Objects=false, Process=false
    Base de datos = adempiere-desktop : 5432 / libertya_AR
    Esquema = libertya
    Usuario = AdminLibertya
    Perfil = Compras
    Compañía = Libertya
    Organización = Default
    Fecha = 2010-10-08 00:00:00
    Impresora = HP-LaserJet-P2015-Series
    OXPHome =
    Language=[Español
    (Argentina),Locale=es_AR,AD_Language=es_AR,DatePattern=DD.MM.YYYY
    ,DecimalPoint=false]
    MClient[1010016-Libertya]
    Documentos Multi-idioma = false
    BaseLanguage = false/false
    PDF License=true
    Java HotSpot(TM) Server VM 14.0-b16
    Linux 2.6.27-15-generic unknown
    === Environment === -2002318939
    Libertya (r) Versión 10.03_15-03-2010 – Software Libre de
    Gestión- (c) 2009 DISYTEL; Implementación: Libertya
    20100315-1136 – SERVICIOS_DIGITALES
    adempiere-desktop/127.0.0.1
    CConnection[name=Servidor_Aplicaciones{adempiere-desktop-libertya_AR-libertya}
    ,AppsHost=Servidor_Aplicaciones,AppsPort=1099,RMIoverHTTP=false
    ,type=PostgreSQL,DBhost=adempiere-desktop,DBport=5432,DBname=libertya_AR
    ,BQ=false,FW=false,FWhost=,FWport=0,UID=libertya,PWD=libertya]
    Database=PostgreSQL – 8.3.9 – Driver =PostgreSQL Native
    Driver – PostgreSQL 8.1 JDBC3 with SSL (build 405) – via
    DataSource
    DB_PostgreSQL[jdbc:postgresql://adempiere-desktop:5432/libertya_AR?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 == 1010075
    #AD_Role_Name == Compras
    #AD_Session_ID == 1027096
    #AD_User_ID == 1010717
    #AD_User_Name == AdminLibertya
    #C_BP_Group_ID == 1010045
    #C_ConversionType_ID == 114
    #C_Country_ID == 119
    #C_Letra_Comprobante_ID == 1010010
    #C_PaymentTerm_ID == 1010083
    #C_Region_ID == 1000027
    #C_TaxCategory_ID == 1010047
    #C_Tax_ID == 1010084
    #C_UOM_ID == 1000000
    #Date == 2010-10-08 00:00:00
    #GL_Category_ID == 1010098
    #M_Locator_ID == 1010278
    #M_PriceList_ID == 1010601
    #M_Product_Category_ID == 1010146
    #M_Warehouse_ID == 1010048
    #Printer == HP-LaserJet-P2015-Series
    #SalesRep_ID == 1010717
    #ShowAcct == Y
    #ShowAdvanced == Y
    #ShowTrl == N
    #StdPrecision == 2
    #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ú
    1110|Find_Table_ID == 1000117
    1113|1113|AD_User_ID == 1010721
    1113|1113|C_BPartner_ID == 1012149
    1113|1113|C_BPartner_Location_ID == 1012162
    1113|1113|M_AttributeSetInstance_ID == 0
    1113|1113|M_Product_ID == 0
    7|0|AD_Tab_ID == 294
    7|0|AD_Table_ID == 259
    7|0|AccessLevel == 1
    7|0|Name == Pedido a Proveedor
    7|0|SQL == SELECT
    C_Repair_Order_ID,C_CashLine_ID,C_Payment_ID,Acceptance,Processing
    ,IsSOTrx,C_Order_ID,IsInvoiced,DatePrinted,IsCreditApproved,IsSelfService
    ,DateAcct,Processed,IsDelivered,DeliveryRule,SendEMail,IsTransferred
    ,IsActive,repair_priority,IsPrinted,IsSelected,repair_state,InvoiceRule
    ,Pay_Location_ID,Pay_BPartner_ID,Bill_BPartner_ID,Bill_Location_ID
    ,Ref_Order_ID,program_invoice,Bill_User_ID,IsApproved,IsTaxIncluded
    ,AD_Client_ID,AD_Org_ID,DocumentNo,POReference,Description,C_DocTypeTarget_ID
    ,DateOrdered,DatePromised,dateprod,daterealprod,C_BPartner_ID
    ,CreateVendorProductLines,C_BPartner_Location_ID,AD_User_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_Project_ID,C_Activity_ID,C_Campaign_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,1010016) AND
    C_Order.AD_Org_ID IN(0,1010053) ORDER BY DocumentNo DESC
    7|1|AD_Tab_ID == 293
    7|1|AD_Table_ID == 260
    7|1|AccessLevel == 1
    7|1|LinkColumnName == C_Order_ID
    7|1|Name == Línea Ped. Proveedor
    7|1|SQL == SELECT
    OpenMatrix,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
    ,PriceLimit,Processed,QtyReserved,Ref_OrderLine_ID,IsDescription
    ,IsActive,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,C_Project_ID,Created
    ,CreatedBy,Updated,UpdatedBy FROM C_OrderLine WHERE
    C_Order_ID=1013973 AND C_OrderLine.AD_Client_ID
    IN(0,1010016) AND C_OrderLine.AD_Org_ID IN(0,1010053) ORDER
    BY Line
    7|2|AD_Tab_ID == 692
    7|2|AD_Table_ID == 473
    7|2|AccessLevel == 3
    7|2|LinkColumnName == C_OrderLine_ID
    7|2|Name == Correspondencias
    7|AD_Client_ID == 1010016
    7|AD_Org_ID == 1010053
    7|AD_User_ID == 1010721
    7|Acceptance == 0
    7|AutoCommit == Y
    7|BaseTable_ID == 259
    7|Bill_BPartner_ID == 1012149
    7|Bill_Location_ID == 1012162
    7|Bill_User_ID == 1010721
    7|C_BPartner_ID == 1012149
    7|C_ConversionType_ID == 114
    7|C_Currency_ID == 118
    7|C_DocTypeTarget_ID == 1010524
    7|C_DocType_ID == 0
    7|C_Order_ID == 1013973
    7|C_PaymentTerm_ID == 1010083
    7|C_Tax_ID == 1010084
    7|ChargeAmt == 0.00
    7|CopyFrom == N
    7|CreateVendorProductLines == N
    7|DateAcct == 2010-10-08 00:00:00
    7|DateOrdered == 2010-10-08 00:00:00
    7|DatePromised == 2010-10-08 00:00:00
    7|DeliveryRule == A
    7|DeliveryViaRule == P
    7|Discount == 0
    7|DocAction == CO
    7|DocStatus == DR
    7|DocTypeKey == POO
    7|DocumentNo == 800003
    7|FreightAmt == 0
    7|FreightCostRule == I
    7|GrandTotal == 0.00
    7|InvoiceRule == D
    7|IsActive == Y
    7|IsApproved == N
    7|IsCreditApproved == N
    7|IsDelivered == N
    7|IsDescription == N
    7|IsDiscountPrinted == N
    7|IsDropShip == N
    7|IsInvoiced == N
    7|IsPrinted == N
    7|IsSOTrx == N
    7|IsSelected == N
    7|IsSelfService == N
    7|IsTaxIncluded == N
    7|IsTransferred == N
    7|Line == 10
    7|LineNetAmt == 0
    7|M_PriceList_ID == 1010596
    7|M_PriceList_Version_ID == 1010525
    7|M_Warehouse_ID == 1010048
    7|OpenMatrix == N
    7|PaymentRule == P
    7|Posted == N
    7|PriceActual == 0
    7|PriceEntered == 0
    7|PriceLimit == 0
    7|PriceList == 0
    7|PriorityRule == 5
    7|Processed == N
    7|Processing == N
    7|QtyDelivered == 0
    7|QtyEntered == 1
    7|QtyInvoiced == 0
    7|QtyOrdered == 1
    7|QtyReserved == 0
    7|SalesRep_ID == 1010717
    7|SendEMail == N
    7|TotalLines == 0.00
    7|WindowName == Pedido a Proveedor
    AutoCommit == Y
    P1010098|InventoryKind == IO
    P103|Type == S
    P143|C_BPartner_ID == 1012142
    P189|DataType == S
    P|AD_FTDoc == 1002145
    P|C_Dockey == 018a9567ea15470312c40d3e5d6bbcd4
    P|LOCAL_AR == Y
    java.naming.provider.url =jnp://Servidor_Aplicaciones:1099

    === System ==OXP_HOMEfile.encoding=UTF-8
    file.encoding.pkg=sun.io
    file.separator=/
    java.awt.graphicsenv=sun.awt.X11GraphicsEnvironment
    java.awt.printerjob=sun.print.PSPrinterJob
    java.class.path=lib/OXP.jar:lib/OXPXLib.jar:lib/CMPCS.jar:lib/JasperReports.jar:
    java.class.version=50.0
    java.endorsed.dirs=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/endorsed
    java.ext.dirs=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/ext:/usr/java/packages/lib/ext

    java.home=/usr/lib/jvm/java-6-sun-1.6.0.14/jre
    java.io.tmpdir=/tmp
    java.library.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386/server:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib

    java.runtime.name=Java(TM) SE Runtime Environment
    java.runtime.version=1.6.0_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) Server VM
    java.vm.specification.name=Java Virtual Machine
    Specification
    java.vm.specification.vendor=Sun Microsystems Inc.
    java.vm.specification.version=1.0
    java.vm.vendor=Sun Microsystems Inc.
    java.vm.version=14.0-b16
    line.separator
    os.arch=i386
    os.name=Linux
    os.version=2.6.27-15-generic
    path.separator=:
    sun.arch.data.model=32
    sun.boot.class.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/resources.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/rt.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/jsse.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/jce.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/charsets.jar:/usr/lib/jvm/java-6-sun-1.6.0.14/jre/classes

    sun.boot.library.path=/usr/lib/jvm/java-6-sun-1.6.0.14/jre/lib/i386
    sun.cpu.endian=little
    sun.cpu.isalistsun.desktop=gnome
    sun.io.unicode.encoding=UnicodeLittle
    sun.java.launcher=SUN_STANDARD
    sun.jnu.encoding=UTF-8
    sun.management.compiler=HotSpot Tiered Compilers
    sun.os.patch.level=unknown
    user.country=AR
    user.dir=/ServidorOXP
    user.home=/home/adempiere
    user.language=es
    user.name=adempiere
    user.timezone=America/Argentina/Buenos_Aires

    Ver encabezados Fuente grande Mostrar imágenes aparte

    #35024

    El mensaje:

    Quote:
    org.postgresql.util.PSQLException: No se ha especificado un
    valor para el parámetro 1

    Indica que el PL/Java de tu instalación no está funcionando bien.

    Como veo que tu equipo se llama adempiere-desktop, supongo que lo has estado usando para instalar también adempiere y es muy probable que el Java configurado a nivel de postgres (si es que lo está) no esté con la version del jdk 1.6 . La versión de java del postgres debe ser 1.6 y se configura para la base de datos independientemente de lo que se esté ejecutando en el servidor de aplicaciones o el cliente.

    Si ejecutas la misma consulta con PGAdmin (cambiando el ? por un cero o cualquier otro numero):

    Quote:
    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,1010016) AND p.AD_Org_ID IN(0,1010053) ORDER BY
    QtyAvailable ASC

    Te va a mostrar el mensaje de error exacto. Probablemente te indique o bien que el PLJava no existe o bien que la JDK tiene una versión diferente del Jar que se ejecuta en la base de datos.

    Lo primero es determinar cual de los dos problemas tenes. Luego hay que solucionarlo revisando la wiki de instalación paso a paso o bien, instalando un postgres en otro equipo (si no querés cambiar el que tenes) y apuntando a la base de datos con el configurar.exe/sh

    Saludos
    Antonio.

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