unable to migrate the report portal to new schema 'reportportal_dev'

[santhoskumara]

our postgres env doesn't have the public schema for security reason so we are migrating the report portal into a new schema 'reportportal_dev' in our postgres server,

We have migrated all the tables using migrations scripts into our new schema.

I verified the table integration_type is present in the schema reportportal_dev.

While start the service-api-5.3.3.jar using start up scripts..
We are getting the Postgres sql exception as 'public.integration_type' does not exist.

So I verified the IntegrationType entity, where schema is defined as 'public' in the table annotation.

In the startup scripts we have overridden the property 'rp.jdbc.url' by specified the host, port user & password appended with current_schema=reportportal_dev.

Also I have added the spring.jpa.properties.hibernate.default_schema=reportportal_dev as a java args in the start up scripts.

but issue not resolved.

Could you help us to provide placeholder in the property/yaml file to override the default schema..

[santhoskumara]

HI I am waiting for the response, could you please update.