12 Replies Latest reply: Mar 28, 2012 6:22 AM by Carl Wilson RSS

Help with AIE 7.1 data exchange config

Kevin NameToUpdate

 

 

Hi

 

I am busy trying to set up and test an external AR data exchange from Sql Server 2005 to Remedy 7.1 Asset system,

 

I have spent quite a few days  now on trying to get AIE  to successfully process the data but so far no luck.


Essentially what I am trying to do is update a number of fields of the AST:ComputerSystem form for existing entries.

If the entry from the vendor form does not exist in AR then create an entry.

 

I have tried numerous configurations of AR System form Mapping screen, specifically in the Query-Data Key Query and Update Query and Option tabs, but all that ever happens is new  entries are created even if ones exists i.e AIE just creates duplicates, and updates never occur??!

 

I have attached screenshots of the pertinent AIE configuration.

 

26-03-2012 08-51-54.jpg

26-03-2012 08-40-21.jpg

22-03-2012 16-58-32.jpg

26-03-2012 08-46-16.jpg

 

26-03-2012 08-47-17.jpg

 

 

I'm so close tosolving this I feel, just need to get AIE to start comparing entries both side...what am i missing or omitting?????

  • 1. Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    42 views no replies?

     

    Any BMC Remedy folk around ?

  • 2. Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi,

    true you are close. 

    You should also realise that a lot of the folks on here are from different timezones, so you should allow time for people to answer from different geographics.

     

    You make use of the "Query" tab to control your flow of records.

     

    The "Data Key Query" is used for new creation of records, so this is where you can place a limitation on what it created based on the query. 

    Note:  The "External Data Store Query" is a SQL based statement, where as the "AR Form Query:" is similar to performing an Advanced Search in AR.

     

    The "Update Query" tab is where you can limit your updates to existing records based on a query.  Again this is an AR based query.

     

    So for creation, the system uses the primary key as the identifier so you may need to include additional fields with the key to limit new creations and updates e.g. Serial Number, Name, etc.

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 3. Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    Hi Carl

     

    I have tried using queries on all thos tabs, the result is the same...

    The system doesn't seem to use them properly or as I expect.

     

    Can you tell me what I need to supply if I require the following:

     

    only update an AR entry if AR.serialnumber = Vendor.serial numbe,  else create new entry in AR.

    Also for testing how do I limit the number of entries to say, 10?

     

    As i have mentioned I have tried everything, with no success.

  • 4. Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi,

    check your options on the Main tab for the data exchange.  There is an option for "Data in target" > "Create a record" > "If no duplicate exists".  Ensure that this is not set to "Always" which will override anything you are attempting to limit with queries/rules/etc.

     

    Also, are you using the "CI Class Mapping" data to create the exchange?  I see you are going to the AST form and not the actual CMDB, so wondering why here first off.

     

    The AIE Guide show some example queries for each type of exchange for limiting updates etc. Check out the section on "Defining a data key query".  Here you can use a mixture of the AR field and the external source field to create a query.  Better explained in the guides with examples than for me to attempt here, but remember these are for limiting the data retrieved as opposed to stopping creation based on a query - this is handled by the Primary Key and the above "Main" tab settings.

     

    To limit the exchange entries, you would need to have a valid external query to match only a subset of records.

     

    It can be a steep learning curve with AIE before the pieces fit into place.

     

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 5. Re: Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    Hi Carl and thank you for your continued assistance...

     

    The data exchange type is AR, not CI class or Relationship class.

     

    I have put up more screen shots to clarify my settings and data exchange config.

     

    I am still confused as to why it is not processing the exchange data correctly

     

    26-03-2012 13-12-44.jpg

    26-03-2012 13-07-20.jpg

     

    26-03-2012 13-10-03.jpg

     

    26-03-2012 13-10-54.jpg

     

    26-03-2012 13-12-03.jpg

  • 6. Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi,

    are you expecting updates or new records?

    You have specified the first 5 rows in the external source looking from your query. 

    Have you validated this is a correct query working against your external store?  It is a SQL based query, so you should be in the format of:

     

    SELECT * FROM {tablename} WHERE rownumber < 5

     

    The other settings "should" stop duplicates.

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 7. Re: Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    Hi

     

     

    SELECT * FROM {tablename} WHERE rownumber < 5 returns first 5 rows of table.

     

    I am expecting updates for the first 5 Vendor returned entries, they match serials in ATS:ComputerSystem for...but the system is actually creating new duplicate entries!!

     

    Why are AR rows not being selected against which to check the External rows selected?

    I have specified $Serial Number$ = $SRC|SerialNumber$ in the Update Query tab.

     

     

    Here is some  the log output

     

    Interestingly, no AR records are being returned, why?

     

    [Mon Mar 26 2012 14:09:32.4980] - <TID: 001> <DTL   > Number of AR System Keys obtained 0.

    [Mon Mar 26 2012 14:09:32.4980] - <TID: 001> <DTL   > Number of Vendor Keys obtained 4.

     

     

    [Mon Mar 26 2012 13:58:26.8620] - <TID: 001> <SQL   > CONNECT ARSystem, USER sa (Native Database)

    [Mon Mar 26 2012 13:58:26.8620] - <TID: 001> <STS   > StartDataHandlers: Connection established to both AR/CMDB and vendor application.

    [Mon Mar 26 2012 13:58:26.8620] - <TID: 001> <STATE > Start Data Exchange at Mon Mar 26 13:58:26 2012

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > **********************************************************************

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > *** Warning: This exchange is configured with a record limit of 6.

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > *** The limit is intended only to limit the data exchanged during testing

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > *** of a new data exchange configuration.  It does not provide EIE with a

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > *** complete list of records available in the system and might result in an

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > *** unpredictable handling of created or deleted records when the limit is reached.

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <STATE > **********************************************************************

     

    [Mon Mar 26 2012 13:58:26.9090] - <TID: 001> <INFO  > rownumber < 5

    [Mon Mar 26 2012 13:58:26.9710] - <TID: 001> <STATE > AR key list provided to Vendor.

    [Mon Mar 26 2012 13:58:27.9710] - <TID: 001> <DTL   > eiearhandler.BuildKeyList(): adding the key field '200000001' for sorting.

    [Mon Mar 26 2012 13:58:27.9710] - <TID: 001> <API   > + ARGetListEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 13:58:57.3620] - <TID: 001> <API   > - ARGetListEntry    OK

    [Mon Mar 26 2012 13:58:57.3620] - <TID: 001> <DTL   > AR System key list created in form 'AST:ComputerSystem'

    [Mon Mar 26 2012 13:58:57.7830] - <TID: 001> <DTL   > Number of AR System Keys obtained 0.

    [Mon Mar 26 2012 13:58:57.7830] - <TID: 001> <DTL   > Number of Vendor Keys obtained 4.

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE >         AddAllRecordsInKeyList: add is supported, [4] entries will be added to AR/CMDB

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE > Start comparing list of records on Mon Mar 26 13:58:58 2012

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE > SessionID=GAMS_CLARIS_COMPUTERSYSTEM

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE > direction=VendorDataIntoAR

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE > updateType=Both New and Changed

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <STATE > AR System Data Server=PHCHBS-S3660

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <SQL   > + Get Data SQL command : SELECT [GAMS_CLRS_DomainName], [Name], [GAMS_CLRS_BIOSVersion], [GAMS_CLARIS_Edition], [GAMS_CLARIS_ApplicationPortfolio], [GAMS_CLARIS_OSName], [GAMS_CLARIS_OwningBU], [GAMS_CLARIS_UsingBU], [GAMS_CLRS_CPU0MaxClockSpeed], [GAMS_CLRS_DriveSize], [GAMS_CLRS_InstallDate], [GAMS_CLRS_LABBusinessUnit], [GAMS_CLRS_LABInstallationType], [GAMS_CLRS_Language], [GAMS_CLRS_MACAddress], [GAMS_CLRS_Manufacturer], [GAMS_CLRS_Model], [GAMS_CLRS_NumberOfCPUs], [GAMS_CLRS_Role], [GAMS_CLRS_Sector], [GAMS_CLRS_Site], [GAMS_CLRS_Source], [GAMS_CLRS_TotalPhysicalMemory], [LastScanDate], [OwnerName], [OwnerContact], [SerialNumber], [AssetLifeCycleStatus], [DatasetId], [SerialNumber] FROM [dbo].[EXT_CLARIS_COMPUTERSYSTEM_MV1] WITH (NOLOCK) WHERE [SerialNumber] = 'HK8T23J' AND (rownumber < 5)

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <SQL   > - Get Data SQL command    OK

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   > Data obtained from Source for mappings: 'test'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 1     : 'GAMS_CLRS_DomainName', Value: 'EU.NOVARTIS.NET'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 2     : 'Name', Value: 'AHGBDD-W29014'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 3     : 'GAMS_CLRS_BIOSVersion', Value: '2.3.1'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 4     : 'GAMS_CLARIS_Edition', Value: 'ENGINE'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 5     : 'GAMS_CLARIS_ApplicationPortfolio', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 6     : 'GAMS_CLARIS_OSName', Value: 'MICROSOFT WINDOWS XP PROFESSIONAL'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 7     : 'GAMS_CLARIS_OwningBU', Value: 'Global Infrastructure Services'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 8     : 'GAMS_CLARIS_UsingBU', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 9     : 'GAMS_CLRS_CPU0MaxClockSpeed', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 10    : 'GAMS_CLRS_DriveSize', Value: '79000'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 11    : 'GAMS_CLRS_InstallDate', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 12    : 'GAMS_CLRS_LABBusinessUnit', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 13    : 'GAMS_CLRS_LABInstallationType', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 14    : 'GAMS_CLRS_Language', Value: 'Swiss German'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 15    : 'GAMS_CLRS_MACAddress', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 16    : 'GAMS_CLRS_Manufacturer', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 17    : 'GAMS_CLRS_Model', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 18    : 'GAMS_CLRS_NumberOfCPUs', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 19    : 'GAMS_CLRS_Role', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 20    : 'GAMS_CLRS_Sector', Value: 'AH'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 21    : 'GAMS_CLRS_Site', Value: 'GBDD'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 22    : 'GAMS_CLRS_Source', Value: 'NLS'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 23    : 'GAMS_CLRS_TotalPhysicalMemory', Value: '1037'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 24    : 'LastScanDate', Value: '1332147905'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 25    : 'OwnerName', Value: ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 26    : 'OwnerContact', Value: 'MILNEGA1'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 27    : 'SerialNumber', Value: 'HK8T23J'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 28    : 'AssetLifeCycleStatus', Value: '3'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 29    : 'DatasetId', Value: 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   > Setting field values of Target for mappings 'test'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 1     : <Domain (id: 260140117)> set to 'EU.NOVARTIS.NET'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 2     : <Name (id: 200000020)> set to 'AHGBDD-W29014'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 3     : <GAMS_BiosVersion (id: 536871943)> set to '2.3.1'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 4     : <Edition (id: 900000027)> set to 'ENGINE'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 5     : <Workgroup (id: 301019600)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 6     : <Environment Specification (id: 301019800)> set to 'MICROSOFT WINDOWS XP PROFESSIONAL'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 7     : <OwningBU (id: 900000025)> set to 'Global Infrastructure Services'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 8     : <UsingBU (id: 900000026)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 9     : <GAMS_MaxClockSpeed (id: 536871915)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 10    : <GAMS_DriveSize (id: 536871919)> set to '79000'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 11    : <Installation Date (id: 260000104)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 12    : <GAMS_LABBusinessUnit (id: 536871939)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 13    : <GAMS_LABInstallType (id: 536871935)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 14    : <GAMS_LanguageSettings (id: 536871931)> set to 'Swiss German'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 15    : <GAMS_MACAdress (id: 536871923)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 16    : <GAMS_CLRS_Manufacturer (id: 900000005)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 17    : <GAMS_CLRS_Model (id: 900000006)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 18    : <GAMS_NumberOfCPUs (id: 536871927)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 19    : <GAMS_CLRS_Role (id: 900000004)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 20    : <GAMS_CLRS_Sector (id: 900000003)> set to 'AH'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 21    : <GAMS_CLRS_Site (id: 900000002)> set to 'GBDD'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 22    : <GAMS_CLRS_Source (id: 900000007)> set to 'NLS'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 23    : <Total Physical Memory (id: 200000022)> set to '1037'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 24    : <LastScanDate (id: 300927600)> set to '03/19/2012 10:05:05'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 25    : <Owner_name (id: 301002900)> set to ''

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 26    : <Owner_contact (id: 301002800)> set to 'MILNEGA1'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 27    : <Serial Number (id: 200000001)> set to 'HK8T23J'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 28    : <AssetLifecycleStatus (id: 7)> set to '3'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   >     Rule 29    : <Data Set Id (id: 400127400)> set to 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <DTL   > Adding entry HK8T23J to form 'AST:ComputerSystem'

    [Mon Mar 26 2012 13:58:58.8150] - <TID: 001> <API   > + ARCreateEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 13:58:59.6900] - <TID: 001> <API   > - ARCreateEntry    OK

    [Mon Mar 26 2012 13:58:59.6900] - <TID: 001> <DTL   > Entry HK8T23J was added to AR

    [Mon Mar 26 2012 13:58:59.6900] - <TID: 001> <SQL   > + Get Data SQL command : SELECT [GAMS_CLRS_DomainName], [Name], [GAMS_CLRS_BIOSVersion], [GAMS_CLARIS_Edition], [GAMS_CLARIS_ApplicationPortfolio], [GAMS_CLARIS_OSName], [GAMS_CLARIS_OwningBU], [GAMS_CLARIS_UsingBU], [GAMS_CLRS_CPU0MaxClockSpeed], [GAMS_CLRS_DriveSize], [GAMS_CLRS_InstallDate], [GAMS_CLRS_LABBusinessUnit], [GAMS_CLRS_LABInstallationType], [GAMS_CLRS_Language], [GAMS_CLRS_MACAddress], [GAMS_CLRS_Manufacturer], [GAMS_CLRS_Model], [GAMS_CLRS_NumberOfCPUs], [GAMS_CLRS_Role], [GAMS_CLRS_Sector], [GAMS_CLRS_Site], [GAMS_CLRS_Source], [GAMS_CLRS_TotalPhysicalMemory], [LastScanDate], [OwnerName], [OwnerContact], [SerialNumber], [AssetLifeCycleStatus], [DatasetId], [SerialNumber] FROM [dbo].[EXT_CLARIS_COMPUTERSYSTEM_MV1] WITH (NOLOCK) WHERE [SerialNumber] = 'R83W4AL' AND (rownumber < 5)

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <SQL   > - Get Data SQL command    OK

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Data obtained from Source for mappings: 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : 'GAMS_CLRS_DomainName', Value: 'ap.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : 'Name', Value: 'PHCNZJ-W10004'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : 'GAMS_CLRS_BIOSVersion', Value: '5CKT62AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : 'GAMS_CLARIS_Edition', Value: 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : 'GAMS_CLARIS_ApplicationPortfolio', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : 'GAMS_CLARIS_OSName', Value: 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : 'GAMS_CLARIS_OwningBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : 'GAMS_CLARIS_UsingBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : 'GAMS_CLRS_CPU0MaxClockSpeed', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : 'GAMS_CLRS_DriveSize', Value: '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : 'GAMS_CLRS_InstallDate', Value: '1328662680'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : 'GAMS_CLRS_LABBusinessUnit', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : 'GAMS_CLRS_LABInstallationType', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : 'GAMS_CLRS_Language', Value: 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : 'GAMS_CLRS_MACAddress', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : 'GAMS_CLRS_Manufacturer', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : 'GAMS_CLRS_Model', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : 'GAMS_CLRS_NumberOfCPUs', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : 'GAMS_CLRS_Role', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : 'GAMS_CLRS_Sector', Value: 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : 'GAMS_CLRS_Site', Value: 'CNZJ'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : 'GAMS_CLRS_Source', Value: 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : 'GAMS_CLRS_TotalPhysicalMemory', Value: '3652'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : 'LastScanDate', Value: '1332147905'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : 'OwnerName', Value: 'KENYOYU1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : 'OwnerContact', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : 'SerialNumber', Value: 'R83W4AL'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : 'AssetLifeCycleStatus', Value: '88'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : 'DatasetId', Value: 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Setting field values of Target for mappings 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : <Domain (id: 260140117)> set to 'ap.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : <Name (id: 200000020)> set to 'PHCNZJ-W10004'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : <GAMS_BiosVersion (id: 536871943)> set to '5CKT62AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : <Edition (id: 900000027)> set to 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : <Workgroup (id: 301019600)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : <Environment Specification (id: 301019800)> set to 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : <OwningBU (id: 900000025)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : <UsingBU (id: 900000026)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : <GAMS_MaxClockSpeed (id: 536871915)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : <GAMS_DriveSize (id: 536871919)> set to '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : <Installation Date (id: 260000104)> set to '02/08/2012 01:58:00'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : <GAMS_LABBusinessUnit (id: 536871939)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : <GAMS_LABInstallType (id: 536871935)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : <GAMS_LanguageSettings (id: 536871931)> set to 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : <GAMS_MACAdress (id: 536871923)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : <GAMS_CLRS_Manufacturer (id: 900000005)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : <GAMS_CLRS_Model (id: 900000006)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : <GAMS_NumberOfCPUs (id: 536871927)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : <GAMS_CLRS_Role (id: 900000004)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : <GAMS_CLRS_Sector (id: 900000003)> set to 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : <GAMS_CLRS_Site (id: 900000002)> set to 'CNZJ'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : <GAMS_CLRS_Source (id: 900000007)> set to 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : <Total Physical Memory (id: 200000022)> set to '3652'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : <LastScanDate (id: 300927600)> set to '03/19/2012 10:05:05'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : <Owner_name (id: 301002900)> set to 'KENYOYU1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : <Owner_contact (id: 301002800)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : <Serial Number (id: 200000001)> set to 'R83W4AL'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : <AssetLifecycleStatus (id: 7)> set to '88'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : <Data Set Id (id: 400127400)> set to 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Adding entry R83W4AL to form 'AST:ComputerSystem'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <API   > + ARCreateEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <ERR   > AddAssetToAR: Error processing entry R83W4AL, form AST:ComputerSystem

    AddAssetToAR: AR API returned error during ARCreateEntry rc = 2

    Der Wert liegt außerhalb der für das Feld angegebenen Grenzwerte (306)

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <API   > - ARCreateEntry    Failed

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <ERR   > Entry R83W4AL was not added to AR

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <SQL   > + Get Data SQL command : SELECT [GAMS_CLRS_DomainName], [Name], [GAMS_CLRS_BIOSVersion], [GAMS_CLARIS_Edition], [GAMS_CLARIS_ApplicationPortfolio], [GAMS_CLARIS_OSName], [GAMS_CLARIS_OwningBU], [GAMS_CLARIS_UsingBU], [GAMS_CLRS_CPU0MaxClockSpeed], [GAMS_CLRS_DriveSize], [GAMS_CLRS_InstallDate], [GAMS_CLRS_LABBusinessUnit], [GAMS_CLRS_LABInstallationType], [GAMS_CLRS_Language], [GAMS_CLRS_MACAddress], [GAMS_CLRS_Manufacturer], [GAMS_CLRS_Model], [GAMS_CLRS_NumberOfCPUs], [GAMS_CLRS_Role], [GAMS_CLRS_Sector], [GAMS_CLRS_Site], [GAMS_CLRS_Source], [GAMS_CLRS_TotalPhysicalMemory], [LastScanDate], [OwnerName], [OwnerContact], [SerialNumber], [AssetLifeCycleStatus], [DatasetId], [SerialNumber] FROM [dbo].[EXT_CLARIS_COMPUTERSYSTEM_MV1] WITH (NOLOCK) WHERE [SerialNumber] = 'R8B652R' AND (rownumber < 5)

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <SQL   > - Get Data SQL command    OK

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Data obtained from Source for mappings: 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : 'GAMS_CLRS_DomainName', Value: 'ap.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : 'Name', Value: 'PHSGRI-W20156'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : 'GAMS_CLRS_BIOSVersion', Value: '5CKT68AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : 'GAMS_CLARIS_Edition', Value: 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : 'GAMS_CLARIS_ApplicationPortfolio', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : 'GAMS_CLARIS_OSName', Value: 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : 'GAMS_CLARIS_OwningBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : 'GAMS_CLARIS_UsingBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : 'GAMS_CLRS_CPU0MaxClockSpeed', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : 'GAMS_CLRS_DriveSize', Value: '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : 'GAMS_CLRS_InstallDate', Value: '1322593020'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : 'GAMS_CLRS_LABBusinessUnit', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : 'GAMS_CLRS_LABInstallationType', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : 'GAMS_CLRS_Language', Value: 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : 'GAMS_CLRS_MACAddress', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : 'GAMS_CLRS_Manufacturer', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : 'GAMS_CLRS_Model', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : 'GAMS_CLRS_NumberOfCPUs', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : 'GAMS_CLRS_Role', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : 'GAMS_CLRS_Sector', Value: 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : 'GAMS_CLRS_Site', Value: 'SGRI'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : 'GAMS_CLRS_Source', Value: 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : 'GAMS_CLRS_TotalPhysicalMemory', Value: '1945'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : 'LastScanDate', Value: '1332147905'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : 'OwnerName', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : 'OwnerContact', Value: 'Limvi3'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : 'SerialNumber', Value: 'R8B652R'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : 'AssetLifeCycleStatus', Value: '88'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : 'DatasetId', Value: 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Setting field values of Target for mappings 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : <Domain (id: 260140117)> set to 'ap.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : <Name (id: 200000020)> set to 'PHSGRI-W20156'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : <GAMS_BiosVersion (id: 536871943)> set to '5CKT68AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : <Edition (id: 900000027)> set to 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : <Workgroup (id: 301019600)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : <Environment Specification (id: 301019800)> set to 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : <OwningBU (id: 900000025)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : <UsingBU (id: 900000026)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : <GAMS_MaxClockSpeed (id: 536871915)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : <GAMS_DriveSize (id: 536871919)> set to '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : <Installation Date (id: 260000104)> set to '11/29/2011 19:57:00'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : <GAMS_LABBusinessUnit (id: 536871939)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : <GAMS_LABInstallType (id: 536871935)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : <GAMS_LanguageSettings (id: 536871931)> set to 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : <GAMS_MACAdress (id: 536871923)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : <GAMS_CLRS_Manufacturer (id: 900000005)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : <GAMS_CLRS_Model (id: 900000006)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : <GAMS_NumberOfCPUs (id: 536871927)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : <GAMS_CLRS_Role (id: 900000004)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : <GAMS_CLRS_Sector (id: 900000003)> set to 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : <GAMS_CLRS_Site (id: 900000002)> set to 'SGRI'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : <GAMS_CLRS_Source (id: 900000007)> set to 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : <Total Physical Memory (id: 200000022)> set to '1945'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : <LastScanDate (id: 300927600)> set to '03/19/2012 10:05:05'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : <Owner_name (id: 301002900)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : <Owner_contact (id: 301002800)> set to 'Limvi3'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : <Serial Number (id: 200000001)> set to 'R8B652R'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : <AssetLifecycleStatus (id: 7)> set to '88'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : <Data Set Id (id: 400127400)> set to 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Adding entry R8B652R to form 'AST:ComputerSystem'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <API   > + ARCreateEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <ERR   > AddAssetToAR: Error processing entry R8B652R, form AST:ComputerSystem

    AddAssetToAR: AR API returned error during ARCreateEntry rc = 2

    Der Wert liegt außerhalb der für das Feld angegebenen Grenzwerte (306)

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <API   > - ARCreateEntry    Failed

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <ERR   > Entry R8B652R was not added to AR

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <SQL   > + Get Data SQL command : SELECT [GAMS_CLRS_DomainName], [Name], [GAMS_CLRS_BIOSVersion], [GAMS_CLARIS_Edition], [GAMS_CLARIS_ApplicationPortfolio], [GAMS_CLARIS_OSName], [GAMS_CLARIS_OwningBU], [GAMS_CLARIS_UsingBU], [GAMS_CLRS_CPU0MaxClockSpeed], [GAMS_CLRS_DriveSize], [GAMS_CLRS_InstallDate], [GAMS_CLRS_LABBusinessUnit], [GAMS_CLRS_LABInstallationType], [GAMS_CLRS_Language], [GAMS_CLRS_MACAddress], [GAMS_CLRS_Manufacturer], [GAMS_CLRS_Model], [GAMS_CLRS_NumberOfCPUs], [GAMS_CLRS_Role], [GAMS_CLRS_Sector], [GAMS_CLRS_Site], [GAMS_CLRS_Source], [GAMS_CLRS_TotalPhysicalMemory], [LastScanDate], [OwnerName], [OwnerContact], [SerialNumber], [AssetLifeCycleStatus], [DatasetId], [SerialNumber] FROM [dbo].[EXT_CLARIS_COMPUTERSYSTEM_MV1] WITH (NOLOCK) WHERE [SerialNumber] = 'S4DKH46' AND (rownumber < 5)

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <SQL   > - Get Data SQL command    OK

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Data obtained from Source for mappings: 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : 'GAMS_CLRS_DomainName', Value: 'eu.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : 'Name', Value: 'PHCHBS-W13063'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : 'GAMS_CLRS_BIOSVersion', Value: '5CKT68AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : 'GAMS_CLARIS_Edition', Value: 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : 'GAMS_CLARIS_ApplicationPortfolio', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : 'GAMS_CLARIS_OSName', Value: 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : 'GAMS_CLARIS_OwningBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : 'GAMS_CLARIS_UsingBU', Value: 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : 'GAMS_CLRS_CPU0MaxClockSpeed', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : 'GAMS_CLRS_DriveSize', Value: '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : 'GAMS_CLRS_InstallDate', Value: '1324300740'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : 'GAMS_CLRS_LABBusinessUnit', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : 'GAMS_CLRS_LABInstallationType', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : 'GAMS_CLRS_Language', Value: 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : 'GAMS_CLRS_MACAddress', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : 'GAMS_CLRS_Manufacturer', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : 'GAMS_CLRS_Model', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : 'GAMS_CLRS_NumberOfCPUs', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : 'GAMS_CLRS_Role', Value: ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : 'GAMS_CLRS_Sector', Value: 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : 'GAMS_CLRS_Site', Value: 'CHBS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : 'GAMS_CLRS_Source', Value: 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : 'GAMS_CLRS_TotalPhysicalMemory', Value: '3636'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : 'LastScanDate', Value: '1332147905'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : 'OwnerName', Value: 'ROMACMA1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : 'OwnerContact', Value: 'daumkph1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : 'SerialNumber', Value: 'S4DKH46'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : 'AssetLifeCycleStatus', Value: '11'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : 'DatasetId', Value: 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Setting field values of Target for mappings 'test'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 1     : <Domain (id: 260140117)> set to 'eu.novartis.net'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 2     : <Name (id: 200000020)> set to 'PHCHBS-W13063'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 3     : <GAMS_BiosVersion (id: 536871943)> set to '5CKT68AUS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 4     : <Edition (id: 900000027)> set to 'UMEVendor Preload'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 5     : <Workgroup (id: 301019600)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 6     : <Environment Specification (id: 301019800)> set to 'Microsoft Windows 7 Enterprise'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 7     : <OwningBU (id: 900000025)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 8     : <UsingBU (id: 900000026)> set to 'NIBR'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 9     : <GAMS_MaxClockSpeed (id: 536871915)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 10    : <GAMS_DriveSize (id: 536871919)> set to '152314'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 11    : <Installation Date (id: 260000104)> set to '12/19/2011 14:19:00'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 12    : <GAMS_LABBusinessUnit (id: 536871939)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 13    : <GAMS_LABInstallType (id: 536871935)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 14    : <GAMS_LanguageSettings (id: 536871931)> set to 'US'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 15    : <GAMS_MACAdress (id: 536871923)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 16    : <GAMS_CLRS_Manufacturer (id: 900000005)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 17    : <GAMS_CLRS_Model (id: 900000006)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 18    : <GAMS_NumberOfCPUs (id: 536871927)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 19    : <GAMS_CLRS_Role (id: 900000004)> set to ''

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 20    : <GAMS_CLRS_Sector (id: 900000003)> set to 'PH'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 21    : <GAMS_CLRS_Site (id: 900000002)> set to 'CHBS'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 22    : <GAMS_CLRS_Source (id: 900000007)> set to 'CONNECT'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 23    : <Total Physical Memory (id: 200000022)> set to '3636'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 24    : <LastScanDate (id: 300927600)> set to '03/19/2012 10:05:05'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 25    : <Owner_name (id: 301002900)> set to 'ROMACMA1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 26    : <Owner_contact (id: 301002800)> set to 'daumkph1'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 27    : <Serial Number (id: 200000001)> set to 'S4DKH46'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 28    : <AssetLifecycleStatus (id: 7)> set to '11'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   >     Rule 29    : <Data Set Id (id: 400127400)> set to 'BMC.ASSET'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <DTL   > Adding entry S4DKH46 to form 'AST:ComputerSystem'

    [Mon Mar 26 2012 13:58:59.7050] - <TID: 001> <API   > + ARCreateEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 13:59:00.0800] - <TID: 001> <API   > - ARCreateEntry    OK

    [Mon Mar 26 2012 13:59:00.0800] - <TID: 001> <DTL   > Entry S4DKH46 was added to AR

    [Mon Mar 26 2012 13:59:00.0800] - <TID: 001> <STATE >             CreateEntry:      2, GetVendorData:      0 Requests total:      4, added:      2, updated:      0, deleted: 0, errors: 2, warnings: 0

    [Mon Mar 26 2012 13:59:00.0800] - <TID: 001> <STS   > WaitForThreadsToComplete: Threads Completed: 49

    [Mon Mar 26 2012 13:59:00.0960] - <TID: 001> <STATE > AR key list provided to Vendor.

    [Mon Mar 26 2012 13:59:01.0960] - <TID: 001> <DTL   > Number of AR System Keys obtained 0.

    [Mon Mar 26 2012 13:59:01.0960] - <TID: 001> <DTL   > Number of Vendor Keys obtained 0.

    [Mon Mar 26 2012 13:59:01.0960] - <TID: 001> <STATE > Session statistics: AR requests: 0, Vendor requests: 4

    [Mon Mar 26 2012 13:59:01.0960] - <TID: 001> <STATE > Session statistics: Requests added: 2, updated: 0, deleted: 0, errors: 2, warnings: 0

    [Mon Mar 26 2012 13:59:01.2370] - <TID: 001> <PERF  >

    [Mon Mar 26 2012 13:59:01.2370] - <TID: 001> <STS   > Sleep until next poll interval or scheduled time for data transfer

    [Mon Mar 26 2012 13:59:01.2680] - <TID: 001> <STS   > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application.

    [Mon Mar 26 2012 14:09:01.5920] - <TID: 001> <SQL   > CONNECT ARSystem, USER sa (Native Database)

    [Mon Mar 26 2012 14:09:01.5920] - <TID: 001> <STS   > StartDataHandlers: Connection established to both AR/CMDB and vendor application.

    [Mon Mar 26 2012 14:09:01.5920] - <TID: 001> <STATE > Start Data Exchange at Mon Mar 26 14:09:01 2012

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > **********************************************************************

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > *** Warning: This exchange is configured with a record limit of 2.

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > *** The limit is intended only to limit the data exchanged during testing

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > *** of a new data exchange configuration.  It does not provide EIE with a

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > *** complete list of records available in the system and might result in an

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > *** unpredictable handling of created or deleted records when the limit is reached.

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <STATE > **********************************************************************

     

    [Mon Mar 26 2012 14:09:01.6230] - <TID: 001> <INFO  > rownumber < 5

    [Mon Mar 26 2012 14:09:01.7010] - <TID: 001> <STATE > AR key list provided to Vendor.

    [Mon Mar 26 2012 14:09:02.7170] - <TID: 001> <DTL   > eiearhandler.BuildKeyList(): adding the key field '200000001' for sorting.

    [Mon Mar 26 2012 14:09:02.7170] - <TID: 001> <API   > + ARGetListEntry -- Form[AST:ComputerSystem]

    [Mon Mar 26 2012 14:09:32.3420] - <TID: 001> <API   > - ARGetListEntry    OK

    [Mon Mar 26 2012 14:09:32.3420] - <TID: 001> <DTL   > AR System key list created in form 'AST:ComputerSystem'

    [Mon Mar 26 2012 14:09:32.4980] - <TID: 001> <DTL   > Number of AR System Keys obtained 0.

    [Mon Mar 26 2012 14:09:32.4980] - <TID: 001> <DTL   > Number of Vendor Keys obtained 4.

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE >         AddAllRecordsInKeyList: add is supported, [4] entries will be added to AR/CMDB

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE > Start comparing list of records on Mon Mar 26 14:09:33 2012

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE > SessionID=GAMS_CLARIS_COMPUTERSYSTEM

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE > direction=VendorDataIntoAR

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE > updateType=Both New and Changed

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <STATE > AR System Data Server=PHCHBS-S3660

    [Mon Mar 26 2012 14:09:33.4980] - <TID: 001> <SQL   > + Get Data SQL command : SELECT [GAMS_CLRS_DomainName], [Name], [GAMS_CLRS_BIOSVersion], [GAMS_CLARIS_Edition], [GAMS_CLARIS_ApplicationPortfolio], [GAMS_CLARIS_OSName], [GAMS_CLARIS_OwningBU], [GAMS_CLARIS_UsingBU], [GAMS_CLRS_CPU0MaxClockSpeed], [GAMS_CLRS_DriveSize], [GAMS_CLRS_InstallDate], [GAMS_CLRS_LABBusinessUnit], [GAMS_CLRS_LABInstallationType], [GAMS_CLRS_Language], [GAMS_CLRS_MACAddress], [GAMS_CLRS_Manufacturer], [GAMS_CLRS_Model], [GAMS_CLRS_NumberOfCPUs], [GAMS_CLRS_Role], [GAMS_CLRS_Sector], [GAMS_CLRS_Site], [GAMS_CLRS_Source], [GAMS_CLRS_TotalPhysicalMemory], [LastScanDate], [OwnerName], [OwnerContact], [SerialNumber], [AssetLifeCycleStatus], [DatasetId], [SerialNumber] FROM [dbo].[EXT_CLARIS_COMPUTERSYSTEM_MV1] WITH (NOLOCK) WHERE [SerialNumber] = 'HK8T23J' AND (rownumber < 5)

  • 8. Re: Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi,

    to be honest, there could be a number of reasons that you not matching records.

     

    I would start with the Primary Key as this is what the exchange is using as a record locator.  You can add additional fields to this to make the query more exact to find duplicates with this Primary key. 

    You should not map in the field that is used for the main Primary key, so if you are using serial number this may be why the exchange is creating new entries if it is included in the mappings.  Ideally for an AR Form based transfer, this should be a GUID or another number that is not part of the mapping transfer.

     

    I suggest that as you are doing an Asset transfer that you use the CMDB Class Transfer method which has more flexibility around the primary key for this purpose.  It is also wha the AST forms will populate through entry creation.

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 9. Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    Ok, I have just spent the last few hours doing as you suggested and created a CI class mapping exchange...

     

    The result is the same as before.

     

    No updates are taking place and duplicates inserts occur even if I specify otherwise.

     

    I'm now stumped and giving up on AIE.....

  • 10. Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi,

    I would work with BMC Support on this one, it is very hard to diagnose AIE without being able to fully see what is happening.  The settings appear to be correct to stop the duplications.

    There also maybe a know issue with your version?

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/

  • 11. Re: Help with AIE 7.1 data exchange config
    Kevin NameToUpdate

    Hi

     

    I might have to do that, although i've found BMC support to be very slow at best something i'm not going to go into here.

     

    One thing that I need clarifying is the Target Row Query syntax on the Update Query tab of Mapping Information. I suspect this might be an/the issue as the exchange does not seem to be pulling AR form rows that match the external data even though I know they exist.

     

    I have qualified the query according to the User Guide  $Serial Number$ = $SRC|SerialNumber$, however, I read that some data sources may require a different format??

     

    If my external source is a SQL Server table within ARSystem how would I write this query in correct format?

  • 12. Re: Help with AIE 7.1 data exchange config
    Carl Wilson

    Hi Kevin,

    had a colleague go through this also, we cannot see anything other than that there maybe trailing/leading characters that are in the source database that are being stripped by AIE.

    You can change the settings to allow these and re-try your results or is it also recommended to try a different field as the Primary Key.

     

    A couple of other points to check:

     

    1. The Primary Key is set to Serial Number, which could be where there are additional hidden characters and usually this is a manual entry (if not using a discovery source).  Therefore, you could try a different Primary Key such as a hostname to use with the transfer.

    2.  There is a backend form EIE:Data (AIE:Data) that houses the entry for the Primary Key.  Check that there are not other entries for the AIE Field Mapping Name with a "RuleType" of key.  Sometimes AIE does not completely remove the backend entries, so if you have used another key previously it could still be present in there.

    3.  Change the settings to allow addtional characters, and see if this now stops duplicates and updates existing records.

    4.  Remove the update query, the Primary Key will be used based on the settings you have configured (Don't create duplicates, update existing).  If it is still creating duplicates with the Primary Key being the Serial number and having the update query referencing the Serial Number, the update query is effectively not doing anything.

     

    Apart from that we cannot see anything un-toward that would throw out AIE as the settings look as the should.

     

    Good luck.

     

    Cheers

    Carl

     

    http://www.missingpiecessoftware.com/