Troubleshooting
Problem
User is trying to publish FAP data. This works OK. Afterwards, the customer changes their structures (e.g. creates a brand new account inside "Maintain - Account Structure - Define". User then launches the FAP Client (FAP Connect). Because the Controller structures have changed, the button "update structure" becomes active. User clicks "update structures" and the process begins. After a while (e.g. 10 minutes) this process stops with a failure. The TM1 server stops/crashes/fails at this time.
Symptom
FAP Client error:
FAP Service Scheduler Datamart operations failed
Controller Update structure Could not create TI process: Account_Sort_Order_Process No Data Source specified.
Entries inside "tm1server.log":
<...>
1452 [94] INFO 2012-03-22 12:43:01.797 TM1.Comm.SSL SSL read error. SSL Error: 5
5020 [a2] INFO 2012-03-22 13:56:25.885 TM1.Comm.SSL SSL read error. SSL Error: 5
728 [8f] INFO 2012-03-22 14:03:28.625 TM1.Comm.SSL SSL read error. SSL Error: 5
3300 [3] INFO 2012-03-22 14:04:47.594 TM1.Comm.SSL SSL read error. SSL Error: 5
2968 [a6] INFO 2012-03-22 14:06:40.783 TM1.Comm.SSL SSL read error. SSL Error: 5
4212 [] INFO 2012-03-22 14:06:53.440 TM1.Server Closing...
4212 [] INFO 2012-03-22 14:06:53.440 TM1.Server Saving...
4212 [] INFO 2012-03-22 14:06:53.440 TM1.Server The server is coming down...
4212 [] INFO 2012-03-22 14:06:53.455 TM1.Chore Deactivating chore: Check Controller Status
4212 [] INFO 2012-03-22 14:07:26.831 TM1.Server Server shutdown
3652 [] INFO 2012-03-22 14:11:14.396 TM1.Server Data Directory: d:\tm1\fap\01data
3652 [] INFO 2012-03-22 14:11:14.396 TM1.Server Admin Host: SERVERNAME
3652 [] INFO 2012-03-22 14:11:14.396 TM1.Server Logging Directory: d:\tm1\sap\03log
3652 [] INFO 2012-03-22 14:11:14.396 TM1.Server Configuration Directory: d:\tm1\fap\04cfg
3652 [] INFO 2012-03-22 14:11:14.396 TM1.Server Raw Store Directory: d:\tm1\fap\01data
<...>
Another example:
2832 [e] INFO 2012-04-24 15:50:13.373 TM1.Process Process "CompanyGroup_Process": finished executing normally, elapsed time 0.08 seconds
2832 [e] INFO 2012-04-24 15:50:23.873 TM1.Server TM1CubeImpl::ProcessFeeders: Computing feeders for base cube 'ControllerMonthlyCompanyDetails'.
2832 [e] INFO 2012-04-24 15:50:23.873 TM1.Cube.Dependency Adding cube dependency: cube "ControllerMonthlyCompanyDetails" depends on cube "}ElementAttributes_PeriodMonthly"
2832 [e] INFO 2012-04-24 15:52:29.515 TM1.Server TM1CubeImpl::ProcessFeeders: Done computing feeders for base cube 'ControllerMonthlyCompanyDetails'.
2832 [e] INFO 2012-04-24 15:52:52.234 TM1.Process Process "refreshMdxHierarchyProcess" executed by user "Admin"
2832 [e] INFO 2012-04-24 15:52:56.437 TM1.Process Process "refreshMdxHierarchyProcess": finished executing normally, elapsed time 4.20 seconds
3832 [f] INFO 2012-04-24 15:54:03.937 TM1.Comm.SSL SSL read error. SSL Error: 5
3660 [13] INFO 2012-04-24 15:57:28.251 TM1.Comm.SSL SSL read error. SSL Error: 5
3208 [] INFO 2012-04-24 15:59:27.188 TM1.Server Closing...
3208 [] INFO 2012-04-24 15:59:27.188 TM1.Server Saving...
3208 [] INFO 2012-04-24 15:59:27.188 TM1.Server The server is coming down...
2832 [e] INFO 2012-04-24 15:59:27.204 TM1.Comm.SSL SSL read error. SSL Error: 5
3208 [] INFO 2012-04-24 15:59:27.219 TM1.Chore Deactivating chore: Check Controller Status
3208 [] INFO 2012-04-24 16:00:03.376 TM1.Server Server shutdown
2756 [] INFO 2012-04-24 16:00:27.766 TM1.Server Data Directory: d:\tm1\fap\01data
2756 [] INFO 2012-04-24 16:00:27.766 TM1.Server Admin Host: SERVERNAME
Entries inside "Retry.log":
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:599)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:44)
at com.ibm.cognos.fap.service.persistence.tm1.AccountTM1$$EnhancerByCGLIB$$172c1d23.createUpdateElementsTM1Process(<generated>)
at com.ibm.cognos.fap.service.dimension.Account.updateStructure(Account.java:309)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.doUpdateStructure(DatamartTimerTask.java:704)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.run(DatamartTimerTask.java:164)
at java.util.Timer$TimerImpl.run(Timer.java:286)
Caused by: com.ibm.cognos.fap.common.exception.LoggedException: Could not create TI process: Account_Sort_Order_Process
at com.ibm.cognos.fap.service.persistence.tm1.AccountTM1.createUpdateElementsTM1Process(AccountTM1.java:331)
... 10 more
Caused by: com.ibm.cognos.tm1.TM1Exception: No Data Source specified.
at com.ibm.cognos.fap.service.persistence.tm1.AccountTM1.createUpdateElementsTM1Process(AccountTM1.java:328)
... 10 more
Error happened Tue Apr 24 15:43:18 CEST 2012.
Trial 3 failed for method createUpdateElementsTM1Process
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Cognos Controller
Software version:
10.1
Operating system(s):
Windows
Document number:
471307
Modified date:
08 May 2025
UID
swg21590091
Manage My Notification Subscriptions