------------------------------------------- 1/19/2022 5:27:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 5:27:09 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 5:33:33 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) ------------------------------------------- 1/19/2022 5:40:22 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 1/19/2022 5:40: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() ------------------------------------------- 1/19/2022 5:40: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() ------------------------------------------- 1/19/2022 5:41:51 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Customer_history.cs :GetDistributorName Operation ### System.Data.SqlClient.SqlException (0x80131904): Procedure or function prSalesanalysisLoad has too many arguments specified. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Customer_history.GetValueOfCriteria(String prefixText, String contextKey) in d:\BAYER\Zylem\ZylemMIS\Customer_history.asmx:line 2778 ClientConnectionId:541fe949-6039-49a0-b27e-82ed317a2000 Error Number:8144,State:2,Class:16 1/19/2022 6:00:03 AM processDataUsingPostTableXML ### dtFinalFav Count = 3 1/19/2022 6:00:03 AM ProcessData ### Inside Pre Processed Report 1/19/2022 6:00:03 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2022Jan19113003660 ### SELECT distinct cast(cast(t.distributorid as int) as varchar) + replace(convert(varchar(8), getdate(), 112)+convert(varchar(8), getdate(), 114), ':','') as ID,cast(getdate() as varchar(50)) as ScheduledDateTime,Distributor,t.LastImportDate,LastInvoiceDate FROM filewisehashcode t INNER JOIN (SELECT distributorid,MAX(LastImportDate) LastImportDate FROM filewisehashcode where filetype='IN' GROUP BY distributorid) MaxDate ON t.distributorid = MaxDate.distributorid AND t.LastImportDate = MaxDate.LastImportDate Inner join pdistributor pd on t.DistributorId=pd.DistributorId inner join usermaster um on pd.UserId=um.id where pd.IsActive =1 and t.MinDate IS NOT NULL and datediff(day,( CAST ( MaxDate.LastImportDate as Date)) ,( cast(GETDATE() as DATE) )) >10 1/19/2022 6:00:03 AM Post Favourite ### After Fill DataSet 1/19/2022 6:00:04 AM Excel Favourite Report ### Html Case 1/19/2022 6:00:04 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 19Jan2022060003.html 1/19/2022 6:00:04 AM Excel Favourite Report ### After Checking File Exist Or Create New File 1/19/2022 6:00:04 AM Excel Favourite Report ### After Writing to File 1/19/2022 6:00:04 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2022Jan19113003660 1/19/2022 6:00:04 AM processDataUsingPostTableXML ### Create Zip 1/19/2022 6:00:04 AM processDataUsingPostTableXML ### Added PendingXml 1/19/2022 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/19/2022 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/19/2022 6:00:04 AM ProcessData ### Inside Pre Processed Report 1/19/2022 6:00:04 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Jan19113003720 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 1/19/2022 6:05:00 AM Post Favourite ### After Fill DataSet 1/19/2022 6:05:00 AM Excel Favourite Report ### Excel Case 1/19/2022 6:05:00 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 19Jan2022060500.xls 1/19/2022 6:05:00 AM Excel Favourite Report ### After Checking File Exist Or Create New File 1/19/2022 6:05:00 AM Excel Favourite Report ### After Writing to File 1/19/2022 6:05:01 AM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2022Jan19113003720 1/19/2022 6:05:01 AM processDataUsingPostTableXML ### Create Zip 1/19/2022 6:05:01 AM processDataUsingPostTableXML ### Added PendingXml 1/19/2022 6:05:01 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/19/2022 6:05:01 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/19/2022 6:05:01 AM ProcessData ### Inside Pre Processed Report 1/19/2022 6:05:01 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Jan19113003770 ### exec [prDistributorFileUploadStatus] '000000000000001','Jan 19 2022 11:30AM','7','','','','000000000000289','' 1/19/2022 6:05:02 AM Post Favourite ### After Fill DataSet 1/19/2022 6:05:02 AM Excel Favourite Report ### Excel Case 1/19/2022 6:05:03 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 19Jan2022060502.xls 1/19/2022 6:05:03 AM Excel Favourite Report ### After Checking File Exist Or Create New File 1/19/2022 6:05:03 AM Excel Favourite Report ### After Writing to File 1/19/2022 6:05:03 AM processDataUsingPostTableXML ### Write PendingXml ES_DistributorFileUploadStatus 2022Jan19113003770 1/19/2022 6:05:03 AM processDataUsingPostTableXML ### Create Zip 1/19/2022 6:05:03 AM processDataUsingPostTableXML ### Added PendingXml 1/19/2022 6:05:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/19/2022 6:05:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/19/2022 6:05:03 AM processDataUsingPostTableXML ### Finished 1/19/2022 6:05:03 AM processDataUsingPostTableXML ### End ------------------------------------------- 1/19/2022 7:42:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 7:42:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 7:54:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 7:54:54 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 7:54:54 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 8:29:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 8:29:23 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 8:29:46 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) ------------------------------------------- 1/19/2022 8:30: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() ------------------------------------------- 1/19/2022 8:30: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() ------------------------------------------- 1/19/2022 8:30:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 1/19/2022 8:31:08 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000001599342022Jan19083108', '0', '<>0', 'SALE', '000000000159934', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1','0' ------------------------------------------- 1/19/2022 8:52:56 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 8:52:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 9:36:03 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 9:36:03 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 10:40:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 10:40:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/19/2022 12:46:24 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/19/2022 12:46:24 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 1/19/2022 6:00:04 PM processDataUsingPostTableXML ### dtFinalFav Count = 0 1/19/2022 6:00:04 PM processDataUsingPostTableXML ### Finished 1/19/2022 6:00:04 PM processDataUsingPostTableXML ### End