Performance issue - extremely long response time

We’re experiencing extremely long response time and trying to figure out why. It targets specifically Forest Admin on all environments. Somehow queries have trouble to access the FA Front End, while the general navigation is working fine.

One example:

router.get('/integrations/:place_id/relationships/categories', (request, response, next) => {
  const place_id = request.params.place_id;
  const recordSerializer = new RecordSerializer({ name: 'categories' });

  // Get query parameters information
  const pageSize = Number(request.query.page.size) || 20;
  const page = Number(request.query.page.number) || 1;
  const from = (page - 1) * pageSize;
  const to = from + pageSize;

  axios.get(`${API_URL}/forest_admin/places/${place_id}/maintenance_contract_categories`, {
    headers: {
      'Authorization': `Bearer ${process.env.ACCESS_TOKEN}`,
      'X-CURRENT-USER-EMAIL': request.user.email
    }
  }).then(async res => {

    if (res.data) {
      const result = res.data.map(category => {
        return {
          id: category.id,
          display_name: category.display_name,
          mandatory: category.mandatory,
          default: category.default,
          state: category.current_maintenance_contract ? category.current_maintenance_contract.state : '',
          provider: category.current_maintenance_contract ? `${category.current_maintenance_contract.provider.sage_provider.raison_sociale} - ${category.current_maintenance_contract.provider.sage_provider.site_ville}` : '',
          reference: category.current_maintenance_contract ? category.current_maintenance_contract.reference : '',
          origin_date: category.current_maintenance_contract ? category.current_maintenance_contract.origin_date : null,
          end_date: category.current_maintenance_contract ? category.current_maintenance_contract.end_date : null,
          notice_in_month: category.current_maintenance_contract ? category.current_maintenance_contract.notice_in_month : '',
          automatic_renewal: category.current_maintenance_contract ? category.current_maintenance_contract.automatic_renewal : '',
          amount: category.current_maintenance_contract ? category.current_maintenance_contract.amount : '',
          repartition_key_id: category.current_maintenance_contract ? category.current_maintenance_contract.repartition_key_id : '',
          maintenanceContract: {
            id: category.current_maintenance_contract ? category.current_maintenance_contract.id : null
          },
        };
      }).sort((a, b) => {
        return (a.mandatory === b.mandatory) ? 0 : a.mandatory ? -1 : 1;
      });

      response.send({
        ...(await recordSerializer.serialize(result.slice(from, to))),
        meta: { count: res.data.length }
      });
    }
  }).catch(() => {
    response.send({ data: [] });
  });
});

This request took 9 minutes to reach FA

On my back end, my script execute almost immediately. It’s really the response.send which takes 9 minutes…

Context

Please provide in this mandatory section, the relevant information about your configuration:

  • Project name: Sergic
  • Team name: Gestion
  • Environment name: All
  • Agent type & version:
    “forest-express”: “^7.9.4”,
    “forest-express-sequelize”: “^7.12.3”,
  • Recent changes made on your end if any: none

Hello @JeremyV,

Sorry to hear that. We will try to understand what is causing the issue.

  • Does this happened on all collections ?
  • Have you some tools that monitor your infrastructure ? (for example datadog) It could be helpful to understand where the issue is happening.
  • Is it a call to an internal backend ?
  • Can you check that this call is not taking a long time ?

I can see that your querying all maintenance_contract_categories for a given place maybe the query is just gigantic (if you have thousand of maintenance_contract_categories).

  • Do you have the hand on the ${API_URL}/forest_admin/places/${place_id}/maintenance_contract_categories route ?
  • You may directly add the from and to query params to this query to make it faster ?

Thanks in advance for all those answers.

Kind regards,
Morgan

Not all collection, which is weird.

Not that I’m aware of.

It is an external backend, I already checked, this call takes a blink of an eye.

I don’t but the issue is not here.

I may not, it is not provided by the API.

Here’s the result of the API when tested in Postman

