IBM Support

"Could not create the view" when opening "Company - Command Center" caused by invalid financial structure (for example loop in Extended Dimension)

Technote (troubleshooting)


Problem(Abstract)

User clicks "Company - Command Center". User receives an error.

Symptom

The error will vary depending on circumstances. Below are two real-life examples:


Example #1 (Controller 10.2.0)

    Could not create the view: Could not create controller of type com........

    Caused by: ...... Unable to find instance of model of type: userrights[UserRightsModel]
    Caused by: .....
    Caused by: ..... FAIL:!java.lang.StackOverflowError!

ccr.log (By default, this is located here: C:\Program Files\ibm\cognos\ccr_64\log)


    16:10:39,221 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking method,
    java.lang.StackOverflowError
    at java.util.HashMap$KeySet.iterator(HashMap.java:974)
    at java.util.HashSet.iterator(HashSet.java:170)
    at java.util.AbstractCollection.toArray(AbstractCollection.java:137)
    at java.util.ArrayList.<init>(ArrayList.java:151)
    at com.ibm.cognos.ccr.extdim.internal. DefaultExtendedDimensionMember.getMembers(DefaultExtendedDimensionMember.java:185)
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:207)
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:209)
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:209)
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:209)
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:209)


Example #2 (Controller 10.2.1)
    Could not create the view: Model not found: userrights[UserRightsModel]
    com.ibm.cognos.ccr.common.InvalidContextException: Model not found: userrights[UserRightsModel]
    at com.ibm.cognos.ccr.core.ui.databinding.ModelContainer.bindModel(ModelContainer.java:99)
    at com.ibm.cognos.ccr.core.ui.databinding.ModelContainer.<init>(ModelContainer.java:71)
    <....>
    at com.ibm.cognos.ccr.core.ui.util.WorkbenchUtil.openPerspective(WorkbenchUtil.java:725)
    at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.openNewPerspective(IntegrationServiceImpl.java:158)
    at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.run(IntegrationServiceImpl.java:128)
    <....>
    at java.lang.Thread.run(Thread.java:798)".


ccr.log (By default, this is located here: C:\Program Files\IBM\cognos\ccr_64\log)
    08:28:35,830 INFO [cognos.ccr.integration.ServerIntegrationFacade] Executing inUserRightsModelDAO.load...
    08:28:35,830 INFO [cognos.ccr.integration.ServerIntegrationFacade] Model context setup for user USERNAME: 0 ms
    08:28:35,862 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking method,
    com.ibm.cognos.ccr.common.InvalidDataException: Corrupted data in database: Extended dimension member 14 has a reference to itself
    at com.ibm.cognos.ccr.extdim.internal.DefaultExtendedDimensionMember.initLevel(DefaultExtendedDimensionMember.java:213)
    <....>
    08:28:35,862 INFO [cognos.ccr.integration.ServerIntegrationFacade] Finished inUserRightsModelDAO.load (135 bytes): 32 ms, memory usage [kb]: max=524 288 | total=166 784 | free=23 395 | total free=380 899

Cause

The message "Could not create the view" is generic - there are many possible causes for this.

  • TIP: See separate IBM Technote #1612000 for a list of possible causes.
    This Technote specifically relates to the scenario where the cause is an incorrect/invalid financial structure (configuration).

    Example #1:
    In one real-life customer example, there was an invalid member of Extended Dimension 1.
    • Specifically, one of the Extended Dimension Members (‘XYZ’) had itself as parent (loop).

    Example #2:
    In one real-life customer example, when the customer ran 'Verify Structures' they found that for Dim1 there was an error.
    • Specifically, there was a non-connected dim-code (at level 0).

  • Diagnosing the problem

    Check both of the following for clues:

    (a) Entries in the section 'Caused by' (in the on-screen error)

    (b) Messages in the 'ccr.log' file (on the Controller application server)

    • TIP: By default, this is located here: C:\Program Files\IBM\cognos\ccr_64\log

    (c) Run a 'Verify Structures' report, to see if there are any issues.

    Resolving the problem

    Fix the incorrect/invalid financial structure (configuration).


    Example #1:
    In the real-life customer example (where the extended dimension member was looping due to being a parent of itself), the fix was to change the parent to 'total' (i.e. blank) and set level to 1.

    • Alternatively, a different method to fix could be to simply delete the 'bad' member ‘XYZ’ (because perhaps that member was added by mistake). However if there is data referring to this member it may be better to keep it.

    Afterwards, it may be necessary for the end user to clear the cache ("Maintain - Special Utilities - Clear local cache"), then close the Controller client and re-launch Controller.

    Example #2:
    In this real-life customer example, the solution was to:
    • Removing non-connected dim-code from xkod and xkodt
    • Run a Database Optimise.

    Related information

    1441171 - Error 'Model not found in context: journalTyp
    1612000 - ** Troubleshooting ** "Could not create the v

    Document information

    More support for: Cognos Controller
    Controller

    Software version: 10.2.0, 10.2.1

    Operating system(s): Windows

    Reference #: 1691901

    Modified date: 21 April 2017