3 Replies Latest reply: Dec 4, 2012 12:31 AM by 808577 RSS

    Date Conversion Problem in OBIEE11g

    808577
      Hi
      I have text format date (26-MAR-1999) . When I am converting the to Date format using the CAST function I am getting below Error.
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 1 expression on row count -1 failed. [nQSError: 46047] Datetime value 26-MAR-1999 from 26-MAR-1999 does not match the specified format. (HY000)

      Data Base : Essbase 11.1.2
      OBIEE11g(11.1.1.6)

      Could you please help me.

      Regards
      Konduru Hari
        • 1. Re: Date Conversion Problem in OBIEE11g
          Hussein Sawwan-Oracle
          805574 wrote:
          Hi
          I have text format date (26-MAR-1999) . When I am converting the to Date format using the CAST function I am getting below Error.
          State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 1 expression on row count -1 failed. [nQSError: 46047] Datetime value 26-MAR-1999 from 26-MAR-1999 does not match the specified format. (HY000)

          Data Base : Essbase 11.1.2
          OBIEE11g(11.1.1.6)

          Could you please help me.

          Regards
          Konduru Hari
          Please see these docs.

          OBIEE 10g: Error: "View Display Error A date value was expected (received "2008-04-01 00:00:00")" Using a Dashboard Prompt [ID 847776.1]
          Calendar Control Gives An Error: Datetime Value 1/1/2009 Does Not Match The Specified Format [ID 816663.1]
          PROBLEM TO FILTER A COLUMN WITH A PARAMETER OF TYPE DATE [ID 605803.1]
          Essbase : [nQSError: 46046] Datetime value 03-25-1996 does not match the specified format. (HY000) [ID 1113626.1]

          Thanks,
          Hussein
          • 2. Re: Date Conversion Problem in OBIEE11g
            808577
            Hi Hussen

            thanks for the reply.

            can you please attch the doc.

            Regards
            Konduru Hari
            • 3. Re: Date Conversion Problem in OBIEE11g
              Hussein Sawwan-Oracle
              can you please attch the doc.
              You can access the docs via Oracle MOS website -- https://support.oracle.com

              You need to have a valid username/password and CSI number to access MOS website. Posting the contents of MOS docs violates Oracle support agreement policy.

              Thanks,
              Hussein