During upgrade (for instance from 7.6.xx to 8.1.02) the ITSM installer will reset appadmin account, that means the old password will no longer exist. So, if you have only one administrator user (appadmin) try to create another one before the […]
Tag: Knowledge Base
AR Warning message 9429 appears when login to Midtier 8.1.02
Problem AR Warning message 9429 appears when login to Midtier 8.1.02 Solution Please apply latest Midtier 8.1.02 hotfix (dated Nov 07th or later) and add the following parameter to Config.Properties in <midtier>\WEB-INF\classes folder arsystem.display_IE_compatibility_view_alert=false Please follow the Midtier hotfix instructions […]
When we reindex FTS, “Reindexing in progress” keeps running in FTS tab of Server Information
Problem When we reindex FTS, “Reindexing in progress” keeps running in FTS tab of Server Information. Solution Stop AR Server service Delete all the records from the table ft_pending from database. ⇒ Delete from ft_pending: (it is recommended to use […]
Converting Remedy date/time into SQL Server timestamp
How to get the current epoch time in SQL Server? – use this command SELECT DATEDIFF(s, ‘1970-01-01 00:00:00’, GETUTCDATE()) In order to apply it to a Remedy statement you have to replace the GETUTCDATE() with a remedy field and you’ll […]
How to create a License Usage report
In order to create a License Usage report you have to activate license tracking in Server information. The report will be generated afterwords exporting data from the query output (designed of Oracle database): SELECT a.USER_NAME, b.FIRST_NAME, b.LAST_NAME, a.APPLICATION, a.TYPE_OF_LICENSE, a.LAST_DATETIME […]
Passing value for a custom field from one AOT as output to another AOT as a input
Following is the steps to add custom field on SRM/Work Order. Please confirm if the steps have been followed Create a custom field on WO (WOI:WorkOrder form ,WorkOrderCreate_Interface form and WOI:WorkOrderInterface). Configure custom fields on SYS:Form Field Selection and Application […]
Converting Remedy timestamp into Oracle DateTime format
I need a formula that converts the Remedy timestamp into Oracle date/time field. I have referred to KB article: 000000006132 and formula given in the article is working fine. SELECT TO_CHAR(TO_DATE(’01/01/1970 00:00:00′, ‘MM/DD/YYYY HH24:MI:SS’) + (C3 / ( 60 * […]
Regular Expression Easy Guide
Summary of regex constructs. Characters x The character x \ The backslash character \0n The character with octal value 0n (0 ⇐ n ⇐ 7) \0nn The character with octal value 0nn (0 ⇐ n ⇐ 7) \0mnn The character with octal value 0mnn (0 ⇐ m ⇐ 3, 0 ⇐ n ⇐ 7) \xhh […]
Command Line Tools to Monitor Linux Performance
In case of you have performance issues on Linux/Unix machine definitely using one of these tools (or combined them). Ready carefully this article: http://www.tecmint.com/command-line-tools-to-monitor-linux-performance/ Presented tools: Top, VmStat, Lsof, Tcpdump, Netstat, Htop, Iotop, Iostat, IPTraf, Psacct or Acct, NetHogs, iftop, […]
Data codes related to ‘LDAP error code 49’ with Microsoft Active Directory
Problem When BMC Remedy or AREasy accesses the LDAP (in this case Microsoft Active Directory), either to start the server or during configuration tasks, LDAP: error code 49 can be encountered. Symptom The error shown below is similar each time […]