Forum - Too long string during import

Too long string during import

Christoffer Riska

8-6-17

We had a lot of errors during inport in version 82161124.
All errors seem to be related to electronic invoices registers HTSVIVc and VEIVVc.

Does anyone know if this is harmful to the HDB or how to fix this?

2017-01-18 11:36:23 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: HTSVIVc nr: 48426 row: 1 row field: ArtCode NOT TRUNCATING

2017-01-18 11:36:23 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: HTSVIVc nr: 48426 row: 3 row field: ArtCode NOT TRUNCATING
2017-01-18 11:56:22 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: HTSVIVc nr: 50631 row: 1 row field: ArtCode NOT TRUNCATING
2017-01-18 11:56:22 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: HTSVIVc nr: 50631 row: 3 row field: ArtCode NOT TRUNCATING

2017-02-17 18:10:00 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 58772 row: 0 row field: ArtCode NOT TRUNCATING
2017-02-23 13:09:02 Too long string during import: 4000_KG._A_0_42_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 59584 row: 8 row field: ArtCode NOT TRUNCATING
2017-02-23 13:09:02 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 59584 row: 10 row field: ArtCode NOT TRUNCATING
2017-02-23 13:09:02 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: HTSVIVc nr: 59584 row: 11 row field: ArtCode NOT TRUNCATING

2017-02-28 14:45:02 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: HTSVIVc nr: 60216 row: 1 row field: ArtCode NOT TRUNCATING
2017-02-28 14:45:02 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: HTSVIVc nr: 60216 row: 2 row field: ArtCode NOT TRUNCATING
2017-02-28 14:45:02 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: HTSVIVc nr: 60216 row: 3 row field: ArtCode NOT TRUNCATING
2017-02-28 14:45:02 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: HTSVIVc nr: 60216 row: 5 row field: ArtCode NOT TRUNCATING
2017-03-01 15:50:02 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 60449 row: 4 row field: ArtCode NOT TRUNCATING
2017-03-03 17:00:22 Too long string during import: 400_KG._A_1_08_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 61166 row: 9 row field: ArtCode NOT TRUNCATING
2017-03-03 17:00:22 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: HTSVIVc nr: 61166 row: 10 row field: ArtCode NOT TRUNCATING
2017-03-07 16:20:01 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: HTSVIVc nr: 61784 row: 0 row field: ArtCode NOT TRUNCATING
2017-03-08 14:40:02 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 61991 row: 0 row field: ArtCode NOT TRUNCATING
2017-03-25 14:00:02 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 64801 row: 0 row field: ArtCode NOT TRUNCATING
2017-03-30 13:20:02 Too long string during import: 4800_KG._A_0_42_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 65461 row: 8 row field: ArtCode NOT TRUNCATING
2017-03-30 13:20:02 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 65461 row: 10 row field: ArtCode NOT TRUNCATING
2017-03-30 13:20:02 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: HTSVIVc nr: 65461 row: 11 row field: ArtCode NOT TRUNCATING

2017-03-30 13:30:02 Too long string during import: 4000_KG._A_0_42_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 65462 row: 8 row field: ArtCode NOT TRUNCATING
2017-03-30 13:30:02 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 65462 row: 10 row field: ArtCode NOT TRUNCATING
2017-03-30 13:30:02 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: HTSVIVc nr: 65462 row: 11 row field: ArtCode NOT TRUNCATING
2017-04-11 16:40:01 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: HTSVIVc nr: 67907 row: 0 row field: ArtCode NOT TRUNCATING
2017-04-11 16:40:01 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 67909 row: 0 row field: ArtCode NOT TRUNCATING
2017-04-11 16:50:01 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: HTSVIVc nr: 67908 row: 0 row field: ArtCode NOT TRUNCATING
2017-04-13 14:00:00 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 68328 row: 4 row field: ArtCode NOT TRUNCATING
2017-04-13 14:10:00 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 68331 row: 4 row field: ArtCode NOT TRUNCATING

