# Performance issue - extremely long response time

**URL:** <https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988>\
**Category:** Help me!\
**Created:** [January 11, 2022, 11:09am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988 "2022-01-11T11:09:30Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 11, 2022, 11:09am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/1 "2022-01-11T11:09:30Z")

</div>

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:

```javascript
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

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/3/3744b5f5137b7f7991a4d1f40094aaf2ca20a90f.png)

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

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [January 11, 2022, 11:33am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/2 "2022-01-11T11:33:14Z")

</div>

Hello @JeremyV,

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

> [@JeremyV](#):
>
> 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.

- 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.

> [@JeremyV](#):
>
> ` axios.get(`${API\_URL}/forest\_admin/places/${place\_id}/maintenance\_contract\_categories`, {`

- 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

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 11, 2022, 11:41am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/3 "2022-01-11T11:41:36Z")

</div>

> [@morganperre](#):
>
> Does this happened on all collections ?

Not all collection, which is weird.

> [@morganperre](#):
>
> Have you some tools that monitor your infrastructure ? (for example datadog) It could be helpful to understand where the issue is happening.

Not that I’m aware of.

> [@morganperre](#):
>
> Is it a call to an internal backend ?

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

> [@morganperre](#):
>
> Do you have the hand on the `${API_URL}/forest_admin/places/${place_id}/maintenance_contract_categories` route ?

I don’t but the issue is not here.

> [@morganperre](#):
>
> You may directly add the **from** and **to** query params to this query to make it faster ?

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

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

```javascript
[
    {
        "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.

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [January 11, 2022, 12:23pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/4 "2022-01-11T12:23:45Z")

</div>

Hello again,

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

> [@JeremyV](#):
>
> Recent changes made on your end if any: none

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. 🙏

Kind regards,  
Morgan

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 11, 2022, 12:32pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/5 "2022-01-11T12:32:07Z")

</div>

> [@morganperre](#):
>
> You said `on every environment` , so are you experiencing it in development (localhost) ?

Yes indeed.

> [@morganperre](#):
>
> Are you using the same external backend in development/production ?

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

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 11, 2022, 12:38pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/6 "2022-01-11T12:38:23Z")

</div>

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

```javascript
[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)"
}
...

```

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [January 11, 2022, 1:21pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/7 "2022-01-11T13:21:39Z")

</div>

> [@JeremyV](#):
>
> Yes indeed.

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

> [@JeremyV](#):
>
> Same provider, not the same environment in Dev/Staging/Production.

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

> [@JeremyV](#):
>
> Just after the query, I have a LOT of warnings (which I don’t usually have, since I try to avoid warnings)

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. 🙏

Thanks for sharing this.

Best regards,  
Morgan

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 12, 2022, 8:52am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/8 "2022-01-12T08:52:19Z")

</div>

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

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/f/f0a54d70d3690afb17d09307ebdaf8754c72186e.png)

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

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [January 12, 2022, 3:18pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/9 "2022-01-12T15:18:47Z")

</div>

Hey @JeremyV,

> [@JeremyV](#):
>
> For some reason things have improved yesterday afternoon, can’t figure out why.

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

> [@JeremyV](#):
>
> When you have some time, a helping hand would be very much appreciated. 🙂

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

Best regards,  
Morgan

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [January 14, 2022, 10:02am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/10 "2022-01-14T10:02:36Z")

</div>

By doing this :

```javascript
      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`

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [January 14, 2022, 11:50am UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/11 "2022-01-14T11:50:08Z")

</div>

> [@JeremyV](#):
>
> I’ve established that it is the `recordSerializer.serialize` which takes 2 minutes, not the `response.send`

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

Best regards,  
Morgan

---

<div class="post-metadata">

**Author:** ![JeremyV](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jeremyv/32/1033_2.png) [@JeremyV](https://community.forestadmin.com/u/JeremyV)\
**Post date:** [February 9, 2022, 6:01pm UTC](https://community.forestadmin.com/t/performance-issue-extremely-long-response-time/3988/12 "2022-02-09T18:01:37Z")

</div>

Any news ? Thanks 😉