hello,

i am using auto service where i am calling stored procedures in try and catch block

try
{
    // auto start bidding if start time is passed
    db.sp_Auction_Start_FirstTime_Bot();
}
catch (Exception ex)
{
    WriteToFile(DateTime.Now + "Error db.sp_Auction_Start_FirstTime_Bot()=" + ex.InnerException.GetType().Name);
}

many time logs shows this error in execution but how to get exact error so i can trace it, the below error through try and catch is very generic i cannot trace the actual issue

1/7/2021 1:52:33 PMError   db.sp_Auction_Winner_Update()=SqlException
1/7/2021 1:52:34 PMError   db.sp_Auction_Start_FirstTime_Bot()=SqlException
1/7/2021 1:52:34 PMError   db.sp_Auction_Ebid_Insert()=SqlException
1/7/2021 1:52:34 PMError   db.sp_Auction_CSS_Timer()=SqlException
1/7/2021 1:52:34 PMError   db.sp_Auction_Ebid_Insert()=InvalidOperationException