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
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