------------------------------------------- 2/15/2022 4:54:54 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 4:55:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 4:55:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 2/15/2022 4:58:21 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) ------------------------------------------- 2/15/2022 5:21:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 5:21:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 2/15/2022 6:00:02 AM Post Favourite ### After Select Query 2/15/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 2/15/2022 6:00:02 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2022Feb15113002717 ### 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 2/15/2022 6:00:03 AM Post Favourite ### After Fill DataSet 2/15/2022 6:00:03 AM Excel Favourite Report ### Html Case 2/15/2022 6:00:03 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 15Feb2022060003.html 2/15/2022 6:00:03 AM Excel Favourite Report ### After Checking File Exist Or Create New File 2/15/2022 6:00:03 AM Excel Favourite Report ### After Writing to File 2/15/2022 6:00:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 2/15/2022 6:00:03 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 2/15/2022 6:00:03 AM ProcessData ### Inside Pre Processed Report 2/15/2022 6:00:03 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Feb15113002780 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 2/15/2022 6:04:22 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) 2/15/2022 6:04:22 AM ProcessData ### Inside Pre Processed Report 2/15/2022 6:04:22 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Feb15113002833 ### exec [prDistributorFileUploadStatus] '000000000000001','Feb 15 2022 11:30AM','7','','','','000000000000289','' 2/15/2022 6:04:23 AM Post Favourite ### After Fill DataSet 2/15/2022 6:04:23 AM Excel Favourite Report ### Excel Case 2/15/2022 6:04:23 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 15Feb2022060423.xls 2/15/2022 6:04:23 AM Excel Favourite Report ### After Checking File Exist Or Create New File 2/15/2022 6:04:23 AM Excel Favourite Report ### After Writing to File 2/15/2022 6:04:23 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 2/15/2022 6:04:23 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 2/15/2022 6:04:23 AM processDataUsingPostTableXML ### Finished 2/15/2022 6:04:23 AM processDataUsingPostTableXML ### End ------------------------------------------- 2/15/2022 7:30:29 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 7:30:29 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 2/15/2022 7:33:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 7:33:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 2/15/2022 7:36:53 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) ------------------------------------------- 2/15/2022 7:38:37 AM Error in ItemMaster.aspx.cs:In Page_Load() ### Before calling fillCombo() function ### 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) ------------------------------------------- 2/15/2022 7:42:51 AM GenClass Class, FillCombo Function ### After select query for ITEMMASTER ### TargetDetails.aspx.cs :Page_Load() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'prSalesanalysisLoadForTarget'. 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 TargetDetails.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 8:46:24 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 8:46:24 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 2/15/2022 8:47:10 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 8:52:58 AM Linking Class, GetBranchId Function ### After ExecuteScalar ### 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) ------------------------------------------- 2/15/2022 8:55:40 AM BranchDivItem Class, Filling Drop Down ### After binding of the cmbBranch Combo Box ### ItemMaster.aspx.cs:In fillCombo() Function ### select name,id from subgroupmaster where groupid='DIVISION' order by name ------------------------------------------- 2/15/2022 9:03:48 AM Error in FavouriteSequence.aspx.cs:In Page_Load() ### After call to fillCombo() ### DistributorAllocation.aspx.cs : Page_Load ### System.Data.Odbc.OdbcException (0x80131937): ERROR [HY007] [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcDataReader.get_FieldCount() at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.get_VisibleFieldCount() at System.Data.ProviderBase.DataReaderContainer.Create(IDataReader dataReader, Boolean returnProviderSpecificTypes) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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 DistributorAllocation.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:14:12 AM GenClass Class, FillCombo Function ### After Filling DataSet ### DistributorDetails.aspx.cs :Page_Load() ### System.NullReferenceException: Object reference not set to an instance of an object. at DisplayDistributorFile.RadioButtonList1_SelectedIndexChanged(Object sender, EventArgs e) at DisplayDistributorFile.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:17:15 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) ------------------------------------------- 2/15/2022 9:19:03 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### IsAuthorizedUser ### Start IsAuthorizedUser code ------------------------------------------- 2/15/2022 9:19:03 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### IsAuthorizedUser ### End IsAuthorizedUser code ------------------------------------------- 2/15/2022 9:19:38 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMiniOrderBookedReport.aspx.cs :btnGo_Click() Exicuting SP : ### EXEC [pr_ZyleminiOrderBookedReport] '000000000000001','','','','','','','','','01-Feb-2022','28-Feb-2022','','','1','' ------------------------------------------- 2/15/2022 9:19:58 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sku'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #SKUWiseSales select usermaster.Id, '', Pitem.Item,'',sum(ZyleminiOrderDetails.LargeUnit*Pitem.BPC+ZyleminiOrderDetails.SmallUnit) as QuntityInCases,ZyleminiOrderDetails.Rate,sum(amount) as Value from ZyleminiOrderMaster full outer join ZyleminiOrderDetails on ZyleminiOrderDetails.orderid=ZyleminiOrderMaster.id left join usermaster on cast(usermaster.id as int)=ZyleminiOrderMaster.userid left join dbo.Pitem ON dbo.ZyleminiOrderDetails.itemid = dbo.Pitem.itemid where ZyleminiOrderMaster.collectiontype in (0,4) and cast(ZyleminiOrderMaster.CurrentDatetime as date) >='01-Feb-2022' and cast(ZyleminiOrderMaster.CurrentDatetime as date)<='28-Feb-2022' and ZyleminiOrderMaster.Userid in (select userid from #UserChildren) group by usermaster.Id,Item,CollectionType,ZyleminiOrderDetails.rate order by Item 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 GenClass.ExecuteSQL(String ConnectionString, String sql) ------------------------------------------- 2/15/2022 9:20:14 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### ZylemMiniOrderBookedReport.aspx.cs :btnGo_Click() Exicuting SP : ### EXEC [pr_ZyleminiOrderBookedReport] '000000000000001','','','','','','','','','01-Feb-2022','28-Feb-2022','','','3','' ------------------------------------------- 2/15/2022 9:24:30 AM GenClass Class, FillCombo Function ### After Filling DataSet ### In Page_Load ### Settings.aspx(changePassword)page ------------------------------------------- 2/15/2022 9:24:30 AM GenClass Class, FillCombo Function ### After Filling DataSet ### In Page_Load ### Settings.aspx Send ------------------------------------------- 2/15/2022 9:26:51 AM GenClass Class, FillCombo Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:26:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 2/15/2022 9:27: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() ------------------------------------------- 2/15/2022 9:27:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'BRAND', 'MNTHYR', '0000000000000012022Feb15092720', '0', '<>0', 'SALE', '000000000000001', 0, '', '','BRAND','0','','2','3','False','False','False','1','0' ------------------------------------------- 2/15/2022 9:28:19 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 8136 ------------------------------------------- 2/15/2022 9:28:20 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 6066 ------------------------------------------- 2/15/2022 9:28:20 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 8136 ------------------------------------------- 2/15/2022 9:32:52 AM Error in SalesAnalysis.aspx.cs :Page_Load() ### Before select query for SUBGROUPMASTER ### SalesAnalysis.aspx.cs :Page_Load() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prSalesanalysisLoad' expects parameter '@IncludeDateValidation', which was not supplied. 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 InvoiceCount.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:34:34 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SchemeDistributor.aspx.cs :Page_Load ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 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 SchemeDistributor.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:37:47 AM GenClass Class, InsertTimeStamp Function ### After EXEC SP_PackwiseAvailability ### PackwiseAvailabilityReport.aspx.cs :btnGenerate() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The column '3585625' was specified multiple times for 'PivotedTable'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 PackwiseAvailabilityReport.btnGenerate_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:39:03 AM GenClass Class, InsertTimeStamp Function ### After EXEC prWeeklyPlanReport ### WeeklyPlanReport.aspx.cs :btnGenerate_Click ### System.Data.Odbc.OdbcException (0x80131937): ERROR [HY007] [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcDataReader.get_FieldCount() at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.get_VisibleFieldCount() at System.Data.ProviderBase.DataReaderContainer.Create(IDataReader dataReader, Boolean returnProviderSpecificTypes) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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 WeeklyPlanReport.btnGenerate_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:41:28 AM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btNewSearch_Click() ### Procedure call prZylemAuditLogReport '000000000000001','15-Feb-2022','15-Feb-2022','','','','','' ------------------------------------------- 2/15/2022 9:41:28 AM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btNewSearch_Click() ### Data Bind Completed. ------------------------------------------- 2/15/2022 9:43:24 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'prFieldAssistSaleOrderReport'. 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 GenClass.ExecuteSQL(String ConnectionString, String sql) ------------------------------------------- 2/15/2022 9:43:24 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### FieldAssistSaleOrderReport.aspx.cs:InbtnGo_Click() Function ### System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at FieldAssistSaleOrderReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:46:12 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 9:47:30 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ClosingStockReport: Query ### select ClosingStock.DistributorId,PDistributor.Distributor,ClosingStock.ItemId,PItem.Item,PItem.ItemAlias,ClosingAsOnDate,sum(ClosingStock/bpc) as ClosingStock,StockInTransit,TruckWaiting,InterDepotTranfer from ClosingStock,Pdistributor,PItem where ClosingStock.distributorid=Pdistributor.distributorid and PItem.ItemId=ClosingStock.itemid group by ClosingStock.DistributorId,PDistributor.Distributor,ClosingStock.ItemId,PItem.Item,PItem.ItemAlias,ClosingAsOnDate,StockInTransit,TruckWaiting,InterDepotTranfer order by PItem.Item ------------------------------------------- 2/15/2022 9:48:25 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. ------------------------------------------- 2/15/2022 9:48:25 AM Linking Class, FillGrid Function ### After call to the FillGrid function ### DiffReport.aspx.cs:In FillGrid() Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. 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, String srcTable) at DataQCItemLinkTransMismatch.FillGrid() ------------------------------------------- 2/15/2022 10:16:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 10:16:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 2/15/2022 10:17:10 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) ------------------------------------------- 2/15/2022 10:17:36 AM Error in ItemMaster.aspx.cs:In Page_Load() ### Before calling fillCombo() function ### 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) ------------------------------------------- 2/15/2022 10:18:07 AM GenClass Class, FillCombo Function ### After select query for ITEMMASTER ### TargetDetails.aspx.cs :Page_Load() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'prSalesanalysisLoadForTarget'. 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 TargetDetails.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:18:57 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:22:47 AM Linking Class, GetBranchId Function ### After ExecuteScalar ### 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) ------------------------------------------- 2/15/2022 10:24:12 AM BranchDivItem Class, Filling Drop Down ### After binding of the cmbBranch Combo Box ### ItemMaster.aspx.cs:In fillCombo() Function ### select name,id from subgroupmaster where groupid='DIVISION' order by name ------------------------------------------- 2/15/2022 10:34:33 AM Error in FavouriteSequence.aspx.cs:In Page_Load() ### After call to fillCombo() ### DistributorAllocation.aspx.cs : Page_Load ### System.Data.Odbc.OdbcException (0x80131937): ERROR [HY007] [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcDataReader.get_FieldCount() at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.get_VisibleFieldCount() at System.Data.ProviderBase.DataReaderContainer.Create(IDataReader dataReader, Boolean returnProviderSpecificTypes) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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 DistributorAllocation.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:40:50 AM GenClass Class, FillCombo Function ### After Filling DataSet ### DistributorDetails.aspx.cs :Page_Load() ### System.NullReferenceException: Object reference not set to an instance of an object. at DisplayDistributorFile.RadioButtonList1_SelectedIndexChanged(Object sender, EventArgs e) at DisplayDistributorFile.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:41: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) ------------------------------------------- 2/15/2022 10:41:52 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 10:42:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### IsAuthorizedUser ### Start IsAuthorizedUser code ------------------------------------------- 2/15/2022 10:42:07 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### IsAuthorizedUser ### End IsAuthorizedUser code ------------------------------------------- 2/15/2022 10:42:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMiniOrderBookedReport.aspx.cs :btnGo_Click() Exicuting SP : ### EXEC [pr_ZyleminiOrderBookedReport] '000000000000001','','','','','','','','','01-Feb-2022','28-Feb-2022','','','1','' ------------------------------------------- 2/15/2022 10:42:34 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sku'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #SKUWiseSales select usermaster.Id, '', Pitem.Item,'',sum(ZyleminiOrderDetails.LargeUnit*Pitem.BPC+ZyleminiOrderDetails.SmallUnit) as QuntityInCases,ZyleminiOrderDetails.Rate,sum(amount) as Value from ZyleminiOrderMaster full outer join ZyleminiOrderDetails on ZyleminiOrderDetails.orderid=ZyleminiOrderMaster.id left join usermaster on cast(usermaster.id as int)=ZyleminiOrderMaster.userid left join dbo.Pitem ON dbo.ZyleminiOrderDetails.itemid = dbo.Pitem.itemid where ZyleminiOrderMaster.collectiontype in (0,4) and cast(ZyleminiOrderMaster.CurrentDatetime as date) >='01-Feb-2022' and cast(ZyleminiOrderMaster.CurrentDatetime as date)<='28-Feb-2022' and ZyleminiOrderMaster.Userid in (select userid from #UserChildren) group by usermaster.Id,Item,CollectionType,ZyleminiOrderDetails.rate order by Item 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 GenClass.ExecuteSQL(String ConnectionString, String sql) ------------------------------------------- 2/15/2022 10:42:41 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### ZylemMiniOrderBookedReport.aspx.cs :btnGo_Click() Exicuting SP : ### EXEC [pr_ZyleminiOrderBookedReport] '000000000000001','','','','','','','','','01-Feb-2022','28-Feb-2022','','','3','' ------------------------------------------- 2/15/2022 10:44:32 AM GenClass Class, FillCombo Function ### After Filling DataSet ### In Page_Load ### Settings.aspx(changePassword)page ------------------------------------------- 2/15/2022 10:44:32 AM GenClass Class, FillCombo Function ### After Filling DataSet ### In Page_Load ### Settings.aspx Send ------------------------------------------- 2/15/2022 10:44:37 AM GenClass Class, FillCombo Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:44:41 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 2/15/2022 10:44:42 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 2/15/2022 10:44: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() ------------------------------------------- 2/15/2022 10:44:58 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'BRAND', 'MNTHYR', '0000000000000012022Feb15104458', '0', '<>0', 'SALE', '000000000000001', 0, '', '','BRAND','0','','2','3','False','False','False','1','0' ------------------------------------------- 2/15/2022 10:45:09 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 8136 ------------------------------------------- 2/15/2022 10:45:10 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 6066 ------------------------------------------- 2/15/2022 10:45:10 AM GenClass Class, FillCombo Function ### Total Record For table ### Sales Analysis ### 8136 ------------------------------------------- 2/15/2022 10:46:57 AM Error in SalesAnalysis.aspx.cs :Page_Load() ### Before select query for SUBGROUPMASTER ### SalesAnalysis.aspx.cs :Page_Load() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prSalesanalysisLoad' expects parameter '@IncludeDateValidation', which was not supplied. 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 InvoiceCount.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:47:23 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SchemeDistributor.aspx.cs :Page_Load ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. 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 SchemeDistributor.Page_Load(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:49:21 AM GenClass Class, InsertTimeStamp Function ### After EXEC SP_PackwiseAvailability ### PackwiseAvailabilityReport.aspx.cs :btnGenerate() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The column '3585625' was specified multiple times for 'PivotedTable'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 PackwiseAvailabilityReport.btnGenerate_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:49:57 AM GenClass Class, InsertTimeStamp Function ### After EXEC prWeeklyPlanReport ### WeeklyPlanReport.aspx.cs :btnGenerate_Click ### System.Data.Odbc.OdbcException (0x80131937): ERROR [HY007] [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcDataReader.get_FieldCount() at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.get_VisibleFieldCount() at System.Data.ProviderBase.DataReaderContainer.Create(IDataReader dataReader, Boolean returnProviderSpecificTypes) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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 WeeklyPlanReport.btnGenerate_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:51:28 AM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btNewSearch_Click() ### Procedure call prZylemAuditLogReport '000000000000001','15-Feb-2022','15-Feb-2022','','','','','' ------------------------------------------- 2/15/2022 10:51:28 AM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btNewSearch_Click() ### Data Bind Completed. ------------------------------------------- 2/15/2022 10:51:45 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'prFieldAssistSaleOrderReport'. 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 GenClass.ExecuteSQL(String ConnectionString, String sql) ------------------------------------------- 2/15/2022 10:51:45 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### FieldAssistSaleOrderReport.aspx.cs:InbtnGo_Click() Function ### System.IndexOutOfRangeException: Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index) at FieldAssistSaleOrderReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:52:11 AM GenClass Class, FillDropDown Function ### After Filling DataSet ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 2/15/2022 10:52:41 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ClosingStockReport: Query ### select ClosingStock.DistributorId,PDistributor.Distributor,ClosingStock.ItemId,PItem.Item,PItem.ItemAlias,ClosingAsOnDate,sum(ClosingStock/bpc) as ClosingStock,StockInTransit,TruckWaiting,InterDepotTranfer from ClosingStock,Pdistributor,PItem where ClosingStock.distributorid=Pdistributor.distributorid and PItem.ItemId=ClosingStock.itemid group by ClosingStock.DistributorId,PDistributor.Distributor,ClosingStock.ItemId,PItem.Item,PItem.ItemAlias,ClosingAsOnDate,StockInTransit,TruckWaiting,InterDepotTranfer order by PItem.Item ------------------------------------------- 2/15/2022 10:52:52 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. ------------------------------------------- 2/15/2022 10:52:52 AM Linking Class, FillGrid Function ### After call to the FillGrid function ### DiffReport.aspx.cs:In FillGrid() Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. 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, String srcTable) at DataQCItemLinkTransMismatch.FillGrid() ------------------------------------------- 2/15/2022 12:37:59 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 2/15/2022 12:37:59 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 2/15/2022 6:00:05 PM Post Favourite ### After Select Query 2/15/2022 6:00:05 PM ProcessData ### Inside Pre Processed Report 2/15/2022 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Feb15233005813 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 2/15/2022 6:04:23 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) 2/15/2022 6:04:23 PM processDataUsingPostTableXML ### Finished 2/15/2022 6:04:23 PM processDataUsingPostTableXML ### End