issue facing during Appian primary database migration from oracle to PostgreSQL

Question

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

csteward · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO