Product:
Cognos TM1 10.1.1
Architect
Windows 2008 R2 Server
Symptom:
List of cubes and views are not sorted alphabetical for a Swedish user.
ÅÄÖ are not in the right place in the list, they are after A instead of Z.
Solution:
Exit Tm1 architect
Go to windows control panel
Click on region and language icon
Change format from English to Swedish
Click OK
Start Tm1 architect
Login and have a look at the list.
Product:
TM1 9.5.1
Symptom:
Even than you are logged in as Administrator in Cognos TM1 Architect program, many menus are grey as you where logged in as a Anonymous or a person without Admin rights in the TM1 cube.
The user complain that they can not reach the Security – Clients/groups menu on the TM1 application.
Problem:
On the Citrix installation of TM1 Architect there are some files missing from the users folder.
Solution:
Copy the files tm1p8.lic and tm1p.ini from a working local installation of TM1 Architect to the Citrix server.
Place the files in folder c:\programdata\applix\tm1
More Information
http://www-01.ibm.com/support/docview.wss?uid=swg21419930
Product:
Cognos TM1 10.1.1
TM1 Application Web
Windows 2008 R2 Server
Symptom:
New installed TM1 application server, when user surf to TM1 Application web the top right icons is missing (my preferences, help and help options). If you have the mouse pointer over the red cross, the function text will show.
You have surfed to http://tm1server.domain.se:9510/pmpsvc, and logged in to get this issue.
This can happen on a TM1 and BI installation where Cognos BI are on a separate server from Cognos TM1.
Cause:
The Cognos BI server is setup with customized skins. This skin folder is not located on the TM1 application server. Therefore we are missing some icons.
Solution:
Logon to the Cognos BI server and find the customized skin that is used under folder
\\biservername\d$\Program Files (x86)\ibm\cognos\c10_gw\webcontent\skins\NIPPON\shared\images
(the folder path can be different on your Cognos BI gateway server)
On the Cognos TM1 server create this folder
D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\skins\NIPPON\shared\images
Copy the images from the BI server folder \Program Files (x86)\ibm\cognos\c10_gw\webcontent\skins\NIPPON\shared\images
to the TM1 server folder
D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\skins\NIPPON\shared\images
(replace NIPPON with your skin name in above folders)
(because this is TOMCAT using this folder the NIPPON name is case sensitive)
Restart the TM1 application server and test again.
Product:
Cognos TM1
Cognos BI
Windows 2008 R2 server
Symptom:
Can not apply formatting in active forms for TM1.
Solution:
Before installation of TM1, you need to install Microsoft Excel on the TM1 server to make Tm1web work.
Active Forms formatting does not work if you have a language specific Excel version, you must install a Microsoft Excel Multilanguage version.
Recommend that to any Tm1 installation, always install the Microsoft Office multi language versions of Excel 2010.
Product:
Cognos TM1 10.1.1
Windows 2008 R2 server
CAM security
Symptom:
Switched to cam security from TM1 native security and when you login to TM1 Architect you get error message. You get same error message if you try to surf to TM1 Application web at
http://tm1server.domain.se:9510/pmpsvc
IntegratedSecurityMode=5
will give error, but not
IntegratedSecurityMode=2
Error message:
404 – file or directory not found
Possible Solution:
The value in TM1s.cfg for ClientCAMURI is pointing to the wrong Cognos BI server.
When you use security 1 or 2 then the CAM address is not used, and you will not get issues.
Copy the value from ClientCAMURI (http://biserver02.domain.se/ibmcognos/cgi-bin/cognosisapi.dll) and start Internet explorer, paste the value in and try to surf to it, if you get errors here. Then it will not either work for TM1.
Update your TM1s.cfg file and restart your TM1 application service.
…
ServerCAMURI=http://biserver.domain.se:9300/p2pd/servlet/dispatch
ClientCAMURI=http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=1800
CAMPortalVariableFile=portal\variables_TM1.xml
AllowSeparateNandCRules=T
GroupsCreationLimit=100
MaximumCubeLoadThreads = 11
…
The value in TM1p.ini file (in folder C:\Users\%username%\AppData\Roaming\Applix\TM1) is only used when you add users to the TM1 application from TM1 architect. It should have the same value as the TM1S.CFG file.
…
AllowImportCAMClients = F
CognosGatewayURI = http://biserver.domain.se/ibmcognos/cgi-bin/cognosisapi.dll
…
Product:
Windows 2008 R2 server
IBM Cognos TM1 10.2
Cognos BI server is installed on a Windows server
Problem:
How do I setup Cognos TM1 10.2? ( the old version)
Solution:
Download the file tm1_64b_10.2.0_win_ml.tar.gz (CIPW2ML) from IBM website with your IBM account. More info at http://www-01.ibm.com/support/docview.wss?uid=swg24033833
Before you install TM1 10.2 check this things:
On the Windows 2008 Server you need to ensure that the printer spooler service is running.
Go to RUN on the server start menu, and enter Services.msc
Start the “print spooler” service and set it to automatic.
Check that NET framework 4.00 is installed.
Go to Windows Explorer, and check that you have this folder
C:\Windows\Microsoft.NET\Framework\v4.0.30319
If you are missing NET framework – please download and install NET framework 4.00 from
http://www.microsoft.com/en-gb/download/details.aspx?id=17718
Run the file dotNetFx40_Full_x86_x64.exe to install Net Framework.
You must have Net framework version 4 to use Architect or Perspectives all functions.
(Recommended that you have a dedicated workstation with Windows 7 and Excel 2010 where you install TM1 Perspectives and Architect for the TM1 developers to use.)
Ensure you have installed Microsoft Visual C++ 2010 Redistributable
Go to Control panel – program and features
Check that you have installed
Microsoft Visual C++ 2010 Redistributable – x64 10.0.30319
Microsoft Visual C++ 2010 Redistributable – x86 10.0.30319 or 10.0.40219
If not download the files from
http://www.microsoft.com/en-us/download/details.aspx?id=14632
and install by right click and select “Run as Administrator” on the files;
vcredist_x64.exe (size 5585 KB)
vcredist_x86.exe (size 4879 KB)
Log on to the Microsoft Windows 2008 server as a local administrator.
Turn off any running anti-virus software on the server.
Set the User Access Controller settings (UAC) to “never notify”.
Run D:\install\tm1_64b_10.2.0_win_ml\winx64h\iisetup.exe to start the installation.
Select all parts, including the IBM Cognos Insight and IBM Cognos TM1 Performance Modeler.
Wait during the installation – it take some time.
Start IBM Cognos Configuration with “Run as Administrator”
Change localhost under the TM1 Application Server tab to the name of the Windows server.
Leave localhost as is under the Environment tab.
Start the TM1 admin server by right click on it and select start.
Do the same for TM1 Application Server, SData, Planning Sample and GO_New_Stores.
Start notepad from start menu by selecting “Run as administrator”
Open tm1p.ini file from folder c:\programdata\applix\tm1 in notepad.
Change it’s content from this:
[TM1]
DataBaseDirectory = ..\samples\tm1\PData
AdminHost =
ConnectLocalAtStartup = F
LocalServerNetworkProtocol = tcp
IntegratedLogin = F
AdvancedRulesEditor = F
#AllowImportCAMClients = F
#CognosGatewayURI = http:/LocalHost/cognos10/cgi-bin/cognos.cgi
To this content:
[TM1]
DataBaseDirectory = ..\samples\tm1\PData
AdminHost = tm1servername
ConnectLocalAtStartup = F
LocalServerNetworkProtocol = tcp
IntegratedLogin = F
AdvancedRulesEditor = T
AllowImportCAMClients = T
CognosGatewayURI = http://biservername.domain.com/ibmcognos/cgi-bin/cognosisap.dll
(change biservername to your already installed Cognos BI 10 server)
(change tm1servername to the name of the Windows server where you install TM1)
Save the file and exit notepad.
Start Architect from start menu under IBM Cognos TM1 – 64 folder.
Click on Planning Sample to login
Login with user: Admin and password: apple
Exit Architect
This to test the login of Architect.
Change settings in a TM1 server to allow Cognos authentication (CAM login)
Stop the GO_New_Stores Tm1 application from IBM Cognos Configuration.
Open the file D:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\tm1s.cfg
Add these lines to TM1 server configuration file: (Tm1s.cfg)
ServerCAMURI=http://biservername.domain.com:9300/p2pd/servlet/dispatch
ClientCAMURI=http://biservername.domain.com/ibmcognos/cgi-bin/cognosisapi.dll
ClientPingCAMPassport=900
CAMPortalVariableFile=templates\ps\portal\variables_plan.xml
DistributedPlanningOutputDir=.\tunit
ForceReevaluationOfFeedersForFedCellsOnDataChange=T
AllowSeparateNandCRules=T
IntegratedSecurityMode=2
And save the configuration file.
Start the GO_New_Stores Tm1 application from IBM Cognos Configuration.
Start Architect.
Click on GO_New_Stores to login as the Admin.
Right click GO_New_Stores and select security – client/groups.
Click client menu and select add new client
Click on your domain – not cognos.
Click on search icon in top right corner.
Enter the name of the admin user you want to be able to setup the TM1 application.
Search for him.
Mark the user in the list and click Arrow icon to add him to the group.
Click OK to add him to the TM1 application security.
Mark him as ADMIN in TM1 application.
Click OK and exit Architect.
Stop the GO_New_Stores Tm1 application from IBM Cognos Configuration.
Open the file D:\Program Files\ibm\cognos\tm1_64\samples\tm1\GO_New_Stores\tm1s.cfg
in notepad as administrator and change the IntegratedSecurityMode line to:
IntegratedSecurityMode=5
Save the file.
Start the GO_New_Stores Tm1 application from IBM Cognos Configuration.
Start Architect.
Click on GO_New_Stores to login as the Windows user account instead.
To start TM1WEB you surf to this address:
http://tm1servername:9510/tm1web
for IBM Cognos TM1 Application use:
http://tm1servername:9510/pmpsvc
for IBM Cognos Performance Management Hub use:
http://tm1servername:9510/pmhub/pm/admin
for TM1 Operations Console use:
http://tm1servername:9510/pmhub/pm/opsconsole
To get TM1WEB to work you need to add some files to the BI server.
Extract this files D:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\gateway_files\ tm1web_gateway.zip to a d:\temp folder.
Rename the variables_TM1.xml.sample to variables_TM1.xml file
Update the variables_tm1.xml file with the tm1 server name.
Copy the varibales_tm1.xml file to folder C:\Program Files\ibm\cognos\c10\templates\ps\portal on the Cognos BI server (both on BI report server and Content Manager server).
Update the file tm1web.html with the name of the TM1server at line:
// Update the following to point to the location of the TM1Web service(s)
var tm1webServices = [“http://tm1servername:9510”];
Copy the tm1web.html file to folder C:\Program Files\ibm\cognos\c10\webcontent\tm1\web on the Cognos BI server. (if the folder \tm1\web does not exist, create it on BI server).
Mostly you do not need to restart the Cognos BI server to make the changes take affect, but if nothing else helps try a restart of Cognos BI.
More information:
To get TM1 Application Web to use Cognos authentication you also need to:
There are three files, that you need to copy to the Cognos BI server:
variables_plan.xml
planning.html
icon_active_application.gif
Extract the contents of the D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\gateway_files\planning_gateway.zip into three different locations on the Cognos BI C10 server.
variables_plan.xml -> C:\Program Files\ibm\cognos\c10\templates\ps\portal
planning.html -> C:\Program Files\ibm\cognos\c10\webcontent
icon_active_application.gif -> C:\Program Files\ibm\cognos\c10\webcontent\ps\portal\image
icon_active_application.gif -> C:\Program Files\ibm\cognos\c10\webcontent\icd\feeds\image
Update the planning.html with the TM1 server name at this section:
// Update the following to point to the location of the planning service(s)
var planningServices = [“http://TM1machine.company.com:9510”];
More information:
To ensure that Cognos TM1 Applications can properly detect a CAM session termination, set the pmpsvc session timeout to a value higher than the CAM session timeout.
Open the file D:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\ fpmsvc_config.xml
And edit session timeout value to 120 or something higher than what you have set in IBM Cognos Configuration for Cognos BI at the security – authentication – inactivity timeout in seconds.
<?xml version=”1.0″ encoding=”UTF-8″?><fpm_config xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”fpmsvc_config.xsd”>
<service forceQualifiedPaths=”true”>
<businessViewpoint enabled=”false” uri=”http://localhost:9410/bv”/>
<scorecarding enabled=”true”/>
<provisioning allowInstalls=”true” allowUpdates=”true” uri=””/>
<resource path=””/>
<users path=””/>
<external uri=”http://localhost:9510″/>
<session timeout=”60″/>
</service>
<tm1>
<gateway uri=””/>
……………………….
To start using the TM1 applications you need to add applications.
Surf to http://tm1servername:9510/pmpsvc
Enter TM1servername as Admin host (it will be prepopulated)
Select the TM1 application GO_New_Stores to use.
TM1 application web URL should be:
http://tm1servername:9510/tm1web/Contributor.jsp
Cognos BI gateway URI should be:
http://biservername/ibmcognos/cgi-bin/cognosisapi.dll
Click OK.
If you are missing icons in the toolbar for TM1 Application Web, then you are probably using a custom skin in your Cognos BI environment. Change to use a default skin like “business” to get the icons to show.
Restart the TM1 server to make changes take affect.
Check this to get SSO to work https://allthingscognos.wordpress.com/2014/08/26/configuring-performance-modeller-and-tm1-web-with-cam-security-for-tm1-10-2-n/
Product:
Cognos Controller 10.1
Windows 7
Symptom:
How do I uninstall Cognos controller client from my computer ?
So I can install a new version of Cognos controller client.
Solution:
Log on the computer
Go to control panel
Go to program and features
Find Cognos Controller Client in list
Click to uninstall the program
Remove this folders (if they exist).
c:\program files (x86)\cognos\ccr\
%appdata%\cognos\ccr
%localappdata%\VirtualStore\Program Files (x86)\cognos\ccr\
Reboot client computer
Turn off the UAC (user access controller) in control panel
Install the Cognos Controller client from the dos-prompt,
Select CMD from start menu, and right click and select “Run As Administrator”
Change to the folder where you have copied the MSI file locally.
Then enter this to start the installation
msiexec /i CCRLocalClient.msi
Answer the questions with the appropriate server name.
http://servername.domain.com/ibmcognos/controllerserver
Do not select a cache folder.
Unzip the Integration.zip and jre.zip files in the C:\Program Files\cognos\ccr directory.
More information on how to install Cognos Controller
http://www-01.ibm.com/support/docview.wss?uid=swg21608353
More information on what type of Cognos controller clients there are
Product:
Cognos Planning 10.1.1
Windows 2008 R2 Server
Symptom:
New installed Cognos Planning Job server the Data Movement part is missing in Cognos Configuration.
Problem:
After installation only Cognos Planning Server ( from file pln_srv_10.1.1_win_ml.tar) on a new Windows server that is to be used as a planning job server, inside IBM Cognos configuration program under Environment – IBM Cognos service
there is only these components properties to set to true or false:
Dispatcher service enabled?
Planning administration console service enabled?
Planning data service enabled?
Planning job service enabled?
Planning Web service enabled?
Solution:
Install also Cognos Planning Admin tools (like analyst from file pln_adm_10.1.1_win_ml.tar) on the same folder.
Then when you start IBM Cognos Configuration you have “Data movement service enabled?”
under IBM Cognos services – Component Properties.
Recommend to only have these three components on a dedicated Cognos planning job server active:
-Data movement service
-dispatcher service
-planning job service
In case you will be using admin links to import data from Cognos framework manager packages, then you also need to install the Cognos BI files on the Cognos Planning job server. Then you also need to have more Cognos services enabled on the Planning job server.
Product:
Cognos Contoller 10.1.1
Windows 2008 R2 Server
Oracle 11g
Symptom:
New installation of Cognos controller 10, to be used with Oracle database.
When click connect in Cognos Controller DBCONV program you get a error message.
Error message:
** ERROR: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 50
** ERROR: java.sql.SQLRecoverableException: IO-Fel: could not resolve the connect identifier
Solution:
Change the tnsnames.ora file for the oracle client on the Cognos Controller server.
Ensure the tnsnames.ora file only contain the values for the cognos controller database, not reference to other oracle schema or databases.
Ensure the information is written in several lines, as shown below, and not in a single line in the tnsnames.ora file.
FRANGO= (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST= SERVERNAME.DOMAIN.COM)(PORT=1521) ) (CONNECT_DATA= (SERVICE_NAME=service_name)))
Replace italic above with the schema/oracle server name.
More information
http://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm
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: