Hi All ,
I have some very strange behavior in a pair of table fields with a different
form in each table. The first form SQL shows as expected. One list queue to
match the search criteria and the second to display the columns. On the second
form/table I get the same but then I get the fast queue to get all the fields,
a fast queue to get the attachments, and finally a fast queue to get the status
history.
The tables are set up the same and any active links running in the background
are the same. Anybody have any ideas on what might be happening here?
ARS 6.3 Patch 20, with Oracle 9.2, on SunOS 5.9
Thanks
Mark
First Form Table SQL
<SQL > <TID: 0000000037> <RPC ID: 0007514328> <Queue: List > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:20.6081 */SELECT
T142.C1,T142.C1,C536870919,C536871013,C7,C536870926,C536870918,C536870921,C600100085,C600000001,C536870999,C3,C536870974,T142.C1
FROM T142 WHERE (((T142.C7 < 4) AND (T142.C536870950 = 'Mark Brittain')) AND
(T142.C4 = 'IT - Applications')) ORDER BY 14 DESC
<SQL > <TID: 0000000037> <RPC ID: 0007514329> <Queue: List > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:20.7541 */SELECT
T142.C1,T142.C1,C3,C6,C7,C536870921,C536870919,C536871013,C536870930,C600000913,C4,C536870950,C600100179,C600100180,T142.C1
FROM T142 WHERE ('TT#02129563' = T142.C1) ORDER BY 15 ASC
Second Form Table SQL
<SQL > <TID: 0000000037> <RPC ID: 0007514402> <Queue: List > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:46.3599 */SELECT
T141.C1,T141.C1,C536870913,C536870992,C7,C536870964,C536870965,C536870987,C600100085,C600000001,C600100019,C536871104,C3,C536870919,T141.C1
FROM T141 WHERE (((T141.C7 < 3) AND (T141.C4 = 'Mark Brittain')) AND
(T141.C536870950 = 'IT - Applications')) ORDER BY 15 DESC
<SQL > <TID: 0000000037> <RPC ID: 0007514403> <Queue: List > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:46.6713 */SELECT
T141.C1,T141.C1,C7,C3,C536870913,C536870992,C536870916,C536870950,C4,C536870929,C600100179,C600100180
FROM T141 WHERE ('CR000369393' = T141.C1) ORDER BY 1 ASC
Full Second Form SQL
<SQL > <TID: 0000000036> <RPC ID: 0007514404> <Queue: Fast > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:46.7336 */SELECT
C1,C2,C3,C4,C5,C6,C7,C8,0,C112,C100000005,C110000000,C536870912,C536870913,C536870914,C536870915,C536870916,C536870917,C536870918,C536870919,C536870920,C536870921,C536870922,C536870923,C536870924,0,C536870928,C536870929,C536870930,C536870931,C536870932,C5368
Second Form Attachments
<SQL > <TID: 0000000036> <RPC ID: 0007514404> <Queue: Fast > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:46.7719 */SELECT
CO536870925,CC536870925,C536870925,CO536871040,CC536871040,C536871040,CO536871041,CC536871041,C536871041,CO536871042,CC536871042,C536871042,CO536871043,CC536871043,C536871043,CO600100146,CC600100146,C600100146,CO600100147,CC600100147,C600100147,CO600100148,CC600100148,C600100148,CO900090048,CC900090048,C900090048,CO900090050,CC900090050,C900090050,CO900090052,CC900090052,C900090052,CO900090060,CC900090060,C900090060,CO900090061,CC900090061,C900090061,CO900090064,CC900090064,C900090064
FROM B141 WHERE C1 = 'CR000369393'
Second Form Status History
<SQL > <TID: 0000000036> <RPC ID: 0007514404> <Queue: Fast > <Client-RPC:
390620 > <USER: mbrittain > /* Mon Apr 18 2011
15:08:46.7784 */SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5 FROM H141
WHERE entryId = 'CR000369393'
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the
person or entity to which it is addressed and may contain information that is
privileged, confidential, or otherwise protected from disclosure. Distribution
or copying of this e-mail, or the information contained herein, to anyone other
than the intended recipient is prohibited.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
