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 <tommy.mor...@radioshack.com>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: > arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh > *Sent:* Wednesday, June 08, 2011 8:22 AM > > *To:* arslist@ARSLIST.ORG > *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 <tommy.mor...@radioshack.com> > 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 ARSlist: "Where the Answers Are"_ -- Kevin Begosh _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"