Schema upgrade error from 8.1 to 8.2

Testing in our DEV environment with our PROD data. 8.0 worked fine as well as 8.1.

In upgrading the schema from 8.1 to 8.2 I received the error:

Unable to extend index TRIM.RCDATERECEIVED by 1024 in table space INDEX01.

We are running an Oracle DB

The logs are below:

/* 3:17:47 PM: */
# Dataset tool started: Friday, November 06, 2015

/* 3:17:47 PM 47: */
SELECT value FROM TSTWRSYS WHERE code = 'DBVERSION'

/* 3:17:50 PM: */
Step 1

/* 3:17:50 PM 62: */
SELECT uri FROM TSTWRSYS WHERE CODE = 'DBVERSION'

/* 3:17:51 PM 22: */
UPDATE TSTWRSYS SET VALUE = 'CORRUPT' WHERE uri = 808;

/* 3:17:51 PM 31: */
CREATE OR REPLACE FUNCTION lkupCSrch(consName IN VARCHAR2) RETURN VARCHAR2 IS sCond User_Constraints.search_condition%TYPE; BEGIN SELECT search_condition INTO sCond FROM User_Constraints WHERE constraint_name = consName; RETURN sCond; END;;

/* 3:17:51 PM 24: */
CREATE OR REPLACE FUNCTION lkupCExp(tbl_name IN VARCHAR2, idx_name IN VARCHAR2, col_pos IN NUMBER) RETURN VARCHAR2 IS colExp User_Ind_Expressions.column_expression%TYPE; i INTEGER; j INTEGER; BEGIN SELECT column_expression INTO colExp FROM User_Ind_Expressions WHERE column_position = col_pos AND index_name = idx_name AND table_name = tbl_name; i := INSTR(colExp, '"'); j := INSTR(colExp, '"', i 1)-i; RETURN SUBSTR(colExp, i 1, j); END; ;

/* 3:17:51 PM 24: */
ALTER SESSION SET recyclebin = OFF;

/* 3:17:51 PM 364: */
ALTER TABLE TSERECVSN ADD
evCheckedInBy INTEGER;

/* 3:17:51 PM 13: */
UPDATE TSERECVSN SET
evCheckedInBy = 0;

/* 3:17:51 PM 135: */
ALTER TABLE TSERECVSN MODIFY evCheckedInBy INTEGER NOT NULL;

/* 3:17:51 PM 20: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'EVCHECKEDINBY';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_evCheckedInBy';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 3:17:51 PM 48: */
CREATE INDEX evCheckedInBy ON TSERECVSN
(
evCheckedInBy ASC
)
TABLESPACE INDEX01;

/* 3:17:52 PM 55: */
ALTER TABLE TSEVENTDAT ADD
edConnectionIP VARCHAR2(40 CHAR);

/* 3:17:52 PM 37: */
ALTER TABLE TSEVENTDAT ADD
edClientIP VARCHAR2(40 CHAR);

/* 3:17:52 PM 15: */
ALTER TABLE TSEVENTDAT ADD
edAddToAuditLog CHAR(1);

/* 3:17:52 PM 24: */
UPDATE TSEVENTDAT SET
edConnectionIP = ' ',
edClientIP = ' ',
edAddToAuditLog = 'F';

/* 3:17:52 PM 35: */
ALTER TABLE TSEVENTDAT MODIFY edConnectionIP VARCHAR2(40 CHAR) NOT NULL;

/* 3:17:52 PM 20: */
ALTER TABLE TSEVENTDAT MODIFY edClientIP VARCHAR2(40 CHAR) NOT NULL;

/* 3:17:52 PM 19: */
ALTER TABLE TSEVENTDAT MODIFY edAddToAuditLog CHAR(1) NOT NULL;

/* 3:17:52 PM 35: */
ALTER TABLE TSEXFIELD ADD
exSearchClauseName VARCHAR2(50 CHAR);

