Business measures model import failure due to the usage of user defined metric name similar to a predefined metric name

The import of the business measures model may fail if the imported business measures models contains a user defined metric that its name is similar to any predefined metric name.

You must not define any metric in the business measures model when you are modeling it in the Business Measures editor with the name of any predefined metrics. This will cause the importing of the business measures model in the WebSphere® Business Monitor administrative console to fail and the following exception will be thrown:

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "REPOS.META_MONITOR_METRIC" from having duplicate rows for those columns. SQLSTATE=23505
		 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
		 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
		 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
		 at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(Unknown Source)
		 at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(Unknown Source)
		 at com.ibm.wbimonitor.repository.importer.OMEntity.insertEntity(OMEntity.java:714)
		 at com.ibm.wbimonitor.repository.importer.Metric.accept(Metric.java:48)
		 at com.ibm.wbimonitor.repository.importer.RepositoryManager.
				importModelList(RepositoryManager.java:409)
		 at com.ibm.wbimonitor.repository.importer.RepositoryManager.
				repositoryImport(RepositoryManager.java:234)
		 at com.ibm.wbimonitor.repository.importer.RepositoryManager.
				repositoryImport(RepositoryManager.java:198)
		 at com.ibm.wbimonitor.repository.importer.Run.main(Run.java:60)

The following is a list of all predefined names that should not be used for the names of any metrics, counters and stopwatches in the Business Measures editor.

Predefined names in the Business Measures editor
Process Local process and loops
Process Instance Parent ID  
Process Instance ID  
Process Instance Name  
Process Instance Description  
Start Time Start Time
Elapsed Duration Elapsed Duration
Working Duration Working Duration
State State
Is Delayed  
Caller MC Definition Id  
Caller MCIID  
Caller Table Physical Name  
  Instance Parent ID
  Instance Description

Copyright IBM Corporation 2005. All Rights Reserved.