------------------------------------------- 6/6/2022 2:53:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 2:53:48 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 2:53:49 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 2:54: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) ------------------------------------------- 6/6/2022 4:56:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 4:56:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 4:58:01 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) 6/6/2022 6:00:03 AM Post Favourite ### After Select Query 6/6/2022 6:00:03 AM ProcessData ### Inside Pre Processed Report 6/6/2022 6:00:03 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Jun06113003010 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/6/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) 6/6/2022 6:00:04 AM ProcessData ### Inside Pre Processed Report 6/6/2022 6:00:04 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Jun06113003043 ### exec [prDistributorFileUploadStatus] '000000000000001','Jun 6 2022 11:30AM','7','','','','000000000000289','' 6/6/2022 6:00:05 AM Post Favourite ### After Fill DataSet 6/6/2022 6:00:05 AM Excel Favourite Report ### Excel Case 6/6/2022 6:00:05 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 06Jun2022060005.xls 6/6/2022 6:00:05 AM Excel Favourite Report ### After Checking File Exist Or Create New File 6/6/2022 6:00:05 AM Excel Favourite Report ### After Writing to File 6/6/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/6/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/6/2022 6:00:06 AM processDataUsingPostTableXML ### Finished 6/6/2022 6:00:06 AM processDataUsingPostTableXML ### End ------------------------------------------- 6/6/2022 6:17:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 6:17:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 6:17:53 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) ------------------------------------------- 6/6/2022 6:17: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() ------------------------------------------- 6/6/2022 6:18: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() ------------------------------------------- 6/6/2022 6:18: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() ------------------------------------------- 6/6/2022 6: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() ------------------------------------------- 6/6/2022 6:20:28 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,VOUCHER,DATE', 'MONTH', '0000000001655322022Jun06062028', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 6:23: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) ------------------------------------------- 6/6/2022 6:23:45 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() ------------------------------------------- 6/6/2022 6:23: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() ------------------------------------------- 6/6/2022 6:24: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() ------------------------------------------- 6/6/2022 6:24: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() ------------------------------------------- 6/6/2022 6:24:23 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() ------------------------------------------- 6/6/2022 6:24:29 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/6/2022 6:25:38 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,VOUCHER,DATE', 'MONTH', '0000000001655322022Jun06062538', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 6:37:10 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,VOUCHER,DATE', 'MONTH', '0000000001655322022Jun06063710', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 6:39:09 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,VOUCHER,DATE', 'MONTH', '0000000001655322022Jun06063909', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 7:58:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 7:58:45 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 7:58:53 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) ------------------------------------------- 6/6/2022 7:59:01 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() ------------------------------------------- 6/6/2022 7:59: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() ------------------------------------------- 6/6/2022 7:59:09 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() ------------------------------------------- 6/6/2022 7:59: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() ------------------------------------------- 6/6/2022 7:59:23 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() ------------------------------------------- 6/6/2022 8:00:36 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,DATE', 'MONTH', '0000000001655322022Jun06080036', '0', '<>0', 'SALE', '000000000165532', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 8:11:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 8:11:46 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 8:17:23 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) ------------------------------------------- 6/6/2022 8:40:51 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 8:40:51 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 8:57:34 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### Error for Query :update dateitemlink set ToDate='02 Jun 2022',IsLinkUpdated='true',UserId='000000000165532',LastEditDate=getdate() where code ='K-Othrine SC 25.5 15x 1lt' and distributorid='000000000000356' and todate= '2022-6-2' and ID =65468 ------------------------------------------- 6/6/2022 8:57:34 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### AddLink Class, Update_ItemLink Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [40001] [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 131) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteNonQuery() at NewItemLink.Update_ItemLink(String connectionString, String distId, String itemCode, String itemName, String itemBPC, String itemId, String TableName, String FromDate, String ToDate, Int32 OpeningStock, Int32 UniqueItemID, String oldItemId, Boolean isQuantityInCaseItem, Boolean isUnitFromVolumeItem, Double intDealerEndConv, String strLoginId) ------------------------------------------- 6/6/2022 9:07:52 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:07:52 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:11:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:11:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:17:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:17:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:18:50 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:18:50 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:30:23 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) ------------------------------------------- 6/6/2022 9:30: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() ------------------------------------------- 6/6/2022 9:30: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() ------------------------------------------- 6/6/2022 9:31: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() ------------------------------------------- 6/6/2022 9:31:13 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() ------------------------------------------- 6/6/2022 9:31:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:31:26 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 9:32:13 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) ------------------------------------------- 6/6/2022 9:32: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() ------------------------------------------- 6/6/2022 9:32:25 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/6/2022 9:33:04 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'MONTH', '0000000000000042022Jun06093304', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' 6/6/2022 9:34:35 AM ProcessData ### Begin 6/6/2022 9:34:35 AM ProcessData ### Scanning FavouriteReport 6/6/2022 9:34:35 AM ProcessData ### Before Executing Favourite Report Select Query 6/6/2022 9:34:35 AM ProcessData ### After Executing Favourite Report Select Query 6/6/2022 9:34:35 AM ProcessData ### Inside If Action = 0 Condition 6/6/2022 9:34:35 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 9:34:35 AM executeFavoriteQueries ### BEGIN 6/6/2022 9:34:35 AM executeFavoriteQueries ### Before While Condition 6/6/2022 9:34:35 AM executeFavoriteQueries ### After While Condition 6/6/2022 9:34:35 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/6/2022 9:34:35 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/6/2022 9:34:35 AM After Filling DataSet For Query Favourite For User ### 000000000165532 6/6/2022 9:34:35 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/6/2022 9:34:35 AM executeFavoriteQueries ### END 6/6/2022 9:34:35 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 9:34:35 AM ProcessData ### ProcessData Finished 6/6/2022 9:34:35 AM ProcessData ### End ------------------------------------------- 6/6/2022 9:36:30 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,DATE', 'MONTH', '0000000000000042022Jun06093630', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 10:17:28 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 10:17:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 10:17:51 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 10:17:51 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 11:59:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 11:59:24 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 11:59:24 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 11:59:36 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) ------------------------------------------- 6/6/2022 11:59:47 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() ------------------------------------------- 6/6/2022 11:59: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() ------------------------------------------- 6/6/2022 11:59: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() ------------------------------------------- 6/6/2022 11:59: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() ------------------------------------------- 6/6/2022 12:00: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() ------------------------------------------- 6/6/2022 12:00:11 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() ------------------------------------------- 6/6/2022 12:01:47 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,PARTY,AREA,LicenceNo,CUSTOMERID,DATE', 'MONTH', '0000000001655332022Jun06120147', '0', '<>0', 'SALE', '000000000165533', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 12:01:51 PM 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) ------------------------------------------- 6/6/2022 12:01:51 PM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 6/6/2022 12:17:33 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 12:17:33 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 12:24:21 PM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 9735 ------------------------------------------- 6/6/2022 12:24:23 PM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 7057 ------------------------------------------- 6/6/2022 12:24:23 PM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 9735 ------------------------------------------- 6/6/2022 12:58:04 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 12:58:04 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/6/2022 12:59:31 PM ProcessData ### Begin 6/6/2022 12:59:31 PM ProcessData ### Scanning FavouriteReport 6/6/2022 12:59:31 PM ProcessData ### Before Executing Favourite Report Select Query 6/6/2022 12:59:31 PM ProcessData ### After Executing Favourite Report Select Query 6/6/2022 12:59:31 PM ProcessData ### Inside If Action = 0 Condition 6/6/2022 12:59:31 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 12:59:31 PM executeFavoriteQueries ### BEGIN 6/6/2022 12:59:31 PM executeFavoriteQueries ### Before While Condition 6/6/2022 12:59:31 PM executeFavoriteQueries ### After While Condition 6/6/2022 12:59:31 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/6/2022 12:59:31 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/6/2022 12:59:31 PM After Filling DataSet For Query Favourite For User ### 000000000165532 6/6/2022 12:59:31 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/6/2022 12:59:31 PM executeFavoriteQueries ### END 6/6/2022 12:59:31 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 12:59:31 PM ProcessData ### ProcessData Finished 6/6/2022 12:59:31 PM ProcessData ### End ------------------------------------------- 6/6/2022 1:09:57 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 1:09:57 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/6/2022 1:10:05 PM ProcessData ### Begin 6/6/2022 1:10:05 PM ProcessData ### Scanning FavouriteReport 6/6/2022 1:10:05 PM ProcessData ### Before Executing Favourite Report Select Query 6/6/2022 1:10:05 PM ProcessData ### After Executing Favourite Report Select Query 6/6/2022 1:10:05 PM ProcessData ### Inside If Action = 0 Condition 6/6/2022 1:10:05 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 1:10:05 PM executeFavoriteQueries ### BEGIN 6/6/2022 1:10:05 PM executeFavoriteQueries ### Before While Condition 6/6/2022 1:10:05 PM executeFavoriteQueries ### After While Condition 6/6/2022 1:10:05 PM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/6/2022 1:10:05 PM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/6/2022 1:10:05 PM After Filling DataSet For Query Favourite For User ### 000000000165532 6/6/2022 1:10:05 PM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/6/2022 1:10:05 PM executeFavoriteQueries ### END 6/6/2022 1:10:05 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/6/2022 1:10:05 PM ProcessData ### ProcessData Finished 6/6/2022 1:10:05 PM ProcessData ### End ------------------------------------------- 6/6/2022 1:53:02 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 1:53:02 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 2:08:58 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 2:08:58 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 3:29:37 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/6/2022 3:29:37 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/6/2022 3:32:00 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 6/6/2022 3:32: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() ------------------------------------------- 6/6/2022 3:34:01 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() ------------------------------------------- 6/6/2022 3:34:07 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() ------------------------------------------- 6/6/2022 3:34:13 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() ------------------------------------------- 6/6/2022 3:35:24 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,DATE', 'MNTHYR', '0000000001655312022Jun06033524', '0', '<>0', 'SALE', '000000000165531', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 3:35:26 PM 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) ------------------------------------------- 6/6/2022 3:35:26 PM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 6/6/2022 3:36:58 PM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### 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) ------------------------------------------- 6/6/2022 3:40:24 PM GenClass Class, AssignToDropDown Function ### After AssignToDropDown() function for all dropdowns ### 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) ------------------------------------------- 6/6/2022 3:40:29 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() ------------------------------------------- 6/6/2022 3:40:34 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() ------------------------------------------- 6/6/2022 3:40:40 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() ------------------------------------------- 6/6/2022 3:41:56 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001655312022Jun06034156', '0', '<>0', 'SALE', '000000000165531', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','False','1','0' ------------------------------------------- 6/6/2022 3:41:58 PM 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) ------------------------------------------- 6/6/2022 3:41:58 PM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. 6/6/2022 6:00:06 PM Post Favourite ### After Select Query 6/6/2022 6:00:06 PM ProcessData ### Inside Pre Processed Report 6/6/2022 6:00:06 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Jun06233006433 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/6/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) 6/6/2022 6:00:07 PM processDataUsingPostTableXML ### Finished 6/6/2022 6:00:07 PM processDataUsingPostTableXML ### End