Product:
Cognos Controller 10.1.1
Windows 2008 R2 Server
Oracle database
Symptom:
New installation of Cognos Controller 10.1.1. When user select maintain – jobs – define menu, they get a error message after some time.
Problem message:
Could not create the view: !Could not create controller of type com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController for composite class com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionUI!
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:516)
at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.createController(AbstractControllableComposite.java:67)
at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.getController(AbstractControllableComposite.java:58)
at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:547)
at com.ibm.cognos.ccr.core.ui.view.AbstractViewPart.initializeController(AbstractViewPart.java:490)
at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionView.createPartControl(JobDialogDefinitionView.java:55)
at org.eclipse.ui.internal.ViewReference.createPartHelper(ViewReference.java:375)
at org.eclipse.ui.internal.ViewReference.createPart(ViewReference.java:229)
at org.eclipse.ui.internal.WorkbenchPartReference.getPart(WorkbenchPartReference.java:595)
at org.eclipse.ui.internal.PartPane.setVisible(PartPane.java:313)
at org.eclipse.ui.internal.ViewPane.setVisible(ViewPane.java:534)
at org.eclipse.ui.internal.presentations.PresentablePart.setVisible(PresentablePart.java:180)
at org.eclipse.ui.internal.presentations.util.PresentablePartFolder.select(PresentablePartFolder.java:270)
at org.eclipse.ui.internal.presentations.util.LeftToRightTabOrder.select(LeftToRightTabOrder.java:65)
at org.eclipse.ui.internal.presentations.util.TabbedStackPresentation.selectPart(TabbedStackPresentation.java:473)
at org.eclipse.ui.internal.PartStack.refreshPresentationSelection(PartStack.java:1245)
at org.eclipse.ui.internal.PartStack.setSelection(PartStack.java:1198)
at org.eclipse.ui.internal.PartStack.showPart(PartStack.java:1597)
at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:643)
at org.eclipse.ui.internal.PartStack.createControl(PartStack.java:570)
at org.eclipse.ui.internal.PartSashContainer.createControl(PartSashContainer.java:568)
at org.eclipse.ui.internal.PerspectiveHelper.activate(PerspectiveHelper.java:272)
at org.eclipse.ui.internal.Perspective.onActivate(Perspective.java:981)
at org.eclipse.ui.internal.WorkbenchPage.onActivate(WorkbenchPage.java:2714)
at org.eclipse.ui.internal.WorkbenchWindow$27.run(WorkbenchWindow.java:3023)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.WorkbenchWindow.setActivePage(WorkbenchWindow.java:3004)
at org.eclipse.ui.internal.WorkbenchWindow.busyOpenPage(WorkbenchWindow.java:799)
at org.eclipse.ui.internal.Workbench$23.runWithException(Workbench.java:1224)
at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31)
at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:180)
at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)
at org.eclipse.swt.widgets.Display.syncExec(Display.java:4683)
at org.eclipse.ui.internal.StartupThreading.runWithWorkbenchExceptions(StartupThreading.java:50)
at org.eclipse.ui.internal.Workbench.busyOpenWorkbenchWindow(Workbench.java:1220)
at org.eclipse.ui.internal.Workbench.access$31(Workbench.java:1196)
at org.eclipse.ui.internal.Workbench$58.run(Workbench.java:2215)
at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
at org.eclipse.ui.internal.Workbench.openWorkbenchWindow(Workbench.java:2212)
at com.ibm.cognos.ccr.core.ui.util.WorkbenchUtil.openPerspective(WorkbenchUtil.java:685)
at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.openNewPerspective(IntegrationServiceImpl.java:136)
at com.ibm.cognos.ccr.integration.application.internal.IntegrationServiceImpl$MyPerspectiveOpener.run(IntegrationServiceImpl.java:112)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4140)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3757)
at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2696)
at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2660)
at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2494)
at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:674)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:667)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
at com.ibm.cognos.ccr.integration.application.internal.IntegrationApplication.start(IntegrationApplication.java:85)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:344)
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:144)
at java.lang.Thread.run(Thread.java:736)
Caused by: com.ibm.cognos.ccr.common.InvalidContextException: !Could not load model: job!
at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:235)
at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:100)
at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.<init>(AbstractLifeCycleManager.java:89)
at com.ibm.cognos.ccr.integration.application.ValidatingLifeCycleManager.<init>(ValidatingLifeCycleManager.java:47)
at com.ibm.cognos.ccr.integration.application.views.AbstractDialogController.<init>(AbstractDialogController.java:91)
at com.ibm.cognos.ccr.integration.internal.job.ui.JobDialogDefinitionViewController.<init>(JobDialogDefinitionViewController.java:39)
… 63 more
Caused by: com.ibm.cognos.ccr.common.NoSuchModelException: !Unable to find instance of model of type: job[JobModel]!
at com.ibm.cognos.ccr.common.DefaultModelContext.throwNewNoSuchModelException(DefaultModelContext.java:422)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:396)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModel(DefaultModelContext.java:255)
at com.ibm.cognos.ccr.integration.application.AbstractLifeCycleManager.getModel(AbstractLifeCycleManager.java:233)
… 68 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[FAIL:!Array index out of range: 50!, http://servername/ibmcognos/cgi-bin/cognosisapi.dll?t=controller, ?]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(JAXWSClient.java:107)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.executeTask(RemoteDao.java:91)
at com.ibm.cognos.ccr.ccrws.persistence.RemoteDao.getLatestSequenceNumber(RemoteDao.java:63)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.getLatestSequenceNumber(CachingDao.java:78)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.isUpToDate(CachingDao.java:175)
at com.ibm.cognos.ccr.common.persistence.caching.CachingDao.load(CachingDao.java:90)
at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:572)
at com.ibm.cognos.ccr.common.AbstractModel.load(AbstractModel.java:562)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:74)
at com.ibm.cognos.ccr.common.AbstractModelFactory.getNewModel(AbstractModelFactory.java:66)
at com.ibm.cognos.ccr.common.DefaultModelContext.getModelByIdentifier(DefaultModelContext.java:394)
… 70 more
Caused by: java.lang.RuntimeException: MTsxMDE6MjM4ZmZkZWUtZDdhMC1hZTc5LTI1MDQtMjEyYjQ5MTJjNzQwOjMzNDkxMjM0OTQ7MDszOzA7
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:65)
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(WebServiceConnectionException.java:52)
… 81 more
Cause:
The tnsnames.ora file is to large for Cognos Controller to use.
Solution:
Create a smaller tnsnames.ora file and place in a separate folder on the controller server, for example d:\oracle.
Make the tnsnames.ora file only contain the information for the Cognos Controller database, and no other oracle database or oracle schemas.
Then update the ccr-system-properties.properties file, often located in folder, c:\Program Files (x86)\Cognos\C8\Server\integration.
# IBM SOURCE CODE HEADER START
# =====================================================================
# OCO Source Materials
#
# BI and PM: ccr
#
# (C) Copyright IBM Corp. 2004, 2009. All Rights Reserved
#
# The source code for this program is not published or
# otherwise divested of its trade secrets, irrespective of
# what has been deposited with the U.S. Copyright Office.
# =====================================================================
# IBM SOURCE CODE HEADER END
# User defined System properties
# Oracle Network admin directory path, the location of the TNSNAMES.ORA file
oracle.net.tns_admin=D:\\oracle
You must reboot the Controller server to make changes to file ccr-system-properties.properties take affect.
More Information: