by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 server

Symptom:
After installation of Cognos Controller you get an error message when you start Cognos Controller Configuration

Error message in Controller:
Web Service, ControllerProxyServer, could not be found. Section is disabled.
The type initializer for ‘Cognos.Controller.Configuration.CRN’ threw an exception.

Cause:
The IIS installation is damage.

Check by start the IIS manager and expand the Application pool or the site list. You will get error like below:
There was an error while performing this operation
Details:
Filename:
\\?\c:\windows\microsoft.net\framework64\v2.0.50727\CONFIG\web.config
Line number: 13
Error: The configuration section “system.web” cannot be read because it is missing a section declaration.
or
Configuration system failed to initialize.

Possible Solution:
Uninstall IIS from windows and reinstall it from add/remove roles.

by ·0 Comments

Product:
Cognos Controller 10.3
Microsoft Windows 2008 R2 server
Oracle Database 12c

Symptom:
Error when you do optimize of the database inside Cognos Controller 10.3 in a new installation.

Error message:
Number: 5
Source: System.Web.Services
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: ORA-12516: TNS:listener could not find available handler with matching protocol stack
at Microsoft.VisualBasic.
…

Cause:
The Cognos controller use more connections to the database server than the database server is setup for.

Solution:
Increase the max Connections value for the Oracle server from 500 to max 1000.

The Cognos Controller 10.3 can create 300 inactive connections to the database during some heavy processes. If the oracle database use around 90 connections for internal use, then you soon hit the limit of 500 on the Oracle database.

by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database

Symptom:

Error when you try to start Cognos controller client for the first time to new Cognos Controller server.

If you try to surf to this http://controllerservername/ibmcognos/controllerserver/ccrws.asmx

You also get an error message like;

Server Error in ‘/ibmcognos/controllerserver’ application

Could not load type ‘System.ServiceModel.Activation.HttpModule’ from assembly…..

 

Error message in Controller Client details:

Client found response content type of ‘text/html; charset=utf-8’, but expected ‘text/xml’.

The request failed with the error message:

—

<!DOCTYPE html>

<html>

<head>

<title>Could not load type ‘System.ServiceModel.Activation.HttpModule’ from assembly ‘System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’.</title>

<meta name=”viewport” content=”width=device-width” />

<style>

body {font-family:”Verdana”;font-weight:normal;font-size: .7em;color:black;}

p {font-family:”Verdana”;font-weight:normal;color:black;margin-top: -5px}

b {font-family:”Verdana”;font-weight:bold;color:black;margin-top: -5px}

H1 { font-family:”Verdana”;font-weight:normal;font-size:18pt;color:red }

H2 { font-family:”Verdana”;font-weight:normal;font-size:14pt;color:maroon }

pre {font-family:”Consolas”,”Lucida Console”,Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}

.marker {font-weight: bold; color: black;text-decoration: none;}

.version {color: gray;}

Solution:

You need to register the ASPNET with IIS on the Microsoft Windows server.

Start a CMD prompt as an administrator on the Controller servers.

  1. In a command window, go to the c:/Windows/Microsoft.NET/Framework64/v4.0.30319/ directory.
  2. Enter the following command:

aspnet_regiis.exe /i

Repeat on all Cognos Controller servers, and for Cognos Controller 10.2 and 10.3 you need to use NET framework 4.5.6 that is in folder /Framework64/v4.0.30319/.

This is the response you should get from the command:

C:\Windows\Microsoft.NET\Framework64\v4.0.30319>aspnet_regiis /i

Microsoft (R) ASP.NET RegIIS version 4.0.30319.0

Administration utility to install and uninstall ASP.NET on the local machine.

Copyright (C) Microsoft Corporation.  All rights reserved.

Start installing ASP.NET (4.0.30319.0).

……..

Finished installing ASP.NET (4.0.30319.0).

More information:

https://www.ibm.com/support/knowledgecenter/SS9S6B_10.2.0/com.ibm.swg.ba.cognos.qrc_ctrl_inst.10.2.0.doc/t_qsg_ctrl_cnfgaspnet.html

by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database

Symptom:

Error when you try to start Cognos controller client for the first time to new Cognos Controller server.

Error message in Controller Client details:

Client found response content type of ‘text/html’, but expected ‘text/xml’.

The request failed with the error message:

—

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head>

<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″/>

<title>500 – Internal server error.</title>

<style type=”text/css”>

<!–

body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}

fieldset{padding:0 15px 10px 15px;}

