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.
Discussion posts and replies are publicly visible
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.