Thanks for the reply. Sorry for the abbreviations... NE = Normalization Engine and RE = Reconciliation Engine.
Yes, for the MAC CIs (BMC_LANEndPoint) we are using the MAC as the Primary Key We have checked and we are not seeing duplicates in the different import datasets. For example there is one MAC CI in our import (temp) dataset from the network data source and the same MAC CI once in the LANDesk import (temp) dataset. The network import dataset was identified and merged to the production dataset. We then ran an Identify activity on the MAC CI in the LANDesk dataset it ends up with a new ReconciliationId. We are expecting the LANDesk CI to get its ReconId from the network MAC already in the production dataset. Do we have this wrong? *** As I am replying I took a look at the CIs and noticed that our LANDesk MAC CIs have trailing spaces. I can see how that will be a problem. We were doing LTRIM and RTRIM on all of the fields being used as Primary Keys but it looks like it was removed on this mapping. Looks like this instance might be solved. Thanks! Jason On Wed, Aug 11, 2010 at 5:11 PM, Chowdhury, Tauf <[email protected]>wrote: > ** > > Jason, > Not sure what NE and RE is but if you are using an AIE data exchange, is > your Primary Key field the MAC attribute? If not, then that could possibly > be why you see duplicates. Also, are there duplicates in the source or are > there only duplicates after you do a Reconciliation? Actually, is the > duplicate CI in the staging dataset or in BMC.ASSET? If it is in the staging > dataset (the temp dataset where CI's are put into after AIE pulls from the > source), then perhaps it is an AIE mapping issue or just eliminate the dupes > from the source if you can. However, if the dupe is getting created in > BMC.ASSET only after you do your reconciliation, then I would check the > identification rules to make sure you are identifying correctly and CMDB > doesn't think that you are merging a new record every time. > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) on behalf of Jason > Miller > Sent: Wed 8/11/2010 6:27 PM > To: [email protected] > Subject: Atrium Core case sensitive? > > Hello everybody, > > We are fairly new to CMDB/AIE/NE/RE. We are having issues with CIs from > different import sources not identifying as the same CI. Our database is > MS > SQL and is configured as case insensitive. We are now looking to see if > case sensitivity is an issue. For example we will get duplicate MAC CIs in > the production dataset for 001B783ED321 and 001b783ed321 after an ID and > Merge. > > What are we missing. Are there any components in the Atrium Core that are > case sensitive? > > Thanks, > Jason > > ARS 7.5 p5 (before the bad one) > Atrium Core 7.6 p2 > ITSM 7.6 p1 > MS SQL 2008 64 bit > Win 2008 64 bit > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > > ------------------------------ > This e-mail and its attachments may contain Forest Laboratories, Inc. > proprietary information that is privileged, confidential or subject to > copyright belonging to Forest Laboratories, Inc. This e-mail is intended > solely for the use of the individual or entity to which it is addressed. If > you are not the intended recipient of this e-mail, or the employee or agent > responsible for delivering this e-mail to the intended recipient, you are > hereby notified that any dissemination, distribution, copying or action > taken in relation to the contents of and attachments to this e-mail is > strictly prohibited and may be unlawful. If you have received this e-mail in > error, please notify the sender immediately and permanently delete the > original and any copy of this e-mail and any printout. > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
