When you are developing workflows using BMC Developer Studio try to avoid data conversions in Active Links from string to number (decimal or real) because it depends by LOCALE configuration of the end-user: a string value like 9.5 could be […]
Tag: BMC Remedy
Reset Demo/Admin Password
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 […]
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 * […]
ITSM Clarity Connector
Question: How can you quickly realise business value from a fully integrated PPM & ITSM Enterprise Solution? Answer: The ITSM Clarity Connector takes two of the market leaders, CA Clarity PPM & BMC ITSM, and seamlessly integrates the data flow […]