Product:
Cognos Controller 10.2.1 FAP service
Windows 2012 R2
Problem:
When starting the IP in FAP client you get an error message it cannot connect to the TM1 instance called FAP.
Error message:
2015-05-29 10:47:52,183 [schedulerThread] ERROR Scheduler – Could not logon to TM1
com.ibm.cognos.tm1.TM1Exception: SystemServerClientNotFound
at com.ibm.cognos.tm1.API.logonCAMNamespace(Native Method)
at com.ibm.cognos.fap.common.persistence.tm1.TM1Context.login(TM1Context.java:106)
at com.ibm.cognos.fap.service.schedule.Scheduler.updateDatamarts(Scheduler.java:530)
at com.ibm.cognos.fap.service.schedule.Scheduler.run(Scheduler.java:252)
at com.ibm.cognos.fap.service.schedule.Scheduler$1.run(Scheduler.java:157)
at java.lang.Thread.run(Thread.java:795)

Solution:
Enter correct password for the CAM user account domain\cognosfap
Save and try again.
More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21679216&aid=1

Product:
Cognos BI 10.2.2
Windows 2012 R2 server

Issue:
After upgrade from Cognos BI 10.1.1 to Cognos BI 10.2.2 the creation of PDF reports takes several minutes, when it before take only seconds.
HTML reports are as fast they were in the older version of Cognos BI.
If you remove the pictures in the report, then the PDF file is created fast.

Possible Solution:
Copy all the images to the Report BI server, in old version the images that are in reports are on the Cognos BI Gateway server only. Now it is recommended to have them on all BI servers.
Update all servers to have the pictures in the folder .. \samples\images.
D:\Program Files\ibm\cognos\c10_64\webcontent\samples\images

The PDF creation looks locally for the pictures at first, before going to the gateway.

Product:
IBM Data Studio 4.11
Windows 2012 R2 Server
DB2 database

Problem:
To save money the Cognos TM1 project does not want to use TOAD, and instead the free Data Studio – to allow the Developers have access to the data.

When run lanchpad.exe to install the DB2 Data Studio you get a installation screen without buttons. There are no links to select and install the product. Only a OK button to select language in the dialog exist in top right corner.
There should be buttons or menu options on the left side of the dialog, but there are none.
When you click on the OK button at the language, you are only brought back to the same dialog as before.

Instruction say to start LANCHPAD.EXE from the unzipped ibm_ds4110_win.zip file.
But that does not seem to work in some computer environments.

Solution:
Run the INSTALL.EXE instead.
Go to the folder \ibm_ds4110_win\disk1\installerimage_win64\
Right click on INSTALL.EXE and select “Run as Administrator”
This will first install the IBM Installation Manager
When that is done it will automatically start installation of Data Studio.

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

Product:
IBM DB2 Data Studio 4.1.1
Windows 2012 R2 Server
DB2 database

Problem:
Get a error when I start the program Data Studio 4.1.1 Client

Error Message:
Locking is not possible in the directory “D:\xxxx…. ” A common reason is that the file system or Runtime Environment does not support file locking for that location. Please choose a different location, or disable file locking passing “-Dosgi.locking=none” as a VM argument. ….

Possible Solution:
Right click on the icon for Data Studio 4.1.1 Client and start the program “Run As Administrator”.

During installation the Windows environment was not setup to run in a “multiuser environment”.

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

Problem:
Suddenly the FAP client can not login to the TM1 FAP instance, that have worked before.

Error message:
Could not login to TM1, host: servername.domain.com, server name: FAP user name: AD\Roger
SystemServerClientNotFound

Solution:
If you restart the TM1 instance, then you need to restart the FAP service.
1. Stop the FAP Service
2. Stop the TM1Service
3. Start the TM1Service
4. Start the FAP Service

Make sure to pause between the startup of TM1 and FAP, to ensure that the TM1 is up complete and ready to accept calls from clients.

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

Product:

Cognos TM1 10.2.2

Microsoft Windows 2008 R2

 

Symptom:

The TM1 admin service do not start (tm1admsdx64).

If you look into the Windows Event log you find this message;

 

Event log message:

Log Name: Application

Source: Application Error

Date: 8/1/2015 12:32:16 AM

Event ID: 1000

Task Category: (100)

Level: Error

Keywords: Classic

User: N/A

Computer: servername.domain.com

Description:

Faulting application name: tm1admsd.exe, version: 10.2.20100.123, time stamp: 0x5423612c

Faulting module name: MSVCR100.dll, version: 10.0.40219.1, time stamp: 0x4d5f034a

