search

serilog-contrib / serilog-ui

Simple Serilog log viewer UI for several sinks.
MIT License
226 stars 42 forks source link

"Invalid column name 'Properties'." at Serilog UI Home Page, when removeStandardColumns: Properties. #140

Closed rickizud closed 2 months ago

rickizud commented 3 months ago

Describe the bug

Expected behavior

Exception Logs Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Properties'.\r\n at Microsoft.Data.SqlClient.SqlCommand.<>c.b__195_0(Task1 result)\r\n at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()\r\n at System.Threading.Tasks.Task.<>c.<.cctor>b__2810(Object obj)\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n--- End of stack trace from previous location ---\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\r\n--- End of stack trace from previous location ---\r\n at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in //Dapper/SqlMapper.Async.cs:line 434\r\n at Serilog.Ui.MsSqlServerProvider.SqlServerDataProvider1.GetLogsAsync(FetchLogsQuery queryParams)\r\n at Serilog.Ui.MsSqlServerProvider.SqlServerDataProvider1.FetchDataAsync(FetchLogsQuery queryParams, CancellationToken cancellationToken)\r\n at Serilog.Ui.Web.Endpoints.SerilogUiEndpoints.FetchLogsAsync(HttpContext httpContext)\r\n at Serilog.Ui.Web.Endpoints.SerilogUiEndpoints.GetLogsAsync()

followynne commented 3 months ago

@rickizud

can I ask you the version you're using of Serilog.UI?

rickizud commented 2 months ago

@rickizud

can I ask you the version you're using of Serilog.UI?

Latest v3.0.1

rickizud commented 2 months ago

Are u able to load the logs at Serilog-UI Home page? If ur logs table without Properties column.

followynne commented 2 months ago

Hello @rickizud

sorry for the late answer. I tried with the sample app we provide in the repository and it's working.

To correctly configure the property exclusion, please follow these steps.

If you want to check an example for MSSQL, you can see this sample.

Let me know if you have any other doubt, otherwise I'll close the issue!

Regards