/* 3:17:52 PM 19: */
UPDATE TSEXFIELD SET
exSearchClauseName = ' ';

/* 3:17:52 PM 19: */
ALTER TABLE TSEXFIELD MODIFY exSearchClauseName VARCHAR2(50 CHAR) NOT NULL;

/* 3:17:52 PM 19: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'EXSEARCHCLAUSENAME';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_exSearchClauseName';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 3:17:52 PM 29: */
CREATE INDEX exSearchClauseName ON TSEXFIELD
(
UPPER(exSearchClauseName) ASC
)
TABLESPACE INDEX01;

/* 3:17:52 PM 33: */
ALTER TABLE TSJURISDIC ADD
jdValidFrom CHAR(15);

/* 3:17:52 PM 14: */
ALTER TABLE TSJURISDIC ADD
jdValidTo CHAR(15);

/* 3:17:52 PM 6: */
UPDATE TSJURISDIC SET
jdValidFrom = ' ',
jdValidTo = '999912312359591';

/* 3:17:52 PM 18: */
ALTER TABLE TSJURISDIC MODIFY jdValidFrom CHAR(15) NOT NULL;

/* 3:17:52 PM 14: */
ALTER TABLE TSJURISDIC MODIFY jdValidTo CHAR(15) NOT NULL;

/* 3:17:52 PM 119: */
CREATE TABLE TSLOCK
(
lckProcess SMALLINT NOT NULL,
lckCounter INTEGER NOT NULL
)
TABLESPACE DATA01;

/* 3:17:52 PM 44: */
ALTER TABLE TSLOCK ADD CONSTRAINT PKTSLOCK PRIMARY KEY (lckProcess) USING INDEX TABLESPACE INDEX01;

/* 3:17:52 PM 31: */
COMMENT ON TABLE TSLOCK IS 'The Lock table is used to support the creation of long-lived locks for serializing event processes (and possibly other items of work needing serialization)';

/* 3:17:53 PM 30: */
ALTER TABLE TSLOCLOGIN ADD
llAltLogsInAs VARCHAR2(255 CHAR);

/* 3:17:53 PM 20: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'LLALTLOGSINAS';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_llAltLogsInAs';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 3:17:53 PM 21: */
CREATE UNIQUE INDEX llAltLogsInAs ON TSLOCLOGIN
(
UPPER(llAltLogsInAs) ASC
)
TABLESPACE INDEX01;

/* 3:17:53 PM 138: */
DROP INDEX lmDisplayName;

/* 3:17:53 PM 34: */
ALTER TABLE TSONLINEAU ADD
oaConnectionIP VARCHAR2(40 CHAR);

/* 3:17:53 PM 18: */
ALTER TABLE TSONLINEAU ADD
oaClientIP VARCHAR2(40 CHAR);

/* 3:52:57 PM2103988: */
UPDATE TSONLINEAU SET
oaConnectionIP = ' ',
oaClientIP = ' ';

/* 4:00:29 PM 451962: */
ALTER TABLE TSONLINEAU MODIFY oaConnectionIP VARCHAR2(40 CHAR) NOT NULL;

/* 4:01:58 PM 89566: */
ALTER TABLE TSONLINEAU MODIFY oaClientIP VARCHAR2(40 CHAR) NOT NULL;

/* 4:01:59 PM 143: */
ALTER TABLE TSRECACTST ADD
raAssignedBy INTEGER;

/* 4:01:59 PM 21: */
ALTER TABLE TSRECACTST ADD
raActionName VARCHAR2(100 CHAR);

/* 4:01:59 PM 54: */
UPDATE TSRECACTST SET
raAssignedBy = 0,
raActionName = ' ';

/* 4:01:59 PM 24: */
ALTER TABLE TSRECACTST MODIFY raAssignedBy INTEGER NOT NULL;

/* 4:01:59 PM 21: */
ALTER TABLE TSRECACTST MODIFY raActionName VARCHAR2(100 CHAR) NOT NULL;

/* 4:01:59 PM 41: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RAASSIGNEDBY';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_raAssignedBy';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:01:59 PM 82: */
CREATE INDEX raAssignedBy ON TSRECACTST
(
raAssignedBy ASC
)
TABLESPACE INDEX01;

/* 4:01:59 PM 19: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RAACTIONNAME';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_raActionName';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:01:59 PM 76: */
CREATE INDEX raActionName ON TSRECACTST
(
UPPER(raActionName) ASC
)
TABLESPACE INDEX01;

/* 4:01:59 PM 42: */
ALTER TABLE TSRECELEC ADD
reCheckedInBy INTEGER;

/* 4:12:18 PM 618509: */
UPDATE TSRECELEC SET
reCheckedInBy = 0;

/* 4:13:49 PM 91328: */
ALTER TABLE TSRECELEC MODIFY reCheckedInBy INTEGER NOT NULL;

/* 4:13:49 PM 28: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RECHECKEDINBY';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_reCheckedInBy';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:14:24 PM 35105: */
CREATE INDEX reCheckedInBy ON TSRECELEC
(
reCheckedInBy ASC
)
TABLESPACE INDEX01;

/* 4:14:25 PM 76: */
DROP INDEX rkRecUri1;

/* 4:14:25 PM 27: */
DECLARE x INTEGER := 0;
BEGIN
SELECT COUNT(*) INTO x FROM User_Indexes WHERE table_name = 'TSRECLINK' AND index_name = 'U_RKRECURI1';
IF x > 0 THEN
EXECUTE IMMEDIATE 'DROP INDEX 'U_RKRECURI1';
END IF;
END;;

/* 4:14:25 PM 20: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RKRECURI1';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rkRecUri1';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:14:25 PM 96: */
CREATE INDEX rkRecUri1 ON TSRECLINK
(
rkRecUri1 ASC,
rkLinkType ASC,
linkNumber ASC
)
TABLESPACE INDEX01;

/* 4:14:25 PM 33: */
DROP INDEX rkRecUri2;

/* 4:14:25 PM 0: */
DECLARE x INTEGER := 0;
BEGIN
SELECT COUNT(*) INTO x FROM User_Indexes WHERE table_name = 'TSRECLINK' AND index_name = 'U_RKRECURI2';
IF x > 0 THEN
EXECUTE IMMEDIATE 'DROP INDEX 'U_RKRECURI2';
END IF;
END;;

/* 4:14:25 PM 19: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RKRECURI2';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rkRecUri2';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:14:25 PM 81: */
CREATE INDEX rkRecUri2 ON TSRECLINK
(
rkRecUri2 ASC,
rkLinkType ASC,
linkNumber ASC
)
TABLESPACE INDEX01;

/* 4:14:25 PM 55: */
DROP INDEX rlLocUri;

/* 4:14:25 PM 0: */
DECLARE x INTEGER := 0;
BEGIN
SELECT COUNT(*) INTO x FROM User_Indexes WHERE table_name = 'TSRECLOC' AND index_name = 'U_RLLOCURI';
IF x > 0 THEN
EXECUTE IMMEDIATE 'DROP INDEX 'U_RLLOCURI';
END IF;
END;;

/* 4:14:25 PM 19: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RLLOCURI';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rlLocUri';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:17:45 PM 199447: */
CREATE INDEX rlLocUri ON TSRECLOC
(
rlLocUri ASC,
rlLocType ASC,
rlRecUri ASC
)
TABLESPACE INDEX01;

/* 4:17:45 PM 51: */
DROP INDEX rlReviewDateTime;

/* 4:17:45 PM 0: */
DECLARE x INTEGER := 0;
BEGIN
SELECT COUNT(*) INTO x FROM User_Indexes WHERE table_name = 'TSRECLOC' AND index_name = 'U_RLREVIEWDATETIME';
IF x > 0 THEN
EXECUTE IMMEDIATE 'DROP INDEX 'U_RLREVIEWDATETIME';
END IF;
END;;

