ASP.NET web site fail to critical error in ETL of Excel file

Question

I have a website with a single web page on ASP.NET that you need to upload a file in Excel to a folder within the website, extract its contents to insert the data into a table in a database in SQL Server.

When testing its operation on the production web server it shows an error that prevents the process from being carried out in its entirety, the process involved is w3wp.exe; in addition, it can stop the IIS Connection Pool from working.

Error message extracted from Event Viewer

Faulting application name: w3wp.exe, version: 10.0.20348.1, time stamp: 0x405e4c14 Faulting module name: KERNELBASE.dll, version: 10.0.20348.2849, time stamp: 0x6f1cf41e Exception code: 0xe06d7363 Fault offset: 0x000000000003f14c Faulting process id: 0x244c Faulting application start time: 0x01db66a8a60c7bba Faulting application path: c:\windows\system32\inetsrv\w3wp.exe Faulting module path: C:\Windows\System32\KERNELBASE.dll Report Id: 7629be57-6b8a-4716-a8bb-1a20a06c196a Faulting package full name: Faulting package-relative application ID:

 Information message extracted from Event Viewer

Fault bucket , type 0

Event Name: APPCRASH Response: Not available Cab Id: 0   Problem signature: P1: w3wp.exe P2: 10.0.20348.1 P3: 405e4c14 P4: KERNELBASE.dll P5: 10.0.20348.2849 P6: 6f1cf41e P7: e06d7363 P8: 000000000003f14c P9: P10:   Attached files: \?\C:\Windows\TEMP{92305F1D-6BC3-4152-BEDF-76413C6DB647} - OProcSessId.dat \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.c24ade36-f592-4060-aa94-fdb7b6e22aac.tmp.dmp \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.eaad08b4-6009-4835-81aa-2634acdfff4c.tmp.WERInternalMetadata.xml \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.147aa031-b06a-4e53-b5a2-ea499d9c142c.tmp.xml \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.ddec9d82-81d1-4eda-bfb5-a7c7c5842f51.tmp.csv \?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER.f51658fe-fcbf-4ba7-8ccd-070c4feb37ef.tmp.txt   These files may be available here:     Analysis symbol: Rechecking for solution: 0 Report Id: a6f7dcd2-17f7-46c9-b145-0024196c1a15 Report Status: 134217728 Hashed bucket: Cab Guid: 0

Software Development Context

• Web page in ASP.NET Classic
• Code behind VB.NET
• .NET Framework 4.8
• Ajax control toolkit ver. 20
• IIS - Internet Information Server ver. 21H2
• IIS – Pool connection, ver .NET CLR v4.0
• SQL Server 2019 (RTM) - 15.0.2000.5 (X64)   Standard Edition (64-bit)
• Windows Server 2022 Standard 10.0

Description of development

ETL of an Excel file to bring its contents to a SQL SERVER table using:

• OleDbConnection y OleDbCommand (System.Data.OleDb) to extract dato from Excel file.
• Data table (System.Data) to perform transformations on the data in memory.
• SqlBulkCopy to perform the mass loading of existing data in Data table to a table in SQL Server.

Other settings

• Add TRY CATCH to log error messages to a plain text file located in the LOGS folder of the website.
• Creation of UPLOADS folder where the Excel files uploaded to the website will be located.
• Assign Read, Write and Read & Execute permissions to the UPLOADS folder to the DefaultAppPool account (IIS APPPOOL\DefaultAppPool)
• IIS – Application Pools, name: DefaultAppPool; process model – Identity: ApplicationPoolIdentity 

Tests performed

• Successful test from local development environment in Visual Studio connecting to local database.
• Successful test from website published in local IIS in development environment connecting to local database.
• Successful test from local development environment in Visual Studio connecting to production environment database located on another server.
• IDE Visual Studio 2022

Answer 1

W3wp.exe is the process that host the app domain. As your code is crashing you can not catch the error. You should look at the crash dump file for more information. A crash recycles the app pool.

crashes are typically caused by native code. You could add some trace code.