h1{font-size:2.4em;margin:0;color:#FFF;}

h2{font-size:1.7em;margin:0;color:#CC0000;}

h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;}

#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:”trebuchet MS”, Verdana, sans-serif;color:#FFF;

background-color:#555555;}

#content{margin:0 0 0 2%;position:relative;}

.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}

–>

</style>

</head>

Solution:

The WEB.CONFIG file is not correct in the cgi-bin folder on the IIS for the Cognos Controller installation.

It can have been edit and a > character is missing or the “ is not of the correct type.

Open the file in notepad and enter the value manually

Do not copy and paste it from the website. That will give errors.

Using Windows Explorer, open the cgi-bin folder (default = C:\Program Files\ibm\cognos\ccr_64\cgi-bin)

  • Launch NOTEPAD.EXE and edit the file ‘web.config’

TIP: From Windows 2012 onwards, it is not possible to edit files directly unless logged on as the user ‘Administrator’. One easy workaround is to launch a Command Prompt ‘As Administrator’ and (inside there) type: NOTEPAD.EXE.

  • Add the text allowPathInfo=”true” after the entry: resourceType=”xxxxx”

The text should look similar like this inside the web.config file:

<?xml version=”1.0″ encoding=”UTF-8″?>

<configuration>

<system.webServer>

<handlers>

<add name=”IBMCOGNOSISAPI” path=”cognosisapi.dll” verb=”*” modules=”IsapiModule” scriptProcessor=”C:\Program Files\ibm\cognos\ccr_64\cgi-bin\cognosisapi.dll” resourceType=”Unspecified” preCondition=”bitness64″ allowPathInfo=”true” />

<add name=”IBMCOGNOSCGI” path=”*.cgi” verb=”*” modules=”CgiModule” resourceType=”Unspecified” allowPathInfo=”true” />

</handlers>

</system.webServer>

</configuration>

After the update enter IISRESET to restart the web service on the Windows server.

Then test to start the Cognos Controller client again.

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21653338

by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database

Symptom:

Error when you try to check oracle database connection inside Cognos controller configuration on a new Cognos controller installation.

You have entered the values:

Database type: Oracle

Name: default

Provider: OraOLEDB.Oracle.1

User ID:  (the schema name)

Password:  (the password to the schema user in oracle)

Data source: (the oracle SERVICE_NAME)

Error message:

The ‘OraOLEDB.Oracle.1’ provider is not registered on the local machine.

Solution:

  1. Launch a Command Prompt (CMD) as the user ‘Administrator’
  2. Type the following command (or go to the folder where your oracle driver is installed)

CD C:\orarun\ora12102\client\BIN

  1. Type the following commend:

c:\Windows\system32\regsvr32.exe OraOLEDB12.dll

 

C:\orarun\ora12102\Client\BIN>dir oraole*.*

Volume in drive C is SYSTEM

Volume Serial Number is FC7D-6E96

 

Directory of C:\orarun\ora12102\Client\BIN

 

2014-07-31  21:40           744 448 OraOLEDB12.dll

2014-07-31  21:38             1 712 OraOLEDB12.tlb

2014-07-31  21:34             9 728 OraOLEDB12d.dll

2014-07-31  21:33             9 728 OraOLEDB12e.dll

2014-07-31  21:33             9 728 OraOLEDB12f.dll

2014-07-31  21:33             9 728 OraOLEDB12i.dll

2014-07-31  21:34             9 216 OraOLEDB12ja.dll

2014-07-31  21:33             9 216 OraOLEDB12ko.dll

2014-07-31  21:33             9 728 OraOLEDB12ptb.dll

2014-07-31  21:38             9 728 OraOLEDB12us.dll

2014-07-31  21:33             9 216 OraOLEDB12zhs.dll

2014-07-31  21:34             9 216 OraOLEDB12zht.dll

2014-07-31  21:38           139 776 OraOLEDBgmr12.dll

2014-07-31  21:38            15 360 OraOLEDBpus12.dll

2014-07-31  21:34            11 776 OraOLEDBrfc12.dll

2014-07-31  21:33             9 728 OraOLEDBrmc12.dll

2014-07-31  21:38           177 664 OraOLEDBrst12.dll

2014-07-31  21:33            19 968 OraOLEDButl12.dll

18 File(s)      1 215 664 bytes

0 Dir(s)  59 198 668 800 bytes free

C:\orarun\ora12102\Client\BIN>c:\windows\system32\regsvr32.exe OraOLEDB12.dll

C:\orarun\ora12102\Client\BIN>

Then start the Cognos Controller Configuration and test the connection to database again.

