Hello Team, Can you please help me understand why one of our integration for PC update data is not working? Basically I need to add new set of field and the way this works is that the integration is setup on the AIE engine for Asset Management System (AMS) running on Remedy platform v7.1.
The source is from another system/website that has SQL as the backend and is being pulled to AMS. However, when I tried running the job again after adding the new fields, I'm getting these errors. Please help advise. Thank you very much! [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Error: Validation of rules failed. No data exchange will start until the problem is fixed. [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <ERR > *** Unable to transfer data. Field mapping errors must be corrected. *** Above snippet came from attached file found from the server where AIE is hosted/install. Regards, Jojo _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
[Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 14 : <Company (id: 1000000001)> set to 'Texas Instruments' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 15 : <SiteGroup (id: 200000007)> set to 'AIZU' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 16 : <Floor (id: 260000004)> set to 'WP2F' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 17 : <SystemRole (id: 260000002)> set to 'FAB/Clean Room' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 18 : <UserDefined1 (id: 750000004)> set to '' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 19 : <UserDefined2 (id: 750000005)> set to '' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 20 : <WarrantyStartDate (id: 536871927)> set to '04/21/2015 00:00:00' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 21 : <WarrantyEndDate (id: 536871931)> set to '04/22/2018 00:00:00' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 22 : <OrderID (id: 260300004)> set to '' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Rule 23 : <LocalTagNumber (id: 750000000)> set to '' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Key Rule 1 : <SerialNumber (id: 200000001)> set to 'D59PY42' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <DTL > Key Rule 3 : <Name (id: 200000020)> set to 'PCDS1020' [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <SUMM > Creating Class 'BMC.CORE:BMC_ComputerSystem' instance for Key [D59PY42,E014910900,PCDS1020] [Tue Aug 18 2015 22:02:03.3100] - <TID: 001> <API > + CMDBCreateInstance -- Class [BMC.CORE:BMC_ComputerSystem] Key [D59PY42,E014910900,PCDS1020] [Tue Aug 18 2015 22:02:03.4980] - <TID: 001> <API > - CMDBCreateInstance OK Instance [OI-1228200A942A4F84A421BBC49B8F16E9] [Tue Aug 18 2015 22:02:03.4980] - <TID: 001> <SUMM > Creating Class instance OK Instance [OI-1228200A942A4F84A421BBC49B8F16E9] [Tue Aug 18 2015 22:02:03.4980] - <TID: 001> <DTL > Entry D59PY42,E014910900,PCDS1020 was added to AR [Tue Aug 18 2015 22:02:03.4980] - <TID: 001> <SQL > + Get Data SQL command : SELECT [Computer], [ExpenseTag], [SerialNumber], [Manufacturer], [Model], [Status], [UserName], [Type], [SupportGroup], [UserManagerName], [SiteCode], [Location], [SystemRole], [UserDefined1], [UserDefined2], convert(varchar, [WarrantyStartDate], 101) + ' ' + convert(varchar, [WarrantyStartDate], 108), convert(varchar, [WarrantyEndDate], 101) + ' ' + convert(varchar, [WarrantyEndDate], 108), [PO], [LocalTagNumber], [SerialNumber], [Computer] FROM [dbo].[TI_vwAMSSync] WITH (NOLOCK) WHERE [SerialNumber] = 'DD5RM12' AND [ExpenseTag] = 'E014901400' AND [Computer] = 'PABS0040' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <SQL > - Get Data SQL command OK [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Data obtained from Source for mappings: 'Personal Computer Update' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 1 : 'function|lower($Computer$)', Value: 'pabs0040' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 2 : 'ExpenseTag', Value: 'E014901400' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 3 : 'function|lower($SerialNumber$)', Value: 'dd5rm12' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 4 : 'Manufacturer', Value: 'Dell' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 5 : 'Model', Value: 'Latitude E5440' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 6 : 'Status', Value: 'Deployed' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 7 : 'function|lower($UserName$)', Value: 'a0601634' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 8 : 'constant|Expense', Value: 'Expense' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 9 : 'Type', Value: 'Laptop' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 10 : 'SupportGroup', Value: 'Japan' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 11 : 'constant|Hardware', Value: 'Hardware' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 12 : 'function|lower($UserManagerName$)', Value: 'a0601520' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 13 : 'constant|BASEFORM', Value: 'BASEFORM' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 14 : 'constant|Texas Instruments', Value: 'Texas Instruments' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 15 : 'SiteCode', Value: 'AIZU' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 16 : 'Location', Value: 'WP2F' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 17 : 'SystemRole', Value: 'FAB/Clean Room' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 18 : 'UserDefined1', Value: '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 19 : 'UserDefined2', Value: '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 20 : 'WarrantyStartDate', Value: '10/22/2014 00:00:00' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 21 : 'WarrantyEndDate', Value: '10/23/2017 00:00:00' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 22 : 'PO', Value: '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 23 : 'LocalTagNumber', Value: '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Key Rule 1 : 'SerialNumber', Value: 'DD5RM12' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Key Rule 3 : 'Computer', Value: 'PABS0040' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Setting field values of Target for mappings 'Personal Computer Update' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 1 : <Name (id: 200000020)> set to 'pabs0040' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 2 : <TagNumber (id: 260100004)> set to 'E014901400' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 3 : <SerialNumber (id: 200000001)> set to 'dd5rm12' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 4 : <Type (id: 200000004)> set to 'Dell' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 5 : <Item (id: 200000005)> set to 'Latitude E5440' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 6 : <AssetLifecycleStatus (id: 7)> set to '3' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 7 : <zEndUserId (id: 755000015)> set to 'a0601634' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 8 : <AcquiredMethod (id: 260000000)> set to '3' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 9 : <Usage (id: 750000091)> set to 'Laptop' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 10 : <SupportGroup (id: 750000008)> set to 'Japan' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 11 : <Category (id: 200000003)> set to 'Hardware' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 12 : <zReportingManager (id: 755000016)> set to 'a0601520' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 13 : <zUpdatedFrom_ (id: 755000030)> set to '3' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 14 : <Company (id: 1000000001)> set to 'Texas Instruments' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 15 : <SiteGroup (id: 200000007)> set to 'AIZU' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 16 : <Floor (id: 260000004)> set to 'WP2F' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 17 : <SystemRole (id: 260000002)> set to 'FAB/Clean Room' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 18 : <UserDefined1 (id: 750000004)> set to '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 19 : <UserDefined2 (id: 750000005)> set to '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 20 : <WarrantyStartDate (id: 536871927)> set to '10/22/2014 00:00:00' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 21 : <WarrantyEndDate (id: 536871931)> set to '10/23/2017 00:00:00' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 22 : <OrderID (id: 260300004)> set to '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Rule 23 : <LocalTagNumber (id: 750000000)> set to '' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Key Rule 1 : <SerialNumber (id: 200000001)> set to 'DD5RM12' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <DTL > Key Rule 3 : <Name (id: 200000020)> set to 'PABS0040' [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <SUMM > Creating Class 'BMC.CORE:BMC_ComputerSystem' instance for Key [DD5RM12,E014901400,PABS0040] [Tue Aug 18 2015 22:02:03.5290] - <TID: 001> <API > + CMDBCreateInstance -- Class [BMC.CORE:BMC_ComputerSystem] Key [DD5RM12,E014901400,PABS0040] [Tue Aug 18 2015 22:02:03.7010] - <TID: 001> <API > - CMDBCreateInstance OK Instance [OI-3ED111208021432180F94A62AA3D81F7] [Tue Aug 18 2015 22:02:03.7010] - <TID: 001> <SUMM > Creating Class instance OK Instance [OI-3ED111208021432180F94A62AA3D81F7] [Tue Aug 18 2015 22:02:03.7010] - <TID: 001> <DTL > Entry DD5RM12,E014901400,PABS0040 was added to AR [Tue Aug 18 2015 22:02:03.7010] - <TID: 001> <SQL > + Get Data SQL command : SELECT [Computer], [ExpenseTag], [SerialNumber], [Manufacturer], [Model], [Status], [UserName], [Type], [SupportGroup], [UserManagerName], [SiteCode], [Location], [SystemRole], [UserDefined1], [UserDefined2], convert(varchar, [WarrantyStartDate], 101) + ' ' + convert(varchar, [WarrantyStartDate], 108), convert(varchar, [WarrantyEndDate], 101) + ' ' + convert(varchar, [WarrantyEndDate], 108), [PO], [LocalTagNumber], [SerialNumber], [Computer] FROM [dbo].[TI_vwAMSSync] WITH (NOLOCK) WHERE [SerialNumber] = 'J63GLX1' AND [ExpenseTag] = 'E019184500' AND [Computer] = 'LTA0411561' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <SQL > - Get Data SQL command OK [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Data obtained from Source for mappings: 'Personal Computer Update' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Rule 1 : 'function|lower($Computer$)', Value: 'lta0411561' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Rule 2 : 'ExpenseTag', Value: 'E019184500' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Rule 3 : 'function|lower($SerialNumber$)', Value: 'j63glx1' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Rule 4 : 'Manufacturer', Value: 'Dell' [Tue Aug 18 2015 22:02:03.7160] - <TID: 001> <DTL > Rule 5 : 'Model', Value: 'Latitude E6430' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 6 : 'Status', Value: 'Deployed' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 7 : 'function|lower($UserName$)', Value: 'a0411561' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 8 : 'constant|Expense', Value: 'Expense' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 9 : 'Type', Value: 'Laptop' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 10 : 'SupportGroup', Value: 'Santa Clara IT' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 11 : 'constant|Hardware', Value: 'Hardware' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 12 : 'function|lower($UserManagerName$)', Value: 'a0212969' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 13 : 'constant|BASEFORM', Value: 'BASEFORM' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 14 : 'constant|Texas Instruments', Value: 'Texas Instruments' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 15 : 'SiteCode', Value: 'SCLA' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 16 : 'Location', Value: 'Post E9 Cube 2064' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 17 : 'SystemRole', Value: 'Primary' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 18 : 'UserDefined1', Value: '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 19 : 'UserDefined2', Value: '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 20 : 'WarrantyStartDate', Value: '06/28/2013 00:00:00' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 21 : 'WarrantyEndDate', Value: '06/28/2016 00:00:00' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 22 : 'PO', Value: '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 23 : 'LocalTagNumber', Value: '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Key Rule 1 : 'SerialNumber', Value: 'J63GLX1' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Key Rule 3 : 'Computer', Value: 'LTA0411561' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Setting field values of Target for mappings 'Personal Computer Update' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 1 : <Name (id: 200000020)> set to 'lta0411561' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 2 : <TagNumber (id: 260100004)> set to 'E019184500' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 3 : <SerialNumber (id: 200000001)> set to 'j63glx1' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 4 : <Type (id: 200000004)> set to 'Dell' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 5 : <Item (id: 200000005)> set to 'Latitude E6430' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 6 : <AssetLifecycleStatus (id: 7)> set to '3' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 7 : <zEndUserId (id: 755000015)> set to 'a0411561' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 8 : <AcquiredMethod (id: 260000000)> set to '3' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 9 : <Usage (id: 750000091)> set to 'Laptop' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 10 : <SupportGroup (id: 750000008)> set to 'Santa Clara IT' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 11 : <Category (id: 200000003)> set to 'Hardware' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 12 : <zReportingManager (id: 755000016)> set to 'a0212969' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 13 : <zUpdatedFrom_ (id: 755000030)> set to '3' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 14 : <Company (id: 1000000001)> set to 'Texas Instruments' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 15 : <SiteGroup (id: 200000007)> set to 'SCLA' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 16 : <Floor (id: 260000004)> set to 'Post E9 Cube 2064' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 17 : <SystemRole (id: 260000002)> set to 'Primary' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 18 : <UserDefined1 (id: 750000004)> set to '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 19 : <UserDefined2 (id: 750000005)> set to '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 20 : <WarrantyStartDate (id: 536871927)> set to '06/28/2013 00:00:00' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 21 : <WarrantyEndDate (id: 536871931)> set to '06/28/2016 00:00:00' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 22 : <OrderID (id: 260300004)> set to '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Rule 23 : <LocalTagNumber (id: 750000000)> set to '' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Key Rule 1 : <SerialNumber (id: 200000001)> set to 'J63GLX1' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <DTL > Key Rule 3 : <Name (id: 200000020)> set to 'LTA0411561' [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <SUMM > Creating Class 'BMC.CORE:BMC_ComputerSystem' instance for Key [J63GLX1,E019184500,LTA0411561] [Tue Aug 18 2015 22:02:03.7320] - <TID: 001> <API > + CMDBCreateInstance -- Class [BMC.CORE:BMC_ComputerSystem] Key [J63GLX1,E019184500,LTA0411561] [Tue Aug 18 2015 22:02:03.9350] - <TID: 001> <API > - CMDBCreateInstance OK Instance [OI-9D24A646A14B488EA6BC89B20EB9CC9E] [Tue Aug 18 2015 22:02:03.9350] - <TID: 001> <SUMM > Creating Class instance OK Instance [OI-9D24A646A14B488EA6BC89B20EB9CC9E] [Tue Aug 18 2015 22:02:03.9350] - <TID: 001> <DTL > Entry J63GLX1,E019184500,LTA0411561 was added to AR [Tue Aug 18 2015 22:02:03.9350] - <TID: 001> <STATE > CreateEntry: 1, GetVendorData: 0 Requests total: 7, added: 7, updated: 0, deleted: 0, errors: 0, warnings: 0 [Tue Aug 18 2015 22:02:03.9350] - <TID: 001> <STS > WaitForThreadsToComplete: Threads Completed: 49 [Tue Aug 18 2015 22:02:04.0290] - <TID: 001> <STATE > AR key list provided to Vendor. [Tue Aug 18 2015 22:02:05.0290] - <TID: 001> <DTL > Number of AR System Keys obtained 0. [Tue Aug 18 2015 22:02:05.0290] - <TID: 001> <DTL > Number of Vendor Keys obtained 0. [Tue Aug 18 2015 22:02:05.0290] - <TID: 001> <STATE > Session statistics: AR requests: 0, Vendor requests: 7 [Tue Aug 18 2015 22:02:05.0290] - <TID: 001> <STATE > Session statistics: Requests added: 7, updated: 0, deleted: 0, errors: 0, warnings: 0 [Tue Aug 18 2015 22:02:05.1700] - <TID: 001> <PERF > [Tue Aug 18 2015 22:02:05.1700] - <TID: 001> <STS > Sleep until next poll interval or scheduled time for data transfer [Tue Aug 18 2015 22:02:05.2010] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. [Wed Aug 19 2015 01:22:06.2220] - <TID: 001> <DTL > SqlServer.Initialize: Verifying configuration parameters [Wed Aug 19 2015 01:22:06.2220] - <TID: 001> <STS > Scheduled Only mode [Wed Aug 19 2015 01:22:06.2370] - <TID: 001> <API > + CMDBInitialization [Wed Aug 19 2015 01:22:06.2370] - <TID: 001> <API > - CMDBInitialization OK [Wed Aug 19 2015 01:22:06.2370] - <TID: 001> <API > + CMDBSetServerPort -- PortNum [0] RPC [0] [Wed Aug 19 2015 01:22:06.2370] - <TID: 001> <API > - CMDBSetServerPort OK [Wed Aug 19 2015 01:22:06.2840] - <TID: 001> <SQL > CONNECT PCUpdate, USER AMSSync (Native Database) [Wed Aug 19 2015 01:22:06.2840] - <TID: 001> <STS > StartDataHandlers: Connection established to both AR/CMDB and vendor application. [Wed Aug 19 2015 01:22:06.2840] - <TID: 001> <INFO > >>>CMDB Attributes: [Wed Aug 19 2015 01:22:06.2840] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Name] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[TagNumber] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SerialNumber] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Type] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Item] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[AssetLifecycleStatus] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[zEndUserId] [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3000] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[AcquiredMethod] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Usage] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SupportGroup] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Category] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[zReportingManager] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[zUpdatedFrom_] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Company] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SiteGroup] [Wed Aug 19 2015 01:22:06.3150] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Floor] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SystemRole] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[UserDefined1] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[UserDefined2] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[WarrantyStartDate] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[WarrantyEndDate] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[OrderID] [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3310] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[LocalTagNumber] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[MonitorModel] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[MonitorBondNo] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[MonitorMake] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[MonitorSerialNo] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[IPPhoneSerialNo] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SerialNumber] [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3470] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Name] [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[MarkAsDeleted] [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Field mappings in: 'Personal Computer Update' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 1 : <Name (id: 200000020)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 3 : <SerialNumber (id: 200000001)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 4 : <Type (id: 200000004)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 5 : <Item (id: 200000005)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 6 : <AssetLifecycleStatus (id: 7)> Set to data type: 6 (Enum) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 7 : <zEndUserId (id: 755000015)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 8 : <AcquiredMethod (id: 260000000)> Set to data type: 6 (Enum) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 9 : <Usage (id: 750000091)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 10 : <SupportGroup (id: 750000008)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 11 : <Category (id: 200000003)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 12 : <zReportingManager (id: 755000016)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 13 : <zUpdatedFrom_ (id: 755000030)> Set to data type: 6 (Enum) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 14 : <Company (id: 1000000001)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 15 : <SiteGroup (id: 200000007)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 16 : <Floor (id: 260000004)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 17 : <SystemRole (id: 260000002)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 18 : <UserDefined1 (id: 750000004)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 19 : <UserDefined2 (id: 750000005)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 20 : <WarrantyStartDate (id: 536871927)> Set to data type: 7 (Date/Time) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 21 : <WarrantyEndDate (id: 536871931)> Set to data type: 7 (Date/Time) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 22 : <OrderID (id: 260300004)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 23 : <LocalTagNumber (id: 750000000)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 24 : <MonitorModel (id: 755000038)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 25 : <MonitorBondNo (id: 755005002)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 26 : <MonitorMake (id: 755000037)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 27 : <MonitorSerialNo (id: 755000035)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 28 : <IPPhoneSerialNo (id: 755000036)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Delete Rule 1: <MarkAsDeleted (id: 400129100)> Set to data type: 6 (Enum) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <WARN > *** Warning: Duplicate rule in result set 'SerialNumber (id: 200000001)'. *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <WARN > *** Warning: Duplicate rule in result set 'Name (id: 200000020)'. *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > >>>CMDB Key Attributes: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[SerialNumber] [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[TagNumber] [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > + CMDBGetMultipleAttribute -- Class [BMC.CORE:BMC_ComputerSystem]-[Name] [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <API > - CMDBGetMultipleAttribute OK [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <SerialNumber (id: 200000001)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <TagNumber (id: 260100004)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <Name (id: 200000020)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > >>>AR System Query: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Query: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > >>>Vendor Rules: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <DTL > Error: Field tiPerHostMAC has an error. [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <DTL > Error: Field tiPerWLNetAZ has an error. [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <DTL > Error: Field tiPerWRNetAZ has an error. [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <DTL > Error: Field tiPerDeviceType has an error. [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <DTL > Error: Field tiPerHlthState has an error. [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Field mappings in: 'Personal Computer Update' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 1 : <function|lower($Computer$)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 3 : <function|lower($SerialNumber$)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 4 : <Manufacturer> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 5 : <Model> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 6 : <Status> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 7 : <function|lower($UserName$)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 8 : <constant|Expense> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 9 : <Type> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 10 : <SupportGroup> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 11 : <constant|Hardware> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 12 : <function|lower($UserManagerName$)> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 13 : <constant|BASEFORM> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 14 : <constant|Texas Instruments> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 15 : <SiteCode> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 16 : <Location> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 17 : <SystemRole> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 18 : <UserDefined1> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 19 : <UserDefined2> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 20 : <WarrantyStartDate> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 21 : <WarrantyEndDate> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 22 : <PO> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 23 : <LocalTagNumber> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 24 : <tiPerHostMAC> Set to data type: 0 (NULL) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Field Mapping Error for tiPerHostMAC *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > --> Column 'tiPerHostMAC' not defined in table 'dbo.TI_vwAMSSync' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 25 : <tiPerWLNetAZ> Set to data type: 0 (NULL) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Field Mapping Error for tiPerWLNetAZ *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > --> Column 'tiPerWLNetAZ' not defined in table 'dbo.TI_vwAMSSync' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 26 : <tiPerWRNetAZ> Set to data type: 0 (NULL) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Field Mapping Error for tiPerWRNetAZ *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > --> Column 'tiPerWRNetAZ' not defined in table 'dbo.TI_vwAMSSync' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 27 : <tiPerDeviceType> Set to data type: 0 (NULL) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Field Mapping Error for tiPerDeviceType *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > --> Column 'tiPerDeviceType' not defined in table 'dbo.TI_vwAMSSync' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Rule 28 : <tiPerHlthState> Set to data type: 0 (NULL) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Field Mapping Error for tiPerHlthState *** [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > --> Column 'tiPerHlthState' not defined in table 'dbo.TI_vwAMSSync' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Delete Rule 1: <constant|1> Set to data type: 2 (Integer) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > >>>Vendor Keys: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <SerialNumber> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <ExpenseTag> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Key Rule 1 : <Computer> Set to data type: 4 (Character) [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > >>>Vendor Query: [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <INFO > Query: Status != 'Test PCUpdate Functionality' AND computer = 'LTXF010299-TST2' [Wed Aug 19 2015 01:22:06.3620] - <TID: 001> <ERR > *** Error: Validation of rules failed. No data exchange will start until the problem is fixed. [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <ERR > *** Unable to transfer data. Field mapping errors must be corrected. *** [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <API > + CMDBInitialization [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <API > - CMDBInitialization OK [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <API > + CMDBSetServerPort -- PortNum [0] RPC [0] [Wed Aug 19 2015 01:22:06.3780] - <TID: 001> <API > - CMDBSetServerPort OK [Wed Aug 19 2015 01:22:06.4250] - <TID: 001> <SQL > CONNECT PCUpdate, USER AMSSync (Native Database) [Wed Aug 19 2015 01:22:06.4250] - <TID: 001> <STS > StartDataHandlers: Connection established to both AR/CMDB and vendor application. [Wed Aug 19 2015 01:22:06.4250] - <TID: 001> <STATE > Start Data Exchange at Wed Aug 19 01:22:06 2015 [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <API > + CMDBGetClass -- Class [BMC.CORE:BMC_ComputerSystem] [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <API > - CMDBGetClass OK [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <STATE > At least one rule is in error. Exchange requires all rules to be valid. [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <INFO > [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <INFO > Status != 'Test PCUpdate Functionality' AND computer = 'LTXF010299-TST2' [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <STATE > **** Unable to transfer data until all errors have been corrected. *** [Wed Aug 19 2015 01:22:06.4560] - <TID: 001> <ERR > ProcessBulkExchange - Bulk exchange not ready for processing [Wed Aug 19 2015 01:22:06.4870] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. [Wed Aug 19 2015 01:46:26.9560] - <TID: 001> <API > + CMDBInitialization [Wed Aug 19 2015 01:46:26.9560] - <TID: 001> <API > - CMDBInitialization OK [Wed Aug 19 2015 01:46:26.9560] - <TID: 001> <API > + CMDBSetServerPort -- PortNum [0] RPC [0] [Wed Aug 19 2015 01:46:26.9560] - <TID: 001> <API > - CMDBSetServerPort OK [Wed Aug 19 2015 01:46:27.0030] - <TID: 001> <SQL > CONNECT PCUpdate, USER AMSSync (Native Database) [Wed Aug 19 2015 01:46:27.0030] - <TID: 001> <STS > StartDataHandlers: Connection established to both AR/CMDB and vendor application. [Wed Aug 19 2015 01:46:27.0030] - <TID: 001> <STATE > Start Data Exchange at Wed Aug 19 01:46:27 2015 [Wed Aug 19 2015 01:46:27.0180] - <TID: 001> <API > + CMDBGetClass -- Class [BMC.CORE:BMC_ComputerSystem] [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <API > - CMDBGetClass OK [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <STATE > At least one rule is in error. Exchange requires all rules to be valid. [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <INFO > [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <INFO > Status != 'Test PCUpdate Functionality' AND computer = 'LTXF010299-TST2' [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <STATE > **** Unable to transfer data until all errors have been corrected. *** [Wed Aug 19 2015 01:46:27.0340] - <TID: 001> <ERR > ProcessBulkExchange - Bulk exchange not ready for processing [Wed Aug 19 2015 01:46:27.0650] - <TID: 001> <STS > StopDataHandlers: Disconnected from both AR/CMDB and Vendor application. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
