kvmw2130
VMware Employee
VMware Employee

Hello,

I think you might be using a custom database schema instead of dbo.

App Volume 2.18 installer looks for table with dbo schema during upgrade.

* Revert back to working 2.14/2.16.

* Take a valid back of DB and snapshot of all app vol servers.

* Open SQL Management studio and right click on app volume DB and run below query:

Query to transfer the schema structure: alter schema <newschema> transfer tablename.

* In order to update all of the table's schema run below query:

SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name

FROM sys.Objects o

INNER JOIN sys.Schemas s on o.schema_id = s.schema_id

WHERE s.Name = '<inputyourcurrentschemaname>'

And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')

* Above query lists all the table with the query. All we need to do is copy the queries and paste it on new query window and execute it.

Note: This is disruptive action. Please ensure we have a valid back up of DB.

* Once all the schama of tables are updated you may run the upgrade of app volume to 2.18.

View solution in original post