[
    {
        "id": 51,
        "display_name": "Assurance MRI",
        "mandatory": true,
        "tutorial": null,
        "account_code": "61610",
        "default": true,
        "current_maintenance_contract": null
    },
    {
        "id": 69,
        "display_name": "Eau",
        "mandatory": false,
        "tutorial": "## Lorem ipsum dolor sit amet, consectetur adipiscing elit.\n\nDonec nec neque erat. *Etiam vel nibh ornare ex scelerisque varius* aliquet vitae diam. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris id erat ut magna porta ornare. Aliquam posuere nisl ac feugiat aliquet. **Quisque aliquet rhoncus ornare.** Nam egestas nisl vitae enim efficitur, in iaculis purus rhoncus. \n\nNunc nunc magna, mollis at vulputate vel, euismod et urna. Sed ut erat rhoncus, semper metus a, rhoncus lacus. Donec facilisis lacus in elementum eleifend. Integer quis pulvinar mauris. Sed in urna ligula. Nulla mi velit, pretium vel turpis eu, dictum placerat turpis. Suspendisse at dolor augue. Duis mattis elit a mi scelerisque imperdiet ut id justo.",
        "account_code": "60111",
        "default": true,
        "current_maintenance_contract": null
    },
    {
        "id": 70,
        "display_name": "Electricité des Parties Communes",
        "mandatory": false,
        "tutorial": "## Lorem ipsum dolor sit amet, consectetur adipiscing elit.\n\nDonec nec neque erat. *Etiam vel nibh ornare ex scelerisque varius* aliquet vitae diam. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Mauris id erat ut magna porta ornare. Aliquam posuere nisl ac feugiat aliquet. **Quisque aliquet rhoncus ornare.** Nam egestas nisl vitae enim efficitur, in iaculis purus rhoncus. \n\nNunc nunc magna, mollis at vulputate vel, euismod et urna. Sed ut erat rhoncus, semper metus a, rhoncus lacus. Donec facilisis lacus in elementum eleifend. Integer quis pulvinar mauris. Sed in urna ligula. Nulla mi velit, pretium vel turpis eu, dictum placerat turpis. Suspendisse at dolor augue. Duis mattis elit a mi scelerisque imperdiet ut id justo.",
        "account_code": "60211",
        "default": true,
        "current_maintenance_contract": null
    },
    {
        "id": 73,
        "display_name": "Entretien des Parties Communes",
        "mandatory": false,
        "tutorial": null,
        "account_code": "61110",
        "default": true,
        "current_maintenance_contract": null
    },
    {
        "id": 129,
        "display_name": "ANTENNE T.V. ET PARABOLE",
        "mandatory": false,
        "tutorial": null,
        "account_code": null,
        "default": false,
        "current_maintenance_contract": {
            "id": 544,
            "place_id": 328,
            "repartition_key_id": 1724,
            "reference": "21645",
            "origin_date": "2022-01-03",
            "end_date": "2022-12-31",
            "notice_in_month": 3,
            "automatic_renewal": false,
            "state": "active",
            "comment": null,
            "mri_schedule_kind": null,
            "kind": "maintenance",
            "amount": 199800,
            "created_at": "2022-01-03T10:56:01.442+01:00",
            "updated_at": "2022-01-03T10:56:01.442+01:00",
            "provider": {
                "id": 135,
                "matricule": "NOUU",
                "created_at": "2022-01-03T10:56:01.409+01:00",
                "updated_at": "2022-01-03T10:56:01.409+01:00",
                "sage_provider": {
                    "matricule": "NOUU",
                    "siret": "533 782 793 00012",
                    "raison_sociale": "CAB NOUSASSURONS.COM",
                    "site_adresse": "36E RUE DES 20 TOISES",
                    "site_ville": "ST MARTIN LE VINOUX",
                    "site_codepostal": "38950",
                    "telephone": "+33438864140",
                    "email": "",
                    "bic": "CEPAFRPP751",
                    "iban": "FR7617515900000800664927395"
                }
            }
        }
    },
    {
        "id": 164,
        "display_name": "EXTINCTEURS",
        "mandatory": true,
        "tutorial": null,
        "account_code": null,
        "default": false,
        "current_maintenance_contract": {
            "id": 547,
            "place_id": 328,
            "repartition_key_id": 1725,
            "reference": "213455",
            "origin_date": "2022-01-05",
            "end_date": "2022-12-31",
            "notice_in_month": 3,
            "automatic_renewal": false,
            "state": "active",
            "comment": null,
            "mri_schedule_kind": "quarterly",
            "kind": "maintenance",
            "amount": 120000,
            "created_at": "2022-01-06T09:34:35.917+01:00",
            "updated_at": "2022-01-06T09:34:35.917+01:00",
            "provider": {
                "id": 138,
                "matricule": "ACPN",
                "created_at": "2022-01-06T09:34:35.897+01:00",
                "updated_at": "2022-01-06T09:34:35.897+01:00",
                "sage_provider": {
                    "matricule": "ACPN",
                    "siret": "811 173 889 00015",
                    "raison_sociale": "STE ACP NANTERRE",
                    "site_adresse": "10 RUE ARISTIDE BRIAND",
                    "site_ville": "LE MESNIL LE ROI",
                    "site_codepostal": "78600",
                    "telephone": "+33892976639",
                    "email": "acp.cb@orange.fr",
                    "bic": "CMCIFRPP",
                    "iban": "FR7630066108640002033010164"
                }
            }
        }
    }
]

i.e. 6 objects. Problem is not there.

Hello again,

Hum ok. As you said you haven’t changed anything recently.

On our end the response time are pretty good 123.12ms on average on all routes even the worst metric shows response time in a few seconds.

