------------------------------------------- 5/25/2022 3:23:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 3:23:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 3:26:42 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) ------------------------------------------- 5/25/2022 3:47:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 3:47:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 3:59:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 3:59:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:22:05 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:22:05 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:42:30 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:42:30 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:51:04 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:51:04 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:59:12 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:59:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 4:59:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:03:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:03:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:04:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:04:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:05:18 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:05:18 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:05:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:05:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:55 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:06:55 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:24:37 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 5/25/2022 5:32:57 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 5/25/2022 5:36:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:36:01 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:36:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 5:36:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/25/2022 6:00:04 AM Post Favourite ### After Select Query 5/25/2022 6:00:04 AM ProcessData ### Inside Pre Processed Report 5/25/2022 6:00:04 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022May25113003980 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 5/25/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) 5/25/2022 6:00:05 AM ProcessData ### Inside Pre Processed Report 5/25/2022 6:00:05 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022May25113004017 ### exec [prDistributorFileUploadStatus] '000000000000001','May 25 2022 11:30AM','7','','','','000000000000289','' 5/25/2022 6:00:06 AM Post Favourite ### After Fill DataSet 5/25/2022 6:00:06 AM Excel Favourite Report ### Excel Case 5/25/2022 6:00:06 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 25May2022060006.xls 5/25/2022 6:00:06 AM Excel Favourite Report ### After Checking File Exist Or Create New File 5/25/2022 6:00:06 AM Excel Favourite Report ### After Writing to File 5/25/2022 6:00:06 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 5/25/2022 6:00:07 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 5/25/2022 6:00:07 AM processDataUsingPostTableXML ### Finished 5/25/2022 6:00:07 AM processDataUsingPostTableXML ### End ------------------------------------------- 5/25/2022 6:14:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 6:14:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 6:24:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 6:24:36 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 6:24:58 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25:08 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25:11 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25: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() ------------------------------------------- 5/25/2022 6:25:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25: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() ------------------------------------------- 5/25/2022 6:25:32 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25:40 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25: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() ------------------------------------------- 5/25/2022 6:25: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() ------------------------------------------- 5/25/2022 6:25:50 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:25:57 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 5/25/2022 6:26:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,PARTY,AREA,LicenceNo,CUSTOMERID,CUSTOMERCLASS,CUSTOMERCODE,Telephone,GSTNUMBER,ITEM,ITEMALIAS,BRAND,DATE,VOUCHER', 'YEAR', '0000000000009982022May25062615', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/25/2022 6:26:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/25/2022 6:26:36 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/25/2022 6:26:37 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,PARTY,AREA,LicenceNo,CUSTOMERID,CUSTOMERCLASS,CUSTOMERCODE,Telephone,GSTNUMBER,ITEM,ITEMALIAS,BRAND,DATE,VOUCHER', 'YEAR', '0000000000009982022May25062637', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','False','1','0' ------------------------------------------- 5/25/2022 6:26:58 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis.aspx.cs :btnGenerate ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at ReportCriterias.btnGenrate_Click(Object sender, EventArgs e) ------------------------------------------- 5/25/2022 6:26:58 AM GenClass Class, ReturnScaler Function ### Before AcceptChanges() ### SalesAnalysis page, ddlExport_SelectedIndexChanged ### Thread was being aborted. ------------------------------------------- 5/25/2022 6:35:48 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 6:35:48 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 7:09:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 7:09:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 7:55:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 7:55:03 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/25/2022 8:30:03 AM Post Favourite ### After Select Query 5/25/2022 8:30:03 AM ProcessData ### Inside Pre Processed Report 5/25/2022 8:30:03 AM processDataUsingPostTableXML strScript for BAYER QA Last Upload Date Query 2022May25140002903 ### select f.Distributorid, d.Distributor, d.ERPCode, format(f.LastImportDate,'dd-MMM-yyyy HH:mm:ss') as [UploadDate] , format(f.MinDate,'dd-MMM-yyyy') as MinDate, format(f.MaxDate,'dd-MMM-yyyy') as [Last Invoice Date] from FileWiseHashCode f, Pdistributor d where d.distributorid = f.distributorid and cast(f.LastImportDate as date) = cast(getdate() as date) and f.FileType ='IN' order by uploaddate desc , distributor 5/25/2022 8:30:03 AM Post Favourite ### After Fill DataSet 5/25/2022 8:30:03 AM Excel Favourite Report ### Excel Case 5/25/2022 8:30:03 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Last Upload Date Query 25May2022083003.xls 5/25/2022 8:30:03 AM Excel Favourite Report ### After Checking File Exist Or Create New File 5/25/2022 8:30:03 AM Excel Favourite Report ### After Writing to File 5/25/2022 8:30:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 5/25/2022 8:30:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 5/25/2022 8:30:03 AM processDataUsingPostTableXML ### Finished 5/25/2022 8:30:03 AM processDataUsingPostTableXML ### End ------------------------------------------- 5/25/2022 8:43:30 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:43:30 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:46:12 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:46:12 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:46:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:46:58 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:47:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:47:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:49:15 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 8:49:15 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 9:19:12 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 9:19:12 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 9:22:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 9:58:27 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 10:34:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 10:34:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 10:34:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 10:37:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 10:37:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 11:56:30 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 11:56:30 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:25:32 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:25:37 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:25:37 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:28:12 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:28:12 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:10 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### QueryExecuter.aspx.cs :btnExecute ### System.ArgumentNullException: Value cannot be null. Parameter name: path1 at System.IO.Path.Combine(String path1, String path2) at QueryExecuterForSettings.WriteQueryLog(String Type, String Message) at QueryExecuterForSettings.btnExecute_Click(Object sender, EventArgs e) ------------------------------------------- 5/25/2022 12:29:39 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:39 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:45 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:45 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:46 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:29:46 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/25/2022 12:30:10 PM ProcessData ### Begin 5/25/2022 12:30:10 PM ProcessData ### Scanning FavouriteReport 5/25/2022 12:30:10 PM ProcessData ### Before Executing Favourite Report Select Query 5/25/2022 12:30:10 PM ProcessData ### After Executing Favourite Report Select Query 5/25/2022 12:30:10 PM ProcessData ### Inside If Action = 0 Condition 5/25/2022 12:30:10 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/25/2022 12:30:10 PM executeDistributorFileUploadStatus ### BEGIN 5/25/2022 12:30:10 PM executeDistributorFileUploadStatus ### Before Setting Store Procedure Parameter 5/25/2022 12:30:10 PM executeDistributorFileUploadStatus ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000000001 5/25/2022 12:30:10 PM executeDistributorFileUploadStatus ### After Executing Store Procedure For User 000000000000001 5/25/2022 12:30:10 PM executeDistributorFileUploadStatus ### Error converting data type varchar to smallint. 5/25/2022 12:30:10 PM DistributorFileUploadStatus ### END 5/25/2022 12:30:10 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/25/2022 12:30:10 PM ProcessData ### ProcessData Finished 5/25/2022 12:30:10 PM ProcessData ### End ------------------------------------------- 5/25/2022 12:33:18 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:33:18 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:53:35 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 5/25/2022 12:53:35 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 5/25/2022 1:07:51 PM ProcessData ### Begin 5/25/2022 1:07:51 PM ProcessData ### Scanning FavouriteReport 5/25/2022 1:07:51 PM ProcessData ### Before Executing Favourite Report Select Query 5/25/2022 1:07:51 PM ProcessData ### After Executing Favourite Report Select Query 5/25/2022 1:07:51 PM ProcessData ### Inside If Action = 0 Condition 5/25/2022 1:07:51 PM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/25/2022 1:07:51 PM executeDistributorFileUploadStatus ### BEGIN 5/25/2022 1:07:51 PM executeDistributorFileUploadStatus ### Before Setting Store Procedure Parameter 5/25/2022 1:07:51 PM executeDistributorFileUploadStatus ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165533 5/25/2022 1:07:51 PM executeDistributorFileUploadStatus ### After Executing Store Procedure For User 000000000165533 5/25/2022 1:07:51 PM executeDistributorFileUploadStatus ### Error converting data type varchar to smallint. 5/25/2022 1:07:51 PM DistributorFileUploadStatus ### END 5/25/2022 1:07:51 PM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 5/25/2022 1:07:51 PM ProcessData ### ProcessData Finished 5/25/2022 1:07:51 PM ProcessData ### End ------------------------------------------- 5/25/2022 1:24:29 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### An item with the same key has already been added. ------------------------------------------- 5/25/2022 1:35:33 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### An item with the same key has already been added. 5/25/2022 6:00:06 PM Post Favourite ### After Select Query 5/25/2022 6:00:06 PM ProcessData ### Inside Pre Processed Report 5/25/2022 6:00:06 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022May25233006290 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 5/25/2022 6:00:07 PM processDataUsingPostTableXML,Error while executing procedure :EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES', Error: ### Cannot drop the table '##CustomerUnlkDetails', because it does not exist or you do not have permission. Cannot drop the table '##CustomerUnlkDetails_Division', because it does not exist or you do not have permission. INSERT INTO ##CustomerUnlkDetails SELECT CL.ID AS DATAID , PD.DISTRIBUTORGROUP, PD.DistributorId AS DBID, PD.Distributor AS DISTRIBUTOR, CL.Code AS PARTY_ID, CL.Name AS PARTY_NAME, CL.ADDRESS AS PARTY_ADDRESS, T1.CITY, T1.STATE, T1.PINCODE, T1.PHONE_NO, T1.CONTACT_PERSON, T1.MOBILE_PHONE_NO, T1.PAN_NO, T1.LIC_NO, CL.LicenceNo AS GSTNO FROM PDistributor AS PD INNER JOIN CUSTOMERLINK AS CL ON PD.DistributorId = CL.DistributorId AND PD.UnkCustomerId = CL.TargetId LEFT OUTER JOIN TEMPLATE1 AS T1 ON CL.DistributorId = T1.DistributorID AND CL.Code = T1.PARTY_ID WHERE (PD.DISTRIBUTORGROUP IN ('ES','COMMON')) AND (CL.ID > 58178) 5/25/2022 6:00:07 PM processDataUsingPostTableXML ### Finished 5/25/2022 6:00:07 PM processDataUsingPostTableXML ### End