1 Reply Latest reply: Feb 11, 2011 9:02 AM by 821966 RSS

    Unable to parse operation - BIP against JDE E1 with DAS

    686395
      Hi to all,

      I am in the following scenario:

      BI Publisher 10.1.3.4.1 integrated with JdEdwards E1 through DAS (Data Access Server).

      Then, using the connection that uses DAS, when I try tu use an outer join I get the following error:

      Unable to parse the operation [SELECT ..... WHERE AN8=AN8()]

      In the text editor where the query builder builds the query the '+' appears correctly...

      If I launch the query without the outer join then it works correctly!!

      This is quite urgent so any help would be appreciated.

      Many thanks in advance,
      Víctor.
        • 1. Re: Unable to parse operation - BIP against JDE E1 with DAS
          821966
          Hello Victor,
          you had the chance to fix the error?

          me doing the same,

          I'm also connected to a base JDE E1.

          my query is:

          Select     
          TO_DATE (substr(F0411.DGJ,2,6),'yydd') as DGJ,
          F0411.KCO as KCO,
               F0411.DOC as DOC,
               F0411.DCT as DCT,
               F0411.AN8 as AN8,
               F0411.PYE as PYE,
               F0411.SNTO as SNTO,
               F0411.AAP as AAP,
               F0411.AG as AG,
               F0411.SFX as SFX,
               F0101.ALPH as ALPH
          from     JDE.F0101 F0101,
               JDE.F0411 F0411
          where F0411.AN8=F0101.AN8
          and      F0411.DOC between :Doc_desde and :Doc_hasta
          and F0411.DGJ between TO_NUMBER(TO_CHAR(:Fecha_Desde, 'YYYYDDD' )) - 1900000
          and TO_NUMBER(TO_CHAR(:Fecha_Hasta, 'YYYYDDD' )) – 1900000


          error is:
          Unable to parse operation [select     
                   TO_DATE(substr(DGJ,2,6),'yydd') as DGJ,
                   F0411.KCO as KCO,
                F0411.DOC as DOC,
                F0411.DCT as DCT,
                F0411.AN8 as AN8,
                F0411.PYE as PYE,
                F0411.SNTO as SNTO,
                F0411.AAP as AAP,
                F0411.AG as AG,
                F0411.SFX as SFX,
                F0101.ALPH as ALPH
          from      JDE.F0101 F0101,
                JDE.F0411 F0411
          where   F0411.AN8=F0101.AN8
            and       F0411.DOC between ? and ?
            and    F0411.DGJ between TO_NUMBER(TO_CHAR(?, 'YYYYDDD' )) - 1900000
                   AND               TO_NUMBER(TO_CHAR(?, 'YYYYDDD' )) - 1900000].


          why ??
          is the version of the drivers connecting ??

          thanks

          JC