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