Exception code: 0x40000015

Fault offset: 0x00000000000761c9

Faulting process id: 0x6d8

Faulting application start time: 0x01d0c3b20308c42b

Faulting application path: C:\Program Files\IBM\Cognos\tm1_64\bin64\tm1admsd.exe

Faulting module path: C:\Program Files\IBM\Cognos\tm1_64\bin64\MSVCR100.dll

Report Id: fe71016e-37d3-11e5-bd34-0050569d5f35

Event Xml:

<Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event”>;

<System>

<Provider Name=”Application Error” />

<EventID Qualifiers=”0″>1000</EventID>

<Level>2</Level>

<Task>100</Task>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime=”2015-07-31T22:32:16.000000000Z” />

<EventRecordID>105927</EventRecordID>

<Channel>Application</Channel>

<Computer>servername.domain.com</Computer>

<Security />

</System>

<EventData>

<Data>tm1admsd.exe</Data>

<Data>10.2.20100.123</Data>

<Data>5423612c</Data>

<Data>MSVCR100.dll</Data>

<Data>10.0.40219.1</Data>

<Data>4d5f034a</Data>

<Data>40000015</Data>

<Data>00000000000761c9</Data>

<Data>6d8</Data>

<Data>01d0c3b20308c42b</Data>

<Data>C:\Program Files\IBM\Cognos\tm1_64\bin64\tm1admsd.exe</Data>

<Data>C:\Program Files\IBM\Cognos\tm1_64\bin64\MSVCR100.dll</Data>

<Data>fe71016e-37d3-11e5-bd34-0050569d5f35</Data>

</EventData>

</Event>

 

 

Possible Cause:

Some time before you find message in Windows event log about

Event ID: 2013

Description:

The D: disk is at or near capacity. You may need to delete some files.

and you check the D drive to find there is very little space free.

Erase some file to free some GB and restart of server to see if that helps.

 

Possible Solution:

On TM1 servers, change the Virtual Memory for Windows 2008, to not be System Managed and instead set it to be fixed at the same level as the amount of RAM in the server.

Go to Control Panel – System – Advance system settings

Click Settings button for Performance

Click the Advanced tab

Click Change for Virtual Memory

In Virtual Memory dialog

Click on hard drive e.g. D:

Click Custom Size and set a value of

initial size to 8192 MB

maximum size to 33791 MB

(values depend on your hardware).

Click SET.

Click OK.

Restart the Windows server.

Product:

Cognos Controller 10.1 (version 10.1.2159)

Oracle database datamart ( dm version 43 )

Windows 2008 R2 server

 

Symptom:

After a publish to datamart from inside the Cognos Controller client there is no data in the DMFACT table. The publish (export) are very quick – a few minutes – and when you check there is no data in the DM tables in the Datamart.

 

Possible Solution:

You need to ensure that the text for provider and data source are spelled the same in Cognos Controller Configuration for both database connections and Database Connections for publish to datamart. If there are capitals letters they need be the same one both configurations for the two databases, one for the controller data and one for the datamart to be used by Cognos Controller.

The datamart must be of the same database version as the Cognos Controller database, you can not have Cognos Controller in Oracle and the datamart in a Microsoft SQL database, then you will get a “finish with error” when you do the Publish for datamart in Cognos Controller Client.

When you define the datamart inside Cognos Controller, you must set the additional target to be Cognos BI. This will create the data in the database you have defined inside Database Connections for publish to datamart. If you leave it blank it will try to publish the DM data to the same database as your Cognos Controller database. Set additional target to Cognos BI, save the definition, and then go to Transform – Publish Data and Structures – Publish Data Mart.

Only select Period there you have data – otherwise you can get a error message like “no data found” – and select all structures. In this dialog then the Target must be “IBM Cognos BI” and not “none”.

Ensure you have the ojdbc6.jar file in the c:\program files(x86)\ibm\cognos\c10 folder to make the dbconv.exe file to work.  If there are issues, try the :\program files(x86)\ibm\cognos\c10\legacy\dbconv.exe file instead. Point to the udl file in dmdata folder and check that it is of the right DM version.

Changes to the datamart udl take affect direct, but you can restart the Batch service to make them work better.

More information:

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

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

Product:
Cognos TM1 10.1.1
Windows 2008 R2
Internet Explorer

Symptom:
When user from TM1WEB try to export a view to excel using “snapshot to excel” nothing happens. Sometimes there are text in the dialog to select report heading that says “inactivate translation”. Restart of IE or change of language settings does not help.

