Hallo, wir haben JTL in unserem Netzwerk auf einer virtuellen Maschine am Laufen und greifen dann per Remotedesktopverbindung oder teilweise per Teamviewer/Anydesk auf die virtuelle Maschine zu.
Lange Zeit ist die Versandabwicklung inkl. automatischer UPS-Labelerzeugung stabil und fehlerfrei gelaufen. Jetzt plötzlich haben wir ohne dass sich wirklich etwas geändert hat das Problem, dass die JTL API bei der UPS-Labelerzeugung einen Fehler bringt, d.h. es wird kein Label erzeugt/keine Trackingnummer da.
Unser Systemadmin konnte die Ursache bisher nicht eindeutig finden. Wir haben die Rechner und die VM neu gestartet, haben das Zertifikat mehrfach neu installiert auf der VM usw. Nichts hat geholfen, sodass wir teilweise den gesamten Versand von Hand bei UPS einzeln als Versandlabel eingeben müssen
Vielen Dank vorab für eure Hilfe!
Das ist die Fehlermeldung:
Unbehandelte Ausnahme #3B72755701721256 vom Typ System.ServiceModel.CommunicationException in Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
System.ServiceModel.CommunicationException: An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
at System.Net.TlsStream.CallProcessAuthentication(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)
at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.ConnectStream.WriteHeaders(Boolean async)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---
Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at JTL. Shipping.JTLShippingWebAPI.IJtlWebApi.CreateShippingsNew(List`1 packages, EnduserData userData, ShippingServiceProviderType serviceProviderType, TestOrLive testOrLive, String wawiVersion)
at JTL.Shipping.JtlShippingClient.RequestLabelOrReturnLabel(PackageContainerGroup packageContainer, CreateOrRecreate createOrRecreate)
at JTL.Shipping.JtlShippingClient.CreateOrReCreateLabelMultipleTimes(PackageContainerGroup packageContainer, CreateOrRecreate createOrRecreate)
at JTL.Shipping.JtlShippingClient.SeperateAndCreateLabel(PackageContainerGroup wawiPaketGruppe)
at JTL.Shipping.JtlShippingClientWrapper.CreateLabel(IEnumerable`1 pakete, ShippingConfigurationContainer shippingConfigurationContainer)
Unbehandelte Ausnahme #739C96FECB68CB7E vom Typ System.Net.WebException in System.Net.WebResponse GetResponse(): The underlying connection was closed: An unexpected error occurred on a send.
Unbehandelte Ausnahme #8B6832BB687B65A vom Typ System.IO.IOException in Int32 Read(Byte[], Int32, Int32): Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Unbehandelte Ausnahme #5D7970687CD013F9 vom Typ System.Net.Sockets.SocketException in Int32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags): An existing connection was forcibly closed by the remote host
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [dbo].[tkunde] WHERE [kKunde] = @kKunde
@kKunde = '1302'
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 19
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tZahlungsart] WHERE [kZahlungsart] = @kZahlungsart
@kZahlungsart = 14
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tbestellpos] WHERE [tBestellung_kBestellung] = @tBestellung_kBestellung ORDER BY tbestellpos.nSort ASC, tbestellpos.kBestellPos ASC
@tBestellung_kBestellung = 10742
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 3 Zeilen
2023-02-16T10:42:49 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 = 10134
@dZeitstempel_0 = CONVERT(DATETIME, '2023-02-16 10:42:49', 120)
@nStatus_0 = 255
@cMessage_0 = 'An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server.'
2023-02-16T10:42:49 DEBUG - Dauer: 1 ms, 1 Zeilen
2023-02-16T10:42:49 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 = 10135
@dZeitstempel_0 = CONVERT(DATETIME, '2023-02-16 10:42:49', 120)
@nStatus_0 = 255
@cMessage_0 = 'An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server.'
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [tWorkflow]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 2 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [eazybusiness].[dbo].[tbenutzer]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [tWorkflow]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 2 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:56 DEBUG - Dauer: 3 ms, 0 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 0 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:57 DEBUG - Dauer: 6 ms, 0 Zeilen
Zeitstempel: 2023-02-16T10:43:28
Locale: German (Germany)
Locale: English (United States)
Version: 1.2.3.8
Plattform: Wawi
Versionshash: FABD6748
Prozessname: JTL-Wawi
Physikalischer Speicher: 354660352 / Peak: 355307520
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:20,0773287
CPU-Zeit (System): 0:00:08,8296566
Page-Size (Sytem): 1886616 / Peak: 330985472
Page-Size: 255635456 / Peak: 330985472
Offene Handles: 1314
Lange Zeit ist die Versandabwicklung inkl. automatischer UPS-Labelerzeugung stabil und fehlerfrei gelaufen. Jetzt plötzlich haben wir ohne dass sich wirklich etwas geändert hat das Problem, dass die JTL API bei der UPS-Labelerzeugung einen Fehler bringt, d.h. es wird kein Label erzeugt/keine Trackingnummer da.
Unser Systemadmin konnte die Ursache bisher nicht eindeutig finden. Wir haben die Rechner und die VM neu gestartet, haben das Zertifikat mehrfach neu installiert auf der VM usw. Nichts hat geholfen, sodass wir teilweise den gesamten Versand von Hand bei UPS einzeln als Versandlabel eingeben müssen
Vielen Dank vorab für eure Hilfe!
Das ist die Fehlermeldung:
Unbehandelte Ausnahme #3B72755701721256 vom Typ System.ServiceModel.CommunicationException in Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
System.ServiceModel.CommunicationException: An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.FixedSizeReader.ReadPacket(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)
at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)
at System.Net.TlsStream.CallProcessAuthentication(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)
at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.ConnectStream.WriteHeaders(Boolean async)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---
Server stack trace:
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at JTL. Shipping.JTLShippingWebAPI.IJtlWebApi.CreateShippingsNew(List`1 packages, EnduserData userData, ShippingServiceProviderType serviceProviderType, TestOrLive testOrLive, String wawiVersion)
at JTL.Shipping.JtlShippingClient.RequestLabelOrReturnLabel(PackageContainerGroup packageContainer, CreateOrRecreate createOrRecreate)
at JTL.Shipping.JtlShippingClient.CreateOrReCreateLabelMultipleTimes(PackageContainerGroup packageContainer, CreateOrRecreate createOrRecreate)
at JTL.Shipping.JtlShippingClient.SeperateAndCreateLabel(PackageContainerGroup wawiPaketGruppe)
at JTL.Shipping.JtlShippingClientWrapper.CreateLabel(IEnumerable`1 pakete, ShippingConfigurationContainer shippingConfigurationContainer)
Unbehandelte Ausnahme #739C96FECB68CB7E vom Typ System.Net.WebException in System.Net.WebResponse GetResponse(): The underlying connection was closed: An unexpected error occurred on a send.
Unbehandelte Ausnahme #8B6832BB687B65A vom Typ System.IO.IOException in Int32 Read(Byte[], Int32, Int32): Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Unbehandelte Ausnahme #5D7970687CD013F9 vom Typ System.Net.Sockets.SocketException in Int32 Receive(Byte[], Int32, Int32, System.Net.Sockets.SocketFlags): An existing connection was forcibly closed by the remote host
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [dbo].[tkunde] WHERE [kKunde] = @kKunde
@kKunde = '1302'
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tversandart] WHERE [kVersandArt] = @kVersandArt
@kVersandArt = 19
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tZahlungsart] WHERE [kZahlungsart] = @kZahlungsart
@kZahlungsart = 14
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:49 DEBUG - SELECT * FROM [tbestellpos] WHERE [tBestellung_kBestellung] = @tBestellung_kBestellung ORDER BY tbestellpos.nSort ASC, tbestellpos.kBestellPos ASC
@tBestellung_kBestellung = 10742
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 3 Zeilen
2023-02-16T10:42:49 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 = 10134
@dZeitstempel_0 = CONVERT(DATETIME, '2023-02-16 10:42:49', 120)
@nStatus_0 = 255
@cMessage_0 = 'An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server.'
2023-02-16T10:42:49 DEBUG - Dauer: 1 ms, 1 Zeilen
2023-02-16T10:42:49 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 = 10135
@dZeitstempel_0 = CONVERT(DATETIME, '2023-02-16 10:42:49', 120)
@nStatus_0 = 255
@cMessage_0 = 'An error occurred while making the HTTP request to https://api.jtl-shipping.de/JtlWebApi.svc. This could be due to the fact that the server certificate is not configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch of the security binding between the client and the server.'
2023-02-16T10:42:49 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [tWorkflow]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 2 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [eazybusiness].[dbo].[tbenutzer]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 1 Zeilen
2023-02-16T10:42:56 DEBUG - SELECT * FROM [tWorkflow]
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 2 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:56 DEBUG - Dauer: 3 ms, 0 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:56 DEBUG - Dauer: 0 ms, 0 Zeilen
2023-02-16T10:42:56 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, '2023-02-16 12:00:00', 120)
to = CONVERT(DATETIME, '2023-02-16 11:59:59', 120)
2023-02-16T10:42:57 DEBUG - Dauer: 6 ms, 0 Zeilen
Zeitstempel: 2023-02-16T10:43:28
Locale: German (Germany)
Locale: English (United States)
Version: 1.2.3.8
Plattform: Wawi
Versionshash: FABD6748
Prozessname: JTL-Wawi
Physikalischer Speicher: 354660352 / Peak: 355307520
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:00:20,0773287
CPU-Zeit (System): 0:00:08,8296566
Page-Size (Sytem): 1886616 / Peak: 330985472
Page-Size: 255635456 / Peak: 330985472
Offene Handles: 1314