Appian is throwing error: caused by:liquibase .exception.MigrationFaildException:Migration failed for change set db-changelog-000242-liquibase-quartz-init.xml (QRTZ_LOCKS table is already present.)

Question

Appian is throwing error while statrting the application, by saying QRTZ_LOCKS table is already present.
Few points about the environment are below 
1. It is new Appain additional server(like UAT2 or SIT2), this is the first time we are trying to start the instance.
2. The  db schema(oarcle DB) was copied from lower environment(i.e. i contains all the tables Business and meta data. as same schema has been used for both)
3.We cannot drop/rename  the QRTZ_LOCKS table, due to some internal reason.
Can we skip this table creation part by anyhow? Where can i get the complete list of appian meta data tables?
Kindly help me to resolve this issue.

mathieud0001 · Answer

So you setup a new Appian instance and pointed it to the copy of the metadata DB from that lower environment?

Don't think that would work.

Either you setup new instance (with new metadata DB) + business data from lower env or if you plan on copying metadata db, you'll have to copy the actual server files from that Appian instance.

Sign up

Login with SSO

Login to the community

Login with SSO