------------------------------------------- 5/3/2022 3:41:58 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 3:41:58 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 4:14:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 4:14:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/3/2022 6:00:02 AM Post Favourite ### After Select Query 5/3/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 5/3/2022 6:00:02 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022May03113002837 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 5/3/2022 6:00:04 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) 5/3/2022 6:00:04 AM ProcessData ### Inside Pre Processed Report 5/3/2022 6:00:04 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022May03113002907 ### exec [prDistributorFileUploadStatus] '000000000000001','May 3 2022 11:30AM','7','','','','000000000000289','' 5/3/2022 6:00:05 AM Post Favourite ### After Fill DataSet 5/3/2022 6:00:05 AM Excel Favourite Report ### Excel Case 5/3/2022 6:00:06 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 03May2022060005.xls 5/3/2022 6:00:06 AM Excel Favourite Report ### After Checking File Exist Or Create New File 5/3/2022 6:00:06 AM Excel Favourite Report ### After Writing to File 5/3/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 5/3/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 5/3/2022 6:00:06 AM processDataUsingPostTableXML ### Finished 5/3/2022 6:00:06 AM processDataUsingPostTableXML ### End ------------------------------------------- 5/3/2022 6:16:50 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:17:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:17:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:18:56 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) ------------------------------------------- 5/3/2022 6:19:11 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() ------------------------------------------- 5/3/2022 6:19:17 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() ------------------------------------------- 5/3/2022 6:19:20 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() ------------------------------------------- 5/3/2022 6:19:41 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() ------------------------------------------- 5/3/2022 6:22:09 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DAY,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03062209', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DAY','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 6:25:10 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DAY,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03062510', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DAY','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 6:45:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:45:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:55:58 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:55:58 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 6:56:10 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) ------------------------------------------- 5/3/2022 6:56:17 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() ------------------------------------------- 5/3/2022 6:56: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() ------------------------------------------- 5/3/2022 6:56:30 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() ------------------------------------------- 5/3/2022 6:56:33 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() ------------------------------------------- 5/3/2022 6:56:38 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() ------------------------------------------- 5/3/2022 6:58:38 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03065838', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 6:58:58 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03065858', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:01:28 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 7:01:28 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 7:13:28 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 7:13:28 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 7:14:39 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03071439', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:15:00 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03071500', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:15:10 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03071510', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:15:12 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:15:12 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:17:36 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) ------------------------------------------- 5/3/2022 7:18:01 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) ------------------------------------------- 5/3/2022 7:18:12 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) ------------------------------------------- 5/3/2022 7:18:19 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() ------------------------------------------- 5/3/2022 7:18:26 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() ------------------------------------------- 5/3/2022 7:18:31 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() ------------------------------------------- 5/3/2022 7:18:41 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() ------------------------------------------- 5/3/2022 7:20:26 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,DATE,VOUCHER', 'MONTH', '0000000001655322022May03072026', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:21:21 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,DATE,VOUCHER', 'MONTH', '0000000001655322022May03072121', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:25:29 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03072529', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:25:31 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:25:31 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:25:38 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03072538', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:25:41 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:25:41 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:25:54 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() ------------------------------------------- 5/3/2022 7:25:58 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() ------------------------------------------- 5/3/2022 7:26:08 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03072608', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:26:11 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:26:11 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:26:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03072619', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:26:21 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:26:21 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:26:23 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022May03072623', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:26:50 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,VOUCHER', 'MNTHYR', '0000000001655332022May03072650', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:26:53 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:26:53 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:27:50 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() ------------------------------------------- 5/3/2022 7:27:53 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() ------------------------------------------- 5/3/2022 7:27:55 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() ------------------------------------------- 5/3/2022 7:27:59 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() ------------------------------------------- 5/3/2022 7:28:05 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() ------------------------------------------- 5/3/2022 7:29:05 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03072905', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:31:22 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03073121', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:31:24 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:31:24 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:31:56 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03073156', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:31:59 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:31:59 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:32:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03073233', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:32:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:32:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:32:46 AM GenClass Class, FillCombo Function ### After Filling DataSet ### PostedTableCreation.aspx.cs :btnCreateTable_Click ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S01] [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'PDistributor' in the database. 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 PostedTableCreation.btnCreateTable_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:33:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03073319', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:33:22 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:33:22 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:34:06 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() ------------------------------------------- 5/3/2022 7:34:11 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() ------------------------------------------- 5/3/2022 7:34:14 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() ------------------------------------------- 5/3/2022 7:34:19 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() ------------------------------------------- 5/3/2022 7:34: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() ------------------------------------------- 5/3/2022 7:35:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DATE,DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655332022May03073533', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DATE','1','','3','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 7:35:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 7:35:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 7:42:51 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 7:42:51 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/3/2022 7:43:37 AM ProcessData ### Begin 5/3/2022 7:43:37 AM ProcessData ### Scanning FavouriteReport 5/3/2022 7:43:37 AM ProcessData ### Before Executing Favourite Report Select Query 5/3/2022 7:43:37 AM ProcessData ### After Executing Favourite Report Select Query 5/3/2022 7:43:37 AM ProcessData ### Inside If Action = 0 Condition 5/3/2022 7:43:37 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 7:43:37 AM executeFavoriteQueries ### BEGIN 5/3/2022 7:43:37 AM executeFavoriteQueries ### Before While Condition 5/3/2022 7:43:37 AM executeFavoriteQueries ### After While Condition 5/3/2022 7:43:37 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 5/3/2022 7:43:37 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 5/3/2022 7:43:37 AM After Filling DataSet For Query Favourite For User ### 000000000165532 5/3/2022 7:43:37 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 5/3/2022 7:43:37 AM executeFavoriteQueries ### END 5/3/2022 7:43:37 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 7:43:37 AM ProcessData ### ProcessData Finished 5/3/2022 7:43:37 AM ProcessData ### End 5/3/2022 7:44:59 AM ProcessData ### Begin 5/3/2022 7:44:59 AM ProcessData ### Scanning FavouriteReport 5/3/2022 7:44:59 AM ProcessData ### Before Executing Favourite Report Select Query 5/3/2022 7:44:59 AM ProcessData ### After Executing Favourite Report Select Query 5/3/2022 7:44:59 AM ProcessData ### Inside If Action = 0 Condition 5/3/2022 7:44:59 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 7:44:59 AM executeFavoriteQueries ### BEGIN 5/3/2022 7:44:59 AM executeFavoriteQueries ### Before While Condition 5/3/2022 7:44:59 AM executeFavoriteQueries ### After While Condition 5/3/2022 7:44:59 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 5/3/2022 7:44:59 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 5/3/2022 7:45:00 AM After Filling DataSet For Query Favourite For User ### 000000000165532 5/3/2022 7:45:00 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 5/3/2022 7:45:00 AM executeFavoriteQueries ### END 5/3/2022 7:45:00 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 7:45:00 AM ProcessData ### ProcessData Finished 5/3/2022 7:45:00 AM ProcessData ### End ------------------------------------------- 5/3/2022 8:51:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 8:51:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 8:52:00 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() ------------------------------------------- 5/3/2022 8:52:20 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() ------------------------------------------- 5/3/2022 8:52: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() ------------------------------------------- 5/3/2022 8:52: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() ------------------------------------------- 5/3/2022 8:52:49 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() ------------------------------------------- 5/3/2022 8:52:55 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() ------------------------------------------- 5/3/2022 8:53:08 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() ------------------------------------------- 5/3/2022 8:53:10 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() ------------------------------------------- 5/3/2022 8:53:27 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() ------------------------------------------- 5/3/2022 8:53:30 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() ------------------------------------------- 5/3/2022 8:53:33 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() ------------------------------------------- 5/3/2022 8:53:37 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() ------------------------------------------- 5/3/2022 8:53:48 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() ------------------------------------------- 5/3/2022 8:54:00 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() ------------------------------------------- 5/3/2022 8:56:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,PARTY,AREA,ERPCODE,CUSTOMERID,CUSTOMERCLASS,CUSTOMERCLASS2,GSTNUMBER,ITEM,ITEMALIAS,BRAND,DATE,VOUCHER', 'YEAR', '0000000000009982022May03085607', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 8:56:26 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 8:56:26 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 8:56:26 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,PARTY,AREA,ERPCODE,CUSTOMERID,CUSTOMERCLASS,CUSTOMERCLASS2,GSTNUMBER,ITEM,ITEMALIAS,BRAND,DATE,VOUCHER', 'YEAR', '0000000000009982022May03085626', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 8:56:45 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### 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 ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/3/2022 8:56:45 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/3/2022 9:19:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 9:19:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/3/2022 9:23:02 AM CustomerClass Class, Search 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) ------------------------------------------- 5/3/2022 9:23:08 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() ------------------------------------------- 5/3/2022 9:23:12 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() ------------------------------------------- 5/3/2022 9:23:17 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() ------------------------------------------- 5/3/2022 9:23:52 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'PARTY,AREA,ERPCODE,CUSTOMERID,PARTYMOBILE', 'MONTH', '0000000000000042022May03092352', '0', '<>0', 'SALE', '000000000000004', 0, '', '','PARTY','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 9:24:01 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'PARTYMOBILE', 'MONTH', '0000000000000042022May03092401', '0', '<>0', 'SALE', '000000000000004', 0, '', '','PARTYMOBILE','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 9:26:56 AM CustomerClass Class, Search 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) ------------------------------------------- 5/3/2022 9:27:05 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() ------------------------------------------- 5/3/2022 9:27:11 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() ------------------------------------------- 5/3/2022 9:27:14 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() ------------------------------------------- 5/3/2022 9:27:32 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'PARTY,AREA,ERPCODE,CUSTOMERID,Telephone', 'MONTH', '0000000000000042022May03092732', '0', '<>0', 'SALE', '000000000000004', 0, '', '','PARTY','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 9:28:51 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'PARTY,AREA,ERPCODE,CUSTOMERID,Telephone', 'MONTH', '0000000000000042022May03092851', '0', '<>0', 'SALE', '000000000000004', 0, '', '','PARTY','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 9:29:53 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'PARTY,AREA,ERPCODE,CUSTOMERID,Telephone', 'MONTH', '0000000000000042022May03092953', '0', '<>0', 'SALE', '000000000000004', 0, '', '','PARTY','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/3/2022 11:30:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 11:30:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/3/2022 11:30:27 AM ProcessData ### Begin 5/3/2022 11:30:27 AM ProcessData ### Scanning FavouriteReport 5/3/2022 11:30:27 AM ProcessData ### Before Executing Favourite Report Select Query 5/3/2022 11:30:27 AM ProcessData ### After Executing Favourite Report Select Query 5/3/2022 11:30:27 AM ProcessData ### Inside If Action = 0 Condition 5/3/2022 11:30:27 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 11:30:27 AM executeFavoriteQueries ### BEGIN 5/3/2022 11:30:27 AM executeFavoriteQueries ### Before While Condition 5/3/2022 11:30:27 AM executeFavoriteQueries ### After While Condition 5/3/2022 11:30:27 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 5/3/2022 11:30:27 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 5/3/2022 11:30:27 AM After Filling DataSet For Query Favourite For User ### 000000000165532 5/3/2022 11:30:27 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 5/3/2022 11:30:27 AM executeFavoriteQueries ### END 5/3/2022 11:30:27 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 11:30:27 AM ProcessData ### ProcessData Finished 5/3/2022 11:30:27 AM ProcessData ### End ------------------------------------------- 5/3/2022 11:33:13 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) ------------------------------------------- 5/3/2022 11:34:34 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) ------------------------------------------- 5/3/2022 11:51:55 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/3/2022 11:51:55 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/3/2022 11:52:00 AM ProcessData ### Begin 5/3/2022 11:52:00 AM ProcessData ### Scanning FavouriteReport 5/3/2022 11:52:00 AM ProcessData ### Before Executing Favourite Report Select Query 5/3/2022 11:52:00 AM ProcessData ### After Executing Favourite Report Select Query 5/3/2022 11:52:00 AM ProcessData ### Inside If Action = 0 Condition 5/3/2022 11:52:00 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 11:52:00 AM executeFavoriteQueries ### BEGIN 5/3/2022 11:52:00 AM executeFavoriteQueries ### Before While Condition 5/3/2022 11:52:00 AM executeFavoriteQueries ### After While Condition 5/3/2022 11:52:00 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 5/3/2022 11:52:00 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 5/3/2022 11:52:00 AM After Filling DataSet For Query Favourite For User ### 000000000165532 5/3/2022 11:52:00 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 5/3/2022 11:52:00 AM executeFavoriteQueries ### END 5/3/2022 11:52:00 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 11:52:00 AM ProcessData ### ProcessData Finished 5/3/2022 11:52:00 AM ProcessData ### End ------------------------------------------- 5/3/2022 11:54:29 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22001] [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. ------------------------------------------- 5/3/2022 11:54:29 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into USERMASTER (Id,Name,Address,Pin,Telephone,Fax,Login,Password,Type,EmailId,BranchId,LoginStatus,AreaId,ERPCode,LoginDateTime,IsActive,LASTEDITDATE,CreatedBy,CreatedDate,EditedBy,DeletedBy,DeletedDate,DeleteFlag,GSTNumber,Latitude,Longitude) Values('000000000180913','Krupa Pest Control_Tirupati Tirupati','"No. 21-8-110 S.N.Puram Circle JeevakonaTirupati|37AAUFK0067D1Z8 | |"','0','8639888638','','','d41d8cd98f00b204e9800998ecf8427e','4','','000000000000039','','000000000009369','PCO0001571_2','','1','05/03/2022 17:24:18','000000000165532','','','','','','"37AAUFK0067D1Z8 "','','') ------------------------------------------- 5/3/2022 11:59:43 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22001] [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. ------------------------------------------- 5/3/2022 11:59:43 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into USERMASTER (Id,Name,Address,Pin,Telephone,Fax,Login,Password,Type,EmailId,BranchId,LoginStatus,AreaId,ERPCode,LoginDateTime,IsActive,LASTEDITDATE,CreatedBy,CreatedDate,EditedBy,DeletedBy,DeletedDate,DeleteFlag,GSTNumber,Latitude,Longitude) Values('000000000180913','Krupa Pest Control_Tirupati Tirupati','No. 21-8-110 S.N.Puram Circle JeevakonaTirupati 37AAUFK0067D1Z8','0','8639888638','','','d41d8cd98f00b204e9800998ecf8427e','4','','000000000000039','','000000000009369','PCO0001571_2','','1','05/03/2022 17:29:33','000000000165532','','','','','','"37AAUFK0067D1Z8 "','','') 5/3/2022 12:41:56 PM ProcessData ### Begin 5/3/2022 12:41:56 PM ProcessData ### Scanning FavouriteReport 5/3/2022 12:41:56 PM ProcessData ### Before Executing Favourite Report Select Query 5/3/2022 12:41:56 PM ProcessData ### After Executing Favourite Report Select Query 5/3/2022 12:41:56 PM ProcessData ### Inside If Action = 0 Condition 5/3/2022 12:41:56 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 12:41:56 PM executeFavoriteQueries ### BEGIN 5/3/2022 12:41:56 PM executeFavoriteQueries ### Before While Condition 5/3/2022 12:41:56 PM executeFavoriteQueries ### After While Condition 5/3/2022 12:41:56 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 5/3/2022 12:41:56 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 5/3/2022 12:41:57 PM After Filling DataSet For Query Favourite For User ### 000000000165532 5/3/2022 12:41:57 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 5/3/2022 12:41:57 PM executeFavoriteQueries ### END 5/3/2022 12:41:57 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/3/2022 12:41:57 PM ProcessData ### ProcessData Finished 5/3/2022 12:41:57 PM ProcessData ### End 5/3/2022 6:00:05 PM Post Favourite ### After Select Query 5/3/2022 6:00:05 PM ProcessData ### Inside Pre Processed Report 5/3/2022 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022May03233005810 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 5/3/2022 6:00:07 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) 5/3/2022 6:00:07 PM processDataUsingPostTableXML ### Finished 5/3/2022 6:00:07 PM processDataUsingPostTableXML ### End