From yesterday we are getting the below error from one particular responsibility.
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 42040] The session variable, NQ_SESSION.GL_SEGMENT2_SECURITY, is defined as Row-Wise Initialization. It is restricted to usage with equality comparisons. (HY000)
If used from other responsibilities , this is not occurring all the times but sometimes it works and sometimes it doesnt.
What is the cause of this error ? Please somebody help me as this is quite critical.
Broadly, I suspect that the query being used in the init block may be having some issue with the data that's got back.
You may want to narrow down onto the case when this error comes up and see what query is being fired at this point for this init block.When you pass the needed filters to the init block query too, you can understand what data is brought in and how different this is different from rest of the working cases.
Hope this helps to narrow down the problem for you.