Nach Update von Version 1.1.4.13 auf 1.2.1.0 bei einem Klick auf den Reiter "Artikel" bekomme ich folgende Fehlermeldung. Alle anderen Reiter funktionieren einwandfrei.
http://mixum.eu/sql_fehler.PNG
Unbehandelte Ausnahme #3A46B976C3183D8E vom Typ System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
System.Data.SqlClient.SqlException (0x80131904): Der Benutzer hat nicht die Berechtigung, um diese Aktion auszuführen.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at JTL.Database.DbCommandExtensionsType.Fill(IDbCommand command, IDbResult target, IColumnMapper mapper, IResultSetReaderStrategy multipleResultSets)
at JTL.Database.DbConnectionExtensionsType.<>c__DisplayClass7.<Fill>b__6(IDbConnection con)
at JTL.Database.DbConnectionExtensions.<>c__DisplayClass9`1.<Execute>b__7()
at JTL.Database.DbConnectionExtensions.HandleError[T](IDbConnection connection, Func`1 action)
at JTL.Database.DbConnectionExtensions.Execute[T](IDbConnection connection, Func`2 func)
at JTL.Database.DbConnectionExtensionsType.Fill(IDbConnection connection, IDbResult target, IDbCommand command, MissingPropertiesAction missingPropertiesAction, IResultSetReaderStrategy resultSetReaderStrategy)
at JTL.Database.Commands.Entities.DbFillByQueryCommand.Execute(IDbConnection connection, IDbTransaction transaction)
at jtlDatabase.jtlObjectRepositoryBase.AppendAll[T](IList`1 items, String query, IEnumerable`1 parameters)
at jtlDatabase.jtlObjectList`1.appendListFromDB(String sqlQuery, MissingPropertiesMode handleMissingProperties, jtlDBParameter[] oDBParameter_arr)
at jtlDatabase.jtlObjectList`1.fillListFromDB(String cSQL, Boolean bOverfill, jtlDBParameter[] oDBParameter_arr)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.QueryNewTableUpdateSet(String tableUpdateSqlTemplate, String tableSchema, String legacyDatabaseName, String currentDatabaseName)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.GetTableUpdateSet()
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.GetLastTableModificationTime(List`1 tableNames)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.ValidateCacheItem(ITableRelatedCacheItem cacheItemProxy)
at JTL.Data.DataGateway.Caching.DataGatewayCache.Get[TResult](String key)
at JTL.Data.DataGateway.Caching.DataGatewayCache.Get[TResult](Func`1 functionMethod)
at JTL.Data.DataGateway.Gateways.Benutzer.LayoutDataGateway.GetGlobalGridControlLayout(GridControlLayoutKey gridControlLayoutKey)
at JTL.Domain. Wawi.Services.BenutzerEinstellungen.LayoutService.GetGridControlLayout(BenutzerKey benutzerKey, GridControlLayoutKey layoutKey, String computerName)
at JTL.Wawi.WawiDataGrid.Content.GridControlViewModel`1.aYBAqh3r7x(GridControlLayoutKey )
at JTL.Wawi.WawiDataGrid.Content.GridControlViewModel`1.LoadListLayout(GridControlLayoutKey layoutKey)
at JTL.Wawi.ArtikelVerwaltung.Details.Preise.Details.Wawi.WawiPreiseViewModel.Preload()
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.yg4Wl1Prxu(IContentLoad )
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.j17W3vUAUG()
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.OnNavigatedTo(NavigationContext navigationContext)
at JTL.Infrastructure.Navigation.Navigator.<>c__DisplayClass8.<ExecuteNavigation>b__7(INavigationAware n)
at JTL.Infrastructure.Navigation.Navigator.U9dY43uksE(INavigationAware , Action`1 invocation)
at JTL.Infrastructure.Navigation.Navigator.DvwYTi68cw(NavigationContext , Action`1 navigationCallback, INavigationTarget )
at JTL.Infrastructure.Navigation.Navigator.yWXYx9YmVZ(Uri , NavigationParameters , Action`1 navigationCallback)
at JTL.Infrastructure.Navigation.Navigator.Navigate(Uri target, NavigationParameters navigationParameters, Action`1 navigationCallback)
mfg Alex
http://mixum.eu/sql_fehler.PNG
Unbehandelte Ausnahme #3A46B976C3183D8E vom Typ System.Data.SqlClient.SqlException in Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])
System.Data.SqlClient.SqlException (0x80131904): Der Benutzer hat nicht die Berechtigung, um diese Aktion auszuführen.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at JTL.Database.DbCommandExtensionsType.Fill(IDbCommand command, IDbResult target, IColumnMapper mapper, IResultSetReaderStrategy multipleResultSets)
at JTL.Database.DbConnectionExtensionsType.<>c__DisplayClass7.<Fill>b__6(IDbConnection con)
at JTL.Database.DbConnectionExtensions.<>c__DisplayClass9`1.<Execute>b__7()
at JTL.Database.DbConnectionExtensions.HandleError[T](IDbConnection connection, Func`1 action)
at JTL.Database.DbConnectionExtensions.Execute[T](IDbConnection connection, Func`2 func)
at JTL.Database.DbConnectionExtensionsType.Fill(IDbConnection connection, IDbResult target, IDbCommand command, MissingPropertiesAction missingPropertiesAction, IResultSetReaderStrategy resultSetReaderStrategy)
at JTL.Database.Commands.Entities.DbFillByQueryCommand.Execute(IDbConnection connection, IDbTransaction transaction)
at jtlDatabase.jtlObjectRepositoryBase.AppendAll[T](IList`1 items, String query, IEnumerable`1 parameters)
at jtlDatabase.jtlObjectList`1.appendListFromDB(String sqlQuery, MissingPropertiesMode handleMissingProperties, jtlDBParameter[] oDBParameter_arr)
at jtlDatabase.jtlObjectList`1.fillListFromDB(String cSQL, Boolean bOverfill, jtlDBParameter[] oDBParameter_arr)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.QueryNewTableUpdateSet(String tableUpdateSqlTemplate, String tableSchema, String legacyDatabaseName, String currentDatabaseName)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.GetTableUpdateSet()
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.GetLastTableModificationTime(List`1 tableNames)
at JTL.Data.DataGateway.Gateways.Caching.TableSetChacheItemValidator.ValidateCacheItem(ITableRelatedCacheItem cacheItemProxy)
at JTL.Data.DataGateway.Caching.DataGatewayCache.Get[TResult](String key)
at JTL.Data.DataGateway.Caching.DataGatewayCache.Get[TResult](Func`1 functionMethod)
at JTL.Data.DataGateway.Gateways.Benutzer.LayoutDataGateway.GetGlobalGridControlLayout(GridControlLayoutKey gridControlLayoutKey)
at JTL.Domain. Wawi.Services.BenutzerEinstellungen.LayoutService.GetGridControlLayout(BenutzerKey benutzerKey, GridControlLayoutKey layoutKey, String computerName)
at JTL.Wawi.WawiDataGrid.Content.GridControlViewModel`1.aYBAqh3r7x(GridControlLayoutKey )
at JTL.Wawi.WawiDataGrid.Content.GridControlViewModel`1.LoadListLayout(GridControlLayoutKey layoutKey)
at JTL.Wawi.ArtikelVerwaltung.Details.Preise.Details.Wawi.WawiPreiseViewModel.Preload()
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.yg4Wl1Prxu(IContentLoad )
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.j17W3vUAUG()
at JTL.Wawi.Mvvm.ViewModels.NavigationAwareViewModel.OnNavigatedTo(NavigationContext navigationContext)
at JTL.Infrastructure.Navigation.Navigator.<>c__DisplayClass8.<ExecuteNavigation>b__7(INavigationAware n)
at JTL.Infrastructure.Navigation.Navigator.U9dY43uksE(INavigationAware , Action`1 invocation)
at JTL.Infrastructure.Navigation.Navigator.DvwYTi68cw(NavigationContext , Action`1 navigationCallback, INavigationTarget )
at JTL.Infrastructure.Navigation.Navigator.yWXYx9YmVZ(Uri , NavigationParameters , Action`1 navigationCallback)
at JTL.Infrastructure.Navigation.Navigator.Navigate(Uri target, NavigationParameters navigationParameters, Action`1 navigationCallback)
mfg Alex
Zuletzt von einem Moderator bearbeitet: