Skip to Content.
Sympa Menu

freetds - Re: [freetds] Unable to bcp file into MS SQL Server 2008

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Robert Hetzel <beh AT case.edu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unable to bcp file into MS SQL Server 2008
  • Date: Thu, 28 Jan 2010 22:54:39 -0500

There is an identity insert property which may be different than you
expect. If it's set to allow you to insert values in that field rather than
auto-generate a value, then that would explain the key violation.

Bob

On Thu, Jan 28, 2010 at 7:44 PM, Srdan Dukic <srdan.dukic AT gmail.com> wrote:

> Hi,
>
> We've recently upgraded from SQL Server 2005 to 2008 and have
> encountered a strange error when trying to use freebcp to insert data
> into a table. The table schema is identical, the only thing having
> changed being the version of ms sql.
>
> The error is:
>
> Msg 2627, Level 14, State 1
> Server 'ARCHIVESERVER', Line 1
> Violation of PRIMARY KEY constraint 'PK_log_failure'. Cannot
> insert duplicate key in object 'dbo.log_failure'.
> Msg 2627, Level 14
> General SQL Server error: Check messages from the SQL Server
>
> Msg 3621, Level 0, State 0
> Server 'ARCHIVESERVER', Line 1
> The statement has been terminated.
> 10 rows copied.
>
>
> The primary key field is a 'bigint', and is also an identity
> specification with a seed of 1 and an increment of 1 (pretty
> standard).
>
> When I insert, the the id field I put a '0' (zero), the actual line being:
>
> 0 B7/EA-09234-2552D5B4 2010-01-25 00:00:02 3 65535
> 0 [Log text line here]
>
> Where the first value is the 'id'column in question.
>
> Has anyone had this problem before?
>
>
> Thank you
> --
> Srđan Đukić
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page