Issues with Knex Migrations for Oracle DB in Backstage

[surajkendhey]

Environment

Knex version :[email protected]
Database + version: Oracle 21c express
drivers: oracledb
Backstage Version: 1.31.0
OS: Ubuntu

@atiertant
@lorefnon

We are experiencing multiple issues with Knex migrations in our Backstage project. Below are the details of the errors observed:

ORA-01442: column to be modified to NOT NULL is already NOT NULL
This error is observed at multiple places in various migration files.
It required commenting out specific code sections (screenshots attached).

ORA-01408: such column list already indexed
This error is also observed at multiple places in various migration files.
It required commenting out specific code sections (screenshots attached).