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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
