# Upgrade error - CustomerNumber is not unique

**URL:** <https://forum.litium.com/t/upgrade-error-customernumber-is-not-unique/203>\
**Category:** Questions\
**Tags:** litium-6\
**Created:** [August 22, 2018, 12:35pm UTC](https://forum.litium.com/t/upgrade-error-customernumber-is-not-unique/203 "2018-08-22T12:35:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![malin.oborn](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@malin.oborn](https://forum.litium.com/u/malin.oborn)\
**Post date:** [August 22, 2018, 12:35pm UTC](https://forum.litium.com/t/upgrade-error-customernumber-is-not-unique/203/1 "2018-08-22T12:35:22Z")

</div>

When running the Update-LitiumDatabase command (from L5.5.2 -\> L6.2) I encounter the following error

“CustomerNumber (XXXXXX-XXXX) for Organization in Relations is not unique (after space is removed).”

for 4 different CustomerNumbers. But when querying the database, all CustomerNumbers seem to be unique. What might be the problem?

Litium version: 6.2

---

<div class="post-metadata">

**Author:** ![marten](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/marten/32/11_2.png) [@marten](https://forum.litium.com/u/marten)\
**Post date:** [August 23, 2018, 9:22am UTC](https://forum.litium.com/t/upgrade-error-customernumber-is-not-unique/203/2 "2018-08-23T09:22:51Z")

</div>

Did you check if customer number is unique also when removing spaces?  
It needs to be unique within both persons and organizations.

---

<div class="post-metadata">

**Author:** ![malin.oborn](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@malin.oborn](https://forum.litium.com/u/malin.oborn)\
**Post date:** [August 23, 2018, 9:42am UTC](https://forum.litium.com/t/upgrade-error-customernumber-is-not-unique/203/3 "2018-08-23T09:42:33Z")

</div>

My bad, forgot to check for whitespace **inside** the CustomerNumber. Found some duplicates now.