Bei mir nicht.
Poste mal das Fehlerprotokoll.
Beim Klick auf welchen Button kommt der Fehler genau?
Sobald ich auf den Button "Filter laden" klicke.
Unbehandelte Ausnahme #2AB12071EE72822 vom Typ System.Data.SqlClient.SqlException in Void .ctor(System.Data.ProviderBase.DbConnectionPoolIdentity, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SqlCredential, System.Object, System.String, System.Security.SecureString, Boolean, System.Data.SqlClient.SqlConnectionString, System.Data.SqlClient.SessionData, System.Data.ProviderBase.DbConnectionPool, System.String, Boolean, System.Data.SqlClient.SqlAuthenticationProviderManager)
System.Data.SqlClient.SqlException (0x80131904): Fehler bei der Anmeldung für den Benutzer "sa".
bei System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
bei System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
bei System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
bei System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
bei System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
bei System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
bei System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
bei System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
bei System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
bei System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
bei System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
bei System.Data.SqlClient.SqlConnection.Open()
bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
bei jtlCore.Forms.ErweiterteSuche.Filter_laden.Filter_laden_Load(Object sender, EventArgs e)
bei System.Windows.Forms.Form.OnLoad(EventArgs e)
bei System.Windows.Forms.Form.OnCreateControl()
bei System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
bei System.Windows.Forms.Control.CreateControl()
bei System.Windows.Forms.Control.WmShowWindow(Message& m)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.Form.WmShowWindow(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId:fe21d850-4a33-4b17-9a5e-0f33fc5793c4
Fehlernummer (Error Number):18456,Status (State):1,Klasse (Class):14
SQL-Fehlerinformationen: [(local)\JTLWAWI .Net SqlClient Data Provider] Fehler #18456 (Klasse 14) in Zeile 65536: Fehler bei der Anmeldung für den Benutzer "sa".
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 18456
HelpLink.BaseHelpUrl =
http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
2024-12-25T16:59:10 DEBUG - Dauer: 1ms, Result: {}
2024-12-25T16:59:22 DEBUG - IF OBJECT_ID('dbo.tErrorlog', 'U') IS NULL SELECT 0 ELSE SELECT 1;
2024-12-25T16:59:22 DEBUG - Dauer: 0ms, Result: 1
2024-12-25T16:59:22 DEBUG - SELECT TOP 1 * FROM dbo.tErrorlog WHERE cRechnername = @cRechnername AND nFehlerID = @nFehlerID ORDER BY dErstelltUtc ASC
@cRechnername = 'LENOVO'
@nFehlerID = 192267230885914658
2024-12-25T16:59:22 DEBUG - Dauer: 2ms, (bis zum Reader)
2024-12-25T16:59:22 DEBUG - Dauer: 4ms, 1 Zeilen
2024-12-25T16:59:22 DEBUG - UPDATE [dbo].[tErrorlog] SET dErstelltUtc = @dErstelltUtc_0 WHERE kErrorlog = @kErrorlog_0;
@dErstelltUtc_0 = '2024-12-25 03:59:22'
@kErrorlog_0 = 35
2024-12-25T16:59:22 DEBUG - Dauer: 1ms, AffectedRows: 1
2024-12-25T16:59:26 DEBUG - SELECT [tUserSession].[kUserSession]
,[tUserSession].[kOwnerUserSession]
,[tUserSession].[kBenutzer]
,[tUserSession].[kMandant]
,[tUserSession].[iApplicationId]
,[tUserSession].[cCustomIdentifier]
,[tUserSession].[cHostname]
,[tUserSession].[nProcessId]
,[tUserSession].[dLoggedIn]
,[tUserSession].[dLastHeartbeat]
,[tUserSession].[nIsSessionInterruptible]
,[tUserSession].[nSessionInterruptRequested]
,[tUserSession].[dSessionInterruptRequestTimestamp]
,[tUserSession].[cSessionInterruptHostname]
,[tUserSession].[kSessionInterruptBenutzer]
,[tUserSession].[iSessionInterruptMessage]
,[tUser].[cName] AS [cBenutzerName]
,[tMandant].[cName] AS [cMandantName]
,[tUserInterrupt].[cName] AS [cBenutzerNameInterrupt]
FROM [eazybusiness].[dbo].[tUserSession]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUser ON [tUserSession].[kBenutzer] = [tUser].[kBenutzer]
LEFT JOIN [eazybusiness].[dbo].[tMandant] ON [tUserSession].[kMandant] = [tMandant].[kMandant]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUserInterrupt ON [tUserSession].[kSessionInterruptBenutzer] = [tUserInterrupt].[kBenutzer]
WHERE [tUserSession].[kUserSession] = @kUserSession AND dSessionInvalidated IS NULL
@kUserSession = 5271
2024-12-25T16:59:26 DEBUG - Dauer: 0ms, (bis zum Reader)(A)
2024-12-25T16:59:26 DEBUG - Dauer: 0 ms, 1 Zeilen
2024-12-25T16:59:26 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;
@dLastHeartbeat_0 = 12/25/2024 16:59:26 +01:00
@kUserSession_0 = 5271
2024-12-25T16:59:26 DEBUG - Dauer: 11ms, AffectedRows: 1
2024-12-25T17:00:26 DEBUG - SELECT [tUserSession].[kUserSession]
,[tUserSession].[kOwnerUserSession]
,[tUserSession].[kBenutzer]
,[tUserSession].[kMandant]
,[tUserSession].[iApplicationId]
,[tUserSession].[cCustomIdentifier]
,[tUserSession].[cHostname]
,[tUserSession].[nProcessId]
,[tUserSession].[dLoggedIn]
,[tUserSession].[dLastHeartbeat]
,[tUserSession].[nIsSessionInterruptible]
,[tUserSession].[nSessionInterruptRequested]
,[tUserSession].[dSessionInterruptRequestTimestamp]
,[tUserSession].[cSessionInterruptHostname]
,[tUserSession].[kSessionInterruptBenutzer]
,[tUserSession].[iSessionInterruptMessage]
,[tUser].[cName] AS [cBenutzerName]
,[tMandant].[cName] AS [cMandantName]
,[tUserInterrupt].[cName] AS [cBenutzerNameInterrupt]
FROM [eazybusiness].[dbo].[tUserSession]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUser ON [tUserSession].[kBenutzer] = [tUser].[kBenutzer]
LEFT JOIN [eazybusiness].[dbo].[tMandant] ON [tUserSession].[kMandant] = [tMandant].[kMandant]
LEFT JOIN [eazybusiness].[dbo].[tBenutzer] tUserInterrupt ON [tUserSession].[kSessionInterruptBenutzer] = [tUserInterrupt].[kBenutzer]
WHERE [tUserSession].[kUserSession] = @kUserSession AND dSessionInvalidated IS NULL
@kUserSession = 5271
2024-12-25T17:00:26 DEBUG - Dauer: 0ms, (bis zum Reader)(A)
2024-12-25T17:00:26 DEBUG - Dauer: 0 ms, 1 Zeilen
2024-12-25T17:00:26 DEBUG - UPDATE [eazybusiness].[dbo].[tUserSession] SET dLastHeartbeat = @dLastHeartbeat_0 WHERE kUserSession = @kUserSession_0;
@dLastHeartbeat_0 = 12/25/2024 17:00:26 +01:00
@kUserSession_0 = 5271
2024-12-25T17:00:26 DEBUG - Dauer: 11ms, AffectedRows: 1
2024-12-25T17:00:56 DEBUG - IF OBJECT_ID('dbo.tErrorlog', 'U') IS NULL SELECT 0 ELSE SELECT 1;
2024-12-25T17:00:56 DEBUG - Dauer: 0ms, Result: 1
2024-12-25T17:00:56 DEBUG - SELECT TOP 1 * FROM dbo.tErrorlog WHERE cRechnername = @cRechnername AND nFehlerID = @nFehlerID ORDER BY dErstelltUtc ASC
@cRechnername = 'LENOVO'
@nFehlerID = 192267230885914658
2024-12-25T17:00:56 DEBUG - Dauer: 0ms, (bis zum Reader)
2024-12-25T17:00:56 DEBUG - Dauer: 0ms, 1 Zeilen
2024-12-25T17:00:56 DEBUG - UPDATE [dbo].[tErrorlog] SET dErstelltUtc = @dErstelltUtc_0 WHERE kErrorlog = @kErrorlog_0;
@dErstelltUtc_0 = '2024-12-25 04:00:56'
@kErrorlog_0 = 35
2024-12-25T17:00:56 DEBUG - Dauer: 0ms, AffectedRows: 1
Zeitstempel: 2024-12-25T17:01:11
Locale: German (Germany)
Locale: German (Germany)
Version: Der Wert wurde nicht erstellt.
Plattform:
Wawi
WawiSeed: 6.4.11349.50801
Prozessname: JTL-SharpWawi
Physikalischer Speicher: 1418973184 / Peak: 1422876672
Basispriorität: 8
Prioritätsklasse: Normal
CPU-Zeit (User): 0:02:01,5
CPU-Zeit (System): 0:00:22,671875
Page-Size (Sytem): 2541216 / Peak: 1233117184
Page-Size: 1207234560 / Peak: 1233117184
Offene Handles: 3369
Database:
Build: 2411271603 00545d74c8e5ee811b2aa21cb6f4a35ad0e8dfe0
