About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Troubleshooting
Problem
User launches the 'main' Controller client. User imports structures. An error appears.
Afterwards, user launches Controller Web. User tries to open a company. An error appears.
Symptom
Error importing structures:
Import started at: 11/19/2018 3:52:52 PM
Import was completed at: 11/19/2018 3:55:47 PM
The following items was imported
Accounts/Forms: 49311 Records imported
Form Sets: 174 Records imported
Submissions: 772 Records imported
FAIL:com.ibm.cognos.ccr.common.InvalidDataException: Unable to create entity for dto: com.ibm.cognos.ccr.configproperty.internal.ConfigPropertyDTO@b739ab46/id=47, type=null, seqNo=0: ccr.property.currency.base/CONFIG/USD
Actualities: 16 Records imported
Journal Types: 105 Records imported
Automatic Journal Types: 82 Records imported
General Configuration: 186 Records imported
Control Tables - Acquisition Calculations: 2286 Records imported
Control Tables - Intercompany Balances: 152 Records imported
Control Tables - Intercompany Profit: 1 Records imported
Rights: 320 Records imported
Linked Structures: 449 Records imported
Company Structure: 874 Records imported
Dim 1: 18 Records imported
Dim 2: 14 Records imported
Dim 3: 14 Records imported
Dim 4: 22 Records imported
Reports: 3925 Records imported
Report Books: 18 Records imported
Currency Rates: 564 Records imported
Currency Codes: 7 Records imported
Workflow: 167 Records imported
Import Specifications: 861 Records imported
Country or Region Codes: 529 Records imported
Lookup Tables: 24754 Records imported
Allocation Definitions: 0 Records imported
User-defined Business Rules: 0 Records imported
Subsets: 0 Records imported
User Roles: 0 Records imported
Error in Controller Web:
Internal Server Error
URL: http://<servername>:9080/fcm.web/api/reconcile/ STATUS: 500
More than one result was returned from Query.getSingleResult()
Log entry: server=localhost, NDC=<USERNAME>@<databasename>, Time=18-11-19 16:08.07
For more details, please use the button below.
Hide details
Failed URL: http://localhost:9080/fcm.web/api/reconcile/
Exception: More than one result was returned from Query.getSingleResult()
org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:980) org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:529) org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3.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"}}]
Log InLog in 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 Log in button above to access the full document. 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.3.1
Operating system(s):
Windows
Document number:
788039
Modified date:
09 May 2025
UID
ibm10788039
Manage My Notification Subscriptions