8 Replies Latest reply: Mar 26, 2013 9:45 AM by 952937 RSS

    [nQSError: 59001] error

    952937
      Hi Experts,

      I created one column in the report and i apply some calculation on that column in presentation services when i generating the report i am facing the below error

      HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 59001] Binary Logical operation is not permitted on INTEGER, VARBINARY operand(s). (HY000)


      How can i fix this error .


      Regards,
        • 1. Re: [nQSError: 59001] error
          Srini VEERAVALLI
          You might using case statement to validate datatype int values where char type is expected... might be other way..

          Check your datatypes or else share your statement.

          Mark if helps
          • 2. Re: [nQSError: 59001] error
            952937
            Hi ,

            In that new calculated column i am using case statement by using other two columns but there data type is same both are double.


            *(CASE WHEN "A_table"."X_Column" = '@{Date}' THEN (case when "A_Table"."Y_Column" ='@{Year}' then "C_table"."No. of Sales" else 0 END) end) * 100 /case when "A_Table"."Y_Column" ='@{Year}' then "D_Table"."Retail" end*

            the above statement i gave in the column

            Regards,

            Edited by: Rafi.BI on Feb 6, 2013 10:01 PM
            • 3. Re: [nQSError: 59001] error
              Srini VEERAVALLI
              Where are you writing case stmt? if possible cast to int or any.
              if you share your stmt that helps you to get solution.
              • 4. Re: [nQSError: 59001] error
                952937
                This is the statement i gave in that new calculated column(For existing report i added this column).


                *(CASE WHEN "A_table"."X_Column" = '@{Date}' THEN (case when "A_Table"."Y_Column" ='@{Year}' then "C_table"."No. of Sales" else 0 END) end) * 100 /case when "A_Table"."Y_Column" ='@{Year}' then "D_Table"."Retail" end*

                Regards,

                Edited by: Rafi.BI on Feb 6, 2013 10:12 PM

                Edited by: Rafi.BI on Feb 6, 2013 10:12 PM
                • 5. Re: [nQSError: 59001] error
                  Srini VEERAVALLI
                  Where ever you are using presentation variable that requires cast function, all those values are in char.
                  I think this what you need to do.

                  Appreciate if you mark also your old posts

                  Edited by: Srini VEERAVALLI on Feb 7, 2013 12:13 AM

                  BTW: Go for * 100.0 instead of * 100

                  Edited by: Srini VEERAVALLI on Feb 7, 2013 12:15 AM
                  • 6. Re: [nQSError: 59001] error
                    952937
                    Hi,

                    I applied cast function as double for the presentation variables what i used in the expression now it is showing the below error

                    *State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)*

                    Thanks,
                    • 7. Re: [nQSError: 59001] error
                      Srini VEERAVALLI
                      Rafi Sahab,

                      You are getting oracle error, check your cast function(s). It would be nice if you share your case statement with given error..
                      I dont think your issue required these many conversations and time, try to share more info as much as possible.

                      Try to follow this, that helps you and everyone
                      https://forums.oracle.com/forums/ann.jspa?annID=939

                      Thanks

                      Edited by: Srini VEERAVALLI on Feb 7, 2013 9:14 AM

                      Update your older posts to get response ;)

                      Edited by: Srini VEERAVALLI on Mar 26, 2013 9:40 AM

                      Not specific to this post, all of yours, more over its good to update with your solution.

                      Edited by: Srini VEERAVALLI on Mar 26, 2013 9:49 AM
                      • 8. Re: [nQSError: 59001] error
                        952937
                        I Closed this Thread on that day only what i have to update...!