Troubleshooting
Problem
User launches Controller Web. User successfully chooses a database, and logs on.
User selects one of the projects. An error appears.
If the user clicks OK to the error, then they can proceed. However, as they use Controller Web (opening other objects/menus) similar errors appear.
Symptom
Screen:
Internal Server Error
URL: http://servername:9081/fcm.web/api/consolidation/history/job STATUS: 500
Unexpected exception
Log entry: server=<sqlservername>, NDC=ADM@<databasename>, Time=19-06-18 15:35.13
For more details, please use the button below.
Show details
Failed URL: /fcm.web/api/consolidation/history/jobException: Unexpected exception
Log file ("com.ibm.cognos.fcm.log") on the Controller application server:
2019-07-17 17:01:46 | | ERROR | [com.ibm.cognos.fcm.wmc.ccrws.system.SystemPollerDaemon] PollingDaemon[status-updater-client]-55 encountered a problem. Running again after 30000 ms.
com.ibm.cognos.fcm.wmc.ccrws.ServerEndpointException: Cannot retrieve any status updates: Exception occured on data source connection: D:\Program Files\ibm\cognos\ccr_64\Data\databasename.Udl with message: System.Data.OleDb.OleDbException (0x80040E07): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at ControllerServerCommon.Utility.ReadFromDataBase(String udlPath, String selectStatement, Int32 commandTimeout)
at FrStatusB.RealTimeStatusUpdatesWeb.GetReportingAndFormStatusData(String udlPath, WebDataSource dataSourceItem, List`1 contextList, String[] companyCodes, DateTime timeStampDate)
at FrStatusB.RealTimeStatusUpdatesWeb.GetStatusUpdatesList(String udlPath, WebDataSource dataSourceItem, List`1 contextList, DateTime timeStampDate)
at FrStatusB.RealTimeStatusUpdatesWeb.GetResponseStatusUpdatesWebContentItem(String udlPath, WebDataSource dataSourceItem, List`1 contextList, DateTime timeStampDate)
at FrStatusB.RealTimeStatusUpdatesWeb._Closure$__4-0._Lambda$__0(String udlPath)
Document Location
Worldwide
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.0","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.4.0
Operating system(s):
Windows
Document number:
960003
Modified date:
09 May 2025
UID
ibm10960003
Manage My Notification Subscriptions