******Query
select t1.raw_txn_id,t1.batch_type,t1.lexmark_material_number,t1.lexmark_product_desc,t1.qty_shipped_rtrnd,t1.qty_rtrnd,
t1.shipment_dt_year,t1.shipment_dt_month,t1.shipment_dt_day,t1.ordering_party_ref_acct_num,t1.ordering_party_po_num,t1.ordering_party_national_id,t1.ordering_party_cmpny_nm,t1.ordering_party_cntry_cd,t1.ordering_party_addr_1,t1.ordering_party_addr_2,t1.ordering_party_addr_3,t1.ordering_party_city,t1.ordering_party_state_prov,t1.ordering_party_pstl_cd,t1.ship_to_party_ref_acct_num,t1.ship_to_party_national_id,t1.ship_to_party_cmpny_nm,t1.ship_to_party_cntry_cd,t1.ship_to_party_addr_1,t1.ship_to_party_addr_2,t1.ship_to_party_addr_3,t1.ship_to_party_city,t1.ship_to_party_state_prov,t1.ship_to_party_pstl_cd,t1.shipment_dt,t1.bill_to_party_ref_acct_num,t1.bill_to_party_national_id,t1.bill_to_party_cmpny_nm,t1.bill_to_party_cntry_cd,t1.bill_to_party_addr_1,t1.bill_to_party_addr_2,t1.bill_to_party_addr_3,t1.bill_to_party_city,t1.bill_to_party_state_prov,t1.bill_to_party_pstl_cd,t1.participating_pty_national_id,t1.participating_party_addr_1,t1.participating_party_addr_2,t1.participating_party_addr_3,t1.participating_party_city,t1.participating_party_state_prov,t1.participating_party_pstl_cd,t1.participating_party_ref_acct_n,t1.participating_pty_comp_name,t1.participating_pty_cntry_cd,t1.invoice_dt,t1.invoice_dt_year,t1.invoice_dt_month,t1.invoice_dt_day,t1.invoice_nbr,t1.invoice_ln_item_nbr,t1.currency,t1.lexmark_agmt_amount,t1.qty_on_hand,t1.qty_comtd,t1.qty_in_transit,t1.cpturd_year,t1.cpturd_month,t1.cpturd_day,t1.partner_material_ref_nbr,t1.partner_loc_ref_acct_nbr,t1.partner_lctn_nm,t1.partner_lctn_cntry_cd,t1.partner_lctn_addr_1,t1.partner_lctn_addr_2,t1.partner_lctn_addr_3,t1.partner_lctn_city,t1.partner_lctn_state_prov,t1.partner_lctn_pstl_cd,t1.partner_extndd_price,t1.unspsc_cd,t1.upc_cd,t1.raw_txn_hash_key,t1.txn_ln_nbr,t1.potential_duplicate_flag,t1.claim_ind,t1.created_dttm,t1.creatd_by,t1.updated_dttm,t1.upd_by,t1.version,t1.wm_key,t1.cpturd_dt,t1.lexmark_agmt_nbr,cast( t1.lexmark_srl_numbers as varchar(16000)) from CDM_OPS_EV.Raw_TXN t1 where t1.raw_txn_id = ‘33260855’
*************Errro
(HY000/3577) [Teradata Database] [TeraJDBC 13.00.00.20] [Error 3577] [SQLState HY000] Row size or Sort Key size overflow."
[Teradata Database] [TeraJDBC 13.00.00.20] [Error 3577] [SQLState HY000] Row size or Sort Key size overflow.
query is working fine in SQL assistant but from designer we are getting this error.
#webMethods#Integration-Server-and-ESB