by ·0 Comments

Product:
Cognos BI 10.1.1 64 bit version
AIX
Oracle 11.2.0
Java version 1.5

Symptom:
When testing the connection to a oracle data source, the Compatible Query Mode is successful, but you get a error message for Dynamic Query Mode (JDBC).

Error message:
XQE-GEN-0002 An unexpected exception occurred: ocijdbc11 (A file or directory in the path name does not exist.)

Background:
You have installed 32 Bit Oracle client on your Cognos Aix server.
You have set the LIBPATH to /IBM/cognos/oracle/product/11.2.0/client32/lib
You have added oracle path to the PATH variable.
You have copied the ojdbc5.jar file to the /IBM/cognos/c10_64/webapps/p2pd/WEB-INF/lib folder.

Under Dynamic/JDBC connection setting, you can
choose “Service ID”, “TNS Names Alias” and ‘Oracle Net Descriptor”.
This error only occurs on “TNS Names Alias” (OCI driver type only), and ‘Oracle Net
Descriptor” (With OCI driver type).
“Service ID” option and Oracle Net Descriptor (Thin driver type) don’t have this issue.

Solution:
Cognos BI 10.1.1 needs to call 64 Bit Oracle libraries when you use a JAVA OCI driver.
But Compatible Query Mode only supports 32 Bit Oracle client (SQLNET).

Recommendation is to use SERVICE ID to access the Oracle database with JDBC.
Enter the server name to the oracle server using FQDN name.
Enter the port number e.g. 1521.
Enter the oracle service ID, that is the database name.

In previous OCI configuration you set the user name to the schema name and also enter the password for the user name.

Then test the connection again.

Otherwise you need to install both 32bit and 64bit oracle client and update the LIBPATH accordingly, to maybe get it to work.

by ·0 Comments

Product:

Cognos BI 10.1.1

AIX

Java 1.5

 

Problem:

How do I set Cognos BI Service to start automatic on a AIX server after a reboot of the AIX server ?

 

Background:

AIX will run scripts that are placed in folder /etc/rc.d/rc2.d

The name of the script tells AIX when to run it.

S scripts are executed with ‘start’ option during the boot of the machine in the order of next 2 digits (00 to 99).
K scripts are executed during shutdown with ‘stop’ parameter added automatically.

It is simpler to have one script that you copy and name it S99Cognos.sh and K99Cognos.sh.

 

Solution:

Open notepad or other text editor

Enter below into the text editor…………………………………………………….

#!/bin/bash

#################################################
# name: S99Cognos
# purpose: script that will start or stop the cognos application.
#################################################

case “$1” in
start )

su – cogservice -c ‘/opt/IBM/cognos/c10_64/bin64/cogconfig.sh -s’

;;

stop )

su – cogservice -c ‘/opt/IBM/cognos/c10_64/bin64/cogconfig.sh -stop’

;;* )
echo “Usage: $0 (start | stop)”
exit 1
esac

………………………………………………………………………………………………….

Save the file as S99Cognos.sh and

Save the file as K99Cognos.sh

 

You need to update the path in above file to reflect your installations paths.

You need to replace cogservice with your account that run the Cognos service.

 

Ensure the files are saved in folder /etc/rc.d/rc2.d

as the root user (the folder to use depends on the AIX setup).

 

To start IBM HTTPServer:

Open vi or other AIX text editor

Enter below into the text editor…………………………………………………….

 

#!/bin/bash

#################################################
# name: S99HTTPServer
# purpose: script that will start or stop the apache application.
#################################################
start )
export LIBPATH=/opt/IBM/cognos/c10_64/cgi-bin:$LIBPATH
/opt/IBM/HTTPServer/bin/apachectl -k start
;;
stop )
export LIBPATH=/opt/IBM/cognos/c10_64/cgi-bin:$LIBPATH
/opt/IBM/HTTPServer/bin/apachectl -k stop
;;

* )
echo “Usage: $0 (start | stop)”
exit 1
esac

………………………………………………………………………………………………..

Save the file as S99HTTPServer.sh and

