Real Refined Resource Scandinavia AB
RRR|Log - logfile viewer - Filter Table Refresh Problem Admin
Please report any problems to support@rrr.se
Thread ID0000000035
RPC ID0028098634
QueueFast
Client-RPC390620
UserDemo
Overlay-Group1
Rownr Type Timestamp Delta Details
10726 API Tue Jun 19 2012 15:44:48.8579   +CE ARCreateEntry -- schema MOB:Driftinfo from Remedy User (protocol 18) at IP address 131.116.25.13
10727 FLTR Tue Jun 19 2012 15:44:48.8582 0.0003 Start filter processing (phase 1) -- Operation - CREATE on MOB:Driftinfo - <NULL>
10728 FLTR Tue Jun 19 2012 15:44:48.8582           <Filter Level:0 Number Of Filters:0> Checking "MOB:DI/050 Skicka driftinfo till tele2" (50)
10729 FLTR             --> Failed qualification
10730 FLTR Tue Jun 19 2012 15:44:48.8583 0.0001         <Filter Level:0 Number Of Filters:1> Checking "MOB:DI/050 skicka driftinfo till CBT" (50)
10731 FLTR             --> Failed qualification
10732 FLTR Tue Jun 19 2012 15:44:48.8584 0.0001         <Filter Level:0 Number Of Filters:2> Checking "MOB:DI/800 NitroTrans New" (800)
10733 FLTR             --> Passed -- perform actions
10734 FLTR             0: Set Fields
10735 FLTR             Status (7) = 0
10736 FLTR     1: Service on schema -> "MOB:NitroTrans"
10737 FLTR             --> service action input
10738 SQL Tue Jun 19 2012 15:44:48.8588 0.0004         SELECT C536871004,C1,C7 FROM T239 WHERE C1 = ''
10739 SQL Tue Jun 19 2012 15:44:48.8610 0.0022         OK
10740 FLTR             MirjamRequestId (600043006) = 000000000737265
10741 FLTR             SourceForm (600043003) = 2
10742 FLTR             SourceId (600043005) =
10743 FLTR             Driftinfo Status (600043019) = 0
10744 FLTR             Type (600043004) = 0
10745 FLTR Tue Jun 19 2012 15:44:48.8615 0.0005 Start filter processing (phase 1) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
10746 FLTR Tue Jun 19 2012 15:44:48.8615                   <Filter Level:1 Number Of Filters:0> Checking "MOB:NT/svc-101 Request Id To Short" (101)
10747 SQL Tue Jun 19 2012 15:44:48.8616 0.0001                 SELECT C600043002 FROM T396 WHERE C1 = ''
10748 SQL Tue Jun 19 2012 15:44:48.8635 0.0019                 OK
10749 FLTR                     --> Passed -- perform actions
10750 FLTR                     0: Set Fields
10751 FLTR                     MirjamShortId (600043002) = 737265
10752 FLTR Tue Jun 19 2012 15:44:48.8638 0.0003                 <Filter Level:1 Number Of Filters:1> Checking "MOB:NT/svc-102 Short To Request Id" (102)
10753 FLTR                     --> Failed qualification
10754 FLTR Tue Jun 19 2012 15:44:48.8639 0.0001                 <Filter Level:1 Number Of Filters:2> Checking "MOB:NT/svc-103 Mirjam Set Initiator/Responsible" (103)
10755 SQL Tue Jun 19 2012 15:44:48.8639                   SELECT C600043007 FROM T396 WHERE C1 = ''
10756 SQL Tue Jun 19 2012 15:44:48.8644 0.0005                 OK
10757 FLTR                     --> Passed -- perform actions
10758 FLTR                     0: Set Fields
10759 SQL Tue Jun 19 2012 15:44:48.8648 0.0004                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737265') ORDER BY 1 ASC
10760 SQL Tue Jun 19 2012 15:44:48.8665 0.0017                 OK
10761 FLTR                     NitroResponsible (600043008) =
10762 SQL Tue Jun 19 2012 15:44:48.8667 0.0002                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737265') ORDER BY 1 ASC
10763 SQL Tue Jun 19 2012 15:44:48.8682 0.0015                 OK
10764 FLTR                     NitroInitiator (600043007) =
10765 FLTR Tue Jun 19 2012 15:44:48.8683 0.0001                 <Filter Level:1 Number Of Filters:3> Checking "MOB:NT/svc-104 Mirjam Set Assigned" (104)
10766 SQL Tue Jun 19 2012 15:44:48.8683                   SELECT C600043009 FROM T396 WHERE C1 = ''
10767 SQL Tue Jun 19 2012 15:44:48.8688 0.0005                 OK
10768 FLTR                     --> Passed -- perform actions
10769 FLTR                     0: Set Fields
10770 SQL Tue Jun 19 2012 15:44:48.8691 0.0003                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737265') ORDER BY 1 ASC
10771 SQL Tue Jun 19 2012 15:44:48.8705 0.0014                 OK
10772 FLTR                     NitroAssigned (600043009) =
10773 FLTR Tue Jun 19 2012 15:44:48.8706 0.0001                 <Filter Level:1 Number Of Filters:4> Checking "MOB:NT/svc-105 TicketMapping Set PartnerId" (105)
10774 SQL Tue Jun 19 2012 15:44:48.8707 0.0001                 SELECT C600043001 FROM T396 WHERE C1 = ''
10775 SQL Tue Jun 19 2012 15:44:48.8711 0.0004                 OK
10776 FLTR                     --> Passed -- perform actions
10777 FLTR                     0: Set Fields
10778 SQL Tue Jun 19 2012 15:44:48.8714 0.0003                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737265') ORDER BY 1 ASC
10779 SQL Tue Jun 19 2012 15:44:48.8728 0.0014                 OK
10780 FLTR                     NitroPartnerId (600043001) =
10781 FLTR Tue Jun 19 2012 15:44:48.8730 0.0002                 <Filter Level:1 Number Of Filters:5> Checking "MOB:NT/svc-106 Type to New" (105)
10782 FLTR                     --> Passed -- perform actions
10783 FLTR                     0: Set Fields
10784 SQL Tue Jun 19 2012 15:44:48.8731 0.0001                 SELECT COUNT(*) FROM T397 WHERE (T397.C600043006 = '000000000737265') ORDER BY 1 ASC
10785 SQL Tue Jun 19 2012 15:44:48.8745 0.0014                 OK
10786 FLTR                     Type (600043004) = 0
10787 FLTR Tue Jun 19 2012 15:44:48.8747 0.0002                 <Filter Level:1 Number Of Filters:6> Checking "MOB:NT/svc-111 Driftinfo Start" (111)
10788 FLTR                     --> Passed -- perform actions
10789 FLTR                     0: Set Fields
10790 FLTR                     NitroVerifyStep (600043000) = 0
10791 FLTR Tue Jun 19 2012 15:44:48.8749 0.0002                 <Filter Level:1 Number Of Filters:7> Checking "MOB:NT/svc-112 Driftinfo Set Status" (112)
10792 FLTR                     --> Failed qualification
10793 FLTR Tue Jun 19 2012 15:44:48.8750 0.0001                 <Filter Level:1 Number Of Filters:8> Checking "MOB:NT/svc-121 Omfattning Start" (121)
10794 FLTR                     --> Passed -- perform actions
10795 FLTR                     0: Set Fields
10796 FLTR                     NitroVerifyStep (600043000) = 1
10797 FLTR Tue Jun 19 2012 15:44:48.8751 0.0001 Compare to another log with Non Admin User
AR System 7.6.04 SP2, Sybase, Solaris
<Filter Level:1 Number Of Filters:9> Checking "MOB:NT/svc-122 Omfattning Set Cell Id" (122)
10798 FLTR     --> Passed -- perform actions
10799 FLTR     0: Set Fields
10800 SQL Tue Jun 19 2012 15:44:48.8756 0.0005 SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE ((T370.C8 = '737265') AND (T370.C536870958 = 'DK') AND (T370.C536871068 >= 1) AND (NOT ((NULL LIKE '[^ ]%')) OR (T370.C536870913 IS NULL))) ORDER BY 1 ASC
10801 SQL Tue Jun 19 2012 15:44:48.8770 0.0014 OK
10802 SQL Tue Jun 19 2012 15:44:48.8773 0.0003 SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE ((T370.C8 = '737265') AND (T370.C536870958 = 'DK') AND (T370.C536871068 >= 1) AND (NOT ((NULL LIKE '[^ ]%')) OR (T370.C536870913 IS NULL))) ORDER BY 1 ASC
10803 SQL Tue Jun 19 2012 15:44:48.8783 0.0010 OK
10804 FLTR     Omfattning Cell Id (600043029) = S1102
The actual code which sets the above field is a simple Set-Fields: Omfattning Cell Id = COLMAX($tbl Omf Cell Id$)
It works here, apparently because the executing user is Admin, but there should be no difference between users as we are in filters.
Another thing that is strange, and not good, is that two SQL-statements are issued, when clearly only one is needed!
10805 FLTR Tue Jun 19 2012 15:44:48.8785 0.0002                 <Filter Level:1 Number Of Filters:10> Checking "MOB:NT/svc-131 Cell Start" (131)
10806 FLTR                     --> Passed -- perform actions
10807 FLTR                     0: Set Fields
10808 FLTR                     NitroVerifyStep (600043000) = 2
10809 FLTR Tue Jun 19 2012 15:44:48.8786 0.0001                 <Filter Level:1 Number Of Filters:11> Checking "MOB:NT/svc-132 Cell Set Cellkategori" (132)
10810 FLTR                     --> Passed -- perform actions
10811 FLTR                     0: Set Fields
10812 SQL Tue Jun 19 2012 15:44:48.8790 0.0004                 SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE ((T370.C8 = '737265') AND (T370.C536870958 = 'DK') AND (T370.C536871068 >= 1) AND (NOT ((NULL LIKE '[^ ]%')) OR (T370.C536870913 IS NULL))) ORDER BY 1 ASC
10813 SQL Tue Jun 19 2012 15:44:48.8801 0.0011                 OK
10814 SQL Tue Jun 19 2012 15:44:48.8804 0.0003                 SELECT T370.C1,C536870913,C536871068 FROM T370 WHERE ((T370.C8 = '737265') AND (T370.C536870958 = 'DK') AND (T370.C536871068 >= 1) AND (NOT ((NULL LIKE '[^ ]%')) OR (T370.C536870913 IS NULL))) ORDER BY 1 ASC
10815 SQL Tue Jun 19 2012 15:44:48.8815 0.0011                 OK
10816 FLTR                     Cellkat (600043039) = 1
10817 FLTR Tue Jun 19 2012 15:44:48.8816 0.0001                 <Filter Level:1 Number Of Filters:12> Checking "MOB:NT/svc-141 Ownership Start" (141)
10818 FLTR                     --> Passed -- perform actions
10819 FLTR                     0: Set Fields
10820 FLTR                     NitroVerifyStep (600043000) = 3
10821 FLTR Tue Jun 19 2012 15:44:48.8817 0.0001                 <Filter Level:1 Number Of Filters:13> Checking "MOB:NT/svc-142 Ownership Partnercell på Teliaplats" (142)
10822 FLTR                     --> Failed qualification
10823 FLTR Tue Jun 19 2012 15:44:48.8818 0.0001                 <Filter Level:1 Number Of Filters:14> Checking "MOB:NT/svc-142 Ownership Teliacell på Partnerplats" (142)
10824 FLTR                     --> Failed qualification
10825 FLTR Tue Jun 19 2012 15:44:48.8819 0.0001                 <Filter Level:1 Number Of Filters:15> Checking "MOB:NT/svc-142 Ownership Partnercell på okändplats" (142)
10826 FLTR                     --> Failed qualification
10827 FLTR Tue Jun 19 2012 15:44:48.8820 0.0001                 <Filter Level:1 Number Of Filters:16> Checking "MOB:NT/svc-142 Ownership Teliacell på Teliaplats" (142)
10828 FLTR                     --> Passed -- perform actions
10829 FLTR                     0: Set Fields
10830 FLTR                     NitroAssigned (600043009) = TS
10831 FLTR                     NitroResponsible (600043008) = TS
10832 FLTR Tue Jun 19 2012 15:44:48.8822 0.0002                 <Filter Level:1 Number Of Filters:17> Checking "MOB:NT/svc-143 Ownership Initiator=TS" (143)
10833 FLTR                     --> Passed -- perform actions
10834 FLTR                     0: Set Fields
10835 FLTR                     NitroInitiator (600043007) = TS
10836 FLTR Tue Jun 19 2012 15:44:48.8824 0.0002                 <Filter Level:1 Number Of Filters:18> Checking "MOB:NT/svc-151 OK Start" (151)
10837 FLTR                     --> Passed -- perform actions
10838 FLTR                     0: Set Fields
10839 FLTR                     NitroVerifyStep (600043000) = 4
10840 FLTR Tue Jun 19 2012 15:44:48.8825 0.0001                 <Filter Level:1 Number Of Filters:19> Checking "MOB:NT/svc-152 OK Set NitroGUID" (152)
10841 FLTR                     --> Passed -- perform actions
10842 FLTR                     0: Set Fields
10843 FLTR                     Application-Generate-GUID RR
10844 FLTR                     Exit code: 0 Value: RRG2214658098AMFV0GORF36FS8UMI
10845 FLTR                     SourceId (600043005) = RRG2214658098AMFV0GORF36FS8UMI
10846 FLTR Tue Jun 19 2012 15:44:48.8828 0.0003                 <Filter Level:1 Number Of Filters:20> Checking "MOB:NT/svc-159 OK push to NitroTrans" (159)
10847 FLTR                     --> Passed -- perform actions
10848 FLTR                     0: Push Fields -> "MOB:NitroTrans"
10849 FLTR                     <deferred to phase 2>
10850 FLTR Tue Jun 19 2012 15:44:48.8833 0.0005         End of filter processing (phase 1) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
10851 FLTR Tue Jun 19 2012 15:44:48.8833           Restart of filter processing (phase 2) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
10852 FLTR Tue Jun 19 2012 15:44:48.8836 0.0003                 <Filter Level:1 Number Of Filters:21> Checking "MOB:NT/svc-159 OK push to NitroTrans"
10853 FLTR                     0: Push Fields -> "MOB:NitroTrans"
10854 FLTR                     <deferred from filter MOB:NT/svc-159 OK push to NitroTrans>
10855 FLTR                     SourceForm (600043003) = 2
10856 FLTR                     SourceId (600043005) = RRG2214658098AMFV0GORF36FS8UMI
10857 FLTR                     Type (600043004) = 0
10858 FLTR                     MirjamShortId (600043002) = 737265
10859 FLTR                     MirjamRequestId (600043006) = 000000000737265
10860 FLTR                     NitroPartnerId (600043001) =
10861 FLTR                     NitroInitiator (600043007) = TS
10862 FLTR                     NitroResponsible (600043008) = TS
10863 FLTR                     NitroAssigned (600043009) = TS
10864 FLTR Tue Jun 19 2012 15:44:48.8842 0.0006                 Start filter processing (phase 1) -- Operation - CREATE on MOB:NitroTrans - <NULL>
10865 FLTR Tue Jun 19 2012 15:44:48.8842                           <Filter Level:2 Number Of Filters:21> Checking "MOB:NT/800 Push To NitroTicketMapping" (800)
10866 FLTR                             --> Passed -- perform actions
10867 FLTR                             0: Push Fields -> "MOB:NitroTicketMapping"
10868 FLTR                             <deferred to phase 2>
10869 FLTR Tue Jun 19 2012 15:44:48.8847 0.0005                 End of filter processing (phase 1) -- Operation - CREATE on MOB:NitroTrans - <NULL>
10870 SQL Tue Jun 19 2012 15:44:48.8850 0.0003                 BEGIN TRANSACTION
10871 SQL Tue Jun 19 2012 15:44:48.8852 0.0002                 OK
10872 SQL Tue Jun 19 2012 15:44:48.8855 0.0003                 INSERT INTO T396 (C2,C7,C8,C600043001,C600043002,C600043003,C600043004,C600043005,C600043006,C600043007,C600043008,C600043009,C3,C5,C6,C1) VALUES ('Demo',0,'x',NULL,'737265',2,0,'RRG2214658098AMFV0GORF36FS8UMI','000000000737265','TS','TS','TS',1340113488,'Demo',1340113488,'NITROTR00000242')
10873 SQL Tue Jun 19 2012 15:44:48.8874 0.0019                 OK
10874 SQL Tue Jun 19 2012 15:44:48.8877 0.0003                 INSERT INTO H396 (entryId,T0,U0) VALUES ('NITROTR00000242',1340113488,'Demo')
10875 SQL Tue Jun 19 2012 15:44:48.8883 0.0006                 OK
10876 SQL Tue Jun 19 2012 15:44:48.8884 0.0001                 COMMIT TRANSACTION
10877 SQL Tue Jun 19 2012 15:44:48.8957 0.0073                 OK
10878 FLTR Tue Jun 19 2012 15:44:48.8957                   Restart of filter processing (phase 2) -- Operation - CREATE on MOB:NitroTrans - NITROTR00000242
10879 FLTR Tue Jun 19 2012 15:44:48.8958 0.0001                         <Filter Level:2 Number Of Filters:22> Checking "MOB:NT/800 Push To NitroTicketMapping"
10880 FLTR                             0: Push Fields -> "MOB:NitroTicketMapping"
10881 FLTR                             <deferred from filter MOB:NT/800 Push To NitroTicketMapping>
10882 SQL Tue Jun 19 2012 15:44:48.8961 0.0003                         SELECT T397.C1 FROM T397 WHERE (T397.C600043002 = '737265') ORDER BY 1 ASC
10883 SQL Tue Jun 19 2012 15:44:48.8970 0.0009                         OK
10884 FLTR                             MirjamRequestId (600043006) = 000000000737265
10885 FLTR                             MirjamShortId (600043002) = 737265
10886 FLTR                             NitroPartnerId (600043001) =
10887 FLTR                             NitroInitiator (600043007) = TS
10888 FLTR                             NitroResponsible (600043008) = TS
10889 FLTR                             NitroAssigned (600043009) = TS
10890 FLTR                             NitroUpdate (600043000) = 0
10891 FLTR Tue Jun 19 2012 15:44:48.8974 0.0004                         Start filter processing (phase 1) -- Operation - CREATE on MOB:NitroTicketMapping - <NULL>
10892 FLTR Tue Jun 19 2012 15:44:48.8974                                   <Filter Level:3 Number Of Filters:22> Checking "MOB:NTM/800 Update NitroPartnerId in Communication" (800)
10893 FLTR                                     --> Failed qualification
10894 FLTR Tue Jun 19 2012 15:44:48.8975 0.0001                         End of filter processing (phase 1) -- Operation - CREATE on MOB:NitroTicketMapping - <NULL>
10895 SQL Tue Jun 19 2012 15:44:48.8978 0.0003                         BEGIN TRANSACTION
10896 SQL Tue Jun 19 2012 15:44:48.8979 0.0001                         OK
10897 SQL Tue Jun 19 2012 15:44:48.8981 0.0002                         INSERT INTO T397 (C2,C7,C8,C600043001,C600043002,C600043006,C600043007,C600043008,C600043009,C3,C5,C6,C1) VALUES ('Demo',0,'x',NULL,'737265','000000000737265','TS','TS','TS',1340113488,'Demo',1340113488,'NITROTM00062083')
10898 SQL Tue Jun 19 2012 15:44:48.8997 0.0016                         OK
10899 SQL Tue Jun 19 2012 15:44:48.8999 0.0002                         INSERT INTO H397 (entryId,T0,U0) VALUES ('NITROTM00062083',1340113488,'Demo')
10900 SQL Tue Jun 19 2012 15:44:48.9006 0.0007                         OK
10901 SQL Tue Jun 19 2012 15:44:48.9007 0.0001                         COMMIT TRANSACTION
10902 SQL Tue Jun 19 2012 15:44:48.9073 0.0066                         OK
10903 FLTR Tue Jun 19 2012 15:44:48.9075 0.0002                 End of filter processing (phase 2) -- Operation - CREATE on MOB:NitroTrans - NITROTR00000242
10904 FLTR Tue Jun 19 2012 15:44:48.9077 0.0002         End of filter processing (phase 2) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
10905 FLTR             --> service action output
10906 FLTR             NitroGUID (600043005) = RRG2214658098AMFV0GORF36FS8UMI
10907 FLTR             2: Push Fields -> "MOB:NitroTrans"
10908 FLTR             <deferred to phase 2>
10909 FLTR Tue Jun 19 2012 15:44:48.9082 0.0005         <Filter Level:0 Number Of Filters:3> Checking "MOB:NC/800 NitroTrans Create" (800)
10910 FLTR             --> Failed qualification
10911 FLTR Tue Jun 19 2012 15:44:48.9083 0.0001         <Filter Level:0 Number Of Filters:4> Checking "MOB:DI/899 Logga förändring Destination" (899)
10912 FLTR             --> Disabled -- filter is ignored
10913 FLTR Tue Jun 19 2012 15:44:48.9084 0.0001         <Filter Level:0 Number Of Filters:4> Checking "MOB:DI/899 Logga förändring Driftinfo" (899)
10914 FLTR             --> Passed -- perform actions
10915 FLTR             0: Set Fields
10916 FLTR             loggbok (536871003) = Info Misi test TT
10917 FLTR Tue Jun 19 2012 15:44:48.9086 0.0002         <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/899 Logga förändring Status" (899)
10918 FLTR             --> Disabled -- filter is ignored
10919 FLTR Tue Jun 19 2012 15:44:48.9086           <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/899 Logga förändring Visas_ifrån" (899)
10920 FLTR             --> Disabled -- filter is ignored
10921 FLTR Tue Jun 19 2012 15:44:48.9087 0.0001         <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/900 autoskapade fr temip kopior" (900)
10922 FLTR             --> Failed qualification
10923 FLTR Tue Jun 19 2012 15:44:48.9088 0.0001 End of filter processing (phase 1) -- Operation - CREATE on MOB:Driftinfo - <NULL>
10924 SQL Tue Jun 19 2012 15:44:48.9091 0.0003 BEGIN TRANSACTION
10925 SQL Tue Jun 19 2012 15:44:48.9093 0.0002 OK
10926 SQL Tue Jun 19 2012 15:44:48.9095 0.0002 INSERT INTO T239 (C2,C7,C8,C112,C536871000,C536871002,C536871004,C3,C5,C6,C1) VALUES ('Demo',0,'Misi test',';1;','Publik driftinfo Omfattningsstyrd Telenor DK',1340113439,'000000000737265',1340113488,'Demo',1340113488,'000000000437862')
10927 SQL Tue Jun 19 2012 15:44:48.9109 0.0014 OK
10928 SQL Tue Jun 19 2012 15:44:48.9111 0.0002 UPDATE T239 SET C536871001 = $ WHERE C1 = '000000000437862'
10929 SQL Tue Jun 19 2012 15:44:48.9118 0.0007 OK
10930 SQL Tue Jun 19 2012 15:44:48.9119 0.0001 UPDATE T239 SET C536871003 = $ WHERE C1 = '000000000437862'
10931 SQL Tue Jun 19 2012 15:44:48.9126 0.0007 OK
10932 SQL Tue Jun 19 2012 15:44:48.9126   INSERT INTO H239 (entryId,T0,U0) VALUES ('000000000437862',1340113488,'Demo')
10933 SQL Tue Jun 19 2012 15:44:48.9133 0.0007 OK
10934 SQL Tue Jun 19 2012 15:44:48.9133   COMMIT TRANSACTION
10935 SQL Tue Jun 19 2012 15:44:48.9233 0.0100 OK
10936 FLTR Tue Jun 19 2012 15:44:48.9234 0.0001 Restart of filter processing (phase 2) -- Operation - CREATE on MOB:Driftinfo - 000000000437862
10937 FLTR Tue Jun 19 2012 15:44:48.9235 0.0001         <Filter Level:0 Number Of Filters:6> Checking "MOB:DI/800 NitroTrans New"
10938 FLTR             2: Push Fields -> "MOB:NitroTrans"
10939 FLTR             <deferred from filter MOB:DI/800 NitroTrans New>
10940 SQL Tue Jun 19 2012 15:44:48.9238 0.0003         SELECT T396.C1 FROM T396 WHERE (('RRG2214658098AMFV0GORF36FS8UMI' != '000000000437862') AND (T396.C600043005 = 'RRG2214658098AMFV0GORF36FS8UMI')) ORDER BY 1 ASC
10941 SQL Tue Jun 19 2012 15:44:48.9266 0.0028         OK
10942 SQL Tue Jun 19 2012 15:44:48.9267 0.0001         SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,C112,C536871000,C536871001,C536871002,C536871004 FROM T239 WHERE C1 = '000000000437862'
10943 SQL Tue Jun 19 2012 15:44:48.9275 0.0008         OK
10944 SQL Tue Jun 19 2012 15:44:48.9277 0.0002         SELECT entryId,T0,U0,T1,U1 FROM H239 WHERE entryId = '000000000437862'
10945 SQL Tue Jun 19 2012 15:44:48.9286 0.0009         OK
10946 FLTR             SourceId (600043005) = 000000000437862
10947 FLTR Tue Jun 19 2012 15:44:48.9288 0.0002         Start filter processing (phase 1) -- Operation - SET on MOB:NitroTrans - NITROTR00000242
10948 FLTR Tue Jun 19 2012 15:44:48.9289 0.0001         End of filter processing (phase 1) -- Operation - SET on MOB:NitroTrans - NITROTR00000242
10949 FLTR Tue Jun 19 2012 15:44:48.9290 0.0001 End of filter processing (phase 2) -- Operation - CREATE on MOB:Driftinfo - 000000000437862
10950 SQL Tue Jun 19 2012 15:44:48.9291 0.0001 BEGIN TRANSACTION
10951 SQL Tue Jun 19 2012 15:44:48.9292 0.0001 OK
10952 SQL Tue Jun 19 2012 15:44:48.9293 0.0001 UPDATE T396 SET C600043005='000000000437862',C5='Demo',C6=1340113488 WHERE C1 = 'NITROTR00000242'
10953 SQL Tue Jun 19 2012 15:44:48.9322 0.0029 OK
10954 SQL Tue Jun 19 2012 15:44:48.9323 0.0001 COMMIT TRANSACTION
10955 SQL Tue Jun 19 2012 15:44:48.9367 0.0044 OK
10956 API Tue Jun 19 2012 15:44:48.9368 0.0001 -CE OK -- New ID 000000000437862
Total time of call 0.0789