IBM Support

How to set disableDuplicateLevelCheck to true for IBM Cognos Dynamic Cubes

Technote (troubleshooting)


Documentation states to set the option disableDuplicateLevelCheck to true to prevent the check for members with duplicate member keys on IBM Cognos Dynamic Cube startup.

See also:


Error on startup of IBM Cognos Dynamic Cubes, stating that duplicate level keys exist.


Duplicate level keys exist for different members. The check is implemented in IBM Cognos 10.2.1 and higher.
The check makes sure that all level keys are unique, to prevent possible errors in the metadata tree and calculation errors.

Resolving the problem

In case you are experiencing this error, it is recommended that a composite key is used for the level in IBM Cognos Cube Designer to make sure that each level and each member is unique.

However in case you did not experience problems in IBM Cognos 10.2, you can disable the check for duplicate member keys.

  1. Go to Cognos Administration > Configuration > Dispatchers and Services.
  2. Drill down on one of the dispatchers.
  3. Open the properties of the Query Service.
  4. In the Settings tab, go to entries 16 - 19.
  5. For "Additional JVM arguments for the query service (Requires QueryService restart)" add -DdisableDuplicateLevelCheck=true.
  6. Perform these steps for every Dispatcher running a Query Service.
  7. Restart the complete BI environment.

Document information

More support for: Cognos Business Intelligence

Software version: 10.2.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 1652958

Modified date: 14 October 2013

Translate this page: