IBM Support

** Troubleshooting ** "Could not create the view: !Could not create controller of type" when launching Java-related menu items (e.g. "Command Center")

Troubleshooting


Problem

User launches any Java-related menu item (e.g. "Maintain - Jobs - Define"). User receives error message. The error message will vary slightly depending on which menu item is chosen, but in general it will be as below.

Symptom

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:56)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:515)
at com.ibm.cognos.ccr.core.ui.databinding.widgets.AbstractControllableComposite.createController(AbstractControllableComposite.java:67)
at

<....>

Cause

There are several possible causes for similar error messages:
Scenario #1 - Missing JAR file on Controller application server
  • For more details, see separate IBM Technote #1600374
 
Scenario #2 - Windows user (used to run the Controller Java Windows service) does not have sufficient rights to read the JAR file.
  • For more details, see separate IBM Technote #1600374
 
Scenario #3 - Incorrect configuration of the file "ccr-system-properties.properties" on the Controller application server (in the ...Server\integration folder)
For some environments, the location of the TNSNAMES.ORA file must be specified.
  • TIP: For another example, see separate IBM Technote #1618336
 
Scenario #4 - Incorrect configuration (e.g. typo) of System Variable "CCR_JAVA_Home".
  • For more details, see separate IBM Technote #481789
 
Scenario #5 - Customer has copied file (ocijdbc10.dll) on the Controller application server, when using the Oracle 11G client, instead of the 'recommended' solution which is to modify the file "ccr-system-properties.properties".
  • For more details, see separate IBM Technote #1618336
 
Scenario #6 - Invalid Extended dimension structure.
  • For more details, see separate IBM Technotes #1441171 & 1691901.
 
Scenario #7 - Incorrect Windows username/password used for Windows service "IBM Cognos Controller Java Proxy" on the application server.
  • For more details, see separate IBM Technote #1619686
 
Scenario #8 - Invalid "CCRProxy.options" file.
  • For more details, see separate IBM Technote #1636695.
  
Scenario #9 - Java Proxy service has run out of memory
  • For more details, see separate IBM Technote #1646879.
 
Scenario #10 -  Defect in 10.4.2 RTM (10.4.2000.252)
  • For more details, see separate IBM Technote #6116608 .

Environment

Scenario #3
Controller database hosted on Oracle server.

The problem does not occur in all environments. In other words, keeping the default (unmodified) file "ccr-system-properties.properties" will work in most environments.

  • By enabling the path in this file, then Controller's Java-based functionality will try to connect using the 'thin' protocol
  • If the file/path is unmodified (the default settings), then those components will try to use the 'OCI'

TIP: For another example, see separate IBM Technote #1618336.

Diagnosing The Problem

By clicking on "Details" a much bigger explanation of the error appears. Approximately three-quarters of the way down, the 'root cause' of the message is given in the sections "caused by" (after the words "FAIL").
Example - Scenario #2
... 68 more
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.CANNOT_EXECUTE_SERVICE, argument(s)=[FAIL: Message: Automation error
The remote procedure call failed. Source: FrJavaProxyB, http://servername/ibmcognos/controllerserver/CCRWS.asmx, ?]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.executeTask(JAXWSClient.java:107)

Example - Scenario #6
FAIL:!java.lang.StackOverflowError!

Resolving The Problem

Scenarios 1 & 2
Copy database-specific JAR file onto Controller application server
  • See separate IBM Technote #1600374.
 
Scenario #3
Specify the location of the TNSNAMES.ORA file in the ccr-system-properties.properties file in the ...Server\integration folder.
Steps:
  1. Logon to the Controller application server as an administrator
  2. Locate the 'integration' folder. TIP: By default the 'integration' folder is here: C:\Program Files (x86)\ibm\Cognos\C10\Server\integration
  3. Open the file "ccr-system-properties.properties" inside Notepad
  4. Edit the file as appropriate.
Example:
For Oracle 10.2, by default the location of the TNSNAMES.ORA file is usually the directory: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
Therefore, in the case of a default Oracle 10G rel2 client install, you need to modify the file as follows:
# Oracle Network admin directory path, the location of the TNSNAMES.ORA file oracle.net.tns_admin=C:\\oracle\\product\\10.2.0\\client_1\\NETWORK\\ADMIN
  

Scenario #4

Configure System Variable "CCR_JAVA_Home" correctly.
  • See separate IBM Technote #1615017.

 

Scenario #5

Modify the file "ccr-system-properties.properties".
  • See separate IBM Technote #1618615.

Scenario #6

Correct invalid extended dimension structure.
  • See separate IBM Technote #1441171.

Scenario #7
Correct the Windows username/password used for the service "IBM Cognos Controller Java Proxy" on the application server.
  • For more details, see separate IBM Technote #1619686.

Scenario #8
Ensure that either:
  • There is no "CCRProxy.options" file
  • or the "CCRProxy.options" file contains valid memory settings (e.g. 2Gb RAM or less for 32-bit JAVA)
  • or convert the system to use 64-bit JAVA.
For more details, see separate IBM Technote #1636695.
  
Scenario #9
Optimise the Controller application server's Java Proxy service memory subsystem.
  • For more details, see separate IBM Technote #1646879.
 
Scenario #10
Upgrade to Controller 10.4.2 IF1 (or later)
  • For more details, see separate IBM Technote #6116608 .

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 March 2020

UID

swg21612000