Fix error from executing oracle DB scripts: APIM 2.1.0 to 4.0.0 migration
Open
Nobody has claimed this yet.
API-M-4.0.0
API-M-4.1.0
component/migration
Docs/Waiting on SME
help wanted
Severity/Major
Type/Bug
- Dominant language
- CSS
- Stars
- 99
- Forks
- 708
- Avg merge
- 1d 7h
- Merged PRs (30d)
- 22
Description
The Oracle DB script of WSO2AM_DB [1] gives the following errors.
- There is a primary key missing error in the column called COMMENT_ID on AM_API_COMMENTS Table.
- AM_CERTIFICATE_METADATA, AM_APPLICATION_GROUP_MAPPING tables already exist on the database.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Read the linked APIM upgrade guide and locate the WSO2AM_DB Oracle migration script for the 2.1.0 to 4.0.0 upgrade. Reproduce the reported COMMENT_ID primary-key error and existing-table errors, then verify the migration completes without them.
Written by the indexing model from the issue text.
Assessment
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100