Issue with relationship data exchange after upgrade of Atrium from 2.1.00 to 7.6.04
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
Re: Sorting issue on WUT 7.1p3
We have this same problem, and reported it to BMC. Here's a excerpt from their knowledge base: == This issue has been registered via several defects: SW00276920 - For sorting on Selection / Integer fields SW00288363 - For sorting on Date/ Time fields SW00296911 - For sorting on Real fields The current workaround for this issue is to not use these fields as the first column in the result list. If a character field is used as the first column, sorting on the other columns will be enabled as well. Please note: The fact that LONG CHAR fields (i.e. character fields above 255 characters) cannot be sorted in the result list is 'As Designed' - the initial 7.x User Tool allowed this, but this was corrected in the 7.1 User Tool. The current status of the above defects can be monitored by logging into the support website and then follow these instructions: * Select - View/Update under Issue Management * Select - Defect/RFE/CAR tab * Select - Search This will be fixed in the next 7.1 user tool patch. Most likely patch 006. == The defect associated with our issue, SW00276920, has a status of Closed, and Classification of Fixed, so I'm guessing it's in that new patch. We have not installed that patch yet. HTH Regards, Tor Maynard Computer Aid, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Monday, August 18, 2008 10:39 AM To: arslist@ARSLIST.ORG Subject: Re: Sorting issue on WUT 7.1p3 Yes, that's a user tool bug I think. Drew Shuller Tulsa, OK On Mon, 18 Aug 2008, Frank Caruso wrote: ARS 6.3p20 Solaris WUT 7.1p3 Sybase 12.5 We are finding that if the first column of a results list is the Status field (actually, any enumerated field) clicking on the column heading to sort does not work. If you take that same column and drag it any other location the sorting does work. We are all seeing this with data time fields. If you take a date time field and make it the first column in the results list the sorting does not work. This is not happening in MidTier 7.0.1 p7 Anybody else seen this? Frank __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Tomcat lockups under Windows (7.0.1 p6)
Now we're on ARS 7.1, but at the time of the issue we were on 7.0.1 (but not sure what patch). We had (what I think is) a similar issue, and did get a response from BMC. I'm going to copy it here. Hope it helps: You need to allocate more memory for tomcat, here are the details. P R O B L E M: The Tomcat application server crashes or a user finds an Out of memory error in the log. S O L U T I O N: Boost the memory settings using one of the following solutions: On Windows: Choose Start All Programs Apache Tomcat 5.5 Configure Tomcat. In the dialog box that appears, click the Java tab. Set the Initial Memory Pool option to 1024 MB. Set the Maximum Memory Pool option to 1024 MB. Restart Tomcat. On Linux: Change the minimum and maximum heap size using the -Xms and -Xmx JVM parameters, which are available in the catalina.sh file. The new value for CATALINA_OPTS should be as follows: Set CATALINA_OPTS=-Xms1024m -Xmx1024m Restart Tomcat. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati Sent: Thursday, May 22, 2008 12:42 AM To: arslist@ARSLIST.ORG Subject: Re: Tomcat lockups under Windows (7.0.1 p6) ** Hi Rick, We had same issue with ARS 7.0.1 P5 and midtier 7.0.1 P5. We have an open ticket with BMC and they don't seem to have a clue about it. Downgraded midtier to P4, since then Tomcat is running smooth. -- Ankur From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of VanAartsen, Christopher Sent: 22 May 2008 05:25 AM To: arslist@ARSLIST.ORG Subject: Re: Tomcat lockups under Windows (7.0.1 p6) ** Having similar issues on 6.3 with Tomcat, but restarting our Tomcat service fixes the problem. Have you checked your Java Heap size? That's my next move, looks to be the problem in the log files. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Westbrock Sent: Wednesday, May 21, 2008 6:40 PM To: arslist@ARSLIST.ORG Subject: Tomcat lockups under Windows (7.0.1 p6) Hi all- Today for the second time in a two week span Tomcat on my mid-tier has seemingly hung for no obvious reason. In each case the login page would not even come up so I restarted the Tomcat service but to no avail. Restarting the IIS service resolved the issue both times. We had been running this environment for about two months with no issues until a couple of weeks ago and the only change has been to deploy a new web service that allows one of our portal applications to submit a ticket into Remedy but there is no activity on the production server yet since we're still testing in our development environment (where we haven't seen this error at all). I have about a dozen users on the mid-tier off and on during the day. I searched the list and the Remedy KB but haven't seen anyone with similar problems. Environment details are below, any suggestions about where to start troubleshooting would be much appreciated. Thanks, Rick Single Remedy application server: Windows Server 2003 SP 2 IIS 6.0 ARS 7.0.1 patch 6 E-mail Engine 7.0.1 p6 Mid-Tier 7.0.1 p6 Tomcat 5.5 Remote Database Server: Windows Server 2003 SP 2 SQL Server 2000 (8.0.76 SP 3 Standard Edition) _ Rick Westbrock PETCO Telecom Engineer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail message and any attachments may contain legally privileged, confidential or proprietary Information, or information otherwise protected by law of ArvinMeritor, Inc., its affiliates, or third parties. This notice serves as marking of its Confidential status as defined in any confidentiality agreements concerning the sender and recipient. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this e-mail message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this e-mail message from your computer. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___