• Remedy's new RLS (1902/1908), Oracle and "enq:Index contention" waits

    In a recent engagement with a Remedy customer we looked into their performance issue and discovered that the slowdown in the database was stemming from "enq:Index contention" waits.   Drilling down further into ...
    Rajeev Patel
    last modified by Rajeev Patel
  • Top Viewed AR Server Knowledge Articles

    Content moved to Top Viewed AR Server Knowledge Articles
    Gregory Kiyoi
    last modified by Gregory Kiyoi
  • Operating Mode

    Operating Mode  Operating Mode is an feature of AR System introduced in 9.1.02 Release. its called as Operating mode.   Why was Operating Mode needed ?  When upgrading the server, CMDB, or any AR app...
    Rahul (Remedy) Shah
    last modified by Rahul (Remedy) Shah
  • Trending in Support: What data connection is ARERR 9351 really trying to set up?

    Some errors are clearer than others and the same goes for errors thrown by Remedy. Session is invalid or has timed out is pretty clear, Required field not specified is self-explanatory. They’re no-brainers, you ...
    Justin Bakker
    last modified by Justin Bakker
  • Remedy SQL, SQL Plan Directives & Oracle 12c's optimizer features

    If you have SQL statements that are running poorly in an Oracle 12c database and their Explain Plans are showing "... SQL Plan Directive used for this statement" under "Note" you may want to look into turning off the ...
    Rajeev Patel
    last modified by Rajeev Patel
  • Hard Parse? Soft Parse? Execution Plan? session_cached_cursors parameter

    So what does the Oracle database do when a SQL statement comes in to be processed?   A SQL is HARD PARSED the first time it comes into the database:   SYNTAX CHECK       ...
    Rajeev Patel
    last modified by Rajeev Patel
  • Trending in Support: Addressing Server side performance problems - Queues & Threads

    Performance issues can be difficult to pinpoint in some cases, but one fundamental on addressing such issues is to ensure that the internal traffic of a Remedy environment is configured correctly.   This blog po...
    David Still
    last modified by David Still
  • Trending in Support: ARERR9350, better contact your administrator

    This week a follow-up on what we discussed last time: backchannel validation errors and network analysis. Get your Network Sniffer out because we’re going to look at some nasty TCP traffic.   Say you’...
    Justin Bakker
    last modified by Justin Bakker
  • Creating restricted admin (struct admin) users in BMC Remedy ARSystem

    We have seen requirements where Admins like to create users with limited admin privileges like give access only to selected forms like User/Group, Admin console, Server group admin console. Also give limited access to...
    Saroj Sahu
    last modified by Saroj Sahu
  • Critical Remote Code Execution (RCE) vulnerability in Remedy Mid Tier

    BMC Software has identified an unauthenticated Remote Code Execution (RCE) vulnerability in Remedy Mid Tier. Mid Tier versions 9.1, 18.05, 18.08, and 19.02 service packs, and patches are affected by this vulnerabilit...
    John Weigand
    created by John Weigand
  • Testing Times - Remedy Silent Installation with a Container Database.

    Introduction Requirements OS Update and Docker Install MS-SQL Container Installing Remedy (quietly...) Restore an Existing Remedy Database Conclusion Introduction  In my last blog pos...
    Mark Walters
    last modified by Mark Walters
  • User Themes in MidTier 1902

    ‘USER THEME’ - OVERVIEW Remedy 19.02 release includes a new feature called as “User Preference Theme”. This is a Remedy MidTier feature and as the name suggests, it allows users to set prefere...
    Amol Parwekar
    last modified by Amol Parwekar
  • Table & View information

    In interactions with customers it is often noted that getting table/view information is a back and forth operation between Support/PE and the customer.   The accompanying zip file contains SQL scripts, written fo...
    Rajeev Patel
    last modified by Rajeev Patel
  • Remedy AR System 9.x / 18.x Security Vulnerability Hot Fix

    NOTE: This vulnerability is only applicable to AR System on Linux servers.   BMC Software has identified a security vulnerability (CVE-2018-19647) that could allow a remote, unauthenticated attacker to gain arbi...
    John Weigand
    last modified by John Weigand
  • Trending in Support: AR server, the SOAP client (really)

    Integration with 3rd party systems is, of course, always important. After all, we need ways to get data in and out of Remedy, we can hardly keep it to ourselves. Data shared is value gained - you can get more business...
    Justin Bakker
    last modified by Justin Bakker
  • How To Directly Export ARS Tables to CSV

    Many moons ago, BMC deprecated the Windows ARUser client in favor of the web-based Mid-Tier client, and since that time there has been a scenario I have repeatedly run into that does not have a satisfactory solution b...
    Andrew Hicox
    last modified by Andrew Hicox
  • Trending in Support: A new API for the REST of us

    Version 9 is released and with it come some new features. Don’t worry, I’m not planning to list everything that’s changed, but I’d like to have a look at one specific new feature: the REST API....
    Justin Bakker
    last modified by Justin Bakker
  • Apache Struts vulnerabilities

    Some Customers are asking us if AR Server / Mid-Tier is affected by the following Apache Struts vulnerability. https://www.hkcert.org/my_url/en/alert/16042801   Apache Struts is not used by any version of AR Se...
    Abhijit Rajwade
    last modified by Abhijit Rajwade
  • The AST:Base Element view and Remedy 9.x

    If you are running a version of Remedy that is older than 9.1 SP3 you may notice the following join condition in the view definition of AST:Base Element when you open it in Developer Studio:      ...
    Rajeev Patel
    last modified by Rajeev Patel
  • Using the Elastic Stack with Remedy Logs - Part 3

    The Story So Far... The grok Logstash Plugin Index Pattern Refresh Making Use of Remedy Specific Fields in Kibana Filtering Visualizations Wrapping Up The Story So Far... In parts one and t...
    Mark Walters
    last modified by Mark Walters