Save the file as K99HTTPServer.sh

 

Ensure the files are saved in folder /etc/rc.d/rc2.d

as the root user.

Test the scripts carefully before you use them on your production AIX server.

by ·0 Comments

Product:
Cognos BI 10.1.1
AIX server

Symptom:
After you have apply Cognos BI fix pack 1 the Cognos BI service does not start.

More information:
Instlog folder show version tl-BISRVR-10.1-6235.144
cmplst.txt file contain line:
C8BISRVR_version=C8BISRVR-AX64-ML-RTM-10.1.6235.144-0

You have installed from media bisrvr_aix64h_10.1.1_ml.tar.gz

The fixpack you have downloaded and try to install on AIX is
file CBI_10.1.1_AIX64_FP001.tar.gz from
http://www-01.ibm.com/support/docview.wss?uid=swg24033004

Solution:
Copy the file bootstrap_aix64.xml from a clean RTM installation of Cognos BI 10.1.1
and replace the new file in the server where you have installed the fix pack.

The file are in folder /opt/IBM/cognos/c10_64/bin64

After you have replaced the bootstrap_aix64.xml file with the old one, then the Cognos BI service should start.

The bootstrap_aix64.xml you should use are 2971 bytes in size.

This is only a issue on AIX, on Microsoft Windows the Cognos BI fix pack works.

by ·0 Comments

Product:

Cognos TM1 10.2.2

Microsoft Windows 7

Problem:

How update several workstations with the new TM1 certificates?

Solution:

If the users are allowed to run a POWERSHELL script, then something like this may solve the issue:

(you need to adjust PATH for your environment)

# the new certs need to be unziped in folder C:\NewSSLCerts
$strPath = “C:\Program Files\ibm\cognos\tm1_64\bin64\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath

     $CMD = $strPath + ‘importsslcert.exe’
     $arg1 = ‘-remove’
       & $CMD $arg1
     & $CMD

}Else{
  # // File does not exist
}

#  only copy the files to other folders
$strPath = “C:\Program Files\ibm\cognos\tm1_64\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

#  only copy the files to other folders like 32 bit version
$strPath = “C:\Program Files (x86)\ibm\cognos\tm1\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

#  only copy the files to other folders like other drive
$strPath = “d:\Program Files (x86)\ibm\cognos\tm1\bin\ssl\”
$strFile = “applixca.pem”

$strFileName= $strPath + $strFile
If (Test-Path $strFileName){
    
    Copy-Item -Path C:\NewSSLCerts\*.* -Destination $strPath
   
}Else{
  # // File does not exist
}

 

More Information:

http://stevehardie.com/2013/04/powershell-check-if-file-exists/

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

http://ss64.com/ps/copy-item.html

by ·0 Comments

Product:
IBM Cognos Controller 10.2.1 FAP
C8BISRVR_UPDATE_version=C8BISRVR-AW64-ML-RTM-10.2.5002.78-0
C8BISRVR_UPDATE_name=IBM Cognos Business Intelligence Server Update
CONTRL_UPDATE_version=CCR-AW64-ML-RTM-10.2.5003.68-0
CONTRL_UPDATE_name=IBM Cognos Controller Update
Microsoft Windows 2008 R2 Server

Problem:
After update of certificate on TM1 server, the FAP will not work.

Error message:
2016-10-15 13:36:58,382 [schedulerThread] INFO Scheduler – FAP service started
2016-10-15 13:37:31,251 [schedulerThread] ERROR Scheduler – Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerNotFound
at com.ibm.cognos.tm1.API.getServerSecurityMode(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.preLoginCheckIfCAM(TM1Context.java:62)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:454)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:230)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:144)
at java.lang.Thread.run(Thread.java:781)

Solution:
You have the FAP service installed on the Cognos Controller server, and not the TM1 10.2.2 server.
Then there is a TM1 client installed on the Cognos Controller server that also need to have the certifikate updated.

Stop the Cognos services.
Backup the folder D:\Program Files\ibm\cognos\tm1_64\bin64\ssl and D:\Program Files\ibm\cognos\tm1_64\bin\ssl

