View Revisions: Issue #7101

All RevisionsBack to Issue
Summary 0007101: Sybase BCP error cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax
Revision 2025-10-23 11:27 by pbelov
Steps To Reproduce PostgreSQL to Sybase replication (one table, bulk loading)

See attached test files:
9440224.done - SymmetricDS batch
0009440224.dat.create - BCP import staging file

-- Postgres DDL:

CREATE TABLE
    budd001_trps033
    (
        mo_digital_main_prod_id INTEGER NOT NULL,
        prod_no CHARACTER VARYING(14) NOT NULL,
        client_key CHARACTER(4) NOT NULL,
        global_price_category_id INTEGER,
        digital_price_code_id INTEGER,
        pre_order_date DATE,
        lc_published_date TIMESTAMP(6) WITH TIME ZONE,
        lc_and_asset_pub_date TIMESTAMP(6) WITH TIME ZONE,
        schedule_status_id INTEGER,
        pull_date DATE,
        global_notes CHARACTER VARYING(2000),
        cancel_flag CHARACTER(1),
        cancel_date TIMESTAMP(6) WITH TIME ZONE,
        first_functional_date DATE,
        sched_generated_date TIMESTAMP(6) WITH TIME ZONE,
        sched_generated_user CHARACTER(8),
        first_sched_gen_date TIMESTAMP(6) WITH TIME ZONE,
        first_sched_gen_user CHARACTER(8),
        prior_sched_gen_date TIMESTAMP(6) WITH TIME ZONE,
        prior_sched_gen_user CHARACTER(8),
        log_mod_stamp TIMESTAMP(6) WITH TIME ZONE NOT NULL,
        log_mod_user CHARACTER(8) NOT NULL,
        defer_unique_check_id SMALLINT,
        hold_date DATE,
        created_by_user CHARACTER(8) NOT NULL,
        created_on_date TIMESTAMP(6) WITH TIME ZONE NOT NULL,
        product_pricing_basis_id INTEGER,
        wholesale_value_amt NUMERIC(12,3),
        timezone_relevant_flag CHARACTER(1),
        timezone_relevant_gmt_datetime TIMESTAMP(6) WITH TIME ZONE,
        dig_product_tracks_status_id INTEGER NOT NULL,
        publish_key INTEGER,
        pub_state_change_reason_id INTEGER,
        replacement_prod_no CHARACTER VARYING(14),
        original_release_date DATE,
        preorder_preview_flag CHARACTER(1) NOT NULL,
        allow_clip CHARACTER(1) NOT NULL,
        po_datetime_required_flag CHARACTER(1),
        po_in_utc_datetime TIMESTAMP(6) WITH TIME ZONE,
        pull_reason_id INTEGER,
        mod_stamp TIMESTAMP(6) WITH TIME ZONE NOT NULL,
        mod_flag CHARACTER(1) NOT NULL,
        mod_user CHARACTER(8) NOT NULL,
        presave_rel_flag CHARACTER(1),
        presave_rel_datetime TIMESTAMP(6) WITH TIME ZONE,
        presave_cover_flag CHARACTER(1),
        presave_cover_datetime TIMESTAMP(6) WITH TIME ZONE,
        presave_track_flag CHARACTER(1),
        presave_track_datetime TIMESTAMP(6) WITH TIME ZONE,
        send_all_assets_flag CHARACTER(1),
        CONSTRAINT ibudd001rps033a PRIMARY KEY (mo_digital_main_prod_id)
    );

-- Sybase DDL:
CREATE TABLE
    budd001_trps033
    (
        mo_digital_main_prod_id INT NOT NULL,
        prod_no VARCHAR(14) NOT NULL,
        client_key CHAR(4) NOT NULL,
        global_price_category_id INT NULL,
        digital_price_code_id INT NULL,
        pre_order_date DATE NULL,
        lc_published_date DATETIME NULL,
        lc_and_asset_pub_date DATETIME NULL,
        schedule_status_id INT NULL,
        pull_date DATE NULL,
        global_notes VARCHAR(2000) NULL,
        cancel_flag CHAR(1) NULL,
        cancel_date DATETIME NULL,
        first_functional_date DATE NULL,
        sched_generated_date DATETIME NULL,
        sched_generated_user CHAR(8) NULL,
        first_sched_gen_date DATETIME NULL,
        first_sched_gen_user CHAR(8) NULL,
        prior_sched_gen_date DATETIME NULL,
        prior_sched_gen_user CHAR(8) NULL,
        mod_stamp DATETIME NOT NULL,
        mod_flag CHAR(1) NOT NULL,
        mod_user CHAR(8) NOT NULL,
        log_mod_stamp DATETIME NOT NULL,
        log_mod_user CHAR(8) NOT NULL,
        defer_unique_check_id TINYINT NULL,
        hold_date DATE NULL,
        created_by_user CHAR(8) NOT NULL,
        created_on_date DATETIME NOT NULL,
        product_pricing_basis_id INT NULL,
        wholesale_value_amt NUMERIC(12,3) NULL,
        timezone_relevant_flag CHAR(1) NULL,
        timezone_relevant_gmt_datetime DATETIME NULL,
        dig_product_tracks_status_id INT NOT NULL,
        publish_key INT NULL,
        pub_state_change_reason_id INT NULL,
        replacement_prod_no VARCHAR(14) NULL,
        original_release_date DATE NULL,
        preorder_preview_flag CHAR(1) NOT NULL,
        allow_clip CHAR(1) NOT NULL,
        po_datetime_required_flag CHAR(1) NULL,
        po_in_utc_datetime DATETIME NULL,
        pull_reason_id INT NULL,
        presave_rel_flag CHAR(1) NULL,
        presave_rel_datetime DATETIME NULL,
        presave_cover_flag CHAR(1) NULL,
        presave_cover_datetime DATETIME NULL,
        presave_track_flag CHAR(1) NULL,
        presave_track_datetime DATETIME NULL,
        send_all_assets_flag CHAR(1) NULL,
        CONSTRAINT irps033a PRIMARY KEY (mo_digital_main_prod_id)
    );
Revision 2025-10-23 11:22 by pbelov
Steps To Reproduce