View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0006778SymmetricDSBugpublic2025-03-21 02:262025-03-21 13:29
Reporterpbelov Assigned Topbelov  
Prioritynormal 
Status acknowledgedResolutionopen 
Product Version3.15.0 
Target Version3.15.15 
Summary0006778: Debug Sybase error Explicit value specified for identity field in table ABC when 'SET IDENTITY_INSERT' is OFF
DescriptionCustomer reported an issue with SQL Server to Sybase Compare and Repair:
Sybase side throws an error
Explicit value specified for identity field in table ABC when 'SET IDENTITY_INSERT' is OFF

In the local environment issue only happens for a specific table see below
Steps To ReproduceProblem table (when Performing a full load) from MS SQL Server to Sybase:

    <table name="student">
        <column name="stud_id" primaryKey="true" primaryKeySeq="1" required="true" type="NUMERIC" size="18" autoIncrement="true">
            <platform-column name="mssql2016" type="numeric() identity" size="18"/>
        </column>
        <column name="address_id" required="true" type="NUMERIC" size="18">
            <platform-column name="mssql2016" type="numeric" size="18"/>
        </column>
        <column name="ssn" required="true" type="CHAR" size="9">
            <platform-column name="mssql2016" type="char" size="9"/>
        </column>
        <column name="stud_lname" required="true" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="stud_fname" required="true" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="stud_mi" type="CHAR" size="1">
            <platform-column name="mssql2016" type="char" size="1"/>
        </column>
        <column name="dob" required="true" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="sex" required="true" type="CHAR" size="1">
            <platform-column name="mssql2016" type="char" size="1"/>
        </column>
        <column name="race_cd" required="true" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="birth_country_cd" required="true" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="birth_city" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="birth_st_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="drivers_lic" type="CHAR" size="15">
            <platform-column name="mssql2016" type="char" size="15"/>
        </column>
        <column name="drivers_lic_st_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="no_exemptions" required="true" type="SMALLINT" size="5">
            <platform-column name="mssql2016" type="smallint" size="5"/>
        </column>
        <column name="parental_consent" type="CHAR" size="1" default="N">
            <platform-column name="mssql2016" type="char" size="1" default="N"/>
        </column>
        <column name="pass_consent" type="CHAR" size="1" default="N">
            <platform-column name="mssql2016" type="char" size="1" default="N"/>
        </column>
        <column name="web_theme_cd" required="true" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="driver_lic_stat_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="driver_lic_exp_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="stud_lname_upper" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="stud_fname_upper" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="add_user" type="CHAR" size="8">
            <platform-column name="mssql2016" type="char" size="8"/>
        </column>
        <column name="add_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="last_mod_user" type="CHAR" size="8">
            <platform-column name="mssql2016" type="char" size="8"/>
        </column>
        <column name="last_mod_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="image_id" type="NUMERIC" size="18">
            <platform-column name="mssql2016" type="numeric" size="18"/>
        </column>
        <column name="other_name" type="CHAR" size="20">
            <platform-column name="mssql2016" type="char" size="20"/>
        </column>
        <column name="drivers_lic_type_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="drivers_lic_rcvd_on_ctr" required="true" type="CHAR" size="1" default="N">
            <platform-column name="mssql2016" type="char" size="1" default="N"/>
        </column>
        <column name="drivers_lic_rcvd_on_ctr_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="drivers_lic_dfnsv_class_cd" type="NUMERIC" size="18">
            <platform-column name="mssql2016" type="numeric" size="18"/>
        </column>
        <column name="last_arrived_enrtype_id" type="NUMERIC" size="18">
            <platform-column name="mssql2016" type="numeric" size="18"/>
        </column>
        <column name="accom_plan_required" type="CHAR" size="1" default="N">
            <platform-column name="mssql2016" type="char" size="1" default="N"/>
        </column>
        <column name="ad_guid" type="CHAR" size="36">
            <platform-column name="mssql2016" type="char" size="36"/>
        </column>
        <column name="ad_name" type="VARCHAR" size="80">
            <platform-column name="mssql2016" type="varchar" size="80"/>
        </column>
        <column name="ad_ctr_id" type="NUMERIC" size="18">
            <platform-column name="mssql2016" type="numeric" size="18"/>
        </column>
        <column name="ad_pass_expire_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="ad_last_login_dt" type="TIMESTAMP" size="3">
            <platform-column name="mssql2016" type="datetime2" size="3"/>
        </column>
        <column name="alumni" type="CHAR" size="1">
            <platform-column name="mssql2016" type="char" size="1"/>
        </column>
        <column name="ethnicity_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="gender_identity_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="other_gender_identity" type="VARCHAR" size="30">
            <platform-column name="mssql2016" type="varchar" size="30"/>
        </column>
        <column name="preferred_pronoun_cd" type="INTEGER" size="10">
            <platform-column name="mssql2016" type="int" size="10"/>
        </column>
        <column name="other_preferred_pronoun" type="VARCHAR" size="30">
            <platform-column name="mssql2016" type="varchar" size="30"/>
        </column>
        <unique name="student_i1">
            <unique-column name="ssn"/>
        </unique>
        <index name="student_i3">
            <index-column name="stud_lname_upper"/>
        </index>
        <index name="idx_last_enrtype">
            <index-column name="last_arrived_enrtype_id"/>
        </index>
        <index name="idx_student_add_guid">
            <index-column name="ad_guid"/>
        </index>
        <index name="idx_student_add_name">
            <index-column name="ad_name"/>
        </index>
        <index name="idx_student_imageid">
            <index-column name="image_id"/>
        </index>
        <index name="idx_student4view">
            <index-column name="stud_id"/>
            <index-column name="ssn"/>
            <index-column name="dob"/>
            <index-column name="sex"/>
            <index-column name="race_cd"/>
            <index-column name="address_id"/>
        </index>
        <index name="student_ad_name">
            <index-column name="ad_name"/>
        </index>
        <index name="student_fk">
            <index-column name="address_id"/>
        </index>
        <index name="student_i2">
            <index-column name="stud_lname"/>
            <index-column name="stud_fname"/>
        </index>
        <index name="student_i4">
            <index-column name="stud_fname_upper"/>
        </index>
    </table>