/* 4:17:45 PM 21: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RLREVIEWDATETIME';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rlReviewDateTime';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:21:09 PM 203954: */
CREATE INDEX rlReviewDateTime ON TSRECLOC
(
rlReviewDateTime ASC,
rlRecUri ASC
)
TABLESPACE INDEX01;

/* 4:21:09 PM 87: */
DROP INDEX rlSpaceUri;

/* 4:21:09 PM 0: */
DECLARE x INTEGER := 0;
BEGIN
SELECT COUNT(*) INTO x FROM User_Indexes WHERE table_name = 'TSRECLOC' AND index_name = 'U_RLSPACEURI';
IF x > 0 THEN
EXECUTE IMMEDIATE 'DROP INDEX 'U_RLSPACEURI';
END IF;
END;;

/* 4:21:09 PM 33: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RLSPACEURI';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rlSpaceUri';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:23:47 PM 157796: */
CREATE INDEX rlSpaceUri ON TSRECLOC
(
rlSpaceUri ASC,
rlRecUri ASC
)
TABLESPACE INDEX01;

/* 4:23:47 PM 109: */
ALTER TABLE TSRECORD ADD
rcDateSuperseded CHAR(15);

/* 4:23:47 PM 47: */
ALTER TABLE TSRECORD ADD
rcDateReceived CHAR(15);

/* 4:41:16 PM1048464: */
UPDATE TSRECORD SET
rcDateSuperseded = ' ',
rcDateReceived = ' ';

/* 4:50:24 PM 548480: */
ALTER TABLE TSRECORD MODIFY rcDateSuperseded CHAR(15) NOT NULL;

/* 4:52:07 PM 103232: */
ALTER TABLE TSRECORD MODIFY rcDateReceived CHAR(15) NOT NULL;

/* 4:52:08 PM 34: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'SYSLASTUPDATED';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_sysLastUpdated';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:53:42 PM 94069: */
CREATE INDEX sysLastUpdated ON TSRECORD
(
sysLastUpdated ASC
)
TABLESPACE INDEX01;

/* 4:53:42 PM 23: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RCDATESUPERSEDED';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rcDateSuperseded';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:54:59 PM 77468: */
CREATE INDEX rcDateSuperseded ON TSRECORD
(
rcDateSuperseded ASC
)
TABLESPACE INDEX01;

/* 4:54:59 PM 19: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'RCDATERECEIVED';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_rcDateReceived';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:56:15 PM 76216: */
CREATE INDEX rcDateReceived ON TSRECORD
(
rcDateReceived ASC
)
TABLESPACE INDEX01;

/* 4:56:16 PM 166: */
ALTER TABLE TSRECTYPE ADD
rtAuditBreaches CHAR(1);

/* 4:56:16 PM 62: */
UPDATE TSRECTYPE SET
rtAuditBreaches = 'F';

/* 4:56:16 PM 49: */
ALTER TABLE TSRECTYPE MODIFY rtAuditBreaches CHAR(1) NOT NULL;

/* 4:56:16 PM 93: */
ALTER TABLE TSSCHEDUL ADD
schSuppressIndex CHAR(1);

/* 4:56:16 PM 13: */
UPDATE TSSCHEDUL SET
schSuppressIndex = 'F';

/* 4:56:16 PM 20: */
ALTER TABLE TSSCHEDUL MODIFY schSuppressIndex CHAR(1) NOT NULL;

/* 4:56:16 PM 64: */
ALTER TABLE TSWKACTIVI ADD
wacAssignedBy INTEGER;

/* 4:56:16 PM 20: */
UPDATE TSWKACTIVI SET
wacAssignedBy = 0;

/* 4:56:16 PM 29: */
ALTER TABLE TSWKACTIVI MODIFY wacAssignedBy INTEGER NOT NULL;

/* 4:56:16 PM 20: */
DECLARE x User_Objects.Object_Type%TYPE;
BEGIN
SELECT object_type INTO x FROM User_Objects WHERE object_name = 'WACASSIGNEDBY';
IF x > 0 THEN
EXECUTE IMMEDIATE 'ALTER ' || x || ' RENAME TO x_wacAssignedBy';
END IF;
EXCEPTION WHEN OTHERS THEN NULL;
END;;

/* 4:56:16 PM 52: */
CREATE INDEX wacAssignedBy ON TSWKACTIVI
(
wacAssignedBy ASC
)
TABLESPACE INDEX01;

/* 4:56:17 PM 405: */
SELECT index_name FROM User_Ind_Columns WHERE
table_name = 'TSWKDOCUME'
AND column_name = 'WDCTITLE'

/* 4:56:17 PM 7: */
UPDATE TSWKDOCUME SET wdcTitle = ' ' WHERE wdcTitle IS NULL;

/* 4:56:17 PM 92: */
ALTER TABLE TSWKDOCUME MODIFY wdcTitle VARCHAR2(512 CHAR);

/* 4:56:17 PM 14: */
UPDATE TSWKDOCUME SET wdcTitle = ' ' WHERE LENGTH(wdcTitle) = 0 OR wdcTitle IS NULL;

/* 4:56:17 PM 4: */
UPDATE TSWKDOCUME SET wdcTitle = RTRIM ( wdcTitle ) WHERE LENGTH ( RTRIM ( wdcTitle ) ) > 0;

/* 4:56:17 PM 43: */
ALTER TABLE TSWKDOCUME MODIFY wdcTitle VARCHAR2(512 CHAR) NOT NULL;

/* 4:56:17 PM5906806: */
Step 1 Completed

/* 4:56:17 PM: */
Step 2

/* 4:56:17 PM 78: */
SELECT value FROM TSTWRSYS WHERE code = 'PRP_7454'

/* 4:56:17 PM 5: */
DELETE FROM TSTWRSYS WHERE code = 'PRP_7454';

/* 4:56:17 PM 94: */
SELECT MAX(uri) FROM TSNOTES3

/* 4:56:18 PM 26: */
DELETE FROM TSNOTES3 WHERE n3TableUri = 7454 AND n3TableId = 38;

/* 4:56:18 PM 47: */
SELECT value FROM TSTWRSYS WHERE code = 'PRP_7455'

/* 4:56:18 PM 4: */
DELETE FROM TSTWRSYS WHERE code = 'PRP_7455';

/* 4:56:18 PM 33: */
DELETE FROM TSNOTES3 WHERE n3TableUri = 7455 AND n3TableId = 38;

/* 4:56:18 PM 63: */
SELECT value FROM TSTWRSYS WHERE code = 'PRP_7456'

/* 4:56:18 PM 4: */
DELETE FROM TSTWRSYS WHERE code = 'PRP_7456';

/* 4:56:18 PM 5: */
DELETE FROM TSNOTES3 WHERE n3TableUri = 7456 AND n3TableId = 38;

/* 4:56:18 PM 78: */
SELECT value FROM TSTWRSYS WHERE code = 'PRP_694'

/* 4:56:18 PM 4: */
DELETE FROM TSTWRSYS WHERE code = 'PRP_694';

/* 4:56:18 PM 23: */
DELETE FROM TSNOTES3 WHERE n3TableUri = 694 AND n3TableId = 38;

/* 4:56:18 PM 78: */
SELECT value FROM TSTWRSYS WHERE code = 'PRP_7457'

/* 4:56:18 PM 4: */
DELETE FROM TSTWRSYS WHERE code = 'PRP_7457';

/* 4:56:18 PM 4: */
DELETE FROM TSNOTES3 WHERE n3TableUri = 7457 AND n3TableId = 38;

/* 4:56:18 PM 94: */
SELECT DISTINCT luUserType, luFunction1, luFunction2, luFunction3, luFunction4, luFunction5 FROM TSLOCUSAGE WHERE uri > 0

