DBMS error 14450 for Oracle when using XA functionality.

DBMS error 14450 for Oracle when using XA functionality.

book

Article ID: KB0090897

calendar_today

Updated On:

Products Versions
TIBCO InConcert -
Not Applicable -

Description

Description:
The error means: 14450, 00000, "attempt to access a transactional temp table already in use"
// *Cause:  An attempt was made to access a transactional temporary table that
//          has been already populated by a concurrent transaction of the same
//          session.
// *Action: do not attempt to access the temporary table until the
//          concurrent transaction has committed or aborted.

In XA mode your temp your tables cannot be global, otherwise you will
run into locking issues.

To fix this you must make the following changes to the TIBCO InConcert database schema:

1. Shutdown your server

2. Drop all temp tables: BINDER_ID_MAP, ROLE_ID_MAP, TASK_ID_MAP, TABLE

TMP_OBJECTS

3. Recreate temp tables using the following script:

CREATE TABLE BINDER_ID_MAP
(
    OLD_BINDER_ID   RAW(16)     NOT NULL,
    NEW_BINDER_ID   RAW(16)     NOT NULL
) CACHE;

CREATE TABLE ROLE_ID_MAP
(
    OLD_ROLE_ID   RAW(16)     NOT NULL,
    NEW_ROLE_ID   RAW(16)     NOT NULL
) CACHE;

CREATE TABLE TASK_ID_MAP
(
    OLD_TASK_ID   RAW(16)     NOT NULL,
    NEW_TASK_ID   RAW(16)     NOT NULL
) CACHE;

CREATE TABLE TMP_OBJECTS
(
    OBJECT_SET    NUMBER(5)    NOT NULL,
    OBJECT_ID    RAW(16)    NOT NULL
      SORTORDER    NUMBER(10)  NULL
) CACHE;

This will be true for anyone operating in XA mode.  If you upgrade to IC 7.2 you will need to do the same database schema change after upgrade.
Symptoms:

Cause:

Issue/Introduction

DBMS error 14450 for Oracle when using XA functionality.