**
*I enabled a combined server-side Active link, Filter, API, and SQL
logging (and saved all logs to the same file location)". **I marked the
last one of my SQL statements in red in this log.** *
*See the last marked bolded red UPDATE SQL statement way below for example
. In this case I don't want this UPDATE SQL statement to occur. *
*My objective is to **find which workflow item qualifications I need to
change so that this UPDATE does not occur. How do I find how this SQL
statement was generated? *
*The following is a portion of the log. *
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 >
SHR:ConsolidatedList - <NULL>
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > Checking
SHR:CL-SetConsolidatedStatus (500)
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > --> Passed
-- perform actions
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4640 */SELECT T360.C1,T360.C1 FROM T360 WHERE (
T360.C240000005 IS NULL) ORDER BY 1 ASC*
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 >
Assigned To FullName (536870913) =
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > 2:
Set Fields
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4640 */SELECT T360.C1,T360.C1 FROM T360 WHERE ('A81106' =
T360.C240000005) ORDER BY 1 ASC*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4640 */SELECT C240000003,C240000004 FROM T360 WHERE C1 =
'000000000007675'*
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 >
Real Submitter FullName (536870914) = Polo Jorge
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > Checking
BWC:SHR-RealSubmitterFN (500)
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > --> Passed
-- perform actions
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > 0:
Set Fields
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4640 */SELECT T345.C1,T345.C1 FROM T345 WHERE ('HD266570' =
T345.C1) ORDER BY 1 ASC*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4640 */SELECT C240000001 FROM T345 WHERE C1 = 'HD266570'*
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 >
Requester FullName (536870912) = Fulk Robert
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > Checking
BWC:SHR:Cons-SetNames1 (600)
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > --> Failed
qualification
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */ End of filter processing (phase 1)
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */INSERT INTO T355
(C260000003,C4,C240000006,C260000130,C200000003,C200000006,C260000001,C536870917,C200000005,C260000126,C536870916,C260000005,C200000012,C250000032,C240000009,C200000007,C260000000,C260000009,C2,C8,C200000004,C230000009,C300971700,C536870914,C536870913,C536870912,C7,C260000504,C300970000,C300970100,C300970200,C3,C5,C6,C1)
VALUES ('Help Desk Case',NULL,'Access/App',0,'Software','30 W. Spring
St.',1,'EV000206','Unable to
Access',1,'A81106','HD266570','BWC',1,1,'Columbus','Assigned',1,'Fulkw','system
creates case with resolved status','Intrafin','MAINHELPDESK',1,'Polo
Jorge',' ','Fulk
Robert',0,1,0,0,0,1177948963,'A81106',1177948963,'000000000045072')*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */UPDATE T355 SET C240000007 = 'placeholder' WHERE C1 =
'000000000045072'*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */SELECT C240000007 FROM T355 WHERE C1 =
'000000000045072'*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */Set LOB into the above row...*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */INSERT INTO H355 (entryId,T0,U0) VALUES
('000000000045072',1177948963,'A81106')*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */COMMIT TRANSACTION*
<FLTR> <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */ End of filter processing (phase 2)
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */BEGIN TRANSACTION*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4800 */UPDATE T434 SET
C610001201=36,C5='A81106',C6=1177948963 WHERE C1 = 'EV000206'*
*<SQL > <TID: 0000003188> <RPC ID: 0286102605> <Queue: Fast >
<Client-RPC: 390620 > <USER: A81106 > /* Mon Apr 30
2007 12:02:43.4950 */UPDATE T345 SET
C300751700=1177948962,**C7=4**,C250000030=2,C250000016=NULL,C250000017=NULL,C240000016=NULL,C536870916=NULL,C536870914='Date
and time Changed by Status
Pri Assigned Group Assigned Person*
*4/30/2007 12:02:42 PM Polo Jorge New
Medium Access/App **
4/30/2007 12:02:42 PM Polo Jorge Resolved
Medium Access/App
',C250000022=NULL,C250000013=NULL,C250000014=NULL,C250000015=NULL,C250000021=NULL,C250000031=1178121762,C260000004=0,C4=NULL,C250000011=NULL,C5='A81106',C6=1177948963
WHERE C1 = 'HD266570'*
Portions of this message may be confidential under an exemption to Ohio's
public records law or under a legal privilege. If you have received this
message in error or due to an unauthorized transmission or interception,
please delete all copies from your system without disclosing, copying, or
transmitting this message.
__20060125_______________________This posting was submitted with HTML in
it___
