- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.