DWP 3.5 - Invalid column name 'scope'
Jan 22, 2018 4:12 AM
Jan 22, 2018 4:12 AM
-
1. Re: DWP 3.5 - Invalid column name 'scope'
Hugh Fairfield
Jan 23, 2018 6:04 PM
2 of 2 people found this helpfulHi Marek,
One thing to check is that in the AR_SYSTEM_TENANT table in the system database has the DB_ADMIN_User and DB_ADMIN_Password. In 3.3 this wasn't a required field and in 3.4+ it is a required field. It specifies the database user/password for the tenant database. If it is empty, then the database upgrade utility can't connect to the tenant database. If this is the case, the quickest resolution is to roll back to the 3.3 system database and file system. Fill in those values to something valid and re-try the upgrade.
thx!
Hugh
-
2. Re: DWP 3.5 - Invalid column name 'scope'
Marek Ceizel
Jan 24, 2018 6:06 PM
Hi Hugh,
Unfortunatelly my colleagues were faster and did a new SB 3.5 installation. However I'm pretty sure we were not able to make a rollback to 3.3 (no backup). Fortunatelly this is our Test/Play system.
Anyway, thanks a lot.
Marek
-
3. Re: DWP 3.5 - Invalid column name 'scope'
Hugh Fairfield
Jan 24, 2018 6:10 PM
That is too bad. We just found this issue on an internal system and created this KA:
In case you run into this in the future.
Cheers,
Hugh
-
4. Re: DWP 3.5 - Invalid column name 'scope'
Marek Ceizel
Jan 24, 2018 6:43 PM
Hi Hugh,
No problem. However I don't see there the error message which I mentioned.
Did you get something with scope in some log ?
Otherwise it could be something different....
thanks a lot
Marek
-
5. Re: DWP 3.5 - Invalid column name 'scope'
Hugh Fairfield
Jan 24, 2018 6:54 PM
2 of 2 people found this helpfulHi Marek,
The error that is in the KA is what is seen in the upgrade logs. The scope field is in the system database, but not in the tenant database, so when a query against the tenant is run, it hits this error. I compared the databases for the system we had the issue and it was missing the scope field in the tenant database (same as your system). I'm confident it is the same issue.
Cheers,
Hugh
-