Hallo Liebes Forum
Folgende Fehlermeldung erhalte ich beim Versand:
Unbehandelte Ausnahme #2DB61C542897F240 vom Typ JTL.Shipping.Shared.Exceptions.ShippingException in
JTL.Shipping.Shared.Exceptions.ShippingException: Originalmeldung
Meldung: An error occurred when validating input: Folgende Information fehlt: Consignee address mobile phone or email. Bitte geben Sie diese an.
Code: 0004
ID: d690ebd4-11f3-4b9f-bdda-20cc070c10cf
2019-02-22T10:07:56 DEBUG - Dauer: 13 ms, 1 Zeilen
2019-02-22T10:07:56 DEBUG - SELECT TOP 1 * FROM tland WHERE tland.cISO3 = 'DE' OR tland.cISO = 'DE'
2019-02-22T10:07:56 DEBUG - Dauer: 2 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [dbo].[tkunde] WHERE [kKunde] = @kKunde
@kKunde = '553'
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 17
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [tbestellpos] WHERE [tBestellung_kBestellung] = @tBestellung_kBestellung ORDER BY tbestellpos.nSort ASC, tbestellpos.kBestellPos ASC
@tBestellung_kBestellung = 4575
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 2 Zeilen
2019-02-22T10:07:58 DEBUG - INSERT INTO [dbo].[tVersandLog] ([kVersand], [dZeitstempel], [nStatus], [cMessage]) VALUES (@kVersand_0, @dZeitstempel_0, @nStatus_0, @cMessage_0); SELECT SCOPE_IDENTITY() AS [Id];
@kVersand_0 = 152
@dZeitstempel_0 = CONVERT(DATETIME, '2019-02-22 10:07:58', 120)
@nStatus_0 = 255
@cMessage_0 = 'Originalmeldung
Meldung: An error occurred when validating input: Folgende Information fehlt: Consignee address mobile phone or email. Bitte geben Sie diese an.
Code: 0004
ID: d690ebd4-11f3-4b9f-bdda-20cc070c10cf'
2019-02-22T10:07:58 DEBUG - Dauer: 9 ms, 1 Zeilen
2019-02-22T10:07:58 DEBUG - UPDATE [dbo].[tVersand] SET cReference = @cReference_0, cShipmentId = @cShipmentId_0, nStatus = @nStatus_0 WHERE kVersand = @kVersand_0;
@cReference_0 = ''
@cShipmentId_0 = ''
@nStatus_0 = 2
@kVersand_0 = 152
2019-02-22T10:07:58 DEBUG - Dauer: 48ms, AffectedRows: 1
2019-02-22T10:07:58 DEBUG - SELECT * FROM [dbo].[tVersand] WHERE [kVersand] = @kVersand
@kVersand = '152'
2019-02-22T10:07:58 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT * FROM [tWorkflow]
2019-02-22T10:09:30 DEBUG - Dauer: 0 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT * FROM [tWorkflow]
2019-02-22T10:09:30 DEBUG - Dauer: 1 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowQueue.*, tWorkflow.nObjekt FROM tWorkflowQueue JOIN tWorkflow ON tWorkflowQueue.kWorkflow = tWorkflow.kWorkflow
WHERE dStartDate >= @from AND dStartDate <= @to
ORDER BY kWorkflowQueue DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - Dauer: 4 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowLog.*, tWorkflowAktion.*, CONVERT(nvarchar(30), tWorkflowLog.dDatum, 21) AS SortDate, isNull(tWorkflow.cName, '') as WorkflowName
FROM tWorkflowLog
LEFT JOIN tWorkflowAktion ON tWorkflowAktion.kWorkflowAktion = tWorkflowLog.kWorkflowAktion
LEFT JOIN tWorkflow ON tWorkflowLog.kWorkflow = tWorkflow.kWorkflow
WHERE dDatum >= @from AND dDatum <= @to
ORDER BY tWorkflowLog.kWorkflowLog DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowQueue.*, tWorkflow.nObjekt FROM tWorkflowQueue JOIN tWorkflow ON tWorkflowQueue.kWorkflow = tWorkflow.kWorkflow
WHERE dStartDate >= @from AND dStartDate <= @to
ORDER BY kWorkflowQueue DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - Dauer: 4 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - Dauer: 19 ms, 0 Zeilen
Zeitstempel: 2019-02-22T10:11:46
Locale: German (Germany)
Locale: German (Germany)
Version: 1.3.21.0
Plattform: Wawi
Versionshash: E54625B
Prozessname: JTL-Wawi
Physikalischer Speicher: 310054912 / Peak: 311578624
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:11,609375
CPU-Zeit (System): 0:00:13,375
Page-Size (Sytem): 1701896 / Peak: 328339456
Page-Size: 315752448 / Peak: 328339456
Offene Handles: 1546
Folgende Fehlermeldung erhalte ich beim Versand:
Unbehandelte Ausnahme #2DB61C542897F240 vom Typ JTL.Shipping.Shared.Exceptions.ShippingException in
JTL.Shipping.Shared.Exceptions.ShippingException: Originalmeldung
Meldung: An error occurred when validating input: Folgende Information fehlt: Consignee address mobile phone or email. Bitte geben Sie diese an.
Code: 0004
ID: d690ebd4-11f3-4b9f-bdda-20cc070c10cf
2019-02-22T10:07:56 DEBUG - Dauer: 13 ms, 1 Zeilen
2019-02-22T10:07:56 DEBUG - SELECT TOP 1 * FROM tland WHERE tland.cISO3 = 'DE' OR tland.cISO = 'DE'
2019-02-22T10:07:56 DEBUG - Dauer: 2 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [dbo].[tkunde] WHERE [kKunde] = @kKunde
@kKunde = '553'
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 17
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:07:57 DEBUG - SELECT * FROM [tbestellpos] WHERE [tBestellung_kBestellung] = @tBestellung_kBestellung ORDER BY tbestellpos.nSort ASC, tbestellpos.kBestellPos ASC
@tBestellung_kBestellung = 4575
2019-02-22T10:07:57 DEBUG - Dauer: 1 ms, 2 Zeilen
2019-02-22T10:07:58 DEBUG - INSERT INTO [dbo].[tVersandLog] ([kVersand], [dZeitstempel], [nStatus], [cMessage]) VALUES (@kVersand_0, @dZeitstempel_0, @nStatus_0, @cMessage_0); SELECT SCOPE_IDENTITY() AS [Id];
@kVersand_0 = 152
@dZeitstempel_0 = CONVERT(DATETIME, '2019-02-22 10:07:58', 120)
@nStatus_0 = 255
@cMessage_0 = 'Originalmeldung
Meldung: An error occurred when validating input: Folgende Information fehlt: Consignee address mobile phone or email. Bitte geben Sie diese an.
Code: 0004
ID: d690ebd4-11f3-4b9f-bdda-20cc070c10cf'
2019-02-22T10:07:58 DEBUG - Dauer: 9 ms, 1 Zeilen
2019-02-22T10:07:58 DEBUG - UPDATE [dbo].[tVersand] SET cReference = @cReference_0, cShipmentId = @cShipmentId_0, nStatus = @nStatus_0 WHERE kVersand = @kVersand_0;
@cReference_0 = ''
@cShipmentId_0 = ''
@nStatus_0 = 2
@kVersand_0 = 152
2019-02-22T10:07:58 DEBUG - Dauer: 48ms, AffectedRows: 1
2019-02-22T10:07:58 DEBUG - SELECT * FROM [dbo].[tVersand] WHERE [kVersand] = @kVersand
@kVersand = '152'
2019-02-22T10:07:58 DEBUG - Dauer: 1 ms, 1 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT * FROM [tWorkflow]
2019-02-22T10:09:30 DEBUG - Dauer: 0 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT * FROM [tWorkflow]
2019-02-22T10:09:30 DEBUG - Dauer: 1 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowQueue.*, tWorkflow.nObjekt FROM tWorkflowQueue JOIN tWorkflow ON tWorkflowQueue.kWorkflow = tWorkflow.kWorkflow
WHERE dStartDate >= @from AND dStartDate <= @to
ORDER BY kWorkflowQueue DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - Dauer: 4 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowLog.*, tWorkflowAktion.*, CONVERT(nvarchar(30), tWorkflowLog.dDatum, 21) AS SortDate, isNull(tWorkflow.cName, '') as WorkflowName
FROM tWorkflowLog
LEFT JOIN tWorkflowAktion ON tWorkflowAktion.kWorkflowAktion = tWorkflowLog.kWorkflowAktion
LEFT JOIN tWorkflow ON tWorkflowLog.kWorkflow = tWorkflow.kWorkflow
WHERE dDatum >= @from AND dDatum <= @to
ORDER BY tWorkflowLog.kWorkflowLog DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - SELECT TOP 1000 tWorkflowQueue.*, tWorkflow.nObjekt FROM tWorkflowQueue JOIN tWorkflow ON tWorkflowQueue.kWorkflow = tWorkflow.kWorkflow
WHERE dStartDate >= @from AND dStartDate <= @to
ORDER BY kWorkflowQueue DESC
from = CONVERT(DATETIME, '2019-02-22 12:00:00', 120)
to = CONVERT(DATETIME, '2019-02-22 11:59:59', 120)
2019-02-22T10:09:30 DEBUG - Dauer: 4 ms, 0 Zeilen
2019-02-22T10:09:30 DEBUG - Dauer: 19 ms, 0 Zeilen
Zeitstempel: 2019-02-22T10:11:46
Locale: German (Germany)
Locale: German (Germany)
Version: 1.3.21.0
Plattform: Wawi
Versionshash: E54625B
Prozessname: JTL-Wawi
Physikalischer Speicher: 310054912 / Peak: 311578624
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:11,609375
CPU-Zeit (System): 0:00:13,375
Page-Size (Sytem): 1701896 / Peak: 328339456
Page-Size: 315752448 / Peak: 328339456
Offene Handles: 1546