/* 4:56:19 PM 8: */
UPDATE TSLOCUSAGE SET luUserType = 0, luFunction1 = 0, luFunction2 = 0, luFunction3 = 0, luFunction4 = 0, luFunction5 = 0 WHERE uri > 0 AND luUserType = 0 AND luFunction1 = 0 AND luFunction2 = 0 AND luFunction3 = 0 AND luFunction4 = 2048 AND luFunction5 = 0;

/* 4:56:19 PM 6: */
UPDATE TSLOCUSAGE SET luUserType = 1, luFunction1 = -503311709, luFunction2 = -872423424, luFunction3 = 10225, luFunction4 = 0, luFunction5 = 0 WHERE uri > 0 AND luUserType = 6 AND luFunction1 = -503311709 AND luFunction2 = -872423424 AND luFunction3 = 12273 AND luFunction4 = 0 AND luFunction5 = 0;

/* 4:56:19 PM 6: */
UPDATE TSLOCUSAGE SET luUserType = 1, luFunction1 = -486510429, luFunction2 = -872423424, luFunction3 = 2032, luFunction4 = 0, luFunction5 = 0 WHERE uri > 0 AND luUserType = 6 AND luFunction1 = -486510429 AND luFunction2 = -872423424 AND luFunction3 = 2032 AND luFunction4 = 0 AND luFunction5 = 0;

/* 4:56:19 PM 63: */
SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'UPM_CVT'

/* 4:56:19 PM 62: */
SELECT MAX(uri) FROM TSTWRSYS

/* 4:56:19 PM 31: */
INSERT INTO TSTWRSYS (uri,code,value) VALUES (3326, 'UPM_CVT', '1');

/* 4:56:19 PM 78: */
SELECT uri, fdPropertyId, fdExStyle FROM TSFORMDEF WHERE fdPropertyId > 0

/* 4:56:19 PM 19: */
UPDATE TSRECTYPE SET rtAuditBreaches = 'T';

/* 4:56:19 PM 129: */
UPDATE TSRECORD SET rcDateSuperseded = lastActionDateTime WHERE EXISTS ( SELECT 1 FROM TSRECLINK WHERE rkRecUri1 = TSRECORD.uri AND rkLinkType = 4);

/* 4:56:19 PM 79: */
UPDATE TSRECORD SET rcDateSuperseded = ( SELECT MAX(udvFieldVal) FROM TSUDFDATEV WHERE udvObjectType = 6 AND udvObjectUri = TSRECORD.URI AND udvFieldUri IN ( SELECT URI FROM TSEXFIELD WHERE exFieldName = 'DATE SUPERSEDED') ) WHERE EXISTS ( SELECT 1 FROM TSEXFIELD WHERE exFieldName = 'DATE SUPERSEDED' ) AND EXISTS ( SELECT 1 FROM TSUDFDATEV WHERE udvObjectType = 6 AND udvObjectUri = TSRECORD.URI AND udvFieldUri IN ( SELECT URI FROM TSEXFIELD WHERE exFieldName = 'DATE SUPERSEDED') ) AND EXISTS ( SELECT 1 FROM TSRECLINK WHERE rkRecUri1 = TSRECORD.uri AND rkLinkType = 4 );

/* 5:31:16 PM2096133: */
UPDATE TSRECORD SET rcDateReceived = regDateTime;

/* 5:31:16 PM2096135: */
SQL Failed: Error executing SQL statement: ORA-01654: unable to extend index TRIM.RCDATERECEIVED by 1024 in tablespace INDEX01
Details: Extended SQL Error Information:
Number = 0x80040e14
Source = OraOLEDB
Description = ORA-01654: unable to extend index TRIM.RCDATERECEIVED by 1024 in tablespace INDEX01
SQLState =
NativeError = 1654
SQL command: UPDATE TSRECORD SET rcDateReceived = regDateTime

/* 5:31:16 PM2098369: */
Step 2 Completed

Thanks in advance!

Ralph