Hi All, I suddenly got into a spooky situation when everything works fine and suddenly next day you retry and things starts to act weird. There's a filter which when passed sets a field and here's the SQL and FLTR log excerpt for the same. This is for the ticket coming in through mail > 0: Set Fields > /* Tue Feb 06 2007 07:06:28.0521 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 = '000000000000093' > /* Tue Feb 06 2007 07:06:28.0547 */COMMIT WORK > Application-Bus-Time-Diff "1170741900" "1170741986" "Silver - Major" "Silver - Major" > Exit code: 0 Value: 0 > Temp_Restoration_Time (1404051404) = 0 till 3 days back this would calculate the exact difference and now it only gives me 0. Nothing changed in these few days. Now the scary part is, when this same filter acts and pass the qualification for another ticket, it calculates the right business time difference and also the log shows more SQL commands: > 0: Set Fields > /* Tue Feb 06 2007 07:01:15.0537 */SELECT C536870931,C1404050501,C1404051002,C1404051001 FROM T116 WHERE C1 = '000000000000089' > /* Tue Feb 06 2007 07:01:15.0574 */COMMIT WORK > /* Tue Feb 06 2007 07:01:15.0595 */SELECT T80.C1,C8 FROM T80 WHERE (T80.C8 = 'Gold - Critical') ORDER BY 1 ASC > /* Tue Feb 06 2007 07:01:15.0632 */COMMIT WORK > /* Tue Feb 06 2007 07:01:15.0656 */SELECT C600 FROM T80 WHERE C1 = '000000000000016' > /* Tue Feb 06 2007 07:01:15.0682 */COMMIT WORK > /* Tue Feb 06 2007 07:01:15.0702 */SELECT T153.C1,C8 FROM T153 WHERE (T153.C8 = 'Gold - Critical') ORDER BY 1 ASC > /* Tue Feb 06 2007 07:01:15.0729 */COMMIT WORK > /* Tue Feb 06 2007 07:01:15.0749 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C180,C181,C620,C621,C622,C623,C624,C625,C626,C 630,C631,C632,C633,C634,C635,C636,C1201032721,C1201032802,C1402031913,C2 005101201 FROM T153 WHERE C1 = '000000000000027' > /* Tue Feb 06 2007 07:01:15.0777 */SELECT entryId,T0,U0,T1,U1,T2,U2 FROM H153 WHERE entryId = '000000000000027' > /* Tue Feb 06 2007 07:01:15.0799 */COMMIT WORK > Application-Bus-Time-Diff "1170405711" "1170741672" "Gold - Critical" "Gold - Critical" > Exit code: 0 Value: 335961 > Temp_Restoration_Time (1404051404) = 335961 there is NO SET FIELD IF condition why it is calculating 0 in the first case? and Why is the difference between the number of SQL calls? Regards Ankur
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
