Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"Data Replication detected an error in the database driver: otl_exception ODBC" while performing initial sync
Problem Description
Initial sync fails with the following error message:

IDR-060108 E An error occurred during initial synchronization of the target table 'XXXXXX.ZZZ' with the source table 'YYYYYY'.

IDR-000413 E Data Replication detected an error in the database driver: otl_exception ODBC

                                                Driver error code: -12

                                                Driver error message: PQputCopyEnd COPY "XXXX"."ZZZ"

                                                (

                                                contr_agree_number,transaction_date,crediting_date,agent_id,billing_flag,fk5_program_code,fk5_promotion_code,fk4_customer_nbr,fk3_part_estab_cd,

fk2_proml_itm_code,crediting_time,act_duration,amount_spent,adjustment_number,credit_status,suspense_status,credit_source,approved_date,sent_date,distance,flat_rate,creation_date,

creation_time,id,measurment_type,datetimestamp,fk1_non_air_id,valid_flag,fk3_partner_code,partner_reject_cod,nc_statement_date,debit_credit_indic,reversed_flag,transfer_mem_nbr,

rec_seq_nbr,blank_act_date_ind,partner_rejt_name,request_date,other_award_program_code,other_award_prgm_member_nbr,transfer_in_out_ind,internet_ref_nbr,other_award_prgm_pts,

number_of_block_miles,points_exchange_promotion_code,points_exchange_bonus,internet_client_ip

                                                )

                                                FROM STDIN WITH  DELIMITER AS ';' NULL AS  E'\\N' failed. EOF:0 Message:ERROR:  value too long for type character varying(10)  (seg0 HKGX1LNX603-PHD:40000 pid=14960)

                                                CONTEXT:  COPY ZZZ, line 3606764, column 4715565082203762

                                                

                                                Variable: 

                                                SQL statement: ​

Cause
​In this scenario, there was a discrepancy in the source and target column size.
Solution
​To resolve this issue, modify the target table column size to match with the source table column size.
More Information
Applies To
Product: Universal Data Replication
Problem Type: Configuration
User Type: Developer
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/29/2020 8:51 AMID:577961
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)