Extending CMDB may report failures when extending/synching classes if “Max Entries Returned By Getlist” has been set to a limit and other errors.

Problem

 

When the CMDB is extended or synchronized with Asset (cmdb2asset synch), then the extensions may include cmdbdriver scripts, AR scripts, and/or data import operations. These operations may encounter AR Errors which mean that the operation failed, or AR WARN messages which mean the operation succeeded but with exceptions to the requested operation.  These warnings can be due to configuration problems or defects, but more importantly they will not be visible in the UI because they are captured in logs. One of those logs is CMDBSynchronizeUI.log. Each time a synchronization (Update UI) is triggered, the progress can be observed in this log and its completion is tracked by this last line of the log:

 

“Application UI synchronization completed”

 

If all of the operations were completed successfully. If not than errors might be seen in the log. Although some errors or warnings can be ignore.

 

These errors would say:

 

“Message:  The query matched more than the maximum number of entries specified for retrieval”  < This is a problem. This message typically means the “Max Entries Returned by GetList” setting for the server is not set to zero.

 

“Failed to create reserved system field: DSOUniqueId on Form” < This can be ignored.

 

“Admin operations are disabled on this server” < This is a problem. Uncheck the “Disable Admin Operations.

 

 

Solution

 

To check the value for  “Max Entries Returned by GetList” setting, access the AR System Administration Console from BMC Remedy User (or Mid-Tier) and select the following from the Vertical Navigation Bar:

AR System Administration Console –> General –> Server Information -> Select the Configuration Page

 

Check the value of  “Max Entries Returned By Getlist”

 

It is possible that this setting even if set to zero and the above warning may still be encountered.  It may be related to installation on a server that is slow low on resources, either due to insufficient memory or for other reasons.

Other reasons maybe users on the system are performing resource consuming tasks or data processing tasks such as Reconciliation or AIE Data Exchanges may have been triggered at the same time.

 

NOTE: The system should be returned to its previous state by restoring the limit as it was before.

 

On this same page you will also find the “Disable Admin Operations”. If it is checked, then please uncheck it.

Making changes in this panel will prompt for ARS restart. Please do so once you’ve completed the changes in this panel.

Protected: 24×7 Call List

This post is password protected. To view it please enter your password below:


It’s finally here!

My family and I picked up my brand new 2010 Street Triple from Southern California Triumph yesterday (6/23) and trailered it back home last night.  I took it out this morning for a test ride and it was awesome!  The deal from Jay Cissell was the best ever.  If you are ever looking for a Triumph motorcycle give Jay a ring at 714-256-6700.

Cursor Sharing

Sharing Cursors

Values for CURSOR_SHARING are:

  • EXACT (default)
    • SQL statements must be identical to share cursors.
  • SIMILAR
    • SQL statements that are similar share cursors, provided that their respective execution plans are the same.
  • FORCE
    • SQL statements that are similar share cursors regardless of the impact on the execution plan. Bind peeking is done on the first parse, and possibly later due to adaptive cursor sharing (11g).

SIMILAR statements are identical except for the values of some literals.

Read the rest of this entry »

SSL Troubleshooting

 Troubleshooting SSL with Certutil

This document contains steps that have been used to configure SSL for use with the Remedy AREA and ARDBC LDAP plugins. Most of the information in this document is supported by the individual 3rd party vendors, not BMC, but has been provided as a convenience to the customer. These steps were written from a Windows Server perspective but should be applicable, with some interpretation, to most Unix platforms.

Read the rest of this entry »

Fiddler Videos

http://www.fiddler2.com/Fiddler/help/video/

How to Configure JMX for JConsole

Viewing JMX Data

Use a JMX client to view data gathered by JMX. JConsole, which is included in the JDK 1.5, is one such client.

Using JConsole Locally

To use JConsole on the same machine your server is running on, set the JAVA_OPTS property as follows: Read the rest of this entry »

Win2008 64bit IIS 7 and Tomcat

Download the latest Tomcat binaries for Win64 (AMD64 or x64)

  1. Download Tomcat binaries (Windows Service Installer) from http://tomcat.apache.org/download-60.cgiNOTE: It appears the latest Tomcat Service Installer now supports 64 bit so the below files may no longer be needed
  2. Download 64 bit Tomcat Native binaries from http://tomcat.apache.org/download-native.cgi
  3. Download 64 bit versions of tomcat6.exe and tomcat6w.exe from http://svn.apache.org/viewvc/tomcat/tc6.0.x/tags/TOMCAT_6_0_20/res/procrun/
    (replace the 6_0_20 to reflect the version you downloaded in step 1
  4. Download 64 bit Isapi_Redirector.dll from http://tomcat.apache.org/download-connectors.cgi

Install Tomcat Read the rest of this entry »

7.6.03 and earlier C# API (including ARODBC)

You must use Visual Studio .NET 2003 with AR System 7.6.03 and earlier for compiled API’s and ODBC programs.  This is because BMC R&D uses VS 2003 as their compiler platform.  Note:  this is true for 32-bit AR Servers.  The 7.6.03 64-bit AR Server requires VS .NET 2008. Read the rest of this entry »

Setting the LANG env for Linux

1. First check to make sure the system supports the charset you want to use.

# locale -a | grep en_US

2.

#LANG=en_US.utf8

#export LANG