Download the updated TM1 SSL Certificates from the following location: http://www.ibm.com/support/fixcentral/quickorder?product=ibm%2FInformation+Management%2FCognos+TM1&fixids=BA-CTM1-SSL-ZIP-IF001

Extract the downloaded file/archive and extract it to any directory. For the purpose of this document, our files will be extracted in to <tm1_client_install_dir>\tm1_64\NewSSLCerts\

Copy the contents of the folder you extracted earlier <tm1_client_install_dir>\tm1_64\NewSSLCerts\ , and place them inside of the 2 directories listed above in Step 4. During this process, you will be required to REPLACE all conflicting files as we must replace the old certificate files with new ones.

 

After all files have been copied successfully, navigate to <tm1_client_install_dir>\tm1_64\bin\ssl\

Execute the uninstallSSL.bat file, to uninstall old keys from the Windows Keystore

If uninstallSSL.bat does not exist, run importsslcert.exe -remove from Command Line

Execute the importsslcert.exe file, to install the new keys in to the Windows Keystore
Start the Cognos services.

Start IBM Cognos FAP service.

Login to IBM Cognos Controller Financial Analytics Publisher and do a initial publish by click on START in the Data Marts tab.

If it works, then the certificate it replaced good.

by ·0 Comments

Product:
Cognos Controller FAP 10.1.1
Windows 2008 R2 Server
Cognos TM1 10.2.2
Oracle database

Issue:
In a multi server setup, when you try to connect to the TM1 server from a terminal server where Cognos TM1 Architect is installed, you get the list of TM1 servers, but when you click on ONE TM1 server ( for example the one called FAP ) then there is no login. Only a not responding message for some time, and then you are back inside TM1 Architect.
If you use TM1 Architect on the same server as where TM1 is installed, then it works fine.

Possible Solution:
There are two networks cards in the TM1 server machine. One network card for access by clients, and the other network card for the company backup routines.
TM1 server will bind and only use the first network card found on the Microsoft Windows 2008 server. And if that is not the card used by clients, you will get this issue.
Go to Control Panel
Go to Network and Sharing Center
Click Change adapter settings
Press the ALT key to get menus on top in the dialog
Select Advance – advance settings from the menu
In adaptor and bindings dialog for connections you see two networks listed
Mark the one that belongs to the client network ( it may start with ip 10 ) and click on the up arrow icon on the right.
Click OK
Close the dialog.
Restart the TM1 services, and test again from TM1 Architect on the Terminal server or client computer.

by ·0 Comments

Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2 Server

Problem:
When starting the FAP service, where we use Cognos BI CAM authentication, we get a error in the logs that say:
“Could not login to TM1, host: , server name: , user name: <namespace\username>”
C8ITKShared (C:\Program Files\IBM\cognos\TM1_64\bin64\ C8ITKShared.dll is not a valid Win32 application.)

Background:
TM1 10.2.2 64 bit server installed to same Windows server as the Controller FAP Service.
The Windows FAP Service are 32 bit and uses 32 bit dll.
The new FAP client is 64 bit and uses the 64 bit dll and database drivers.
Default install of TM1 10.2.2 only install 64 bit dll files for TM1.

Solution:
Install TM1 Architect in 32 bit version to the server.
Add the path to the C8ITKShared.dll to the system path e.g. C:\Program Files (x86)\IBM\cognos\TM1\bin.
Right click on My Computer and select properties
Click on Advance System Settings
Click Environment Variables
Select PATH and click Edit
Update the path and save.
Click OK to exit dialog.
Restart the Server.

More Information:
http://www-01.ibm.com/support/docview.wss?uid=swg21450399

by ·0 Comments

Product:
Cognos TM1 10.2.2
Windows 2008 R2 Server

Issue:
How do I copy a cube from on TM1 server to another TM1 server in a different environment? The 2 TM1 servers are part of two different BI installations, they use the same Active Directory for authentication, and there are no firewall issues between the servers.

