------------------------------------------- 6/13/2022 4:10:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 4:10:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/13/2022 4:20:38 AM ProcessData ### Begin 6/13/2022 4:20:38 AM ProcessData ### Scanning FavouriteReport 6/13/2022 4:20:38 AM ProcessData ### Before Executing Favourite Report Select Query 6/13/2022 4:20:38 AM ProcessData ### After Executing Favourite Report Select Query 6/13/2022 4:20:38 AM ProcessData ### Inside If Action = 0 Condition 6/13/2022 4:20:38 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 4:20:38 AM executeFavoriteQueries ### BEGIN 6/13/2022 4:20:38 AM executeFavoriteQueries ### Before While Condition 6/13/2022 4:20:38 AM executeFavoriteQueries ### After While Condition 6/13/2022 4:20:38 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/13/2022 4:20:38 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/13/2022 4:20:38 AM After Filling DataSet For Query Favourite For User ### 000000000165532 6/13/2022 4:20:38 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/13/2022 4:20:38 AM executeFavoriteQueries ### END 6/13/2022 4:20:38 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 4:20:38 AM ProcessData ### ProcessData Finished 6/13/2022 4:20:38 AM ProcessData ### End 6/13/2022 4:23:22 AM ProcessData ### Begin 6/13/2022 4:23:22 AM ProcessData ### Scanning FavouriteReport 6/13/2022 4:23:22 AM ProcessData ### Before Executing Favourite Report Select Query 6/13/2022 4:23:22 AM ProcessData ### After Executing Favourite Report Select Query 6/13/2022 4:23:22 AM ProcessData ### Inside If Action = 0 Condition 6/13/2022 4:23:22 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 4:23:22 AM executeFavoriteQueries ### BEGIN 6/13/2022 4:23:22 AM executeFavoriteQueries ### Before While Condition 6/13/2022 4:23:22 AM executeFavoriteQueries ### After While Condition 6/13/2022 4:23:22 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/13/2022 4:23:22 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/13/2022 4:23:22 AM After Filling DataSet For Query Favourite For User ### 000000000165532 6/13/2022 4:23:22 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/13/2022 4:23:22 AM executeFavoriteQueries ### END 6/13/2022 4:23:22 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 4:23:22 AM ProcessData ### ProcessData Finished 6/13/2022 4:23:22 AM ProcessData ### End ------------------------------------------- 6/13/2022 4:45:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 4:45:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 4:52:59 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 4:53:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 4:53:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 5:14:47 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 5:14:47 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 5:26:14 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 5:26:14 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 5:28:11 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 5:28:11 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 5:30:40 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 5:30:40 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 5:33:16 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 5:33:16 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 5:54:34 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 5:54:34 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/13/2022 6:00:02 AM Post Favourite ### After Select Query 6/13/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 6/13/2022 6:00:02 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Jun13113002370 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/13/2022 6:00:04 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) 6/13/2022 6:00:04 AM ProcessData ### Inside Pre Processed Report 6/13/2022 6:00:04 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Jun13113002410 ### exec [prDistributorFileUploadStatus] '000000000000001','Jun 13 2022 11:30AM','7','','','','000000000000289','' 6/13/2022 6:00:05 AM Post Favourite ### After Fill DataSet 6/13/2022 6:00:05 AM Excel Favourite Report ### Excel Case 6/13/2022 6:00:05 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 13Jun2022060005.xls 6/13/2022 6:00:05 AM Excel Favourite Report ### After Checking File Exist Or Create New File 6/13/2022 6:00:05 AM Excel Favourite Report ### After Writing to File 6/13/2022 6:00:05 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/13/2022 6:00:05 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/13/2022 6:00:05 AM processDataUsingPostTableXML ### Finished 6/13/2022 6:00:05 AM processDataUsingPostTableXML ### End ------------------------------------------- 6/13/2022 6:01:12 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:01:13 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:09:36 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:09:36 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:10:48 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:10:48 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:13:17 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:13:17 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:14:22 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:14:22 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:18:43 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:18:43 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:20:25 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:20:25 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:22:36 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:22:36 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:24:57 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:24:57 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:25:58 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:25:58 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:27:11 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:27:11 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:27:55 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:27:55 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:28:48 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:28:48 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:30:51 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:30:51 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:32:31 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:32:31 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:33:33 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:33:33 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:35:19 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:35:19 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:36:24 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 6:36:24 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 6:55:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:55:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:55:34 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:55:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:56:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 6:56:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000160444'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000160444' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000162113'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000162113' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170172'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170172' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170173'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170173' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170174'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000170174' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176218'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176218' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176219'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176219' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176220'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176220' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176221'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176221' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176222'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176222' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176223'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000176223' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178422'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178422' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000179354'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERMASTER set LicenceNo = 'PCO0004020',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000179354' ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_1',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000161819'.Qurey: ------------------------------------------- 6/13/2022 7:06:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_1',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000161819' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_2',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000163488'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_2',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000163488' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_3',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172930'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_3',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172930' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_4',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172931'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_4',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172931' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_5',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172932'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_5',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000172932' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_6',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178976'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_6',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178976' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_7',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178977'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_7',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178977' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_8',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178978'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_8',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178978' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_9',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178979'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_9',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178979' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_10',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178980'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_10',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178980' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_11',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178981'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_11',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000178981' ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_12',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000181182'.Qurey: ------------------------------------------- 6/13/2022 7:06:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_12',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000181182' ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, SaveData ### Query:Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_13',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000182116'.Qurey: ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update USERMASTER set Name = 'Entos De-Pest Solutions Pvt. Ltd',Telephone = '9566143388',ERPCode = 'PCO0004020_13',LASTEDITDATE = '06/13/2022 12:36:12' where Id = '000000000182116' ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000160444' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000160444' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000160444' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000160444' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000162113' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000162113' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000162113' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000162113' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170172' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170172' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170172' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170172' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170173' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170173' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170173' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170173' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170174' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000170174' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170174' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000170174' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176218' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176218' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176218' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176218' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176219' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176219' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176219' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176219' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176220' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176220' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176220' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:18 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176220' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176221' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176221' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176221' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176221' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176222' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176222' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176222' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:19 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176222' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176223' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000176223' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176223' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000176223' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000178422' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000178422' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000178422' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000178422' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000179354' and GroupId = 'CUSTOMERCLASS'.Qurey: ------------------------------------------- 6/13/2022 7:06:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007421' where CustomerId = '000000000179354' and GroupId = 'CUSTOMERCLASS' ------------------------------------------- 6/13/2022 7:06:21 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Query:Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000179354' and GroupId = 'CUSTOMERSEGMENT'.Qurey: ------------------------------------------- 6/13/2022 7:06:21 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ZylemMasterTemplateImporting page, UpdateData ### Update CUSTOMERDETAILS set SubGroupId = '000000000007756' where CustomerId = '000000000179354' and GroupId = 'CUSTOMERSEGMENT' ------------------------------------------- 6/13/2022 7:13:39 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:13:39 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:14:46 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:14:46 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:15:42 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:15:42 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:16:56 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:16:56 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:17:48 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:17:48 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:19:25 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:19:25 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 7:20:49 AM GenClass Class, ExecuteSQLQuery Function ### After OdbcConnection ### GenClass Class, ExecuteSQLQuery Function ### ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ------------------------------------------- 6/13/2022 7:20:49 AM GenClass Class, ExecuteSQLStmt Function ### After OdbcConnection ### GenClass Class, ExecuteSQLStmt Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. ------------------------------------------- 6/13/2022 8:49:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 8:49:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/13/2022 8:49:13 AM ProcessData ### Begin 6/13/2022 8:49:13 AM ProcessData ### Scanning FavouriteReport 6/13/2022 8:49:13 AM ProcessData ### Before Executing Favourite Report Select Query 6/13/2022 8:49:13 AM ProcessData ### After Executing Favourite Report Select Query 6/13/2022 8:49:13 AM ProcessData ### Inside If Action = 0 Condition 6/13/2022 8:49:13 AM ProcessData ### Before Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 8:49:13 AM executeFavoriteQueries ### BEGIN 6/13/2022 8:49:13 AM executeFavoriteQueries ### Before While Condition 6/13/2022 8:49:13 AM executeFavoriteQueries ### After While Condition 6/13/2022 8:49:13 AM executeFavoriteQueries ### After Setting Store Procedure Parameter and Before Executing Store Procedure For User 000000000165532 6/13/2022 8:49:13 AM executeFavoriteQueries ### After Executing Store Procedure For User 000000000165532 6/13/2022 8:49:13 AM After Filling DataSet For Query Favourite For User ### 000000000165532 6/13/2022 8:49:13 AM executeFavoriteQueries ### After Generating DatSet Or Excel For User 000000000165532 6/13/2022 8:49:13 AM executeFavoriteQueries ### END 6/13/2022 8:49:13 AM ProcessData ### After Calling Store Procedure For DataSet For Favourite Report For Action = 0 6/13/2022 8:49:13 AM ProcessData ### ProcessData Finished 6/13/2022 8:49:13 AM ProcessData ### End ------------------------------------------- 6/13/2022 8:54:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 8:54:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 10:14:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 10:14:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 10:40:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/13/2022 10:40:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/13/2022 10:42:23 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) ------------------------------------------- 6/13/2022 10:49:45 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 04 Jun 2022 6/13/2022 6:00:07 PM Post Favourite ### After Select Query 6/13/2022 6:00:07 PM ProcessData ### Inside Pre Processed Report 6/13/2022 6:00:07 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Jun13233007207 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/13/2022 6:00:08 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) 6/13/2022 6:00:08 PM processDataUsingPostTableXML ### Finished 6/13/2022 6:00:08 PM processDataUsingPostTableXML ### End