2017-04-27 23:18:19 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 70175 row: 4 row field: ArtCode NOT TRUNCATING
2017-04-28 13:50:01 Too long string during import: 1000_KG._A_0_42_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 70398 row: 7 row field: ArtCode NOT TRUNCATING
2017-04-28 13:50:01 Too long string during import: 1000_KG._A_1_08_EUR_PR._100 is longer than 20 register: HTSVIVc nr: 70398 row: 9 row field: ArtCode NOT TRUNCATING
2017-05-06 15:10:02 Too long string during import: HYVITYS_LASKUUMME_CA_611386 is longer than 20 register: HTSVIVc nr: 72011 row: 4 row field: ArtCode NOT TRUNCATING
2017-05-18 09:29:04 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 72640 row: 0 row field: ArtCode NOT TRUNCATING
2017-05-18 14:59:02 Too long string during import: VAKUUTUSNUMERO_382-4662025-B is longer than 20 register: HTSVIVc nr: 74060 row: 0 row field: ArtCode NOT TRUNCATING
2017-06-07 17:10:02 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 77737 row: 0 row field: ArtCode NOT TRUNCATING
2017-07-04 18:30:03 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 82423 row: 0 row field: ArtCode NOT TRUNCATING
2017-07-08 16:10:00 Too long string during import: VAKUUTUSNUMERO_382-4662025-B is longer than 20 register: HTSVIVc nr: 83519 row: 0 row field: ArtCode NOT TRUNCATING
2017-07-11 14:30:03 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: HTSVIVc nr: 83742 row: 0 row field: ArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4000_KG._A_0_42_EUR_PR._100 is longer than 20 register: VEIVVc nr: 36 row: 8 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 36 row: 10 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: VEIVVc nr: 36 row: 11 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: VEIVVc nr: 70 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4800_KG._A_0_42_EUR_PR._100 is longer than 20 register: VEIVVc nr: 102 row: 8 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 102 row: 10 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: VEIVVc nr: 102 row: 11 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4000_KG._A_0_42_EUR_PR._100 is longer than 20 register: VEIVVc nr: 103 row: 8 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 103 row: 10 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: VEIVVc nr: 103 row: 11 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: VEIVVc nr: 130 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:41:30 Too long string during import: VAKUUTUSNUMERO_380-440203157-U is longer than 20 register: VEIVVc nr: 131 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:19 Too long string during import: VAKUUTUSNUMERO_382-4662025-B is longer than 20 register: VEIVVc nr: 33 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:19 Too long string during import: VAKUUTUSNUMERO_382-4662025-B is longer than 20 register: VEIVVc nr: 56 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: VEIVVc nr: 2 row: 1 row field: VEArtCode NOT TRUNCATING

2017-08-06 18:43:49 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: VEIVVc nr: 2 row: 3 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: VEIVVc nr: 4 row: 1 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: VEIVVc nr: 4 row: 3 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 14 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: VEIVVc nr: 23 row: 1 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: VEIVVc nr: 23 row: 2 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: SAATAVAN_PERUSTE/LASKU is longer than 20 register: VEIVVc nr: 23 row: 3 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: TOIMEKSIANTAJAN_KULUT is longer than 20 register: VEIVVc nr: 23 row: 5 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 25 row: 4 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 400_KG._A_1_08_EUR_PR._100 is longer than 20 register: VEIVVc nr: 30 row: 9 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: PUHELINAVISOINTI_(SOITTO_ENNEN_AJOA is longer than 20 register: VEIVVc nr: 30 row: 10 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 35 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 56 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 73 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 76 row: 4 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 4800_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 77 row: 4 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 4000_KG._A_0_46_EUR_PR._100 is longer than 20 register: VEIVVc nr: 91 row: 4 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: 1000_KG._A_0_42_EUR_PR._100 is longer than 20 register: VEIVVc nr: 92 row: 7 row field: VEArtCode NOT TRUNCATING

2017-08-06 18:43:49 Too long string during import: 1000_KG._A_1_08_EUR_PR._100 is longer than 20 register: VEIVVc nr: 92 row: 9 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: HYVITYS_LASKUUMME_CA_611386 is longer than 20 register: VEIVVc nr: 105 row: 4 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 110 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 148 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 185 row: 0 row field: VEArtCode NOT TRUNCATING
2017-08-06 18:43:49 Too long string during import: VAKUUTUSNUMERO_380-440247839-6 is longer than 20 register: VEIVVc nr: 191 row: 0 row field: VEArtCode NOT TRUNCATING

Ester J.

8-10-17

Hello,

From what I can see, they have too long data entries in the in field.
This should not stop import. Usually this happens when customer is importing data and our systme just does not cut it.
This needs to fix be fixed manually - most likely by exporting the register, fix and import the so it overwrites.

This should not harm or affect anything, it is only really mentioned during Import.

- Ester

Back to the list

New Message
Open Questions My Questions