Real Refined Resource Scandinavia AB
RRR|Log - logfile viewer - Filter Table Refresh Problem Non Admin
Please report any problems to support@rrr.se
Thread ID0000000033
RPC ID0028089138
QueueFast
Client-RPC390620
Userleifadm
Overlay-Group1
Rownr Type Timestamp Delta Details
3742 API Tue Jun 19 2012 13:55:30.4833   +CE ARCreateEntry -- schema MOB:Driftinfo from Remedy User (protocol 18) at IP address 131.116.25.13
3743 FLTR Tue Jun 19 2012 13:55:30.4836 0.0003 Start filter processing (phase 1) -- Operation - CREATE on MOB:Driftinfo - <NULL>
3744 FLTR Tue Jun 19 2012 13:55:30.4837 0.0001         <Filter Level:0 Number Of Filters:0> Checking "MOB:DI/050 Skicka driftinfo till tele2" (50)
3745 FLTR             --> Failed qualification
3746 FLTR Tue Jun 19 2012 13:55:30.4838 0.0001         <Filter Level:0 Number Of Filters:1> Checking "MOB:DI/050 skicka driftinfo till CBT" (50)
3747 FLTR             --> Failed qualification
3748 FLTR Tue Jun 19 2012 13:55:30.4839 0.0001         <Filter Level:0 Number Of Filters:2> Checking "MOB:DI/800 NitroTrans New" (800)
3749 FLTR             --> Passed -- perform actions
3750 FLTR             0: Set Fields
3751 FLTR             Status (7) = 0
3752 FLTR     1: Service on schema -> "MOB:NitroTrans"
3753 FLTR             --> service action input
3754 SQL Tue Jun 19 2012 13:55:30.4843 0.0004         SELECT C536871004,C1,C7 FROM T239 WHERE C1 = ''
3755 SQL Tue Jun 19 2012 13:55:30.4850 0.0007         OK
3756 FLTR             MirjamRequestId (600043006) = 000000000737238
3757 FLTR             SourceForm (600043003) = 2
3758 FLTR             SourceId (600043005) =
3759 FLTR             Driftinfo Status (600043019) = 0
3760 FLTR             Type (600043004) = 0
3761 FLTR Tue Jun 19 2012 13:55:30.4854 0.0004 Start filter processing (phase 1) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
3762 FLTR Tue Jun 19 2012 13:55:30.4854                   <Filter Level:1 Number Of Filters:0> Checking "MOB:NT/svc-101 Request Id To Short" (101)
3763 SQL Tue Jun 19 2012 13:55:30.4855 0.0001                 SELECT C600043002 FROM T396 WHERE C1 = ''
3764 SQL Tue Jun 19 2012 13:55:30.4861 0.0006                 OK
3765 FLTR                     --> Passed -- perform actions
3766 FLTR                     0: Set Fields
3767 FLTR                     MirjamShortId (600043002) = 737238
3768 FLTR Tue Jun 19 2012 13:55:30.4864 0.0003                 <Filter Level:1 Number Of Filters:1> Checking "MOB:NT/svc-102 Short To Request Id" (102)
3769 FLTR                     --> Failed qualification
3770 FLTR Tue Jun 19 2012 13:55:30.4865 0.0001                 <Filter Level:1 Number Of Filters:2> Checking "MOB:NT/svc-103 Mirjam Set Initiator/Responsible" (103)
3771 SQL Tue Jun 19 2012 13:55:30.4866 0.0001                 SELECT C600043007 FROM T396 WHERE C1 = ''
3772 SQL Tue Jun 19 2012 13:55:30.4870 0.0004                 OK
3773 FLTR                     --> Passed -- perform actions
3774 FLTR                     0: Set Fields
3775 SQL Tue Jun 19 2012 13:55:30.4875 0.0005                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737238') ORDER BY 1 ASC
3776 SQL Tue Jun 19 2012 13:55:30.4892 0.0017                 OK
3777 FLTR                     NitroResponsible (600043008) =
3778 SQL Tue Jun 19 2012 13:55:30.4895 0.0003                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737238') ORDER BY 1 ASC
3779 SQL Tue Jun 19 2012 13:55:30.4909 0.0014                 OK
3780 FLTR                     NitroInitiator (600043007) =
3781 FLTR Tue Jun 19 2012 13:55:30.4910 0.0001                 <Filter Level:1 Number Of Filters:3> Checking "MOB:NT/svc-104 Mirjam Set Assigned" (104)
3782 SQL Tue Jun 19 2012 13:55:30.4911 0.0001                 SELECT C600043009 FROM T396 WHERE C1 = ''
3783 SQL Tue Jun 19 2012 13:55:30.4915 0.0004                 OK
3784 FLTR                     --> Passed -- perform actions
3785 FLTR                     0: Set Fields
3786 SQL Tue Jun 19 2012 13:55:30.4919 0.0004                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737238') ORDER BY 1 ASC
3787 SQL Tue Jun 19 2012 13:55:30.4933 0.0014                 OK
3788 FLTR                     NitroAssigned (600043009) =
3789 FLTR Tue Jun 19 2012 13:55:30.4934 0.0001                 <Filter Level:1 Number Of Filters:4> Checking "MOB:NT/svc-105 TicketMapping Set PartnerId" (105)
3790 SQL Tue Jun 19 2012 13:55:30.4934                   SELECT C600043001 FROM T396 WHERE C1 = ''
3791 SQL Tue Jun 19 2012 13:55:30.4939 0.0005                 OK
3792 FLTR                     --> Passed -- perform actions
3793 FLTR                     0: Set Fields
3794 SQL Tue Jun 19 2012 13:55:30.4942 0.0003                 SELECT T397.C1,C600043001,C600043007,C600043008,C600043009,C600043006 FROM T397 WHERE (T397.C600043006 = '000000000737238') ORDER BY 1 ASC
3795 SQL Tue Jun 19 2012 13:55:30.4956 0.0014                 OK
3796 FLTR                     NitroPartnerId (600043001) =
3797 FLTR Tue Jun 19 2012 13:55:30.4957 0.0001                 <Filter Level:1 Number Of Filters:5> Checking "MOB:NT/svc-106 Type to New" (105)
3798 FLTR                     --> Passed -- perform actions
3799 FLTR                     0: Set Fields
3800 SQL Tue Jun 19 2012 13:55:30.4959 0.0002                 SELECT COUNT(*) FROM T397 WHERE (T397.C600043006 = '000000000737238') ORDER BY 1 ASC
3801 SQL Tue Jun 19 2012 13:55:30.4973 0.0014                 OK
3802 FLTR                     Type (600043004) = 0
3803 FLTR Tue Jun 19 2012 13:55:30.4975 0.0002                 <Filter Level:1 Number Of Filters:6> Checking "MOB:NT/svc-111 Driftinfo Start" (111)
3804 FLTR                     --> Passed -- perform actions
3805 FLTR                     0: Set Fields
3806 FLTR                     NitroVerifyStep (600043000) = 0
3807 FLTR Tue Jun 19 2012 13:55:30.4977 0.0002                 <Filter Level:1 Number Of Filters:7> Checking "MOB:NT/svc-112 Driftinfo Set Status" (112)
3808 FLTR                     --> Failed qualification
3809 FLTR Tue Jun 19 2012 13:55:30.4978 0.0001                 <Filter Level:1 Number Of Filters:8> Checking "MOB:NT/svc-121 Omfattning Start" (121)
3810 FLTR                     --> Passed -- perform actions
3811 FLTR                     0: Set Fields
3812 FLTR                     NitroVerifyStep (600043000) = 1
3813 FLTR Tue Jun 19 2012 13:55:30.4979 0.0001 Compare to another log with 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)
3814 FLTR     --> Passed -- perform actions
3815 FLTR     0: Set Fields
3816 FLTR     Omfattning Cell Id (600043029) =
The actual code which sets the above field is a simple Set-Fields: Omfattning Cell Id = COLMAX($tbl Omf Cell Id$)
The column has a value, but nothing is set, but the main issue is that there is no SQL code performed that indicates any refresh on the table in question.
In theory it should work with a simple assign, I would think. The COLMAX() has previously helped trigger a table refresh, but it should not really be needed.
If I change to an Admin user, see parallel log file, SQL code is triggered, and it works. But this happens inside filters, and it should not depend on the user performing the operation.
There seems to be something shaky with filter-tables in conjunction with service-calls...
3817 FLTR Tue Jun 19 2012 13:55:30.4986 0.0007                 <Filter Level:1 Number Of Filters:10> Checking "MOB:NT/svc-131 Cell Start" (131)
3818 FLTR                     --> Failed qualification
3819 FLTR Tue Jun 19 2012 13:55:30.4987 0.0001                 <Filter Level:1 Number Of Filters:11> Checking "MOB:NT/svc-132 Cell Set Cellkategori" (132)
3820 FLTR                     --> Failed qualification
3821 FLTR Tue Jun 19 2012 13:55:30.4988 0.0001                 <Filter Level:1 Number Of Filters:12> Checking "MOB:NT/svc-141 Ownership Start" (141)
3822 FLTR                     --> Failed qualification
3823 FLTR Tue Jun 19 2012 13:55:30.4989 0.0001                 <Filter Level:1 Number Of Filters:13> Checking "MOB:NT/svc-142 Ownership Partnercell på Teliaplats" (142)
3824 FLTR                     --> Failed qualification
3825 FLTR Tue Jun 19 2012 13:55:30.4989                   <Filter Level:1 Number Of Filters:14> Checking "MOB:NT/svc-142 Ownership Teliacell på Partnerplats" (142)
3826 FLTR                     --> Failed qualification
3827 FLTR Tue Jun 19 2012 13:55:30.4990 0.0001                 <Filter Level:1 Number Of Filters:15> Checking "MOB:NT/svc-142 Ownership Partnercell på okändplats" (142)
3828 FLTR                     --> Failed qualification
3829 FLTR Tue Jun 19 2012 13:55:30.4991 0.0001                 <Filter Level:1 Number Of Filters:16> Checking "MOB:NT/svc-142 Ownership Teliacell på Teliaplats" (142)
3830 FLTR                     --> Failed qualification
3831 FLTR Tue Jun 19 2012 13:55:30.4992 0.0001                 <Filter Level:1 Number Of Filters:17> Checking "MOB:NT/svc-143 Ownership Initiator=TS" (143)
3832 FLTR                     --> Failed qualification
3833 FLTR Tue Jun 19 2012 13:55:30.4993 0.0001                 <Filter Level:1 Number Of Filters:18> Checking "MOB:NT/svc-151 OK Start" (151)
3834 FLTR                     --> Failed qualification
3835 FLTR Tue Jun 19 2012 13:55:30.4993                   <Filter Level:1 Number Of Filters:19> Checking "MOB:NT/svc-152 OK Set NitroGUID" (152)
3836 FLTR                     --> Failed qualification
3837 FLTR Tue Jun 19 2012 13:55:30.4994 0.0001                 <Filter Level:1 Number Of Filters:20> Checking "MOB:NT/svc-159 OK push to NitroTrans" (159)
3838 FLTR                     --> Failed qualification
3839 FLTR Tue Jun 19 2012 13:55:30.4995 0.0001         End of filter processing (phase 1) -- Operation - SERVICE on MOB:NitroTrans - <NULL>
3840 FLTR             --> service action output
3841 FLTR             NitroGUID (600043005) =
3842 FLTR             2: Push Fields -> "MOB:NitroTrans"
3843 FLTR             <deferred to phase 2>
3844 FLTR Tue Jun 19 2012 13:55:30.5000 0.0005         <Filter Level:0 Number Of Filters:3> Checking "MOB:NC/800 NitroTrans Create" (800)
3845 FLTR             --> Failed qualification
3846 FLTR Tue Jun 19 2012 13:55:30.5001 0.0001         <Filter Level:0 Number Of Filters:4> Checking "MOB:DI/899 Logga förändring Destination" (899)
3847 FLTR             --> Disabled -- filter is ignored
3848 FLTR Tue Jun 19 2012 13:55:30.5001           <Filter Level:0 Number Of Filters:4> Checking "MOB:DI/899 Logga förändring Driftinfo" (899)
3849 FLTR             --> Passed -- perform actions
3850 FLTR             0: Set Fields
3851 FLTR             loggbok (536871003) = Information from TS on Test 2 from TS 19/6
3852 FLTR Tue Jun 19 2012 13:55:30.5003 0.0002         <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/899 Logga förändring Status" (899)
3853 FLTR             --> Disabled -- filter is ignored
3854 FLTR Tue Jun 19 2012 13:55:30.5004 0.0001         <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/899 Logga förändring Visas_ifrån" (899)
3855 FLTR             --> Disabled -- filter is ignored
3856 FLTR Tue Jun 19 2012 13:55:30.5005 0.0001         <Filter Level:0 Number Of Filters:5> Checking "MOB:DI/900 autoskapade fr temip kopior" (900)
3857 FLTR             --> Failed qualification
3858 FLTR Tue Jun 19 2012 13:55:30.5006 0.0001 End of filter processing (phase 1) -- Operation - CREATE on MOB:Driftinfo - <NULL>
3859 SQL Tue Jun 19 2012 13:55:30.5009 0.0003 BEGIN TRANSACTION
3860 SQL Tue Jun 19 2012 13:55:30.5010 0.0001 OK
3861 SQL Tue Jun 19 2012 13:55:30.5013 0.0003 INSERT INTO T239 (C2,C7,C8,C112,C536871000,C536871002,C536871004,C3,C5,C6,C1) VALUES ('leifadm',0,'Test 2 from TS 19/6',';7676;','Publik driftinfo Omfattningsstyrd Telenor DK',1340106857,'000000000737238',1340106930,'leifadm',1340106930,'000000000437765')
3862 SQL Tue Jun 19 2012 13:55:30.5028 0.0015 OK
3863 SQL Tue Jun 19 2012 13:55:30.5030 0.0002 UPDATE T239 SET C536871001 = $ WHERE C1 = '000000000437765'
3864 SQL Tue Jun 19 2012 13:55:30.5037 0.0007 OK
3865 SQL Tue Jun 19 2012 13:55:30.5038 0.0001 UPDATE T239 SET C536871003 = $ WHERE C1 = '000000000437765'
3866 SQL Tue Jun 19 2012 13:55:30.5047 0.0009 OK
3867 SQL Tue Jun 19 2012 13:55:30.5047   INSERT INTO H239 (entryId,T0,U0) VALUES ('000000000437765',1340106930,'leifadm')
3868 SQL Tue Jun 19 2012 13:55:30.5054 0.0007 OK
3869 SQL Tue Jun 19 2012 13:55:30.5055 0.0001 COMMIT TRANSACTION
3870 SQL Tue Jun 19 2012 13:55:30.5189 0.0134 OK
3871 FLTR Tue Jun 19 2012 13:55:30.5189   Restart of filter processing (phase 2) -- Operation - CREATE on MOB:Driftinfo - 000000000437765
3872 FLTR Tue Jun 19 2012 13:55:30.5193 0.0004         <Filter Level:0 Number Of Filters:6> Checking "MOB:DI/800 NitroTrans New"
3873 FLTR             2: Push Fields -> "MOB:NitroTrans"
3874 FLTR             <deferred from filter MOB:DI/800 NitroTrans New>
3875 SQL Tue Jun 19 2012 13:55:30.5196 0.0003         SELECT T396.C1 FROM T396 WHERE ((0 = 0) AND (T396.C600043005 IS NULL)) ORDER BY 1 ASC
3876 SQL Tue Jun 19 2012 13:55:30.5203 0.0007         OK
3877 FLTR Tue Jun 19 2012 13:55:30.5203   End of filter processing (phase 2) -- Operation - CREATE on MOB:Driftinfo - 000000000437765
3878 API Tue Jun 19 2012 13:55:30.5204 0.0001 -CE OK -- New ID 000000000437765
Total time of call 0.0371