EGL9.2: When Running Change Assistant To Apply A Fix User Receives Error On Altering Tables
(Doc ID 2114254.1)
Last updated on APRIL 08, 2019
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and laterInformation 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |