Hi Roger,
I must disagree with your assertion. There is no reason not to update BMC_BaseElement - esp. if you want no auditing. The WUT uses the API, Import uses the API, AIE uses the API (albeit Merge, Submit, Modify - begging the Q: "Why 3 calls?") and the WUT is an awfully hard way to automate things J I use Meta-Update often enough to update BE for data corrections etc. on masses of data in many environments and across many releases. I do mostly write to the BMC join to create or update because I generally want the w/f to fire and the customers auditing to be effected. But sometimes I have to change things like submit dates etc. or make a whack of ad-hoc corrections, and then I go through the chains of regular forms (by querying the class hierarchy) with a Merge NoWorkflow. That chain always ends in BE J I have also many times updated only BE for non-core field changes. Cheers Ben Chernys Senior Software Architect Description: logoSthInc-sm Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Roger Justice Sent: April-17-12 20:09 To: arslist@ARSLIST.ORG Subject: Re: Update Base Element using AIE ** You should never try to update base element through eith import or AIE. You can do it using the WUT since it is a regular form. -----Original Message----- From: Wirasat Siddiqi <wirasat_sidd...@ao.uscourts.gov> To: arslist <arslist@ARSLIST.ORG> Sent: Tue, Apr 17, 2012 2:06 pm Subject: Re: Update Base Element using AIE ** I am restricting only to production dataset (BMC.ASSET) as we not using any reconciliation process. I am not entering any search criteria to limit the data exchange so it should search the entire base element form. However, the data exchange is only searching where 'ClassId' = "BMC_ASSETBASE" as opposed to the entire base element form. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: "Neely, Leonard" <lne...@columnit.com> To: arslist@ARSLIST.ORG Date: 04/17/2012 01:20 PM Subject: Re: Update Base Element using AIE Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> _____ ** Where is the reference to the Rule Validation error in the log you mentioned? Are you updating records in a non-production dataset where it will then get reconciled to the production dataset? Or, are you updating records directly in the production (BMC.ASSET) dataset? If the later, you may want to restrict your Data Exchange to just that dataset. Also, You may want to try using the $KEY$=$KEYLIST$ in the AR From Query section of your Data Exchange. This will limit the query against the AR Form to values that exists in the vendor key list. Leonard From: Action Request System discussion list(ARSList) [ <mailto:arslist@ARSLIST.ORG> mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, April 17, 2012 7:14 AM To: arslist@ARSLIST.ORG Subject: Update Base Element using AIE ** I am trying to update BMC.CORE:BMC_BaseElement class using AIE. I am using instanceID as my primary key. And I am just updating a custom attribute that I added to the Base Element class. I have selected 'Never' from cerate a record from Data Exchange Configuration window as I just want to update the record. When I run the data exchange, I get the Rule Validation Error in the logs. Also, I am seeing following lines in the debug logs. Waiting for next chunk [Tue Apr 17 2012 09:34:16.5040] - <TID: 001> <INFO > CMDB Query: 'ClassId' = "BMC_ASSETBASE" [Tue Apr 17 2012 09:34:16.5040] - <TID: 001> <DTL > CCMDBHandler.BuildClsKeyList(): adding the key field 'Name' for sorting. [Tue Apr 17 2012 09:34:16.5040] - <TID: 001> <INFO > CCMDBHandler::BuildAttributeKeyList => CMDBGetListIntances : From Index [0] Chunksize [50000] [Tue Apr 17 2012 09:34:16.5190] - <TID: 001> <INFO > CCMDBHandler::BuildAttributeKeyList => CMDBGetListIntances : Qualifer:['ClassId' = "BMC_ASSETBASE"] Fetched [4] [Tue Apr 17 2012 09:34:16.5190] - <TID: 001> <STATE > CCMDBHandler::BuildAttributeKeyList => CMDBGetListIntances : Qualifer:['ClassId' = "BMC_ASSETBASE"] Fetched [4] [Tue Apr 17 2012 09:34:16.5190] - <TID: 001> <DTL > Number of AR System Keys obtained 4 [Tue Apr 17 2012 09:34:16.5190] - <TID: 001> <DTL > Number of Vendor Keys obtained 1. Not sure why it is getting 4 records from AR system. Although, there is only record I can see in the base element with that instance ID. Any help would be appreciated. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov _attend WWRUG12 <http://www.wwrug.com/> www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image003.jpg>>
