Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
829 B
1
Indexable
Never
[2023-07-21, 06:58:16 UTC] {logging_mixin.py:117} INFO - Error-unsupported format character 'Y' (0x59) at index 533. Line No. 106
iam getting above error for the line 106 and below is the line
pdSubEntityData = pd.read_sql(sql, con=dbConnection)
and query that iam fteching is below
Select E.Customer_Id "id",E.Customer_Id "customerid",E.Cust_Mkt_Id "customercategory",E.Cust_Segment_Id "customersegment",E.created_on as  "createdon",A.Party_Type "partytype",D.Fname "customerfirstname",D.Lname "customerlastname",E.Op_Id "opid",E.Bu_Id "buid", a.party_nbr as "partyId",d.fname "firstname",d.lname "lastname" from tibtcare.tcare_party a ,tibtcare.tcare_contact d,tibtcare.tcare_customer e  where  a.party_nbr=d.party_nbr  And   A.Party_Nbr=E.Party_Nbr and  a.party_type='INDIVIDUAL' AND DATE_FORMAT(E.CREATED_ON , '%%Y')='2018'