EGL9.2: When Running Change Assistant To Apply A Fix User Receives Error On Altering Tables (Doc ID 2114254.1)

Last updated on MARCH 08, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, People Tools 8.53

Error in Change Assistant when Altering Tables for <Bug 19915763>


ERROR
-----------------------
USE FSDEV
SET IMPLICIT_TRANSACTIONS ON
ALTER TABLE PS_JRNL_LN ADD TAS_GWA VARCHAR(26) NULL
ALTER TABLE PS_JRNL_LN ADD BETC_CD VARCHAR(8) NULL
ALTER TABLE PS_JRNL_LN ADD JRNL_LINE_ORIG_SRC VARCHAR(3) NULL
UPDATE PS_JRNL_LN SET TAS_GWA = ' ', BETC_CD = ' ', JRNL_LINE_ORIG_SRC
 = ' '
(66127393 rows affected)
ALTER TABLE PS_JRNL_LN ALTER COLUMN TAS_GWA VARCHAR(26) NOT NULL
Msg 9002, Level 17, State 4, Server F-PS-SQL-DEV-1, Line 1
The transaction log for database 'FSDEV' is full due to
'ACTIVE_TRANSACTION'.
The statement has been terminated.
ALTER TABLE PS_JRNL_LN ALTER COLUMN BETC_CD VARCHAR(8) NOT NULL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Altering Tables in Change Assistant


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