-
1. Re: DWP 3.5 - Invalid column name 'scope'
Hugh FairfieldJan 23, 2018 6:04 PM (in response to Marek Ceizel)
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 CeizelJan 24, 2018 6:06 PM (in response to Hugh Fairfield)
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 FairfieldJan 24, 2018 6:10 PM (in response to Marek Ceizel)
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 CeizelJan 24, 2018 6:43 PM (in response to Hugh Fairfield)
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 FairfieldJan 24, 2018 6:54 PM (in response to Marek Ceizel)
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
-
6. Re: DWP 3.5 - Invalid column name 'scope'
Marek CeizelJan 25, 2018 1:20 AM (in response to Hugh Fairfield)
Thank you Hugh