# ErrorHTTP422 but no details given from forest-express-sequelize

**URL:** https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482
**Category:** Help me!
**Created:** [July 10, 2023, 7:34pm UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482 "2023-07-10T19:34:22Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)
#### Post date: [July 10, 2023, 7:34pm UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/1 "2023-07-10T19:34:22Z")

</div>

Hey ! I discovered when updating a record using **RecordUpdater** that when I’m violating a primary key, the recordUpdater throws a **ErrorHTTP422** , with a message “Validation error” but no detail is given about the error. I need to manually go to resource-updater and put a console.log of the error [here](https://github.com/ForestAdmin/forest-express-sequelize/blob/7b5fd0e3e7c507569c8e6fe3446417103e5a8f6f/src/services/resource-updater.js#L30C47-L30C47) to understand that it is PK violation.

Is it an expected behavior of the library that no details about the error is given ?

---

<div class="post-metadata">

### Author: ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)
#### Post date: [July 11, 2023, 7:47am UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/2 "2023-07-11T07:47:23Z")

</div>

Hi @Simon_BRAMI1 👋  
please can you share with us the version of forest-express-sequelize did you use ? 🙏  
And the sample of code who are using RecordUpdater.

---

<div class="post-metadata">

### Author: ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)
#### Post date: [July 11, 2023, 8:19am UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/3 "2023-07-11T08:19:29Z")

</div>

Hi Arnaud, I’m using “^9.2.6” version 🙂

The sample of code is a bit long but here’s a simplified version:

```js
//....
const recordUpdater = new RecordUpdater(CatalogueItem, user, defaultQuery);
const recordToUpdate = await recordUpdater.deserialize(body);
try {
   const record = await recordUpdater.update(recordToUpdate, catalogueItemId);
   let recordSerialized = await recordUpdater.serialize(record);
   response.status(200).send(recordSerialized);
}
 catch (e) {
   next(e);
}

```

There’s nothing crazy about it, the issue is only the error message being too simple and not explicit about the PK violation.

---

<div class="post-metadata">

### Author: ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)
#### Post date: [July 11, 2023, 8:42am UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/4 "2023-07-11T08:42:02Z")

</div>

pretty strange actually when i do a thing similar i ged a “nice error”

 ![Capture d’écran 2023-07-11 à 10.38.25](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/4/43a0a7a3bacda41274977560582dbf597ac18ceb.png)

---

<div class="post-metadata">

### Author: ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)
#### Post date: [July 11, 2023, 11:28am UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/5 "2023-07-11T11:28:50Z")

</div>

In my case I’m violating a composite PK composed by 3 columns. Maybe that’s why ?

---

<div class="post-metadata">

### Author: ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)
#### Post date: [July 11, 2023, 11:31am UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/6 "2023-07-11T11:31:19Z")

</div>

Here is what my console.log was printing:

```javascript
UniqueConstraintError [SequelizeUniqueConstraintError]: Validation error
    at Query.formatError (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/dialects/postgres/query.js:312:18)
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/dialects/postgres/query.js:71:18
From previous event:
    at Query.run (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/dialects/postgres/query.js:64:23)
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/sequelize.js:641:29
From previous event:
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/sequelize.js:641:12
From previous event:
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/sequelize.js:637:10
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/node_modules/retry-as-promised/index.js:70:21
    at new Promise (<anonymous>)
    at retryAsPromised (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/node_modules/retry-as-promised/index.js:60:10)
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/sequelize.js:627:30
From previous event:
    at Sequelize.query (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/sequelize.js:576:23)
    at QueryInterface.update (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/query-interface.js:1012:27)
    at /Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/model.js:3985:52
    at processImmediate (internal/timers.js:464:21)
From previous event:
    at self.save (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/sequelize/lib/model.js:3962:8)
    at ResourceUpdater.perform (/Users/simonbrami/rendu/edumiam/forest_backend/node_modules/forest-express-sequelize/dist/services/resource-updater.js:32:22)
    at async updateCatalogueItem (/Users/simonbrami/rendu/edumiam/forest_backend/controllers/catalogueItem.js:435:22)
    at async /Users/simonbrami/rendu/edumiam/forest_backend/routes/catalogue-item.js:111:32 {
  errors: [
    ValidationErrorItem {
      message: 'start_opco must be unique',
      type: 'unique violation',
      path: 'start_opco',
      value: '2022-06-25',
      origin: 'DB',
      instance: [catalogueItem],
      validatorKey: 'not_unique',
      validatorName: null,
      validatorArgs: []
    },
    ValidationErrorItem {
      message: 'learner_id must be unique',
      type: 'unique violation',
      path: 'learner_id',
      value: '5843',
      origin: 'DB',
      instance: [catalogueItem],
      validatorKey: 'not_unique',
      validatorName: null,
      validatorArgs: []
    },
    ValidationErrorItem {
      message: 'catalogue_entity_id must be unique',
      type: 'unique violation',
      path: 'catalogue_entity_id',
      value: '54',
      origin: 'DB',
      instance: [catalogueItem],
      validatorKey: 'not_unique',
      validatorName: null,
      validatorArgs: []
    }
  ],
  fields: {
    start_opco: '2022-06-25',
    learner_id: '5843',
    catalogue_entity_id: '54'
  },
.......

```

---

<div class="post-metadata">

### Author: ![Arnaud\_Moncel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/arnaud_moncel/32/24_2.png) [@Arnaud\_Moncel](https://community.forestadmin.com/u/Arnaud_Moncel)
#### Post date: [July 11, 2023, 12:35pm UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/7 "2023-07-11T12:35:46Z")

</div>

Maybe Sequelize doesn’t render properly this kind of error.  
As we take only the message for display purpose, that’s why the error look’s bad.  
Like we see it, is working nicely on “simple” constraint error.

Let me know if i can help more.

---

<div class="post-metadata">

### Author: ![Simon\_BRAMI1](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/simon_brami1/32/2753_2.png) [@Simon\_BRAMI1](https://community.forestadmin.com/u/Simon_BRAMI1)
#### Post date: [July 12, 2023, 2:47pm UTC](https://community.forestadmin.com/t/errorhttp422-but-no-details-given-from-forest-express-sequelize/6482/8 "2023-07-12T14:47:38Z")

</div>

Ok, thanks anyways for helping! 🙂
