Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community

AIP Scanner - SQL exception in log

Copper Contributor

Hi,

 

I have AIP scanner job scanning around 114 repository. Scan job runs perfectly for first 20+ days. After that i see SQL exception in AIPscanner log and the  'TotalScannedFiles' is either 0 or same count repeats.

Then i had to create a new Database instance, start scan and again SQL error comes up in log after 20+ days. This has been the trend for last 4 months. PFB SQL error trace log and let me know a solution to overcome this so that scan job can get completed. 

 

"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."

 

NOTE: MSSQL timeout is set to 0. There was no server reboot or service restart done when scan job was running.

 

AIP UL version: 2.12.62.0

0 Replies