------------------------------------------- 4/27/2022 5:06:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:06:36 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:18:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:18:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:18:44 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/27/2022 5:18: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() ------------------------------------------- 4/27/2022 5:18:52 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/27/2022 5:19:12 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr27051912', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 5:19:32 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr27051932', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 5:20:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Apr27052007', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 5:25:49 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:25:49 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 5:31:22 AM 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/27/2022 6:00:02 AM Post Favourite ### After Select Query 4/27/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 4/27/2022 6:00:02 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr27113002297 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 4/27/2022 6:00:05 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/27/2022 6:00:05 AM ProcessData ### Inside Pre Processed Report 4/27/2022 6:00:05 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Apr27113002373 ### exec [prDistributorFileUploadStatus] '000000000000001','Apr 27 2022 11:30AM','7','','','','000000000000289','' 4/27/2022 6:00:05 AM Post Favourite ### After Fill DataSet 4/27/2022 6:00:06 AM Excel Favourite Report ### Excel Case 4/27/2022 6:00:06 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 27Apr2022060005.xls 4/27/2022 6:00:06 AM Excel Favourite Report ### After Checking File Exist Or Create New File 4/27/2022 6:00:06 AM Excel Favourite Report ### After Writing to File 4/27/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/27/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/27/2022 6:00:06 AM processDataUsingPostTableXML ### Finished 4/27/2022 6:00:06 AM processDataUsingPostTableXML ### End ------------------------------------------- 4/27/2022 6:05:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 6:05:10 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 6:05:10 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 6:35:17 AM DistributorFileUploadStatus.aspx.cs :btnGenerate_Click() ### System.NullReferenceException: Object reference not set to an instance of an object. at DistributorFileUploadStatus.btnGenerate_Click(Object sender, EventArgs e) ------------------------------------------- 4/27/2022 7:55:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 7:55:26 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/27/2022 7:56:57 AM ProcessData ### Begin 4/27/2022 7:56:57 AM ProcessData ### Scanning FavouriteReport 4/27/2022 7:56:57 AM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 7:56:57 AM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 7:56:57 AM ProcessData ### Inside If Action = 0 Condition 4/27/2022 7:56:57 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 7:56:57 AM executeFavoriteQueries ### BEGIN 4/27/2022 7:56:57 AM executeFavoriteQueries ### Before While Condition 4/27/2022 7:56:57 AM executeFavoriteQueries ### After While Condition 4/27/2022 7:56:57 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 7:56:57 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 7:56:57 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 7:56:57 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 7:56:57 AM executeFavoriteQueries ### END 4/27/2022 7:56:57 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 7:56:57 AM ProcessData ### ProcessData Finished 4/27/2022 7:56:57 AM ProcessData ### End ------------------------------------------- 4/27/2022 8:58:59 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 8:58:59 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 8:59:06 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/27/2022 8:59: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() ------------------------------------------- 4/27/2022 8:59: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() ------------------------------------------- 4/27/2022 8:59:34 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MNTHYR', '0000000000000042022Apr27085934', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 9:09:32 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/27/2022 9:09: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() ------------------------------------------- 4/27/2022 9:09:43 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/27/2022 9:10:12 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042022Apr27091012', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 9:10:45 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042022Apr27091045', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 9:11:02 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042022Apr27091102', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 9:23:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 9:23:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 9:24:51 AM CustomerClass Class, Search Function ### After OdbcConnection Open ### CustomerClass Class, Search ### System.Data.Odbc.OdbcException (0x80131937): ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]>>insert into #Cust select * from CUSTOMERMASTER Inner Join (SELECT CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE FROM (SELECT * from CUSTOMERDETAILS) AS SOURCETABLE PIVOT(max(SubgroupId) FOR groupid IN ( AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE)) AS PIVOTABLE GROUP BY CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE) As Details On CUSTOMERMASTER.Id = Details.CustomerId ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #pcustomer select Id, UserId , Transfer,ContactPerson, LicenceType, LicenceNo,LastEditDate from #Cust,(select distinct customerid as custid from fnGetCustomersOnly('000000000000001')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id 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.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/27/2022 9:28:40 AM CustomerClass Class, Search Function ### After OdbcConnection Open ### CustomerClass Class, Search ### System.Data.Odbc.OdbcException (0x80131937): ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]>>insert into #Cust select * from CUSTOMERMASTER Inner Join (SELECT CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE FROM (SELECT * from CUSTOMERDETAILS) AS SOURCETABLE PIVOT(max(SubgroupId) FOR groupid IN ( AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE)) AS PIVOTABLE GROUP BY CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE) As Details On CUSTOMERMASTER.Id = Details.CustomerId ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #pcustomer select Id, UserId , Transfer,ContactPerson, LicenceType, LicenceNo,LastEditDate from #Cust,(select distinct customerid as custid from fnGetCustomersOnly('000000000000001')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id 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.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/27/2022 9:46:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 9:46:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:01: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/27/2022 10:01:51 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/27/2022 10:02:47 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'ITEM,ITEMALIAS', '0000000000000042022Apr27100247', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:02:56 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/27/2022 10:03:16 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/27/2022 10:03:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr27100318', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:04:26 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr27100426', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:04:54 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'FINYEAR', '0000000000000042022Apr27100454', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:08:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:08:09 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:12:21 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/27/2022 10:12: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() ------------------------------------------- 4/27/2022 10:12:34 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/27/2022 10:12:52 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27101252', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:23:11 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:23:11 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/27/2022 10:23:19 AM ProcessData ### Begin 4/27/2022 10:23:19 AM ProcessData ### Scanning FavouriteReport 4/27/2022 10:23:19 AM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 10:23:19 AM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 10:23:19 AM ProcessData ### Inside If Action = 0 Condition 4/27/2022 10:23:19 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 10:23:19 AM executeFavoriteQueries ### BEGIN 4/27/2022 10:23:19 AM executeFavoriteQueries ### Before While Condition 4/27/2022 10:23:19 AM executeFavoriteQueries ### After While Condition 4/27/2022 10:23:19 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 10:23:19 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 10:23:19 AM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 10:23:19 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 10:23:19 AM executeFavoriteQueries ### END 4/27/2022 10:23:19 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 10:23:19 AM ProcessData ### ProcessData Finished 4/27/2022 10:23:19 AM ProcessData ### End ------------------------------------------- 4/27/2022 10:32:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:32:15 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:32:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:33:06 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:33:17 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:34:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:38:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:44:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:49:37 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:49:37 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 10:49:55 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/27/2022 10:50: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() ------------------------------------------- 4/27/2022 10:50:04 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/27/2022 10:53:35 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### 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/27/2022 10:53:51 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/27/2022 10:53:56 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/27/2022 10:54:45 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000001655322022Apr27105445', '0', '<>0', 'SALE', '000000000165532', 0, '', '','ITEM','1','','3','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 10:55:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000001655322022Apr27105507', '0', '<>0', 'SALE', '000000000165532', 0, '', '','ITEM','1','','3','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:02:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 11:02:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 11:11:15 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/27/2022 11:11:18 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/27/2022 11:11:21 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/27/2022 11:11:58 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,VOUCHER,ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27111158', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:15:56 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,VOUCHER,ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27111556', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:16:09 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,VOUCHER,ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27111609', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:28:47 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/27/2022 11:28:52 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/27/2022 11:28: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() ------------------------------------------- 4/27/2022 11:29:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27112914', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:29:25 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27112925', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:42:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 11:42:45 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 11:45:26 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/27/2022 11:45: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() ------------------------------------------- 4/27/2022 11:45:34 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/27/2022 11:46:34 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27114634', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:46:53 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27114653', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 11:47:13 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/27/2022 12:21:39 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 12:21:39 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 12:28:55 PM 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/27/2022 12:29:05 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/27/2022 12:29:08 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/27/2022 12:29:28 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27122928', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','1','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 12:30:49 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27123049', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 12:35:35 PM 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/27/2022 12:36:41 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'ITEM,ITEMALIAS', 'MONTH', '0000000000000042022Apr27123641', '0', '<>0', 'SALE', '000000000000004', 0, '', '','ITEM','0','','2','3','False','False','False','1','0' ------------------------------------------- 4/27/2022 1:02:17 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 1:02:17 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/27/2022 1:02:24 PM ProcessData ### Begin 4/27/2022 1:02:24 PM ProcessData ### Scanning FavouriteReport 4/27/2022 1:02:24 PM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 1:02:24 PM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 1:02:24 PM ProcessData ### Inside If Action = 0 Condition 4/27/2022 1:02:24 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:02:24 PM executeFavoriteQueries ### BEGIN 4/27/2022 1:02:24 PM executeFavoriteQueries ### Before While Condition 4/27/2022 1:02:24 PM executeFavoriteQueries ### After While Condition 4/27/2022 1:02:24 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 1:02:24 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 1:02:24 PM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 1:02:24 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 1:02:24 PM executeFavoriteQueries ### END 4/27/2022 1:02:24 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:02:24 PM ProcessData ### ProcessData Finished 4/27/2022 1:02:24 PM ProcessData ### End 4/27/2022 1:03:56 PM ProcessData ### Begin 4/27/2022 1:03:56 PM ProcessData ### Scanning FavouriteReport 4/27/2022 1:03:56 PM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 1:03:56 PM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 1:03:56 PM ProcessData ### Inside If Action = 0 Condition 4/27/2022 1:03:56 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:03:56 PM executeFavoriteQueries ### BEGIN 4/27/2022 1:03:56 PM executeFavoriteQueries ### Before While Condition 4/27/2022 1:03:56 PM executeFavoriteQueries ### After While Condition 4/27/2022 1:03:56 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 1:03:56 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 1:03:56 PM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 1:03:56 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 1:03:56 PM executeFavoriteQueries ### END 4/27/2022 1:03:56 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:03:56 PM ProcessData ### ProcessData Finished 4/27/2022 1:03:56 PM ProcessData ### End 4/27/2022 1:05:21 PM ProcessData ### Begin 4/27/2022 1:05:21 PM ProcessData ### Scanning FavouriteReport 4/27/2022 1:05:21 PM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 1:05:21 PM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 1:05:21 PM ProcessData ### Inside If Action = 0 Condition 4/27/2022 1:05:21 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:05:21 PM executeFavoriteQueries ### BEGIN 4/27/2022 1:05:21 PM executeFavoriteQueries ### Before While Condition 4/27/2022 1:05:21 PM executeFavoriteQueries ### After While Condition 4/27/2022 1:05:21 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 1:05:21 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 1:05:21 PM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 1:05:21 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 1:05:21 PM executeFavoriteQueries ### END 4/27/2022 1:05:21 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:05:21 PM ProcessData ### ProcessData Finished 4/27/2022 1:05:21 PM ProcessData ### End 4/27/2022 1:06:28 PM ProcessData ### Begin 4/27/2022 1:06:28 PM ProcessData ### Scanning FavouriteReport 4/27/2022 1:06:28 PM ProcessData ### Before Executing Favourite Report Select Query 4/27/2022 1:06:28 PM ProcessData ### After Executing Favourite Report Select Query 4/27/2022 1:06:28 PM ProcessData ### Inside If Action = 0 Condition 4/27/2022 1:06:28 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:06:28 PM executeFavoriteQueries ### BEGIN 4/27/2022 1:06:28 PM executeFavoriteQueries ### Before While Condition 4/27/2022 1:06:28 PM executeFavoriteQueries ### After While Condition 4/27/2022 1:06:28 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 4/27/2022 1:06:28 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 4/27/2022 1:06:28 PM After Filling DataSet For Query Favourite For User ### 000000000165532 4/27/2022 1:06:28 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 4/27/2022 1:06:28 PM executeFavoriteQueries ### END 4/27/2022 1:06:28 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 4/27/2022 1:06:28 PM ProcessData ### ProcessData Finished 4/27/2022 1:06:28 PM ProcessData ### End ------------------------------------------- 4/27/2022 1:50:02 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/27/2022 1:50:02 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/27/2022 1:55:01 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/27/2022 2:04:42 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/27/2022 2:06:06 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/27/2022 6:00:06 PM Post Favourite ### After Select Query 4/27/2022 6:00:06 PM ProcessData ### Inside Pre Processed Report 4/27/2022 6:00:06 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr27233006357 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 4/27/2022 6:00:08 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/27/2022 6:00:08 PM processDataUsingPostTableXML ### Finished 4/27/2022 6:00:08 PM processDataUsingPostTableXML ### End