------------------------------------------- 4/23/2022 5:28:03 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 5:28:03 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/23/2022 6:00:02 AM Post Favourite ### After Select Query 4/23/2022 6:00:02 AM ProcessData ### Inside Pre Processed Report 4/23/2022 6:00:02 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr23113002050 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' ------------------------------------------- 4/23/2022 6:03:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 6:03:03 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/23/2022 6:04:49 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) 4/23/2022 6:04:49 AM ProcessData ### Inside Pre Processed Report 4/23/2022 6:04:49 AM processDataUsingPostTableXML strScript for ES_DistributorFileUploadStatus 2022Apr23113002113 ### exec [prDistributorFileUploadStatus] '000000000000001','Apr 23 2022 11:30AM','7','','','','000000000000289','' 4/23/2022 6:04:50 AM Post Favourite ### After Fill DataSet 4/23/2022 6:04:50 AM Excel Favourite Report ### Excel Case 4/23/2022 6:04:50 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_ES_DistributorFileUploadStatus 23Apr2022060450.xls 4/23/2022 6:04:50 AM Excel Favourite Report ### After Checking File Exist Or Create New File 4/23/2022 6:04:50 AM Excel Favourite Report ### After Writing to File 4/23/2022 6:04:50 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/23/2022 6:04:50 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/23/2022 6:04:50 AM processDataUsingPostTableXML ### Finished 4/23/2022 6:04:50 AM processDataUsingPostTableXML ### End ------------------------------------------- 4/23/2022 7:35:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 7:35:23 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 7:45:18 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 7:45:18 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 8:30:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 8:30:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 9:15:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 9:15:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 9:44:09 AM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnDownload_Click() ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 4/23/2022 10:27:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 10:27:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 10:30:56 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('000000000000004')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid and CustomerId='000000000158608' ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/23/2022 10:59:32 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 10:59:32 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 10:59:46 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('000000000000004')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/23/2022 11:49:19 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 11:49:19 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 11:50:11 AM CustomerClass Class, Search Function ### After OdbcConnection Open ### CustomerClass Class, Search ### System.Data.Odbc.OdbcException (0x80131937): ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]>>insert into #Cust select * from CUSTOMERMASTER Inner Join (SELECT CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE FROM (SELECT * from CUSTOMERDETAILS) AS SOURCETABLE PIVOT(max(SubgroupId) FOR groupid IN ( AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE)) AS PIVOTABLE GROUP BY CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE) As Details On CUSTOMERMASTER.Id = Details.CustomerId ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #pcustomer select Id, UserId , Transfer,ContactPerson, LicenceType, LicenceNo,LastEditDate from #Cust,(select distinct customerid as custid from fnGetCustomersOnly('000000000000001')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/23/2022 12:07:00 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 12:07:00 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/23/2022 12:07:11 PM CustomerClass Class, Search Function ### After OdbcConnection Open ### CustomerClass Class, Search ### System.Data.Odbc.OdbcException (0x80131937): ERROR [21S01] [Microsoft][ODBC SQL Server Driver][SQL Server]Column name or number of supplied values does not match table definition. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]>>insert into #Cust select * from CUSTOMERMASTER Inner Join (SELECT CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE FROM (SELECT * from CUSTOMERDETAILS) AS SOURCETABLE PIVOT(max(SubgroupId) FOR groupid IN ( AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE)) AS PIVOTABLE GROUP BY CustomerId,AREA,BRANCH,CUSTOMERCLASS,CUSTOMERCLASS2,CUSTOMERGROUP,CUSTOMERSEGMENT,CUSTOMERSUBSEGMENT,LICENCETYPE,OCTROIZONE) As Details On CUSTOMERMASTER.Id = Details.CustomerId ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]insert into #pcustomer select Id, UserId , Transfer,ContactPerson, LicenceType, LicenceNo,LastEditDate from #Cust,(select distinct customerid as custid from fnGetCustomersOnly('000000000000001')) as Customers,AREAPARENTLIST where customers.custid =#Cust.Id and #Cust.AREA =AreaParentList.Areaid ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]@ColumnName-Area ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]With Column Name:->SELECT DISTINCT #pcustomer.CUSTOMERId as Id, #pcustomer.UserId as [UId], CASE WHEN USERMASTER.IsActive = 1 THEN Name WHEN USERMASTER.IsActive = 0 THEN Name + ' (CLOSED)' END AS NAME, USERMASTER.Pin, USERMASTER.Telephone, USERMASTER.Login, USERMASTER.EmailId,#pcustomer.ContactPerson, #pcustomer.Transfer, #pcustomer.LicenceType, #pcustomer.LicenceNo,USERMASTER.ERPCode,#pcustomer.LastEditDate ,Area FROM #pcustomer,USERMASTER ,Pcustomer where Pcustomer.Customerid=#pcustomer.CustomerId and #pcustomer.UserId = USERMASTER.Id order by Id at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CustomerClass.Search(String ConnectionString, String tableName) ------------------------------------------- 4/23/2022 12:31:59 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/23/2022 12:31:59 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/23/2022 6:00:05 PM Post Favourite ### After Select Query 4/23/2022 6:00:05 PM ProcessData ### Inside Pre Processed Report 4/23/2022 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2022Apr23233005710 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 4/23/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) 4/23/2022 6:00:08 PM processDataUsingPostTableXML ### Finished 4/23/2022 6:00:08 PM processDataUsingPostTableXML ### End