So I imagine the issue happen on your side, whether a matter of code in the Forest Admin back or something more exotic !

  • You said on every environment, so are you experiencing it in development (localhost) ?
  • Are you using the same external backend in development/production ?

I’ll try to book a debug session with you and our team to dig into the problem. It’s very hard to diagnose any issue here. I’ll come back in MP when I get you a meeting. :pray:

Kind regards,
Morgan

Yes indeed.

Same provider, not the same environment in Dev/Staging/Production.

Just after the query, I have a LOT of warnings (which I don’t usually have, since I try to avoid warnings)

[forest] 🌳🌳🌳  Cannot set the reference immeuble value because of an unexpected error: Cannot read property 'sergicIdFull' of null
{
  "stack": "TypeError: Cannot read property 'sergicIdFull' of null\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:28\nFrom previous event:\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:8)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the gestionnaire value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:322:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the assistant copro value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:359:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the contrat parent value because of an unexpected error: WHERE parameter "attachmentable_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"attachmentable_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:396:56)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the reference immeuble value because of an unexpected error: Cannot read property 'sergicIdFull' of null
{
  "stack": "TypeError: Cannot read property 'sergicIdFull' of null\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:28\nFrom previous event:\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:8)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the gestionnaire value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:322:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the assistant copro value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:359:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the contrat parent value because of an unexpected error: WHERE parameter "attachmentable_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"attachmentable_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:396:56)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the reference immeuble value because of an unexpected error: Cannot read property 'sergicIdFull' of null
{
  "stack": "TypeError: Cannot read property 'sergicIdFull' of null\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:28\nFrom previous event:\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:8)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the gestionnaire value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:322:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the assistant copro value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:359:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the contrat parent value because of an unexpected error: WHERE parameter "attachmentable_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"attachmentable_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:396:56)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the reference immeuble value because of an unexpected error: Cannot read property 'sergicIdFull' of null
{
  "stack": "TypeError: Cannot read property 'sergicIdFull' of null\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:28\nFrom previous event:\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:8)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the gestionnaire value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:322:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the assistant copro value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:359:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the contrat parent value because of an unexpected error: WHERE parameter "attachmentable_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"attachmentable_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:396:56)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the reference immeuble value because of an unexpected error: Cannot read property 'sergicIdFull' of null
{
  "stack": "TypeError: Cannot read property 'sergicIdFull' of null\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:28\nFrom previous event:\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:303:8)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
[forest] 🌳🌳🌳  Cannot set the gestionnaire value because of an unexpected error: WHERE parameter "resource_id" has invalid "undefined" value
{
  "stack": "Error: WHERE parameter \"resource_id\" has invalid \"undefined\" value\n    at PostgresQueryGenerator.whereItemQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2085:13)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2074:25\n    at Array.forEach (<anonymous>)\n    at PostgresQueryGenerator.whereItemsQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2072:35)\n    at PostgresQueryGenerator.getWhereConditions (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:2484:19)\n    at PostgresQueryGenerator.selectQuery (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-generator.js:1307:28)\n    at QueryInterface.select (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\query-interface.js:1119:27)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1754:34\nFrom previous event:\n    at Function.findAll (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1752:8)\n    at Function.findOne (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\sequelize\\lib\\model.js:1921:17)\n    at Object.get (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\forest\\maintenance-contracts.js:322:46)\n    at setSmartFieldValue (C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:43:33)\n    at C:\\Users\\jvollant\\WebDev\\Syndic One Rebirth\\node_modules\\forest-express-sequelize\\node_modules\\forest-express\\dist\\services\\smart-fields-values-injector.js:124:22\n    at processImmediate (internal/timers.js:464:21)"
}
...

“Perfect” this will help a lot during the debug session.

Thanks for the information. I’ll tend to say that not related to this call if all environments are affected.

Good catch they are all related to a forest-express service smart-fields-values-injector.js.

Hum, it looks like it’s due to some null properties. That might be a starting point to investigate. :pray:

Thanks for sharing this.

Best regards,
Morgan

Hi @morganperre
For some reason things have improved yesterday afternoon, can’t figure out why.
Some pages are still very slow though.

When you have some time, a helping hand would be very much appreciated. :slight_smile:

Hey @JeremyV,

It’s kind of a good news but it’s very weird.

A colleague should schedule a meeting as soon as possible to make the light this subject. :pray:

Best regards,
Morgan

By doing this :

      console.log('avant serialize');
      const serializedResult = {
        ...(await recordSerializer.serialize(result.slice(from, to))),
        meta: { count: res.data.length }
      };
      console.log('apres serialize');

      response.send(serializedResult);

I’ve established that it is the recordSerializer.serialize which takes 2 minutes, not the response.send

1 Like

Thanks for investigating. :pray:
I’m looking forward to have more insight following the scheduled debug-session.

Best regards,
Morgan

Any news ? Thanks :wink: