# Fehler Migrationsassistent sales\_channel Value is not a valid UUID

**URL:** <https://forum.shopware.com/t/fehler-migrationsassistent-sales-channel-value-is-not-a-valid-uuid/69815>\
**Category:** Installation / Einstieg\
**Created:** [24. September 2020 um 07:27 UTC](https://forum.shopware.com/t/fehler-migrationsassistent-sales-channel-value-is-not-a-valid-uuid/69815 "2020-09-24T07:27:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![digitalisman](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@digitalisman](https://forum.shopware.com/u/digitalisman)\
**Post date:** [24. September 2020 um 07:27 UTC](https://forum.shopware.com/t/fehler-migrationsassistent-sales-channel-value-is-not-a-valid-uuid/69815/1 "2020-09-24T07:27:36Z")

</div>

Hallo Zusammen,

ich versuche einen SHopware 5.6.4 auf Shopware 6.3.1.1 zu migrieren. Leider werden die Daten nur teilweise migriert. Die Kunden und Bestellungen leider garnicht im Log steht dieser fehler (Kleiner Auszug):

Migration log generated at 24.09.2020 07:19:59 UTC  
Run id: 8878871a4b6e445dbde51fd1dda9626f  
Status: finished  
Created at: 24.09.2020 07:19:16 UTC  
Updated at: 24.09.2020 07:19:38 UTC  
Last control user id: F994CBE8AE484C32BB0FB5E461548481  
Connection id: 1328fbf23d1f409690900c008fe711f0  
Connection name: SW5 Tortentuning  
Profile: shopware56  
Gateway: api

Selected data:

- basicSettings (total: 6)  
&nbsp;&nbsp; &nbsp;- language (total: 0)  
&nbsp;&nbsp; &nbsp;- category\_custom\_field (total: 0)  
&nbsp;&nbsp; &nbsp;- category (total: 0)  
&nbsp;&nbsp; &nbsp;- customer\_group\_custom\_field (total: 0)  
&nbsp;&nbsp; &nbsp;- customer\_group (total: 0)  
&nbsp;&nbsp; &nbsp;- currency (total: 0)  
&nbsp;&nbsp; &nbsp;- sales\_channel (total: 1)  
&nbsp;&nbsp; &nbsp;- number\_range (total: 5)
- customersOrders (total: 161)  
&nbsp;&nbsp; &nbsp;- customer\_custom\_field (total: 0)  
&nbsp;&nbsp; &nbsp;- customer (total: 78)  
&nbsp;&nbsp; &nbsp;- shipping\_method (total: 1)  
&nbsp;&nbsp; &nbsp;- order\_custom\_field (total: 0)  
&nbsp;&nbsp; &nbsp;- order (total: 60)  
&nbsp;&nbsp; &nbsp;- order\_document\_custom\_field (total: 0)  
&nbsp;&nbsp; &nbsp;- order\_document (total: 22)
- processMediaFiles (total: 22)  
&nbsp;&nbsp; &nbsp;- media (total: 22)

--------------------Log-entries---------------------

[info] SWAG\_MIGRATION\_LANGUAGE\_ENTITY\_ALREADY\_EXISTS  
The language entity already exists  
The language entity with source id “1” already exists and cannot be written.

[info] SWAG\_MIGRATION\_\_SHOPWARE\_UNSUPPORTED\_NUMBER\_RANGE\_TYPE  
Unsupported number range type  
NumberRange-Entity with source id “926” could not be converted because of unsupported type: sSERVICE1.

[info] SWAG\_MIGRATION\_\_SHOPWARE\_UNSUPPORTED\_NUMBER\_RANGE\_TYPE  
Unsupported number range type  
NumberRange-Entity with source id “927” could not be converted because of unsupported type: sSERVICE2.

[info] SWAG\_MIGRATION\_\_SHOPWARE\_UNSUPPORTED\_NUMBER\_RANGE\_TYPE  
Unsupported number range type  
NumberRange-Entity with source id “928” could not be converted because of unsupported type: blogordernumber.

[error] SWAG\_MIGRATION\_RUN\_EXCEPTION  
An exception occurred  
Entity: sales\_channel, sourceId: 56e4c039485144e89ebf38c73fe4a56f  
Value is not a valid UUID:

[error] SWAG\_MIGRATION\_RUN\_EXCEPTION  
An exception occurred  
Entity: number\_range, sourceId: 9fe0dbd13b694ae481bfa98a9fdf1152  
An exception occurred while executing ‘INSERT INTO `number_range_sales_channel` (`id`, `number_range_id`, `sales_channel_id`, `number_range_type_id`, `created_at`) VALUES (?, ?, ?, ?, ?)’ with params ["\xaf\x20\x28\x1f\x75\xc5\x4b\xb5\xa0\xd4\xc3\xef\xf4\x29\x4e\x5a", “\x69\x81\x4c\x7a\x1f\xf2\x41\x41\x97\x90\x94\x70\xdb\x2e\x6e\xe6”, “\xc5\x44\xb1\x66\xb0\x2a\x46\xd0\xb4\x5f\xf9\xe1\x57\x97\xd2\xb9”, “\x9f\x26\x17\x24\x03\xf2\x46\xbd\xb9\x5c\x0f\x7c\x8c\xfa\x08\x62”, “2020-09-24 07:19:32.399”]:SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`tortentunsw6`.`number_range_sales_channel`, CONSTRAINT `fk.number_range_sales_channel.sales_channel_id` FOREIGN KEY (`sales_channel_id`) REFERENCES `sales_channel` (`id`) ON DELETE CASCADE ON)

---

<div class="post-metadata">

**Author:** ![Krispin](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/krispin/32/12849_2.png) [@Krispin](https://forum.shopware.com/u/Krispin)\
**Post date:** [30. September 2020 um 05:57 UTC](https://forum.shopware.com/t/fehler-migrationsassistent-sales-channel-value-is-not-a-valid-uuid/69815/2 "2020-09-30T05:57:11Z")

</div>

Hi,

anscheinend konnte ein SalesChannel nicht migriert werden und somit können wahrscheinlich auch alle Kunden und Bestellungen, die an diesem SalesChannel hängen auch nicht migriert werden. Komisch ist der Fehler „Value is not a valid UUID:“ beim Schreiben des SalesChannels.

Gruß

Krispin

---

<div class="post-metadata">

**Author:** ![digitalisman](https://avatars.discourse-cdn.com/v4/letter/d/dbc845/32.png) [@digitalisman](https://forum.shopware.com/u/digitalisman)\
**Post date:** [30. September 2020 um 06:10 UTC](https://forum.shopware.com/t/fehler-migrationsassistent-sales-channel-value-is-not-a-valid-uuid/69815/3 "2020-09-30T06:10:08Z")

</div>

Guten Morgen, ich habe einen 6.1 Shop aufgesetzt und dort die Migration durchgeführt ohne Probleme… es scheint demnach mit der 6.3.1.1. zusammenzuhängen. Was mir noch aufgefallen ist … beim Saltechannel kann bei der Domain keine Sprache hinzugefügt werden… demnach kann auch kein neuer Salechannel hinzugefügt werden… ich denke das genau hier das Problem liegt.