Solution:
There is a add on installed in your browser, that prevents TM1WEB to send to Excel.
Look at the top of your browser window – if there are a extra line of buttons you may have a add on toolbar. In one case it was “Google Toolbar” that gave the problem.
Turn off Google Toolbar by click on the left “x” and select permanent deactivate Google toolbar.

More information:
https://en.wikipedia.org/wiki/Google_Toolbar
https://support.google.com/toolbar/answer/9231?hl=en&ref_topic=1727206&vid=1-635757569835073343-1277689272

https://support.google.com/toolbar/answer/146786?vid=1-635757566323118119-1277689272

Product:
Cognos Controller FAP service
Windows 2012 R2
Microsoft SQL database

Symptom:
Start FAP Initial Publish for first time, after a half hour you get a fail message. Also show “java.lang.StackOverflowError” if you hold your mouse over the message in FAP log dialog.
You try by restart and new test but get same result again.

Text in C:\Program Files\ibm\cognos\ccr_64\Server\FAP\error.log file can be:

2015-08-25 17:47:42,429 [schedulerThread] INFO Scheduler – FAP service started on host:SEservername.domainsweden.com
2015-08-25 18:15:30,786 [pool-4-thread-7] ERROR RetryInterceptor – Trial 1 failed for method populateMonthlyPeriod
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:45)
at com.ibm.cognos.fap.service.persistence.dao.period.PeriodFAPDaoMSSqlServer$$EnhancerByCGLIB$$519ff1f8.populateMonthlyPeriod()
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:182)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)

at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.Period.addMonthlyPeriodIfItNotExist(Period.java:184)
at com.ibm.cognos.fap.service.dimension.facts.BaseFactsHandler.addPeriodsIfTheyNotExist(BaseFactsHandler.java:276)
at com.ibm.cognos.fap.service.dimension.facts.CompositeFactsHandler.addPeriodsIfTheyNotExist(CompositeFactsHandler.java:258)
at com.ibm.cognos.fap.service.dimension.facts.Facts$Transformer.run(Facts.java:128)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:483)
at java.util.concurrent.FutureTask.run(FutureTask.java:274)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
at java.lang.Thread.run(Thread.java:801)
Caused by:
java.lang.StackOverflowError
at java.util.concurrent.CopyOnWriteArrayList.toArray(CopyOnWriteArrayList.java:364)
at java.util.logging.Logger.accessCheckedHandlers(Logger.java:1368)
at java.util.logging.LogManager$RootLogger.accessCheckedHandlers(LogManager.java:1507)
at java.util.logging.Logger.getHandlers(Logger.java:1362)
at java.util.logging.Logger.log(Logger.java:624)
at java.util.logging.Logger.doLog(Logger.java:653)
at java.util.logging.Logger.log(Logger.java:676)
at java.util.logging.Logger.severe(Logger.java:1162)
at com.microsoft.sqlserver.jdbc.TDSParser.throwUnexpectedTokenException(tdsparser.java:97)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:88)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1488)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processResults(SQLServerStatement.java:1135)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processBatch(SQLServerStatement.java:1123)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.processExecuteResults(SQLServerStatement.java:1115)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.processResponse(SQLServerPreparedStatement.java:347)
at com.microsoft.sqlserver.jdbc.TDSCommand.close(IOBuffer.java:4660)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.discardLastExecutionResults(SQLServerStatement.java:93)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.closeInternal(SQLServerStatement.java:583)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closeInternal(SQLServerPreparedStatement.java:172)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.close(SQLServerStatement.java:595)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at com.ibm.cognos.fap.common.persistence.dao.BaseDao.closeJDBCObjects(BaseDao.java:85)
at com.ibm.cognos.fap.service.persistence.dao.period.PeriodFAPDao.populateMonthlyPeriod(PeriodFAPDao.java:135)
… 5294 more

Solution:
Try with a different Cognos Controller database as a source. Try with less period of data, only select 6 months instead of 18 months inside the FAP manager client.

Product:
Cognos TM1 performance modeler 10.2.2
Windows 2012 R2
RDP server (terminal server)

Symptom:
You start Performance modeler local on the terminal server and connects to the TM1 server.
When you select “import data” you get a error message. But after the message (you click OK one) then you get your drive dialog to select a txt file.

You get same error if you from Excel on same server select File – Open.

“This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator”.

Solution:
This is by setup on the Terminal server. You should not have access to the C drive.
This is a normal behavior.

Ask the Terminal Server administrator for a better behavior.

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