Possible Solution:
Use a ODBO connection in Cognos TM1 Architect to create the copy.
Start TM1 Architect and log in to the receiving TM1 server.
Right click and select to create a new process.
Select Datasource type: ODBO – cube.
In connection you need to enter this information:
ODBO Provider: IBM Cognos TM1 OLE DB MD Provider
ODBO Location: servername.domain.com (servername of the windows host that have TM1 admin service)
ODBO Datasource: FAP (name of the TM1 server where you want to get data from)
ODBO Catalog:
ODBO UserID: username (name of the admin user in TM1 application)
ODBO Password: password
Additional Connection Parameters: Provider String=”CAMNamespace=CDS”
The additional Connection Parameters is only if you have a TM1 application that use CAM/BI authentication – enter the name of the Cognos BI namespace, in our example CDS.
Click on CONNECT button – if no errors then you wrote the correct values above.
Go to Load ODBO Cube dialog tab
Select ODBO Cube to load from: FAPMonthlyCompanyDetails (or any other cube you want to import)
Select TM1 Cube to load to: FAPMonth (or any other name you have for it)
Cube Type: Physical Cube
TM1 Cube Action: Create Cube
Data Action: Store Values
Click on Cube Dimensions dialog tab
Here you can change what dimensions the values should connect to, or let the import create the new dimensions in your TM1 receiving server.
Click on MDX Query tab
Here you should be possible to adjust the MDX if you need to.
Click SAVE icon to save the process, give it a name like: FAP import from external server
Run the process.
Depending on the size of the TM1 Cube this can take some time.
When done you should have a copy of the cube and the dimensions.

More Information:
http://blog.tm1tutorials.com/2012/07/27/automating-data-transfers-between-tm1-servers/
http://blog.tm1tutorials.com/tag/odbo/

by ·0 Comments

Product:
Cognos Planning 10.1.1
Windows 2008 R2 Server
Oracle database

Problem:
When a user inside Cognos Planning Administration Console ( CAC ) click on the Monitoring Console tab he get a error message and when he click OK the CAC program exits (crash).

Error message:
Run time error 13 – type mismatch

Solution:
Truncate two tables inside the Cognos Planning Store.

p_pnrequestprogress
and p_pnrequest

Start SQL developer
Login to the database as COGPLAN (the schema that have access as the planning and planning store databases)
Enter;

truncate p_pnrequestprogress
truncate p_pnrequest

Commit
And test again from inside Cognos Planning Administrator to click on Monitoring Console.

by ·0 Comments

Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2
Oracle Database
Problem:
FAP process stops when it founds a user in Controller that does not exist in CAM source (LDAP or AD)
Error in FAP log:
2015-01-07 12:36:03,673 [IP:FAP] ERROR RetryInterceptor – Trial 3 failed for method addCAMUser
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1$$EnhancerByCGLIB$$3867900c.addCAMUser()
at com.ibm.cognos.fap.service.security.User.createUsers(User.java:87)
at com.ibm.cognos.fap.service.security.Security.publish(Security.java:64)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.initialPublish(DatamartTimerTask.java:501)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.access$300(DatamartTimerTask.java:80)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask$1.run(DatamartTimerTask.java:367)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not add CAM user AD\username1 with CAMID
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:320)
… 12 more
Caused by:
com.ibm.cognos.tm1.TM1Exception: ObjectRegistrationFailed
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:314)
… 12 more

Possible Solution:
Go into the Cognos Controller client, and erase all users that should not be there. That has left the company and does not exist in the Active Directory.
http://www-01.ibm.com/support/docview.wss?uid=swg21632436
Different solution is to run SQL script to erase all users that have no CAMID in the table XCAMUSER inside the Cognos Controller database.
Start SQL developer and connect to the Cognos Controller database
Enter below to list the free rows:
Select * from frango.xcamuser where camid = ‘ ‘;
Enter below to make a copy of the table before deleting its contents:
create table xcamuser_backup as select * from xcamuser;
Enter below to delete the empty rows:
Delete from frango.xcamuser where camid = ‘ ‘;