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 […]
Tag: Technology
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 […]
Setting up two-way (mutual) SSL with Tomcat on Java
I recently wanted to set up Tomcat for two-way (mutual) SSL. It turns out this is fairly easy, particularly with Java since it now provides writes, and not just reads, of PKCS#12 keystores directly, so you don’t actually need to […]
Enabling NTLM Authentication (Single Sign-On) in Firefox
You have noticed that when you are using Internet Explorer and you browse to your companies intranet page that it will automatically authenticate you but when you use Firefox you will be prompted with a login box! This simple procedure […]