Unable to Run Migrations – database.json Missing Error When Using npm run db:migrate

[Dinuu10]

Describe the bug
Unable to Run Migrations – database.json Missing Error When Using npm run db:migrate.

To Reproduce
Steps to reproduce the behavior:

1. Install and integrate auth-service and user-tenant-service from Sourceloop.
2. Set up .env with DB configs.
3. Attempt to run migration using a command like: npm run db:migrate
4. See the error regarding missing database.json.

Expected behavior
Migration should run successfully.

Screenshots

Additional context
Add any other context about the problem here.

[rohitvishwakarma-sf]

In which OS are your facing this issue ?

[Dinuu10]

In which OS are your facing this issue ?

I'm using windows 11.

[rohitvishwakarma-sf]

Seems like its considering ' to be a part of file name. Can you try removing ' from your scripts in package.json

Try Changing it from

"db:migrate:authentication-service": "db-migrate up --config 'authentication-service/database.js' -m 'authentication-service/migrations'"

to

"db:migrate:authentication-service": "db-migrate up --config authentication-service/database.js -m authentication-service/migrations"

[Dinuu10]

Yes @rohitvishwakarma-sf it worked after removing ' from the script.
Thanks for the help!