• 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
  • Remedy 9.x, Oracle Case Insensitivity and SQL with LIKE conditions

    Remedy 9.x/18.x is written in Java. One of the features that was introduced was to avoid sending literal values in Remedy SQL statements as was the case in 8.x and prior versions.   The statement is now prepared ...
    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
  • Prerequisite for AR System platform upgrade to 9.x version using installer/d2p

    Introduction : This blog will give you the brief idea about the prerequisite needs to consider before performing AR system platform upgrade using installer. Also included prerequisite needs to consider while applying ...
    Snehal Gaikwad
    last modified by Snehal Gaikwad
  • 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
  • Quick and Easy Remedy Mid-Tier Testing Using Containers with Docker

    Introduction Setting up the Docker Environment Apache Tomcat Containers Pump Up The Volume .war (What is it Good For?) Managing Multiple Configurations Testing with a Load Balancer Summary ...
    Mark Walters
    last modified by Mark Walters
  • 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
  • Top Viewed AR Server Knowledge Articles

    December 2018 list of top viewed AR Server knowledge articles, this will be regularly updated.   Article Number Title 000114508 REMEDY 9.x Release - CONFIGURATION CHECKLIST from the BMC R&D PERFORMANCE ...
    Gregory Kiyoi
    last modified by Gregory Kiyoi
  • 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