------------------------------------------- 1/7/2021 6:51:40 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 6:51:40 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/7/2021 7:49:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 7:49:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/7/2021 8:51:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 8:51:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/7/2021 8:51:32 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 1/7/2021 8:51:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 1/7/2021 8:51:35 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink ------------------------------------------- 1/7/2021 8:51:36 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: AMBITION (10X1LT)-1LT ------------------------------------------- 1/7/2021 8:51:36 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: AMBITION (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:36 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: ANTROCAL(50X100GR) ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: BELT EXPERT (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (100X50ML)-50ML ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (10X1LT)-1LT ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (20X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (20X500ML) ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:37 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: Confidor Super (50x100ml)-100ml ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: Confidor Super (50X50ML)-50ML ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR SUPER(20X250ML)-250 ML ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: CONFIDOR SUPER(20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: COUNCIL ACTIV12X(5X90GR) ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: COUNCIL ACTIVE 8X(10X45GR)-45GR ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC 101 (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:38 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC 101 2(50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC 28 (10X1LT )- 1LT ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC 28(20X 500ML)-500ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC100(50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC24.6 (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: DECIS EC28 (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: ETHREL (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: ETHREL (50X100ML)-100 ML ------------------------------------------- 1/7/2021 8:51:39 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: EVERGOL XTEND(100X40ML)-40ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FAME (20X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FAME (40X50ML)-50 ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: Fame 20X(10X10 Ml)-10 ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOLICUR (10X 1LT)-1LT ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOLICUR (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOLICUR (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:40 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOLICUR(50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOOST (20X250 GR)-250 GR ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: FOOST (24X500GR)-500GR ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: GAUCHO (100X 50 ML)-50 ML ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: GAUCHO (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: GAUCHO 50X100ML ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: JUMP (80X40GR)-40GR ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: JUMP 160X(10X2GR)-2GR ------------------------------------------- 1/7/2021 8:51:41 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: JUMP 2X(15X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LARVIN (10X1KG)-1KG ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LARVIN (20X250 GR)-250 GR ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LARVIN (20X500GR)-500GR ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LARVIN (40X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LAUDIS (10X 57.5 ML)-57.5 ML ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LAUDIS (8X115ML)-115ML ------------------------------------------- 1/7/2021 8:51:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LESENTA (100X40GR)-40GR ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LESENTA (50X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LUNA EXPERIENCE (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: LUNA EXPERIENCE (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: MELODY DUO(50X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: MOVENTO ENERGY (10X1LT)-1LT ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: MOVENTO ENERGY (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: MOVENTO ENERGY (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO (100X50GR)-50GR ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO (20X500GR)-500GR ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO (40X250GR)-250GR ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO (50X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO 20X(10X10GR)-10 GR ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: NATIVO-(10 X 1KG)-1KG ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON (100X50ML)-50ML ------------------------------------------- 1/7/2021 8:51:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON -500ML ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON(10X1 LT)-1 LT ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: OBERON(40X200ML)-200ML ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: RAXIL 5X(10X100GR)-100GR ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: RAXIL 5X(25X40GR)-40GR ------------------------------------------- 1/7/2021 8:51:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: RAXIL EASY (50X 100ML)-100ML ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: RAXIL EASY(100X50 ML)-50ML ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GOLD (20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GOLD (40X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GOLD (50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GR(20X1KG)-1KG ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GR(4X5KG)-5KG ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT GRO (20X1KG)-1KG ------------------------------------------- 1/7/2021 8:51:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT ULTRA (5X4KG)-4KG ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT ULTRA GRO (2X10KG)-10KG ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT ULTRA(5X4KG)-4KG ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT(10X1LT)-1LT ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT(20X250ML)-250ML ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT(20X500ML)-500ML ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: REGENT(50X100ML)-100ML ------------------------------------------- 1/7/2021 8:51:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000634, Code: SPINTOR 10X(20X7ML)-7ML ------------------------------------------- 1/7/2021 8:51:47 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink ------------------------------------------- 1/7/2021 9:14:18 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 9:14:18 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/7/2021 9:38:19 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 9:38:19 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/7/2021 10:28:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 10:28:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/7/2021 10:28:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 1/7/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 3 1/7/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/7/2021 6:00:02 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jan07233002197 ### 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/7/2021 6:00:02 PM Post Favourite ### After Fill DataSet 1/7/2021 6:00:02 PM Excel Favourite Report ### Html Case 1/7/2021 6:00:02 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 07Jan2021060002.html 1/7/2021 6:00:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/7/2021 6:00:02 PM Excel Favourite Report ### After Writing to File 1/7/2021 6:00:02 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jan07233002197 1/7/2021 6:00:02 PM processDataUsingPostTableXML ### Create Zip 1/7/2021 6:00:02 PM processDataUsingPostTableXML ### Added PendingXml 1/7/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/7/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/7/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/7/2021 6:00:02 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jan07233002203 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 1/7/2021 6:00:05 PM Post Favourite ### After Fill DataSet 1/7/2021 6:00:05 PM Excel Favourite Report ### Excel Case 1/7/2021 6:00:05 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 07Jan2021060005.xls 1/7/2021 6:00:05 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/7/2021 6:00:05 PM Excel Favourite Report ### After Writing to File 1/7/2021 6:00:05 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jan07233002203 1/7/2021 6:00:05 PM processDataUsingPostTableXML ### Create Zip 1/7/2021 6:00:05 PM processDataUsingPostTableXML ### Added PendingXml 1/7/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/7/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/7/2021 6:00:05 PM ProcessData ### Inside Pre Processed Report 1/7/2021 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jan07233002203 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 1/7/2021 6:00:16 PM Post Favourite ### After Fill DataSet 1/7/2021 6:00:16 PM Excel Favourite Report ### Excel Case 1/7/2021 6:00:16 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 07Jan2021060016.xls 1/7/2021 6:00:16 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/7/2021 6:00:16 PM Excel Favourite Report ### After Writing to File 1/7/2021 6:00:16 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jan07233002203 1/7/2021 6:00:16 PM processDataUsingPostTableXML ### Create Zip 1/7/2021 6:00:16 PM processDataUsingPostTableXML ### Added PendingXml 1/7/2021 6:00:16 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/7/2021 6:00:16 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/7/2021 6:00:16 PM processDataUsingPostTableXML ### Finished 1/7/2021 6:00:16 PM processDataUsingPostTableXML ### End