This discussion is archived
8 Replies Latest reply: Mar 26, 2013 7:45 AM by 952937 RSS

[nQSError: 59001] error

952937 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I Closed this Thread on that day only what i have to update...!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points