You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was testing this program, and I get a SqlTraceException. It appears to look for ordinal "DatabaseID", but doesn't find it. It throws an exception and hangs after execution. Below is the stack trace.
It is not clear what is causing this error. I am unsure if it is a bug in the system or if it is user error (using a invalid trace file).
What would be the cause of this and how would I fix this error?
Thanks,
Paul Wowk
Microsoft.SqlServer.Management.Trace.SqlTraceException was unhandled by user code
HResult=-2146233088
Message=Failed to find column ordinal.
Source=Microsoft.SqlServer.ConnectionInfoExtended
StackTrace:
at Microsoft.SqlServer.Management.Trace.TraceReader.GetOrdinal(String name)
at SqlPermissions.Core.Utility.DataExtensions.TryGetOrdinal(IDataRecord record, String fieldName, Nullable1& ordinal) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Utility\DataExtensions.cs:line 234 at SqlPermissions.Core.Trace.Event.LogoutEventLoaderInfo..ctor(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\LogoutEventLoaderInfo.g.cs:line 37 at SqlPermissions.Core.Trace.Event.EventFactory.<.cctor>b__4(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\EventFactory.g.cs:line 42 at SqlPermissions.Core.Trace.Event.EventFactory.Build(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\EventFactory.cs:line 82 at SqlPermissions.Core.Trace.TraceSource.<>c__DisplayClass6.<GetEvents>b__4(IObserver1 o, CancellationToken c) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\TraceSource.cs:line 95
at System.Reactive.Linq.QueryLanguage.<>c__DisplayClass1f31.<Create>b__1f1(IObserver1 observer)
at System.Reactive.AnonymousObservable1.SubscribeCore(IObserver1 observer)
at System.Reactive.ObservableBase1.Subscribe(IObserver1 observer)
InnerException:
The text was updated successfully, but these errors were encountered:
I was testing this program, and I get a SqlTraceException. It appears to look for ordinal "DatabaseID", but doesn't find it. It throws an exception and hangs after execution. Below is the stack trace.
It is not clear what is causing this error. I am unsure if it is a bug in the system or if it is user error (using a invalid trace file).
What would be the cause of this and how would I fix this error?
Thanks,
Paul Wowk
Microsoft.SqlServer.Management.Trace.SqlTraceException was unhandled by user code
HResult=-2146233088
Message=Failed to find column ordinal.
Source=Microsoft.SqlServer.ConnectionInfoExtended
StackTrace:
at Microsoft.SqlServer.Management.Trace.TraceReader.GetOrdinal(String name)
at SqlPermissions.Core.Utility.DataExtensions.TryGetOrdinal(IDataRecord record, String fieldName, Nullable
1& ordinal) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Utility\DataExtensions.cs:line 234 at SqlPermissions.Core.Trace.Event.LogoutEventLoaderInfo..ctor(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\LogoutEventLoaderInfo.g.cs:line 37 at SqlPermissions.Core.Trace.Event.EventFactory.<.cctor>b__4(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\EventFactory.g.cs:line 42 at SqlPermissions.Core.Trace.Event.EventFactory.Build(IDataRecord record) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\Event\EventFactory.cs:line 82 at SqlPermissions.Core.Trace.TraceSource.<>c__DisplayClass6.<GetEvents>b__4(IObserver
1 o, CancellationToken c) in c:\Users\pvwowk\Source\Repos\sqlperms\SqlPermissions.Core\Trace\TraceSource.cs:line 95at System.Reactive.Linq.QueryLanguage.<>c__DisplayClass1f3
1.<Create>b__1f1(IObserver
1 observer)at System.Reactive.AnonymousObservable
1.SubscribeCore(IObserver
1 observer)at System.Reactive.ObservableBase
1.Subscribe(IObserver
1 observer)InnerException:
The text was updated successfully, but these errors were encountered: