Manually running ProactiveNet Sybase DB Rebuild

This is an workaround that could be used when standard rebuild procedure fails because of “memory exhausted”: pw database rebuild fails with error Dynamic Memory Exhausted Manually running the steps and using a larger cache size resolved the issue1) dbunload […]

How to disable the Shutdown Tracker in Windows Server 2008 R2

Open Group Policy editor.  You could use MMC and add the local group policy snap in or you can simply click on Start and then type gpedit.msc. Navigate to Computer Configuration / Administrative Templates / System Find the setting called […]

Some ITSM pages are not properly displayed with Google Chrome on MidTier 8.1.02

Some ITSM pages are not properly displayed with Google Chrome on MidTier 8.1.02. The part of ITSM page is hidden (the controls are not display because of a big blank area in the left side). With IE and Firefox, the […]

Avoid conversions from string to number in Active Links

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 […]

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 […]