If above does not work, then you need to reinstall the Oracle drivers in a correct manner.

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21694296

by ·0 Comments

Product:
Cognos Controller 10.1.1 and 10.3
Oracle database
Microsoft Windows 2008 R2 server

Symptom:
When you publish to DataMart from inside Cognos controller you get an error message.

You have inside Cognos Controller configuration setup a DataMart connection for you Controller database like this:

Error message:
ORA-04052: error occurred when looking up remote object FRANGO.DMTEMPLATE@DMPUBLISH.COMPANYX.COM

Possible Solution:
Start SQL Developer and connect to the controller data schema.

The connection string is not updated correct inside the database from the Controller configuration setup.
Then do this commands (you need to edit the connection for your environment)

DROP DATABASE LINK “DMPUBLISH.COMPANYX.COM”;

CREATE DATABASE LINK “DMPUBLISH.COMPANYX.COM”;
CONNECT TO FRANGO
IDENTIFIED BY <PASSWORD>

USING ‘
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = LX1234.COMPANYX.COM) (PORT = 1521))
( CONNECT_DATA =
( SERVER = DEDICATED)
( SERVICE_NAME = IT0123.COMPANYX.COM)
)
)  ‘ ;

Then after this update – try the DataMart function inside Cognos controller again.

by ·0 Comments

Product:

Cognos Controller 10.3 (CONTRL_version=CCR-AW64-ML-RTM-10.3.0.169-0)

Microsoft Windows 2008 R2 Server

Oracle 12c database (version  Release 12.1.0.2.0) 64 bit

Symptom:

When connect to an Oracle Controller database you get an error during the upgrade steps inside Cognos Controller Configuration program.

Error message in DBCONV:

Running DB Step: 950

Running script batch: script/ora_950.batch

Running script: script/ora/ora_update_xmenu.sql

Running DB Step: 951

Running DB Step: 952

Running script batch: ora_952.batch

Running script: script/ora_xrclayout_add_column.sql

** ERROR: java.sql.SQLSyntaxErrorException: ORA-00904: “DBMS_LOB”.”SUBSTR”: ogiltig identifierare

ORA-06512: vid rad 12

The SQL command that give the error are:

DECLARE

sSql VARCHAR2(4000);

BEGIN

IF NOT UFNC_OBJECT_EXISTS(‘SELECT 1 FROM user_tab_COLUMNS WHERE table_name = ”XRCLAYOUT” AND column_name = ”EXCELFILEFORMAT”’) THEN

sSql := ‘ALTER TABLE XRCLAYOUT ADD EXCELFILEFORMAT number DEFAULT (0) NOT NULL’;

EXECUTE IMMEDIATE (sSql);

sSql := ‘UPDATE XRCLAYOUT SET EXCELFILEFORMAT = 56’;

EXECUTE IMMEDIATE (sSql);

sSql := ‘UPDATE XRCLAYOUT SET EXCELFILEFORMAT = 51 WHERE UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(layout, 2,1)) = ”PK”’;

EXECUTE IMMEDIATE (sSql);

END IF;

END;

Possible Solution:

There can be a setting on the Oracle database that does not allow that many connections. Please check and increase.

Please note: If you get a error during upgrade of a cognos controller database – then the database will be corrupt, because some upgrade steps will be missing. You must restore the original database and run the upgrade steps again from the beginning to ensure the database is fully functional.

It can be that you have the wrong ojdbc7.jar file in the controller folder.

Copy the correct ODBC file from the Oracle client installation on the server

Can be this folder:

C:\orarun\ora12102\Client\jdbc\lib\ojdbc6.jar

To the folders of the Cognos controller installation

that normally is these folders;

C:\Program Files\ibm\cognos\ccr_64

C:\Program Files\ibm\cognos\ccr_64\server\integration

C:\Program Files\ibm\cognos\ccr_64\server\FAP\lib

C:\Program Files\ibm\cognos\ccr_64\webapps\p2pd\WEB-INF\lib

Close the Controller Configuration and start it again so it can pick up the new driver jar file you have paste into the controller ccr_64 folder.

You can also be needing to run the DBCONV.EXE program as standalone from Cognos Controller Configuration.

Go to folder /ccr_64/ and start DBCONV.EXE

Click on the button with dots to select the correct UDL file.

Then click on Connection Button.

Now you can click on Upgrade button, and it should work better.

There can also be other cause of this issue – ensure the host name in cognos controller configuration only use the servername and not .domain.com – the new code does not accept period in server name for the data source.

 

More Information:

Cognos Controller use different connection methods to connect to ORACLE databases, like this:

ODBC = Controller Consolidation part

OLEDB = Controller Applications part

JDBC = used by DBCONV and java parts, also used by Cognos BI CQM reports

OCI  = used by Cognos BI DQM reports (not found on Cognos Controller server)

by ·0 Comments

Product:

Cognos Planning 10.2

Windows 2012 server

Issue:

How install the new Cognos planning on windows server?

Some help:

Use of this information should help you get it right, ensure this things are done before you test the installation.

To integrate with Cognos BI try this  tips from ”How can I install IBM Cognos Planning in the same environment as 64-bit IBM Cognos Business Intelligence”

http://www-01.ibm.com/support/docview.wss?uid=swg21501838

Error when start Planning Analyst and other tools ”cannot find files”
Ensure to do this:

renamed adminbifs.amf to adminbif.AMF
renamed adminodbc.AMF to adminodb.AMF
http://www-01.ibm.com/support/docview.wss?uid=swg21635667

Windows supports long file names up to 255 characters in length. Windows also generates an MS-DOS compatible short file name in 8.3 format to allow MS-DOS based or 16-bit windows based programs to access these files. When the 8.3 setting is enabled only short file names are generated. Therefore the long file name of adminbifs.AMF is shortened to adminbif.AMF and adminodbc.AMF is shortened to adminodb.AMF and this causes the error on startup as the file cannot be located as it does not exist under that name and Analyst is a 32-bit program and works off the long file name only.
Error when starting Planning Analyst of type ”cannot connect libraries”
Ensure to do this:

1. Launch MSCONFIG by from the Run menu.

2. Click on the Tools tab. Scroll down till you find “Disable UAC” . Click on that line.
3. Press the Launch button.
4. A CMD window will open. When the command is done, you can close the window.
5. Close MSCONFIG. You need to reboot the computer for changes to apply.

OR

Alternate Solution:
1. Give the everyone group full control to the folder where the libraries are located.

OR
Alternate Solution: If User Account Control resolution above does not resolve issue:
1. Right-click the Analyst shortcut
2. Select Properties > Compatibility tab
3. Check the box: Run this Program as Administrator
4. Now open Analyst as the user who is receiving the error.

http://www-01.ibm.com/support/docview.wss?uid=swg21380414

To have access to the folders on the SQL server you need to do this:
Install the SQL Server Client tools (if this has not already been done).

NB For SQL Server 2005 you need to have the full SQL Client installed (comes with SQL Express) as the Native Client does not install all of the required .dll files.
For SQL Server 2008 full client tools required.

Once the SQL Server Client tools are installed, ensure that the Contributor user account used to connect to SQL Server has EXEC permissions to the following Extended Stored Procedures in the Masters Database:

xp_availablemedia
xp_subdirs
http://www-01.ibm.com/support/docview.wss?uid=swg21343839
Contributor Datastore server connection check Trusted Connection instead of login with an account

Depending on the setup you should use Trusted or SQL account login. Try the other if you have issues like “Subscript out of range”
http://www-01.ibm.com/support/docview.wss?uid=swg21986012

There are more things to configure — search google.com if you get issues.

http://www-01.ibm.com/support/docview.wss?uid=swg21991365&myns=swgimgmt&mynp=OCSSPN2D&mync=R&cm_sp=swgimgmt-_-OCSSPN2D-_-R

https://www.ibm.com/support/knowledgecenter/SSPN2D_10.2.0/com.ibm.swg.ba.cognos.cp_inst_cr_winux.10.2.0.doc/c_installingcognos8planningwithcognos8businessintelligence.html

by ·0 Comments

Product:
Cognos BI 10.2.2 fix pack 7
Microsoft Windows 2008 R2 Server

Symptom:
Running the installation program for Cognos BI and Cognos BI fix pack are very slow. The program stand still a long time at same step.

Cause:
If you look in task manager you will see that the process using more than 25% of the CPU are MsMpEng.exe Antimalware service Executable. The System Center Endpoint Protection program is installed and set to have real-time protection on the server.

Antivirus software will always slow down the copy of files during installation of Cognos Programs. It is recommended to turn off Antivirus software during install and exclude the Cognos program and subfolder from the real time scan on the servers.

Installation of IBM Cognos Business Intelligence Server Updates 7 took 3 hours with Microsoft anti-virus software turned on instead of a few minutes when it was turned off.

If IT department do not want to turn off Antivirus on servers, work around is that you can try to install both Cognos BI and Cognos TM1 at the same time but to different folders. This will gain you a little time.