------------------------------------------- 4/20/2022 3:55:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 3:55:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:22:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:22:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:49:33 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:49:33 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:53:29 AM DistributorClass Class, Search Function ### Before Search ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 4:55:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 4:55:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 5:04:16 AM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 5:22:55 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 5:22:55 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 5:25:17 AM GenClass Class, AssignToDropDown Function ### After ExecuteReader ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 5:25:24 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 5:25:28 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() 4/20/2022 5:25:29 AM ProcessData ### Begin 4/20/2022 5:25:29 AM ProcessData ### Scanning FavouriteReport 4/20/2022 5:25:29 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 5:25:29 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 5:25:29 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 5:25:29 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:25:29 AM executeFavoriteQueries ### BEGIN 4/20/2022 5:25:29 AM executeFavoriteQueries ### Before While Condition 4/20/2022 5:25:29 AM executeFavoriteQueries ### After While Condition 4/20/2022 5:25:29 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 5:25:29 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 5:25:29 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 5:25:29 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 5:25:29 AM executeFavoriteQueries ### END 4/20/2022 5:25:29 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:25:29 AM ProcessData ### ProcessData Finished 4/20/2022 5:25:29 AM ProcessData ### End ------------------------------------------- 4/20/2022 5:25:50 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MNTHYR', '0000000000000042022Apr20052550', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 5:26:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) 4/20/2022 5:27:05 AM ProcessData ### Begin 4/20/2022 5:27:05 AM ProcessData ### Scanning FavouriteReport 4/20/2022 5:27:05 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 5:27:05 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 5:27:05 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 5:27:05 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:27:05 AM executeFavoriteQueries ### BEGIN 4/20/2022 5:27:05 AM executeFavoriteQueries ### Before While Condition 4/20/2022 5:27:05 AM executeFavoriteQueries ### After While Condition 4/20/2022 5:27:05 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 5:27:05 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 5:27:05 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 5:27:05 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 5:27:05 AM executeFavoriteQueries ### END 4/20/2022 5:27:05 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:27:05 AM ProcessData ### ProcessData Finished 4/20/2022 5:27:05 AM ProcessData ### End ------------------------------------------- 4/20/2022 5:29:51 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 5:29:51 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/20/2022 5:29:58 AM ProcessData ### Begin 4/20/2022 5:29:58 AM ProcessData ### Scanning FavouriteReport 4/20/2022 5:29:58 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 5:29:58 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 5:29:58 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 5:29:58 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:29:58 AM executeFavoriteQueries ### BEGIN 4/20/2022 5:29:58 AM executeFavoriteQueries ### Before While Condition 4/20/2022 5:29:58 AM executeFavoriteQueries ### After While Condition 4/20/2022 5:29:58 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 5:29:58 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 5:29:58 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 5:29:58 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 5:29:58 AM executeFavoriteQueries ### END 4/20/2022 5:29:58 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 5:29:58 AM ProcessData ### ProcessData Finished 4/20/2022 5:29:58 AM ProcessData ### End ------------------------------------------- 4/20/2022 5:31:12 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MNTHYR', '0000000000000042022Apr20053112', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 5:44:30 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MNTHYR', '0000000000000042022Apr20054430', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 5:50:50 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MNTHYR', '0000000000000042022Apr20055050', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 5:52:01 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### After binding of the ddlDistributor dropdownlist ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) 4/20/2022 6:00:02 AM Post Favourite ### After Select Query 4/20/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 4/20/2022 6:00:02 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr20113002083 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 4/20/2022 6:04:43 AM processDataUsingPostTableXML,Error while executing procedure :EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES', Error: ### Cannot drop the table '##CustomerUnlkDetails', because it does not exist or you do not have permission. Cannot drop the table '##CustomerUnlkDetails_Division', because it does not exist or you do not have permission. INSERT INTO ##CustomerUnlkDetails SELECT CL.ID AS DATAID , PD.DISTRIBUTORGROUP, PD.DistributorId AS DBID, PD.Distributor AS DISTRIBUTOR, CL.Code AS PARTY_ID, CL.Name AS PARTY_NAME, CL.ADDRESS AS PARTY_ADDRESS, T1.CITY, T1.STATE, T1.PINCODE, T1.PHONE_NO, T1.CONTACT_PERSON, T1.MOBILE_PHONE_NO, T1.PAN_NO, T1.LIC_NO, CL.LicenceNo AS GSTNO FROM PDistributor AS PD INNER JOIN CUSTOMERLINK AS CL ON PD.DistributorId = CL.DistributorId AND PD.UnkCustomerId = CL.TargetId LEFT OUTER JOIN TEMPLATE1 AS T1 ON CL.DistributorId = T1.DistributorID AND CL.Code = T1.PARTY_ID WHERE (PD.DISTRIBUTORGROUP IN ('ES','COMMON')) AND (CL.ID > 58178) 4/20/2022 6:04:43 AM ProcessData ### Inside Pre Processed Report 4/20/2022 6:04:43 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Apr20113002157 ### exec [prDistributorFileUploadStatus] '000000000000001','Apr 20 2022 11:30AM','7','','','','000000000000289','' 4/20/2022 6:04:44 AM Post Favourite ### After Fill DataSet 4/20/2022 6:04:44 AM Excel Favourite Report ### Excel Case 4/20/2022 6:04:44 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 20Apr2022060444.xls 4/20/2022 6:04:44 AM Excel Favourite Report ### After Checking File Exist Or Create New File 4/20/2022 6:04:44 AM Excel Favourite Report ### After Writing to File 4/20/2022 6:04:44 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/20/2022 6:04:44 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/20/2022 6:04:44 AM processDataUsingPostTableXML ### Finished 4/20/2022 6:04:44 AM processDataUsingPostTableXML ### End ------------------------------------------- 4/20/2022 6:44:13 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 6:44:13 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/20/2022 6:44:19 AM ProcessData ### Begin 4/20/2022 6:44:19 AM ProcessData ### Scanning FavouriteReport 4/20/2022 6:44:19 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 6:44:19 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 6:44:19 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 6:44:19 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 6:44:19 AM executeFavoriteQueries ### BEGIN 4/20/2022 6:44:19 AM executeFavoriteQueries ### Before While Condition 4/20/2022 6:44:19 AM executeFavoriteQueries ### After While Condition 4/20/2022 6:44:19 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 6:44:19 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 6:44:19 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 6:44:19 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 6:44:19 AM executeFavoriteQueries ### END 4/20/2022 6:44:19 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 6:44:19 AM ProcessData ### ProcessData Finished 4/20/2022 6:44:19 AM ProcessData ### End ------------------------------------------- 4/20/2022 8:49:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 8:49:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 8:51:34 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 8:51:40 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 8:51:44 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 8:52:06 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20085206', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 9:09:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 9:09:10 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 9:15:18 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 9:15:18 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 10:07:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 10:07:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/20/2022 10:08:26 AM ProcessData ### Begin 4/20/2022 10:08:26 AM ProcessData ### Scanning FavouriteReport 4/20/2022 10:08:26 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 10:08:26 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 10:08:26 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 10:08:26 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 10:08:26 AM executeFavoriteQueries ### BEGIN 4/20/2022 10:08:26 AM executeFavoriteQueries ### Before While Condition 4/20/2022 10:08:26 AM executeFavoriteQueries ### After While Condition 4/20/2022 10:08:26 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 10:08:26 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 10:08:26 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 10:08:26 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 10:08:26 AM executeFavoriteQueries ### END 4/20/2022 10:08:26 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 10:08:26 AM ProcessData ### ProcessData Finished 4/20/2022 10:08:26 AM ProcessData ### End 4/20/2022 10:27:16 AM ProcessData ### Begin 4/20/2022 10:27:16 AM ProcessData ### Scanning FavouriteReport 4/20/2022 10:27:16 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 10:27:16 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 10:27:16 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 10:27:16 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 10:27:16 AM executeFavoriteQueries ### BEGIN 4/20/2022 10:27:16 AM executeFavoriteQueries ### Before While Condition 4/20/2022 10:27:16 AM executeFavoriteQueries ### After While Condition 4/20/2022 10:27:16 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 10:27:16 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 10:27:16 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 10:27:16 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 10:27:16 AM executeFavoriteQueries ### END 4/20/2022 10:27:16 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 10:27:16 AM ProcessData ### ProcessData Finished 4/20/2022 10:27:16 AM ProcessData ### End ------------------------------------------- 4/20/2022 10:39:56 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 10:39:56 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:15:19 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### After binding of the ddlDistributor dropdownlist ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 11:15:22 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:15:25 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:15:29 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:15:48 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20111548', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 11:16:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20111633', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 11:24:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:24:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/20/2022 11:24:48 AM ProcessData ### Begin 4/20/2022 11:24:48 AM ProcessData ### Scanning FavouriteReport 4/20/2022 11:24:48 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 11:24:48 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 11:24:48 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 11:24:48 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 11:24:48 AM executeFavoriteQueries ### BEGIN 4/20/2022 11:24:48 AM executeFavoriteQueries ### Before While Condition 4/20/2022 11:24:48 AM executeFavoriteQueries ### After While Condition 4/20/2022 11:24:48 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 11:24:48 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 11:24:48 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 11:24:48 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 11:24:48 AM executeFavoriteQueries ### END 4/20/2022 11:24:48 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 11:24:48 AM ProcessData ### ProcessData Finished 4/20/2022 11:24:48 AM ProcessData ### End 4/20/2022 11:32:17 AM ProcessData ### Begin 4/20/2022 11:32:17 AM ProcessData ### Scanning FavouriteReport 4/20/2022 11:32:17 AM ProcessData ### Before Executing Favourite Report Select Query 4/20/2022 11:32:17 AM ProcessData ### After Executing Favourite Report Select Query 4/20/2022 11:32:17 AM ProcessData ### Inside If Action = 0 Condition 4/20/2022 11:32:17 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 11:32:17 AM executeFavoriteQueries ### BEGIN 4/20/2022 11:32:17 AM executeFavoriteQueries ### Before While Condition 4/20/2022 11:32:17 AM executeFavoriteQueries ### After While Condition 4/20/2022 11:32:17 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/20/2022 11:32:17 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/20/2022 11:32:17 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/20/2022 11:32:17 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/20/2022 11:32:17 AM executeFavoriteQueries ### END 4/20/2022 11:32:17 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/20/2022 11:32:17 AM ProcessData ### ProcessData Finished 4/20/2022 11:32:17 AM ProcessData ### End ------------------------------------------- 4/20/2022 11:33:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:33:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:37:27 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:37:27 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 11:37:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 11:37:39 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:37:42 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:38:02 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20113802', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 11:40:48 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 11:43:21 AM Linking Class, FillGrid Function ### After dgItemLink.DataBind() ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 11:43:25 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:43:28 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 11:43:46 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20114346', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 11:44:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20114413', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 11:45:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr20114516', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:08:05 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 12:08:20 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 12:08:21 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 12:34:45 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 12:34:45 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 12:34:51 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 12:36:55 PM AddLink Class, Fill Frop Down Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 12:36:58 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 12:37:03 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 12:37:28 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'ITEM,ITEMALIAS', '0000000000000042022Apr20123728', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:37:39 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 12:37:39 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 12:37:42 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 4/20/2022 12:37:43 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr20123743', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:38:03 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr20123803', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:38:44 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr20123844', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:39:07 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr20123907', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:39:30 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE', 'FINYEAR', '0000000000000042022Apr20123930', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:39:59 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE', 'FINYEAR', '0000000000000042022Apr20123959', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:43:32 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE', 'FINYEAR', '0000000000000042022Apr20124332', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:44:29 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20124429', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:45:03 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20124503', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:48:20 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20124820', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:50:11 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125011', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:50:48 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125048', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:51:26 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125126', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:51:48 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125148', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:53:12 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125312', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:54:01 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20125401', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 12:54:37 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :UPDATE SALES SET SALEQUANTITY=(SALEQUANTITY/0)*0, ItemId='000000000000423',PriceListId= 0,rate=0,value=0 FROM SALES WHERE DistributorId='000000000000369' AND ItemCode='Premise 350 SC 250 ML' and voucherdate >='01 Jan 1900' ------------------------------------------- 4/20/2022 12:54:37 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [22012] [Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 4/20/2022 12:54:51 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :UPDATE SALES SET SALEQUANTITY=(SALEQUANTITY/0)*1, ItemId='000000000000423',PriceListId= 0,rate=0,value=0 FROM SALES WHERE DistributorId='000000000000369' AND ItemCode='Premise 350 SC 250 ML' and voucherdate >='01 Jan 1900' ------------------------------------------- 4/20/2022 12:54:51 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [22012] [Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 4/20/2022 12:55:00 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :UPDATE SALES SET SALEQUANTITY=(SALEQUANTITY/0)*1, ItemId='000000000000423',PriceListId= 0,rate=0,value=0 FROM SALES WHERE DistributorId='000000000000369' AND ItemCode='Premise 350 SC 250 ML' and voucherdate >='01 Jan 1900' ------------------------------------------- 4/20/2022 12:55:00 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [22012] [Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 4/20/2022 12:57:04 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :UPDATE SALES SET SALEQUANTITY=(SALEQUANTITY/0)*1, ItemId='000000000000423',PriceListId= 0,rate=0,value=0 FROM SALES WHERE DistributorId='000000000000369' AND ItemCode='Premise 350 SC 250 ML' and voucherdate >='01 Jan 1900' ------------------------------------------- 4/20/2022 12:57:04 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [22012] [Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 4/20/2022 12:57:25 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :UPDATE SALES SET SALEQUANTITY=(SALEQUANTITY/0)*1, ItemId='000000000000423',PriceListId= 0,rate=0,value=0 FROM SALES WHERE DistributorId='000000000000369' AND ItemCode='Premise 350 SC 250 ML' and voucherdate >='01 Jan 1900' ------------------------------------------- 4/20/2022 12:57:25 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [22012] [Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 4/20/2022 12:59:55 PM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 4/20/2022 12:59:55 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 4/20/2022 12:59:57 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 4/20/2022 12:59:57 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 4/20/2022 1:00:55 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 1:03:14 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010314', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:03:30 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010330', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:04:27 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010427', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:05:10 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010510', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:05:56 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010556', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:06:36 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010636', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:07:09 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010709', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:07:54 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010754', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:08:40 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010840', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:09:11 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20010911', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:10:25 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011025', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:10:51 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011051', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:11:17 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011117', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:12:08 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011208', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:12:30 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011230', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:12:54 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011254', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:13:55 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011355', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:14:39 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011439', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:15:52 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011552', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:16:40 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011640', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:17:47 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011747', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:18:35 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,ITEMSIZE,VOUCHER', 'FINYEAR', '0000000000000042022Apr20011835', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/20/2022 1:37:02 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 1:37:02 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 1:42:46 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 1:42:46 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 2:10:56 PM QueryExecuter.aspx.cs :btnExecute ### System.ArgumentNullException: Value cannot be null. Parameter name: path1 at System.IO.Path.Combine(String path1, String path2) at QueryExecuter.WriteQueryLog(String Type, String Message) at QueryExecuter.Executcommonfunction() ------------------------------------------- 4/20/2022 2:11:01 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/20/2022 2:11:01 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/20/2022 2:13:45 PM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnDownload_Click() ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 4/20/2022 2:20:17 PM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 2:20:24 PM GenClass Class, FillCombo Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 4/20/2022 2:20:40 PM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 4/20/2022 2:20:42 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 4/20/2022 2:20:44 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 4/20/2022 2:23:12 PM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing 4/20/2022 6:00:05 PM Post Favourite ### After Select Query 4/20/2022 6:00:05 PM ProcessData ### Inside Pre Processed Report 4/20/2022 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr20233005090 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 4/20/2022 6:04:58 PM processDataUsingPostTableXML,Error while executing procedure :EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES', Error: ### Cannot drop the table '##CustomerUnlkDetails', because it does not exist or you do not have permission. Cannot drop the table '##CustomerUnlkDetails_Division', because it does not exist or you do not have permission. INSERT INTO ##CustomerUnlkDetails SELECT CL.ID AS DATAID , PD.DISTRIBUTORGROUP, PD.DistributorId AS DBID, PD.Distributor AS DISTRIBUTOR, CL.Code AS PARTY_ID, CL.Name AS PARTY_NAME, CL.ADDRESS AS PARTY_ADDRESS, T1.CITY, T1.STATE, T1.PINCODE, T1.PHONE_NO, T1.CONTACT_PERSON, T1.MOBILE_PHONE_NO, T1.PAN_NO, T1.LIC_NO, CL.LicenceNo AS GSTNO FROM PDistributor AS PD INNER JOIN CUSTOMERLINK AS CL ON PD.DistributorId = CL.DistributorId AND PD.UnkCustomerId = CL.TargetId LEFT OUTER JOIN TEMPLATE1 AS T1 ON CL.DistributorId = T1.DistributorID AND CL.Code = T1.PARTY_ID WHERE (PD.DISTRIBUTORGROUP IN ('ES','COMMON')) AND (CL.ID > 58178) 4/20/2022 6:04:58 PM processDataUsingPostTableXML ### Finished 4/20/2022 6:04:58 PM processDataUsingPostTableXML ### End