OBIA 11g Extender for BIAPPS fails with error: ODI-10207: Uncategorized exception during transaction system usage. Transaction rolled back because transaction was set to RollbackOnly. (Doc ID 1965147.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

In OBIA 11.1.1.8.1, while updating the Balancing Segment according to the following document:
OBIA Configuration Guide 11.1.1.8.1 > section B.2.100.1 Configuring GL Segment and GL Account Dimensions

ODI extension is failing at steps 7 - 9

The following error occurs during ODI extension -

[2015-01-15T11:08:29.958+00:00] [OracleBIServerComponent] [INCIDENT_ERROR:1] [] [] [ecid: ] [tid: 1430] oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage. [[
Transaction rolled back because transaction was set to RollbackOnly.
]]
[2015-01-15T11:08:29.959+00:00] [OracleBIServerComponent] [INCIDENT_ERROR:1] [] [] [ecid: ] [tid: 1430] oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage. [[
Transaction rolled back because transaction was set to RollbackOnly.
at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.translateSpringTransactionException(TransactionManagerSpringAdapter.java:273)
at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.commit(TransactionManagerSpringAdapter.java:70)
at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:112)

 

These errors are seen in the OBIEE Administration Tool log

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms