Well that should work then. I was thinking that if the ID was some long cryptic value that there may be an extra character at the end that BE didn't like. But looks like that can't be an issue.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kevin Begosh Sent: Wednesday, June 08, 2011 9:35 AM To: [email protected] Subject: Re: AIE Mapping Against Base Element ** I will do that as soon as I can get back in, but I am not sure I follow the logic. Right now there is a row in the .csv file with a Asset ID of 2048 and the only record in Base Element in my dataset has a Asset ID of 2048. What is changing them both to 01 going to do? On Wed, Jun 8, 2011 at 10:30 AM, Tommy Morris <[email protected]> wrote: ** Just for grins, change the Asset ID of one of your subset records to "01" in both BE and your data source just to see if there is something in the primary key field that BE doesn't like. That is a goofy thought since you can match against ComputerSystem but maybe there is some work flow thereto normalize the data. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kevin Begosh Sent: Wednesday, June 08, 2011 9:19 AM To: [email protected] Subject: Re: AIE Mapping Against Base Element ** I thought it was odd to. I have not had any other issues with AIE jobs, created, updated etc.... Just on Base Element. On Wed, Jun 8, 2011 at 10:13 AM, Tommy Morris <[email protected]> wrote: ** That is odd. I do not have a test system up with AIE right now so I can 't dig through my old jobs and turn one into an update. What are the user permissions on the ID that is running your AIE? From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kevin Begosh Sent: Wednesday, June 08, 2011 9:02 AM To: [email protected] Subject: Re: AIE Mapping Against Base Element ** That is what I was thinking as well. I actually did delete all my records to 1 and I am only trying to import 18 record as well. When I ran AIE agains BMC_BaseElement it tried to create the record and the AR Requests count was zero Session statistics: AR requests: 0, Vendor requests: 18 When I ran it against computer system it found the record Session statistics: AR requests: 1, Vendor requests: 18 And it updated the computer system. It is like for some reason it cannot find it in Base Element and I don't know why. On Wed, Jun 8, 2011 at 9:50 AM, Tommy Morris <[email protected]> wrote: ** Sorry if this suggestion isn't very helpful but since I was doing a create and not an update then I'm just guessing at what may be happening. Try to use a smaller subset of data and then log the heck out of it. If you only use two records for your import then the logs shouldn't become so unmanageable that you can't parse through them. If you can AIE into one of the joins then you should be able to hit the base. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kevin Begosh Sent: Wednesday, June 08, 2011 8:22 AM To: [email protected] Subject: Re: AIE Mapping Against Base Element ** Tommy, Thanks for the reply. I am trying to update Base Element and that is the reason for the email because I am not having any luck. What I have right now is about 20k CI's among a number of classes, I think there is about 18 different classes I have pushed to total. I was just giving another spreadsheet that had extra data about all those assets. The only thing that this new spreadsheet has that will match the CI's currently in the system is Asset ID. So in my primary Key I have it matching Asset ID to Asset ID. Then in my data mappings I have three fields I am pushing over, these three fields are all custom attributes I added to Base Element. In my Mapping options I am only modifying records not creating and I have it restricted to my dataset, and I am pushing to BMC_BaseElement When I run this it looks via the logs that is cannot find the records I have in the CMDB based on the Asset ID because it tries to create records every time and the AR System form count is 0. I built the exact same mapping and put it against the BMC_ComputerSystem class and it worked fine. I know that I can do this via a staging form but I wanted to keep it all in the mappings if possible. I have never mapped to Base Element before so I did not know if there was some rule I am missing, like you can only create, or you have to have another attribute mapped etc... On Tue, Jun 7, 2011 at 10:04 PM, Tommy Morris <[email protected]> wrote: ** If you are just updating and do not wish the OOB filters to kick off the Base Element is safe enough to import to from AIE. I recently imported around 400k assets from a 5.5 system into CMDB 7.6p1 and the only way that I could pull it off in a timely manner was to run them into BE. I imported them into the BMC.SANDBOX dataset and let the OOB reconciliation jobs pull them into BMC.ASSET. Worked great. _attend WWRUG11 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ -- Kevin Begosh _attend WWRUG11 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ -- Kevin Begosh _attend WWRUG11 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com <http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ -- Kevin Begosh _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
