Can't connect to the DB

Hello,

I am getting the following error when i am trying to connect to my microsoft SQL database using Docker
✓ Connecting to your database
:heavy_multiplication_x: Analyzing the database

Cannot generate your project.
An unexpected error occurred. Please reach out for help in our Developers community (https://community.forestadmin.com/) or create a Github issue with following error: SequelizeDatabaseError: Timeout: Request failed to complete in 15000ms
(node:15) UnhandledPromiseRejectionWarning: SequelizeDatabaseError: Timeout: Request failed to complete in 15000ms
at Query.formatError (/usr/local/lib/node_modules/lumber-cli/node_modules/sequelize/lib/dialects/mssql/query.js:321:12)
at Request.connection.lib.Request [as userCallback] (/usr/local/lib/node_modules/lumber-cli/node_modules/sequelize/lib/dialects/mssql/query.js:81:23)
at Request.callback (/usr/local/lib/node_modules/lumber-cli/node_modules/tedious/lib/request.js:40:14)
at Connection.message (/usr/local/lib/node_modules/lumber-cli/node_modules/tedious/lib/connection.js:2305:24)
at Connection.dispatchEvent (/usr/local/lib/node_modules/lumber-cli/node_modules/tedious/lib/connection.js:1220:36)
at MessageIO.messageIo.on (/usr/local/lib/node_modules/lumber-cli/node_modules/tedious/lib/connection.js:1093:14)
at MessageIO.emit (events.js:198:13)
at Message.message.on (/usr/local/lib/node_modules/lumber-cli/node_modules/tedious/lib/message-io.js:33:14)
at Message.emit (events.js:203:15)
at endReadableNT (/usr/local/lib/node_modules/lumber-cli/node_modules/readable-stream/lib/_stream_readable.js:1094:12)
at process._tickCallback (internal/process/next_tick.js:63:19)
(node:15) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
(node:15) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.

Thank you for your help

Hi @Romain :wave: Thank you for your feedback.

It seems the connection has been established:

✓ Connecting to your database

Still, the analysis of your database has failed:

:heavy_multiplication_x: Analyzing the database

Unfortunately, the message displayed here by the install process is not super helpful. We have to find a way to learn more about why the timeout has occurred:

:newspaper_roll: Could you check if there is an error in your database logs? Or check for the last executed query?
:elephant: Is your database heavy? Does it usually respond fast?
:hourglass_flowing_sand: Since the analysis could take some time, could you increase the timeout temporarily?
:point_right: You mentioned that it fails using docker. Do you mean that it works with NPM install?

Also, could you try with a test database (a few table sand some data)? If it still fails, we could try to import that test database on our own and trace the error.

Thank you for your feedback :pray:

No response. Let’s consider the issue fixed and close the topic.