no my asset ID's are all int under 6 characters and under. On Wed, Jun 8, 2011 at 10:41 AM, Tommy Morris <tommy.mor...@radioshack.com>wrote:
> ** > > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh > *Sent:* Wednesday, June 08, 2011 9:35 AM > > *To:* arslist@ARSLIST.ORG > *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 <tommy.mor...@radioshack.com> > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh > *Sent:* Wednesday, June 08, 2011 9:19 AM **** > > > *To:* arslist@ARSLIST.ORG > *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 <tommy.mor...@radioshack.com> > 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: > arslist@ARSLIST.ORG] *On Behalf Of *Kevin Begosh > *Sent:* Wednesday, June 08, 2011 9:02 AM **** > > > *To:* arslist@ARSLIST.ORG > *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 <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 > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > > > > -- > Kevin Begosh > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** > > > > > -- > Kevin Begosh > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** > _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"