IBM Support

"TM1Exception: The Server Object could not be found" when using FAP, caused by having more than one FAP service using the same FAP database

Troubleshooting


Problem

User launches "IBM Cognos FAP" from the start menu. The Controller "Financial Analytics Publisher" (FAP) Window appears. User starts an initial publish. User clicks the 'logs' tab. After a few seconds, an error appears ("Could not login to TM1") in the 'log' tab (of the FAP GUI). If the user hovers their mouse over this message, then the error 'SystemServerNotFound' appears.

Symptom

Error.log (By default, located here: ...\Program Files\ibm\cognos\ccr_64\server\FAP )

2014-12-23 12:24:49,302 [schedulerThread] INFO Scheduler - FAP service started
2014-12-23 12:26:48,345 [IP:archController] ERROR RetryInterceptor - Trial 1 failed for method createExtDimNameTM1Process
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:76)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:607)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:45)
at com.ibm.cognos.fap.service.persistence.tm1.ExtDimTM1$$EnhancerByCGLIB$$d984eb64.createExtDimNameTM1Process(<generated>)
at com.ibm.cognos.fap.service.dimension.ExtDim.initialPublish(ExtDim.java:146)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.initialPublish(DatamartTimerTask.java:482)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.access$300(DatamartTimerTask.java:82)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask$1.run(DatamartTimerTask.java:371)
at java.lang.Thread.run(Thread.java:781)
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not create stub TI process: Countries_Name_ExtDimProcess
at com.ibm.cognos.fap.service.persistence.tm1.BaseTM1.createStubTM1Process(BaseTM1.java:382)
at com.ibm.cognos.fap.service.persistence.tm1.ExtDimTM1.createExtDimNameTM1Process(ExtDimTM1.java:172)
... 11 more
Caused by:
com.ibm.cognos.tm1.TM1Exception: The Server Object could not be found.
at com.ibm.cognos.fap.service.persistence.tm1.BaseTM1.createStubTM1Process(BaseTM1.java:361)
... 12 more
2014-12-23 12:27:46,361 [schedulerThread] INFO Scheduler - FAP service stopped
2014-12-23 12:28:37,888 [schedulerThread] INFO Scheduler - FAP service started

Cause

There are many different possible causes for similar errors.

  • TIP: See Technote #1664572 for more examples.

This Technote specifically relates to the scenario where the cause is that the customer mistakenly has 2 (or more) application servers with FAP services pointing to the same FAP database.

Example:
The customer has a separate server (with another Windows FAP service) located somewhere else (on the same network). This second server's FAP service is also configured to connect to the same FAP database (as the first server).

Diagnosing The Problem

Check other host machines on the network.

  • Have they got a FAP service running?
  • Is the FAPService.properties file (by default, located here: \Program Files\ibm\cognos\ccr_64\server\FAP) showing the same database name and location?

Resolving The Problem

Ensure that only each FAP database is only accessed by one application server's FAP service.

[{"Product":{"code":"SS9S6B","label":"Cognos Controller"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1;10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21693576