Table 'OA2Auths_OA2ScopeGrants' already exists
Written By
Alexandra Rujzam
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
Legacy Article
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
Issue
The following error occurs while upgrading a database to DXP 7.1 or higher
Table 'OA2Auths_OA2ScopeGrants' already exists
Environment
- Upgrading Portal 6.2 or DXP 7.0 -> DXP 7.1 or higher
Resolution
This error says that the table already exists, but OA2Auths_OA2ScopeGrants table should only exists when OAuth2 is used and it was not supported before DXP 7.1.
Please make sure that the whole database is dropped, then imported again before running the upgrade process.
First check if OA2Auths_OA2ScopeGrants table exists in the 'pre-upgrade database' because if so, then it means that the upgrade has been run two times on the same database - without dropping and recreating the whole schema. Please note that this should be avoided in general, the upgrade shouldn't be run more than once on a database.
Did this article resolve your issue ?