.net调试“HTTP Error 500.23 - Internal Server Error”错误解决方法

本文提供了解决.NET项目中HTTPError500.23-InternalServerError错误的两种方法:改变应用程序池设置和修改程序池名称。通过在IIS中调整设置,可以有效地解决此常见的HTTP内部服务器错误。

调试.net时,HTTP Error 500.23 - Internal Server Error,这个错误的发生率挺高。解决方法如下,共两种方法:

一、改变用程序池。

1、打开IIS,在右侧打开高级设置,即Advanced Setting

2、选择应用程序池,即Application pool ,然后把应用程序池选择为Classic .Net AppPool即可。

二、改变用程序池名字。

1、找到对应的 应用程序池(Application pool )的名字,我这里是 demo在IIS主页,找到 "Application Pools"。

2、在中间列表中打开 "demo",将 Managed pipeline mode 由 Integrated 改为 Classic 即可。

INFO 2025-07-23 15:24:56,497 [161 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.0 POST http://13.85.254.9:8166/api/services/app/DataImportService/ImportDataFileAsync multipart/form-data; boundary=----WebKitFormBoundaryJB846y1an0UYVNYV 12811 INFO 2025-07-23 15:24:56,498 [161 ] pNetCore.Cors.Infrastructure.CorsService - Policy execution failed. INFO 2025-07-23 15:24:56,498 [161 ] pNetCore.Cors.Infrastructure.CorsService - Request origin http://localhost:8090 does not have permission to access the resource. INFO 2025-07-23 15:24:56,498 [161 ] uthentication.JwtBearer.JwtBearerHandler - Successfully validated the token. INFO 2025-07-23 15:24:56,502 [ion:0] ore.Mvc.Internal.ControllerActionInvoker - Route matched with {area = "app", action = "ImportDataFileAsync", controller = "DataImportService"}. Executing action Zebra.Data.DataImportService.ImportDataFileAsync (Zebra.Application) INFO 2025-07-23 15:24:56,502 [ion:0] pNetCore.Cors.Infrastructure.CorsService - Policy execution failed. INFO 2025-07-23 15:24:56,502 [ion:0] pNetCore.Cors.Infrastructure.CorsService - Request origin http://localhost:8090 does not have permission to access the resource. INFO 2025-07-23 15:24:56,503 [ion:0] uthorization.DefaultAuthorizationService - Authorization was successful. INFO 2025-07-23 15:24:56,503 [ion:0] Abp.Logging.LogHelper - The Root Path:D:\Suncere\Web服务\pub-exe INFO 2025-07-23 15:24:56,503 [ion:0] Abp.Logging.LogHelper - NOT DEBUG INFO 2025-07-23 15:24:56,505 [ion:0] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Zebra.Data.DataImportService.ImportDataFileAsync (Zebra.Application) with arguments (Microsoft.AspNetCore.Http.Internal.FormFile) - Validation state: Valid ERROR 2025-07-23 15:24:56,514 [161 ] Zebra.Web.Core.Mvc.ZebraExceptionFilter - Sheet index (1) is out of range (0..0) System.ArgumentException: Sheet index (1) is out of range (0..0) at Zebra.Data.DataImportService.ImportDataFileAsync(IFormFile file) in F:\海南\HaiNanSystem\【XC-201901148】海南省环境空气质量联网建设项目\源码\Trunk\城市平台(源于新框架84121)\src\Zebra.Application\Data\DataImportService.cs:line 363 at lambda_method(Closure , Object ) at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync() at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync() INFO 2025-07-23 15:24:56,518 [161 ] .Mvc.Infrastructure.ObjectResultExecutor - Executing ObjectResult, writing value of type 'Abp.Web.Models.AjaxResponse'. INFO 2025-07-23 15:24:56,518 [161 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Zebra.Data.DataImportService.ImportDataFileAsync (Zebra.Application) in 15.962ms INFO 2025-07-23 15:24:56,518 [161 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 21.0612ms 500 application/json; charset=utf-8 导入失败,分析报错
07-24
2025-09-18 09:47:38.200 [reactor-http-nio-2] DEBUG io.netty.buffer.AbstractByteBuf - -Dio.netty.buffer.checkAccessible: true 2025-09-18 09:47:38.200 [reactor-http-nio-2] DEBUG io.netty.buffer.AbstractByteBuf - -Dio.netty.buffer.checkBounds: true 2025-09-18 09:47:38.200 [reactor-http-nio-2] DEBUG io.netty.util.ResourceLeakDetectorFactory - Loaded default ResourceLeakDetector: io.netty.util.ResourceLeakDetector@7e881c36 2025-09-18 09:47:38.243 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [c658418b, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] New http connection, requesting read 2025-09-18 09:47:38.243 [reactor-http-nio-2] DEBUG reactor.netty.transport.TransportConfig - [c658418b, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] Initialized pipeline DefaultChannelPipeline{(reactor.left.httpCodec = io.netty.handler.codec.http.HttpServerCodec), (reactor.left.httpTrafficHandler = reactor.netty.http.server.HttpTrafficHandler), (reactor.right.reactiveBridge = reactor.netty.channel.ChannelOperationsHandler)} 2025-09-18 09:47:38.251 [reactor-http-nio-2] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.maxCapacityPerThread: 4096 2025-09-18 09:47:38.251 [reactor-http-nio-2] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.ratio: 8 2025-09-18 09:47:38.251 [reactor-http-nio-2] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.chunkSize: 32 2025-09-18 09:47:38.251 [reactor-http-nio-2] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.blocking: false 2025-09-18 09:47:38.251 [reactor-http-nio-2] DEBUG io.netty.util.Recycler - -Dio.netty.recycler.batchFastThreadLocalOnly: true 2025-09-18 09:47:38.288 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [c658418b, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] Increasing pending responses, now 1 2025-09-18 09:47:38.299 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServer - [c658418b-1, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@721f3cd7 2025-09-18 09:47:38.337 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [c658418b-1] HTTP POST "/master/transportTime/add" 2025-09-18 09:47:38.364 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [c658418b-1] Mapped to com.hvlink.controller.TransportTimeController#insert(TransportTimeDTO) 2025-09-18 09:47:38.381 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [c658418b-1] Content-Type:application/json 2025-09-18 09:47:38.391 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [c658418b-1] 0..1 [com.hvlink.entity.dto.TransportTimeDTO] 2025-09-18 09:47:38.411 [reactor-http-nio-2] DEBUG reactor.netty.channel.FluxReceive - [c658418b-1, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] [terminated=false, cancelled=false, pending=0, error=null]: subscribing inbound receiver 2025-09-18 09:47:38.431 [reactor-http-nio-2] DEBUG o.s.http.codec.json.Jackson2JsonDecoder - [c658418b-1] Decoded [TransportTimeDTO(id=null, companyCode=null, supplierCode=null, factoryCode=null, warehouseCode=null, (truncated)...] 2025-09-18 09:47:38.449 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [com.hvlink.service.impl.TransportTimeServiceImpl.insert]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT 2025-09-18 09:47:38.645 [reactor-http-nio-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited 2025-09-18 09:47:39.108 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [ConnectionID:1 ClientConnectionId: 69f1048c-e727-4578-a768-9bd8edc01bc9] for JDBC transaction 2025-09-18 09:47:39.112 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [ConnectionID:1 ClientConnectionId: 69f1048c-e727-4578-a768-9bd8edc01bc9] to manual commit 2025-09-18 09:47:39.140 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-09-18 09:47:39.152 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] 2025-09-18 09:47:39.189 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 69f1048c-e727-4578-a768-9bd8edc01bc9] will be managed by Spring 2025-09-18 09:47:39.192 [reactor-http-nio-2] DEBUG c.h.m.master.TransportTimeMapper.existsByCodes - ==> Preparing: SELECT CASE WHEN EXISTS ( SELECT 1 FROM tm_transport_time ) THEN 1 ELSE 0 END 2025-09-18 09:47:39.223 [reactor-http-nio-2] DEBUG c.h.m.master.TransportTimeMapper.existsByCodes - ==> Parameters: 2025-09-18 09:47:39.260 [reactor-http-nio-2] DEBUG c.h.m.master.TransportTimeMapper.existsByCodes - <== Total: 1 2025-09-18 09:47:39.272 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] 2025-09-18 09:47:39.303 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] from current transaction 2025-09-18 09:47:39.312 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.TransportTimeMapper.insert - ==> Preparing: INSERT INTO tm_transport_time ( transport_time, is_deleted, create_by, create_time, update_by, update_time ) VALUES ( ?, ?, ?, ?, ?, ? ) 2025-09-18 09:47:39.338 [reactor-http-nio-2] DEBUG c.hvlink.mapper.master.TransportTimeMapper.insert - ==> Parameters: 49.0(Double), false(Boolean), admin(String), 2025-09-18 09:47:39.301(Timestamp), admin(String), 2025-09-18 09:47:39.301(Timestamp) 2025-09-18 09:47:39.374 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] 2025-09-18 09:47:39.462 [reactor-http-nio-2] DEBUG o.s.beans.factory.xml.XmlBeanDefinitionReader - Loaded 11 bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 2025-09-18 09:47:39.463 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'DB2' 2025-09-18 09:47:39.467 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Derby' 2025-09-18 09:47:39.467 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'H2' 2025-09-18 09:47:39.468 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'HDB' 2025-09-18 09:47:39.469 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'HSQL' 2025-09-18 09:47:39.470 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Informix' 2025-09-18 09:47:39.470 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MS-SQL' 2025-09-18 09:47:39.470 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'MySQL' 2025-09-18 09:47:39.471 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Oracle' 2025-09-18 09:47:39.471 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'PostgreSQL' 2025-09-18 09:47:39.472 [reactor-http-nio-2] DEBUG o.s.b.factory.support.DefaultListableBeanFactory - Creating shared instance of singleton bean 'Sybase' 2025-09-18 09:47:39.472 [reactor-http-nio-2] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - Looking up default SQLErrorCodes for DataSource [com.hvlink.config.DataSourceConfig$1@23ee2ccf] 2025-09-18 09:47:39.484 [reactor-http-nio-2] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - SQL error codes for 'Microsoft SQL Server' found 2025-09-18 09:47:39.484 [reactor-http-nio-2] DEBUG o.s.jdbc.support.SQLErrorCodesFactory - Caching SQL error codes for DataSource [com.hvlink.config.DataSourceConfig$1@23ee2ccf]: database product name is 'Microsoft SQL Server' 2025-09-18 09:47:39.486 [reactor-http-nio-2] DEBUG o.s.j.support.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '515', will now try the fallback translator 2025-09-18 09:47:39.486 [reactor-http-nio-2] DEBUG o.s.jdbc.support.SQLStateSQLExceptionTranslator - Extracted SQL state class '23' from value '23000' 2025-09-18 09:47:39.488 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] 2025-09-18 09:47:39.489 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@17d2ae20] 2025-09-18 09:47:39.490 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback 2025-09-18 09:47:39.490 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [ConnectionID:1 ClientConnectionId: 69f1048c-e727-4578-a768-9bd8edc01bc9] 2025-09-18 09:47:39.515 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [ConnectionID:1 ClientConnectionId: 69f1048c-e727-4578-a768-9bd8edc01bc9] after transaction 2025-09-18 09:47:39.523 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [c658418b-1] Using 'application/json' given [application/json, text/plain, */*] and supported [application/json, application/*+json, application/x-ndjson, text/event-stream] 2025-09-18 09:47:39.524 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [c658418b-1] 0..1 [com.hvlink.common.Result<java.lang.String>] 2025-09-18 09:47:39.533 [reactor-http-nio-2] DEBUG o.s.http.codec.json.Jackson2JsonEncoder - [c658418b-1] Encoding [Result(status=500, msg=<EOL><EOL>### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServer (truncated)...] 2025-09-18 09:47:39.564 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [c658418b-1, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] Detected non persistent http connection, preparing to close 2025-09-18 09:47:39.599 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [c658418b-1, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] Last HTTP packet was sent, terminating the channel 2025-09-18 09:47:39.599 [reactor-http-nio-2] DEBUG reactor.netty.channel.ChannelOperations - [c658418b-1, L:/192.168.10.122:9000 - R:/192.168.10.221:63369] [HttpServer] Channel inbound receiver cancelled (operation cancelled). 2025-09-18 09:47:39.634 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [c658418b-1] Completed 200 OK
最新发布
09-19
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值