:) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 02, 2011 4:15 PM To: [email protected] Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio
Ok ... I am bad today.. I didn't even look at the WHERE clause -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, March 02, 2011 5:08 PM To: [email protected] Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio That’s odd … The SQL is for a LEFT outer JOIN so it should return all rows from T1415 (AR System Metadata: actlink) even if there is no corresponding row in T1417 (AR System Object Relationships) since T1415 is on the left. SELECT TOP 1000000000 J0.C1, J0.C20000, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON (J0.C20000 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0)) ORDER BY J0.C1 ASC Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, March 02, 2011 4:30 PM To: [email protected] Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio ** Some more information on this for the list….I experienced this some more today and decided to do some digging. I found the cause/fix for it. I wanted to know where Dev studio got its list of workflow, so I turned on SQL logging and found this <API > /* Wed Mar 02 2011 14:52:27.2290 */+GLEWMSF ARGetListEntryWithMultiSchemaFields -- from Developer Studio (protocol 14) at IP address x.x.x.x <SQL > /* Wed Mar 02 2011 14:52:27.2290 */SELECT TOP 1000000000 J0.C1, J0.C20000, J0.C20013, J0.C20012, J0.C20500, J0.C20005, J0.C20506, J0.C20001, J0.C20002, J0.C20003, J1.C756, J1.C757 FROM T1415 J0 LEFT JOIN T1417 J1 ON (J0.C20000 = J1.C754) WHERE ((J1.C751 = 501) AND (J1.C756 = 1) AND (J0.C20001 > 0)) ORDER BY J0.C1 ASC <SQL > /* Wed Mar 02 2011 14:52:27.3700 */OK I found that 1415 was ‘AR System Metadata: actlink’ and 1417 was ‘AR System Object Relationships’. So it appears that if you have object relationships turned on, Dev Studio uses that table. So I looked through that list and found my missing AL wasn’t in the list. So I broke the join apart and pulled the same data minus the join and found my AL WAS in that list…. So I went into that table and looked, and sure enough, my AL did not have an entry….so I went into the admin console and unchecked ‘Record Object Relationships’, restarted (it deleted the records), re-checked it, restarted, and low and behold it showed up….so…. There is a bug somewhere in the object relationship status that doesn’t record all objects….and because the records aren’t there, those objects don’t show up in the dev studio…..bad design if you ask me…but I now have a workaround to it, and that’s what I truly needed ☺ -----Original Message----- From: LJ LongWing [mailto:[email protected]] Sent: Friday, February 11, 2011 9:25 AM To: '[email protected]' Subject: RE: EXTERNAL: Re: workflow objects hiding in Developer Studio So you weren’t able to find a common cause of the ones that disappeared? And FYI, the only ones I have seen ‘missing’ are AL’s. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Friday, February 11, 2011 8:58 AM To: [email protected] Subject: Re: EXTERNAL: Re: workflow objects hiding in Developer Studio ** LJ and Fred, It’s got to be gremlins. Today I opened the filters and saw all of them BUT there are Active Links still missing/hiding. I did the same thing LJ. Opened an AL in the old admin tool and cycled the enabled check box. Saved it in the Admin tool then I went to the Dev Studio (both running at the same time) and hitF5 and that AL showed up in the list now. Maybe by tomorrow they’ll all be there. Oh and on the filters that showed up today, they have their old modified dates so nothing was done to the filters elsewhere. On to 7.6.04 I guess. Thanks all. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Friday, February 11, 2011 10:43 AM To: [email protected] Subject: EXTERNAL: Re: workflow objects hiding in Developer Studio ** John, I just came across this situation in my 7.5 Patch 7 environment earlier this week. The only way I was able to find the workflow was in the 7.1 Admin tool, same as you, a simple save caused it to re-appear in the 7.5 Dev studio…I haven’t had a chance to do a deep dive on this and figure out what is going on or exactly what caused it. One ‘clue’ on my part is that the workflow I’m dealing with is all associated (either primary form or push to that form) to a form that was renamed. I don’t have much, anything you can share about your cause might help nail it down. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Thursday, February 10, 2011 5:09 PM To: [email protected] Subject: workflow objects hiding in Developer Studio ** Hello Listers, ARS 7.6.03 SQL Server 2005 Has anyone had the experience of workflow that “appears” to be missing from the system? I did an upgrade from 7.1 to 7.6.03 and when I go in to try to find my filters there are 2 filters in the All Objects | Filters section. Now I’ve increased the number to 221 by finding the filters via the Applications sections an “touching” them. In the Application listing the Primary Form column is empty until I open a filter and disable/enable it then save it. The Primary Form is displayed in the filter object when opened just not in the list’s column. I don’t want to open and mess with every filter, active link and escalation in the system. Is there perhaps setting to configure for this? I’ve checked the “Filter by” and everything is cleared. I set the Relationship checkbox via the Administration console and restarted the services before I ever noticed the “missing” objects. I really new to the Developer Studio so I may have munged something along the way. Any help is appreciated. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
