In case of you need to reset the password for an administrator account (for instance for Demo – default admin account) you have to configure ARSystem instance to allow execution of arcache and to execute the following command: arcache.exe -Ua […]
Technology
Reset of appadmin account during Upgrade
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 […]
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, […]