View Revisions: Issue #6778
| Summary | 0006778: Debug Sybase error Explicit value specified for identity field in table ABC when 'SET IDENTITY_INSERT' is OFF | ||
|---|---|---|---|
| Revision | 2025-03-21 02:26 by pbelov | ||
| Description | Customer 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 |
||
| Revision | 2025-05-02 20:32 by pbelov | ||
| Description | Customer 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, most likely due to an earlier error which is leaving JdbcTransaction object in the SET IDENTITY_INSERT =ON state for the PRIOR table (and only 1 table is allowed on Sybase per transaction/connection). |
||