Hmmm. Thanks Matt, but I think it ain't quite that easy. The source datasets cannot have their CIs deleted at any time. (requirement)
1) I do NOT want a merge activity in these conditions. Rather, based on conditions in all three datasets, I would need to select 1) whether I wanted to do a merge or not, and 2) the source dataset Have you tried the Workflow Execution stuff? It is this area of code that BMC raised the SW thingy for. That code simply doesn't work with any attributes not in BaseElement. The Trace message out of recon for this area of code use "s" instead of "%s" as a printf format string! Try also qualifications containing 0 (CLOB) length char fields from BaseElement. When you say "temporarily" do you mean DO fields? Or in the DB? The "Additionally" part is done with normal filters when the user is the recon user. Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Matt Worsdell Sent: June 22, 2009 4:36 PM To: [email protected] Subject: Re: Recon Jobs Questions Yup Easy. 1.Perform an Identification job on those with your qual and ensure that auto identify is set to off. 2.Do your Merge activity. 3.Delete reconciled CIs from source dataset. 4.Perform Identification on remainder. 5.Final Merge activity. For part 2, you'd need to create a comparison job that runs workflow to get the attributes from the unrelated dataset and store them temporarily. You could then qualify that. Matt > ARS 7.1 p1 > ITSM 7.0.3 p5 > Oracle > Sun > > Hi Folks, > > Quick Q for any Recon experts. > > Is there any way to add a target dataset qualification to a merge job? > > In my case, I have a whack of qualifications for the Source dataset's > CI but I want to add a qualification on the destination CI such that > if destination CI does not exist then do the merge else if it does > exist then only do the merge if this qualification is passed. > > It seems that ARS is always appending AND 'DatasetID' == > "$Src_Dataset_ID$") > to any merge qualifications. > > Similarly, I do NOT want to do the Merge if an attribute is set in an > unrelated dataset. > > Additionally, it seems that there is no way to indicate that a single > attribute is NOT to be merged when the CI does not exist in the target > dataset. If the CI exists, you can weigh the attribute of the target > higher than that of the source. One would have hoped a weight of 0 > would mean to NOT merge that attribute at all. > > Finally, just judging from the logs, it would seem that the SQL is > generated to select CIs BEFORE any get workflow, so the fields set by > get workflow cannot be used in qualifications. However, this Get > workflow could throw errors preventing the recon merges from happening > or adjust values as needed. This begs the question: Can a filter > cancel an update without throwing an error? > > We have had many issues with recon some of which have generated SW > changes that will be in the "next major release" - not 7.5. It would > seem that recon has not been well thought out or is really only > designed to handle the specific purpose of merging different discovery > products' attributes into a whole CI. > > Cheers > Ben Chernys > > Senior Software Architect > Software Tool House Inc. > > Canada / Deutschland / Germany > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: <mailto:[email protected]> > mailto:[email protected] > Web: <http://www.softwaretoolhouse.com/> > http://www.softwaretoolhouse.com > > A free notepad for Diary fields: > <http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm> > http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm > An ARS API scripting tool used for migrations, integrations, imports, > reports, extracts, batch jobs: > <http://www.softwaretoolhouse.com/products/SthMupd> > http://www.softwaretoolhouse.com/products/SthMupd > > > > > > > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
