ARListers: We've recently upgraded from the following: ARSystem 7.1.00 Build 200708221849 Atrium 2.1.00 Patch 5 AIE 7.1.00 Patch 006 Asset Mgmt 7.0.03 OS - MS Windows Server 2003 Std Edition SP2 DB - MS SQL Server 9.0.5266
To the following: ARSystem 7.6.04 Patch 4 Atrium 7.6.04 Patch 4 AIE 7.6.04 Patch 4 Asset Mgmt 7.6.04 Patch 4 OS - MS Windows Server 2008 R2 Std DB - MS SQL Server 10.50.4270 When we performed the upgrade, we performed many steps, but in simple terms, we installed ARSystem, then a couple of patches of Asset to enable the installation of Atrium, then Atrium, then Asset Mgmt, and then, because AIE didn't work correctly (fields were missing on the EIE:MappingInfo form), BMC Support directed us to uninstall and reinstall just AIE. After we did that, data exchanges seemed to work, and most of them still do, but unfortunately, all relationship data exchanges where we do not Restrict to DatasetId in the mapping do not work. The following is an excerpt from the log showing normal counts (when it was running before the upgrade): [Tue Apr 23 2013 20:39:33.4100] - <TID: 001> <STATE > Session statistics: Relationship class requests: 3077, Class1-Class2 requests: 3707 [Tue Apr 23 2013 20:39:33.4100] - <TID: 001> <STATE > Session statistics: Requests added: 0, updated: 3076, deleted: 1, errors: 0, warnings: 0 The following is an excerpt from the first run of this same exchange after the upgrade: [Thu May 02 2013 08:10:26.2530] - <TID: 001> <STATE > Session statistics: Relationship class requests: 6152, Class1-Class2 requests: 3597, ByPassed: 0 Class1 Records [Thu May 02 2013 08:10:26.2530] - <TID: 001> <STATE > Session statistics: Requests added: 0, updated: 0, ByPassed: 0, deleted: 6152, errors: 0, warnings: 0 ,ignored: 0 The following is an excerpt from the next run of that same exchange (all subsequent runs have similar counts): [Mon May 06 2013 13:09:06.1220] - <TID: 001> <STATE > Session statistics: Relationship class requests: 0, Class1-Class2 requests: 3610, ByPassed: 0 Class1 Records [Mon May 06 2013 13:09:06.1220] - <TID: 001> <STATE > Session statistics: Requests added: 0, updated: 0, ByPassed: 0, deleted: 0, errors: 0, warnings: 0 ,ignored: 0 I've entered an issue with BMC, but they/we still can't determine what to do to get exchanges like this to work. I did spend some time with an Atrium expert on a webex, and he explained that we're not doing things the way he would do them, but it would be a significant change to our design. Our goal is to somehow get these data exchanges to work, but he didn't have an explanation for this immediate issue. He did say, maybe that having the data on a flat file than in a database table might help. I did try that, but unfortunately, got the same results (did not create the relationships). Mapping details: Relationship source = External Data Store Direction = External Data into CMDB External Data Store = SqlServer Table Name = dbo.Application_Server Restrict to DatasetId = NULL If a record is deleted from source = Mark as deleted Namespace = BMC.CORE Relationship Class Name = BMC_Dependency Primary Class = BMC_ComputerSystem Secondary Class = BMC_Application If anyone has encountered similar behavior, please let me know what you did to fix it. I can supply more details. Thanks! Tor Maynard Air Products and Chemicals, Inc. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
