TriniDBA

Problem: While running patch 6241631, the following error occurs:

FAILED: file icxwtab.odf  on worker  1.

Attempted to run ICXDLTMP.SQL, but it gave an error:

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1;

TRANSACTION_ID   COUNT(*)
-------------- ----------
    2119244000          2

select rowid, creation_date, transaction_id, session_id
from icx_transactions
where transaction_id='2119244000';

delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';

Solution: There is a duplicate transaction_id in the icx.icx_transactions.

SELECT TRANSACTION_ID, count(*)
FROM ICX.ICX_TRANSACTIONS
GROUP BY TRANSACTION_ID
HAVING count(*)>1;

TRANSACTION_ID   COUNT(*)
-------------- ----------
    2119244000          2

select rowid, creation_date, transaction_id, session_id
from icx_transactions
where transaction_id='2119244000';

delete from icx_transactions where rowid = 'AAA74DAAjAAAe7dAAq';