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-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).
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