Additional Information
2025-03-20 21:12:07,553 WARN [client-sybase15client] [JdbcSqlTemplate] [client-sybase15client-dataloader-4] Explicit value specified for identity field in table 'sybase15client.dbo.student_' when 'SET IDENTITY_INSERT' is OFF.
. Failed to execute: INSERT INTO sybase15client.dbo.student_ (stud_id,address_id,ssn,stud_lname,stud_fname,stud_mi,dob,sex,race_cd,birth_country_cd,birth_city,birth_st_cd,drivers_lic,drivers_lic_st_cd,no_exemptions,parental_consent,pass_consent,web_theme_cd,driver_lic_stat_cd,driver_lic_exp_dt,stud_lname_upper,stud_fname_upper,add_user,add_dt,last_mod_user,last_mod_dt,image_id,other_name,drivers_lic_type_cd,drivers_lic_rcvd_on_ctr,drivers_lic_rcvd_on_ctr_dt,drivers_lic_dfnsv_class_cd,last_arrived_enrtype_id,accom_plan_required,ad_guid,ad_name,ad_ctr_id,ad_pass_expire_dt,ad_last_login_dt,alumni,ethnicity_cd,gender_identity_cd,other_gender_identity,preferred_pronoun_cd,other_preferred_pronoun) SELECT stud_id,address_id,ssn,stud_lname,stud_fname,stud_mi,dob,sex,race_cd,birth_country_cd,birth_city,birth_st_cd,drivers_lic,drivers_lic_st_cd,no_exemptions,parental_consent,pass_consent,web_theme_cd,driver_lic_stat_cd,driver_lic_exp_dt,stud_lname_upper,stud_fname_upper,add_user,add_dt,last_mod_user,last_mod_dt,image_id,other_name,drivers_lic_type_cd,drivers_lic_rcvd_on_ctr,drivers_lic_rcvd_on_ctr_dt,drivers_lic_dfnsv_class_cd,last_arrived_enrtype_id,accom_plan_required,ad_guid,ad_name,ad_ctr_id,ad_pass_expire_dt,ad_last_login_dt,alumni,ethnicity_cd,gender_identity_cd,other_gender_identity,preferred_pronoun_cd,other_preferred_pronoun FROM sybase15client.dbo.student
Tagsdialect: sybase

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-03-21 02:26 pbelov New Issue
2025-03-21 02:26 pbelov Status new => assigned
2025-03-21 02:26 pbelov Assigned To => pbelov
2025-03-21 02:26 pbelov Tag Attached: dialect: sybase
2025-03-21 13:29 pbelov Status assigned => acknowledged