View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0007101SymmetricDS ProBugpublic2025-10-23 11:222025-10-23 11:32
Reporterpbelov Assigned To 
Prioritynormal 
Status acknowledgedResolutionopen 
Product Version3.16.0 
Summary0007101: Sybase BCP error cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax
DescriptionSybase BCP error when importing data in a .dat.create file:

2025-10-20 12:30:22,220 INFO [grps-syb-dbstsme1] [PullService] [grps-syb-dbstsme1-pull-dgra001-100] Pull data received from grps:pgdbstbmg1:pgdbstbmg1 on queue dgra001. 12 rows and 1 batches were processed. (tgra022, tgra023, tgra015)
2025-10-20 12:30:59,972 INFO [gras-001] [PullService] [gras-001-pull-default-51] Pull data received from amp:000:000 on queue default. 20 rows and 11 batches were processed. (vaoa005_forrep)
2025-10-20 12:31:02,026 INFO [grps-syb-dbstsme1] [BcpDatabaseWriter] [grps-syb-dbstsme1-dataloader-32] About to bulk copy table DWRK001.dbo.budd001_trps033 from /TSMEGRPS/SymmetricDS/ASBTSYMDS/inst/symmetric-server-latest/tmp/grps-syb-dbstsme1/bulkloaddir/0009440224.dat.create
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] Starting copy...
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,054 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] CSLIB Message: - L0/O0/S0/N24/1/0:
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field.
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] bcp copy in failed
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] 0 rows copied.
2025-10-20 12:31:02,055 INFO [grps-syb-dbstsme1] [BcpCommand] [grps-syb-dbstsme1-dataloader-32] Clock Time (ms.): total = 9
Steps To ReproducePostgreSQL 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)
    );

Additional InformationMitigated by turning BCP off with the parameter db.jdbc.bulk.execute.batch.override=true
Tagsbulk, dialect: sybase

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-10-23 11:22 pbelov New Issue
2025-10-23 11:27 pbelov Steps to Reproduce Updated View Revisions
2025-10-23 11:27 pbelov Additional Information Updated View Revisions
2025-10-23 11:28 pbelov Tag Attached: dialect: sybase
2025-10-23 11:28 pbelov Tag Attached: bulk
2025-10-23 11:32 pbelov Status new => acknowledged