persistence issue in xcenter (SQL server)
Hi Mosc,
We are facing issues with the transaction replication to xcenter sometimes
on 8/10 at 1:38 PM we faced the following issue which caused the error in replication and the transaction didn't reach xcenter
2018-08-10 13:43:53,442 ERROR [ReplicationResequencingPublisher_1000::>=191..<214] [FAILED_PERSISTENCE_LOG] Persistence Failed: dtv.data2.access.impl.jdbc.JDBCException: makePersistent() exception caught trying to persist dao of type [dtv.xst.dao.trl.impl.SaleReturnLineItemDAO] with id: dtv.xst.dao.trl.RetailTransactionLineItemId id value: 1000::208::1533859200000::1::117639::1 on datasource: Local. Statement: INSERT INTO trl_sale_lineitm(organization_id, rtl_loc_id, business_date, wkstn_id, trans_seq, rtrans_lineitm_seq, create_date, create_user_id, update_date, update_user_id, base_extended_price, base_unit_price, department_id, extended_amt, rcpt_count, gross_amt, inventory_action_code, item_id, item_id_entry_mthd_code, net_amt, rpt_base_unit_price, original_business_date, original_rtrans_lineitm_seq, original_rtl_loc_id, original_trans_seq, original_wkstn_id, price_derivtn_mthd_code, price_entry_mthd_code, quantity, return_comment, return_flag, return_typcode, sale_lineitm_typcode, scanned_item_id, serial_nbr, entered_description, unit_price, vat_amt, force_zero_extended_amt_flag, return_reascode, tax_group_id, net_quantity, gross_quantity, food_stamps_applied_amount, vendor_id, regular_base_price, shipping_weight, unit_cost, attached_item_flag, initial_quantity) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,