Support Article
Error on upgrading to FSIF 7.31
Summary
Error occurs after upgrading to Pega Foundation for Financial Services (FSIF) 7.31.
Error Messages
ERROR:
Error starting at line : 187 in command -
ALTER TABLE PEGASRLF_DATA.REQ_LINK MODIFY "PXCREATEOPERATOR" CLOB
Error report -
SQL Error: ORA-22858: invalid alteration of datatype
22858. 00000 - "invalid alteration of datatype"
*Cause: An attempt was made to modify the column type to object, REF,
nested table, VARRAY or LOB type.
*Action: Create a new column of the desired type and copy the current
column data to the new type using the appropriate type
constructor.
Steps to Reproduce
Upgrade from FSIF 7.21.1 to FSIF 7.31.
Root Cause
The Drop script for the PEGASRLF_DATA.REQ_LINK table was missing in the media, and as the table already existed, the table columns were altered.
Resolution
Perform the below local-change to resolve the issue:1. Drop the table
2. Reimport the JAR file
3. Download the SQL scripts
4. Run the SQL scripts manually by connecting to the database
5. Continue with the Import wizard
Tags:
Published September 21, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.