04-29-2013 01:08 AM
I can see below query in my log file mutliple times but unable to find out from where it is coming?
SELECT m1."NUMBER" FROM PROBSUMMARYM1 m1 WHERE ((m1."PROBLEM_STATUS" <> :Y or m1."CLOSE_TIME">:Y and m1."PROBLEM_STATUS"=:Y) AND (m1."NUMBER">'IM131313')) ORDER BY m1."NUMBER" ASC
If any one had same issue or can any one tel me from where exactly is this query fired ??
06-27-2013 07:38 AM
Queries are convert in to Sm syntax before sending to rdms .
So here we can not say from where here you have to check the lines nearby of the above query in sm.log file.
But why are you concerned about the query , there will lots of such query in log file ?
Assign Kudo, if found post useful and mark it accepted if solves the issue.