Troubleshooting
Problem
User clicks "Maintain – User – User Roles". User clicks the '+' (plus) button. An error appears.
Symptom
Something unexpected happened. You may have to restart the application to continue.
Reason:
[FatalException] Could not execute command
Com.ibm.cognos.ccr.core.ui.commands.NewItem
Details:
[FatalException] Could not execute command com.ibm.cognos.ccr.core.ui.commands.NewItem
Could not execute command com.ibm.cognos.ccr.core.ui.commands.NewItem
Caused by InjectionException: com.ibm.cognos.ccr.common.EntityIdGenerationException: Could not generate id for EntityType: Role
Caused by EntityIdGenerationException: Could not generate id for EntityType: Role
Caused by WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http :// servername/ibmcognos/controllerserver/CCRWS.asmx, passport=MTswMTA6MDQ2ZWViNTUtZjM3Ni1lZjQxLWRiODAtOGIwY2UzYzg2NGY3OjE5NzU0NjM3ODg7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=idGenerator, methodName=nextId, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@573ee167])]
Caused by ResponseException: FAIL:com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction
--- stack trace ---
com.ibm.cognos.ccr.common.FatalException: Could not execute command com.ibm.cognos.ccr.core.ui.commands.NewItem
at com.ibm.cognos.ccr.core.ui.util.WorkbenchUtil.internalRunCommand(Unknown Source)
<....>
at java.lang.Thread.run(Thread.java:798)
Caused by: org.eclipse.e4.core.di.InjectionException: com.ibm.cognos.ccr.common.EntityIdGenerationException: Could not generate id for EntityType: Role
at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:68)
<....>
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.EntityIdGenerationException: Could not generate id for EntityType: Role
at com.ibm.cognos.ccr.ccrws.persistence.RemoteEntityIdGenerator.nextId(Unknown Source)
<....>
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.WebServiceConnectionException: exceptionId=ERR.ANY.WEBSERVICECONNECTIONEXCEPTION.SERVICE_FAILED, argument(s)=[url=http: // servername/ibmcognos/controllerserver/CCRWS.asmx, passport=MTswMTA6MDQ2ZWViNTUtZjM3Ni1lZjQxLWRiODAtOGIwY2UzYzg2NGY3OjE5NzU0NjM3ODg7MDszOzA7, request=executeTask(com.ibm.cognos.ccr.common.ws.ServerTask: beanID=idGenerator, methodName=nextId, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@573ee167])]
at com.ibm.cognos.ccr.ccrws.JAXWSClient.processResponse(Unknown Source)
<....>
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
at java.lang.Thread.run(Thread.java:798)
Caused by: com.ibm.cognos.ccr.common.ResponseException: FAIL:com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction
at com.ibm.cognos.ccr.common.WebServiceConnectionException.<init>(Unknown Source)
<....>
at com.ibm.cognos.ccr.integration.IntegrationServiceAdapter$MyEclipseStarter.run(IntegrationServiceAdapter.java:167)
at java.lang.Thread.run(Thread.java:798)
ccr.log:
09:01:56,894 ERROR [cognos.ccr.integration.ServerIntegrationFacade] Failed when invoking operation: com.ibm.cognos.ccr.integration.ExecuteTaskCallable@c8a34659/com.ibm.cognos.ccr.common.ws.ServerTask: beanID=idGenerator, methodName=nextId, args.length=1, args=[com.ibm.cognos.ccr.common.ws.ServerTask$InstanceData@ab2a521e]
com.ibm.cognos.ccr.common.SQLRollbackException: Failed to rollback transaction
at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
at java.lang.reflect.Method.invoke(Method.java:620)
at com.ibm.cognos.ccr.common.ws.ServerTask.execute(ServerTask.java:87)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:57)
at com.ibm.cognos.ccr.integration.ExecuteTaskCallable.call(ExecuteTaskCallable.java:32)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.execute(ServerIntegrationFacade.java:240)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTaskWithoutExceptionHandling(ServerIntegrationFacade.java:130)
at com.ibm.cognos.ccr.integration.ServerIntegrationFacade.executeTask(ServerIntegrationFacade.java:113)
Caused by:
java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2360)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2407)
at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:301)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:200)
at com.ibm.cognos.ccr.common.persistence.SQLEntityIdGenerator.nextId(SQLEntityIdGenerator.java:83)
... 10 more
09:01:56,925 INFO [cognos.ccr.i
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3","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
Modified date:
08 May 2025
UID
swg22000945