Receiving Node based error when using Resource Query GUI Write option

Queries and Resources
, ,
1

This all occurs with the cloud-hosted version of retool

While using the resource query option, where the source is an oracle sql database , I am unable to write to the any table using the GUI option. I am able to write using the the SQL side of the resource query.

This occurs within both app resource queries and workflow queries

The error is as follows:

{
    "data": null,
    "metadata": null,
    "error": {
        "error": true,
        "message": "Knex: run\n$ npm install oracledb --save\nCannot find module 'oracledb'\nRequire stack:\n- /retool/node_modules/.pnpm/knex@0.21.16_mssql@7.2.1_mysql2@2.3.3_pg@8.11.3_tedious@11.8.0/node_modules/knex/lib/dialects/oracledb/index.js\n- /retool/node_modules/.pnpm/knex@0.21.16_mssql@7.2.1_mysql2@2.3.3_pg@8.11.3_tedious@11.8.0/node_modules/knex/lib/config-resolver.js\n- /retool/node_modules/.pnpm/knex@0.21.16_mssql@7.2.1_mysql2@2.3.3_pg@8.11.3_tedious@11.8.0/node_modules/knex/lib/knex.js\n- /retool/node_modules/.pnpm/knex@0.21.16_mssql@7.2.1_mysql2@2.3.3_pg@8.11.3_tedious@11.8.0/node_modules/knex/lib/index.js\n- /retool/node_modules/.pnpm/knex@0.21.16_mssql@7.2.1_mysql2@2.3.3_pg@8.11.3_tedious@11.8.0/node_modules/knex/knex.js\n- /retool/backend/transpiled/dbconnector/connectors/retoolTable/connector.js\n- /retool/backend/transpiled/dbconnector/connectors/retoolTable/retoolTable.js\n- /retool/backend/transpiled/dbconnector/connectors/googleSheets/googleSheets.js\n- /retool/backend/transpiled/dbconnector/connectorFactory.js\n- /retool/backend/transpiled/dbconnector/db.js\n- /retool/backend/transpiled/dbconnector/utils/metricsMonitor.js\n- /retool/backend/transpiled/dbconnector/main.js",
        "isRetoolSystemError": false,
        "queryExecutionMetadata": {
            "estimatedResponseSizeBytes": 1250,
            "resourceTimeTakenMs": 2,
            "isPreview": false,
            "resourceType": "oracledb",
            "lastReceivedFromResourceAt": 1712102426326
        }
    }
}

We Attempted:

  1. added the oracledb module to the workflow; error persisted
    2.added the knex module in addition to the workflow; error persisted

This all occurred after 8 months or so of using the specific resource queries and method without issue.
We should be able to re-write links to this DB using SQL, but wanted to report the bug in the mean time

2

Thank you for reporting. We're noticing this problem on our end as well! We're in the process of rolling back the affected change. Please expect it to be fixed soon! I'll update here when it's done.

3

Hi Harry - when do you expect this to be resolved?

4

@snommis It should be resolved now. Can you test again?

5

All set, thank you so much @Harry_Doan - are we ok to remove the libraries to tried to import directly into the workflow now (e.g. oracledb/knex)?

Also could you please help us understand if theres a way to track when changes like these happen so we can be sure to test?

6

You should be able to remove those libraries (oracledb and knex) now, and you won’t need to add them again.

This change was an unintentional regression as part of our normal release process, so I don’t think there’s anything you could have done to track or predict it. As with any incident in production we’ll do a post-mortem on our side to make sure it doesn’t happen again.

Thank you for your patience and for helping us fix this!

7

Yeah @snommis, this is an issue with our internal code and you shouldn't need to change your workflow blocks in anyway. Like @Sam_Stern said, it's an unexpected event and we'll do a post-mortem to prevent it from happening again.