book
Article ID: KB0090897
calendar_today
Updated On:
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.