------------------------------------------- 
 
5/11/2021 4:19:18 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 4:19:19 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 5:07:05 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('000000000000005')) as Customers,AREAPARENTLIST
		where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT DISTINCT CUSTOMERId as Id, UserId as [UId], CASE WHEN IsActive = 1 THEN Name WHEN IsActive = 0 THEN Name + 
		' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,ContactPerson,
		Transfer, LicenceType, LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate  FROM #pcustomer,USERMASTER 
		where #pcustomer.UserId = USERMASTER.Id  and NAME Like '%newparty_4231774%' 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)
 
 ------------------------------------------- 
 
5/11/2021 5:07:43 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('000000000000005')) as Customers,AREAPARENTLIST
		where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT DISTINCT CUSTOMERId as Id, UserId as [UId], CASE WHEN IsActive = 1 THEN Name WHEN IsActive = 0 THEN Name + 
		' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,ContactPerson,
		Transfer, LicenceType, LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate  FROM #pcustomer,USERMASTER 
		where #pcustomer.UserId = USERMASTER.Id  and NAME Like '%newparty_4231774%' 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)
 
 ------------------------------------------- 
 
5/11/2021 5:08:13 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('000000000000005')) as Customers,AREAPARENTLIST
		where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT DISTINCT CUSTOMERId as Id, UserId as [UId], CASE WHEN IsActive = 1 THEN Name WHEN IsActive = 0 THEN Name + 
		' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,ContactPerson,
		Transfer, LicenceType, LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate  FROM #pcustomer,USERMASTER 
		where #pcustomer.UserId = USERMASTER.Id  and NAME Like '%newparty%' 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)
 
 ------------------------------------------- 
 
5/11/2021 5:08:38 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('000000000000005')) as Customers,AREAPARENTLIST
		where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid
ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT DISTINCT CUSTOMERId as Id, UserId as [UId], CASE WHEN IsActive = 1 THEN Name WHEN IsActive = 0 THEN Name + 
		' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,ContactPerson,
		Transfer, LicenceType, LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate  FROM #pcustomer,USERMASTER 
		where #pcustomer.UserId = USERMASTER.Id  and NAME Like '%newparty%' 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)
 
 ------------------------------------------- 
 
5/11/2021 5:12:17 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 5:12:17 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 5:44:40 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 5:44:40 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 7:03:26 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 7:03:26 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 8:12:51 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 8:12:52 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 8:56:20 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 8:56:20 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 9:29:53 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 9:29:53 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 10:10:22 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 10:10:39 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)
 
 ------------------------------------------- 
 
5/11/2021 10:10:53 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/11/2021 10:11:03 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/11/2021 10:11:03 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/11/2021 10:11:29 AM
GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols  ### System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length
   at System.String.Substring(Int32 startIndex, Int32 length)
   at ReportCriterias.getColumns()
 
 ------------------------------------------- 
 
5/11/2021 10:11:53 AM
GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec  ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YEAR', '0000000000009962021May11101153', '0', '<>0', 'SALE', '000000000000996', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1'
 
 ------------------------------------------- 
 
5/11/2021 10:12:46 AM
GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec  ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YEAR', '0000000000009962021May11101246', '0', '<>0', 'SALE', '000000000000996', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1'
 
 ------------------------------------------- 
 
5/11/2021 10:35:10 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 10:35:10 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 10:35:21 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)
 
 ------------------------------------------- 
 
5/11/2021 11:47:16 AM
Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click    ###  NewLogin.aspx page 
 
 ------------------------------------------- 
 
5/11/2021 11:47:16 AM
CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in   if (loginType == 1 || loginType == 0)  ###  NewLogin.aspx page 
5/11/2021 6:00:02 PM
processDataUsingPostTableXML  ### dtFinalFav Count = 5
5/11/2021 6:00:02 PM
ProcessData ### Inside Pre Processed Report
5/11/2021 6:00:02 PM
processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status  2021May11233002603 ### 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 
5/11/2021 6:00:03 PM
Post Favourite  ### After Fill DataSet
5/11/2021 6:00:03 PM
Excel Favourite Report ### Html Case
5/11/2021 6:00:03 PM
Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 11May2021060003.html
5/11/2021 6:00:03 PM
Excel Favourite Report ### After Checking File Exist Or Create New File
5/11/2021 6:00:03 PM
Excel Favourite Report ### After Writing to File
5/11/2021 6:00:03 PM
processDataUsingPostTableXML  ### Write PendingXml BAYER QA Distributor File Upload Status  2021May11233002603
5/11/2021 6:00:03 PM
processDataUsingPostTableXML  ### Create Zip 
5/11/2021 6:00:03 PM
processDataUsingPostTableXML  ### Added PendingXml
5/11/2021 6:00:03 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 
5/11/2021 6:00:03 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 
5/11/2021 6:00:03 PM
ProcessData ### Inside Pre Processed Report
5/11/2021 6:00:03 PM
processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log  2021May11233002650 ### EXEC prZylemAuditLogReport '','','','','','','',''
5/11/2021 6:00:03 PM
processDataUsingPostTableXML,Error while executing procedure :EXEC prZylemAuditLogReport '','','','','','','','', Error: ### INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
5/11/2021 6:00:03 PM
ProcessData ### Inside Pre Processed Report
5/11/2021 6:00:03 PM
processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES  2021May11233002697 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES'
5/11/2021 6:00:04 PM
Post Favourite  ### After Fill DataSet
5/11/2021 6:00:04 PM
Excel Favourite Report ### Excel Case
5/11/2021 6:00:04 PM
Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 11May2021060004.xls
5/11/2021 6:00:04 PM
Excel Favourite Report ### After Checking File Exist Or Create New File
5/11/2021 6:00:04 PM
Excel Favourite Report ### After Writing to File
5/11/2021 6:00:04 PM
processDataUsingPostTableXML  ### Write PendingXml GenerateUnlinkedCustomerLinking ES  2021May11233002697
5/11/2021 6:00:04 PM
processDataUsingPostTableXML  ### Create Zip 
5/11/2021 6:00:04 PM
processDataUsingPostTableXML  ### Added PendingXml
5/11/2021 6:00:04 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 
5/11/2021 6:00:04 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 
5/11/2021 6:00:04 PM
ProcessData ### Inside Pre Processed Report
5/11/2021 6:00:04 PM
processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS  2021May11233002737 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS'
5/11/2021 6:00:05 PM
Post Favourite  ### After Fill DataSet
5/11/2021 6:00:05 PM
Excel Favourite Report ### Excel Case
5/11/2021 6:00:05 PM
Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 11May2021060005.xls
5/11/2021 6:00:05 PM
Excel Favourite Report ### After Checking File Exist Or Create New File
5/11/2021 6:00:05 PM
Excel Favourite Report ### After Writing to File
5/11/2021 6:00:06 PM
processDataUsingPostTableXML  ### Write PendingXml GenerateUnlinkedCustomerLinking CS  2021May11233002737
5/11/2021 6:00:06 PM
processDataUsingPostTableXML  ### Create Zip 
5/11/2021 6:00:06 PM
processDataUsingPostTableXML  ### Added PendingXml
5/11/2021 6:00:06 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 
5/11/2021 6:00:06 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 
5/11/2021 6:00:06 PM
ProcessData ### Inside Pre Processed Report
5/11/2021 6:00:06 PM
processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count   2021May11233002810 ### EXEC prUnMappedproductCount_BAYER
5/11/2021 6:01:20 PM
Post Favourite  ### After Fill DataSet
5/11/2021 6:01:20 PM
Excel Favourite Report ### Excel Case
5/11/2021 6:01:20 PM
Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count  11May2021060120.xls
5/11/2021 6:01:20 PM
Excel Favourite Report ### After Checking File Exist Or Create New File
5/11/2021 6:01:20 PM
Excel Favourite Report ### After Writing to File
5/11/2021 6:01:20 PM
processDataUsingPostTableXML  ### Write PendingXml Bayer Zylem S3 unmapped product count   2021May11233002810
5/11/2021 6:01:20 PM
processDataUsingPostTableXML  ### Create Zip 
5/11/2021 6:01:20 PM
processDataUsingPostTableXML  ### Added PendingXml
5/11/2021 6:01:20 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 
5/11/2021 6:01:20 PM
processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 
5/11/2021 6:01:20 PM
processDataUsingPostTableXML ###  Finished
5/11/2021 6:01:20 PM
processDataUsingPostTableXML ### End