issue facing during Appian primary database migration from oracle to PostgreSQL

our current appian primary database is on oracle which we are migrating to PostgreSQL we are using GCP DMS for migration from oracle to PostgreSQL after migration we found few column which is as  BLOB in oracle is migrated as bytea in postgresql no when we are starting tomcat we are getting error 

org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [edit_events] in table [app_edit_history]; found [bytea (Types#BINARY)], but expecting [oid (Types#BLOB)]

is any one faced this issue please help with resolution

  Discussion posts and replies are publicly visible

Parents
  • Does the environment load regardless of the error?  What is the field type in the XSD currently?

    Either way, sounds like you will need an update to your data type to support the migration.  If the environment loads and connects to the database, one thing you can do is create a 'temp' CDT where you allow Appian to create the CDT based off the new table.  Take the field definitions from the temp CDT for any that need changing and apply them to your primary CDT.

    Related documentation on Field Types

Reply
  • Does the environment load regardless of the error?  What is the field type in the XSD currently?

    Either way, sounds like you will need an update to your data type to support the migration.  If the environment loads and connects to the database, one thing you can do is create a 'temp' CDT where you allow Appian to create the CDT based off the new table.  Take the field definitions from the temp CDT for any that need changing and apply them to your primary CDT.

    Related documentation on Field Types

Children
No Data