IBM Support

"FAIL:com.ibm.cognos.ccr.common.InvalidDataException: Unable to create entity for" error importing structures (in main), then "STATUS: 500 More than one result was returned from Query.getSingleResult()" error trying to open company in Controller Web

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:

image-20181212155614-1

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.

Document Information

Modified date:
09 May 2025

UID

ibm10788039

Page Feedback