Error on upgrading to FSIF 7.31
Error occurs after upgrading to Pega Foundation for Financial Services (FSIF) 7.31.
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
Steps to Reproduce
Upgrade from FSIF 7.21.1 to FSIF 7.31.
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.
ResolutionPerform 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
0% found this useful