Call to SQLExecDirect failed with %1

Question

Hi

I am using SERVER 2k8 R2 and SQL Server 2008 sp1. I have already created two perf counters which are running fine. When I create 3rd one it stops with this error "Call to SQLExecDirect failed with %1". When I see windiws event log the error is "[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__CounterD__1FB2147B03317E3D'. Cannot insert duplicate key in object 'dbo.CounterData'. 430A ". I thought may be i ducpicated one of the counter with my other datacollector but that is not the case. I also took SQL trace. and the only two inserts I found was

- insert bulk CounterData("GUID" uniqueidentifier,"CounterID" int,"RecordIndex" int,"CounterDateTime" char(24) COLLATE SQL_Latin1_General_CP1_CI_AS,"CounterValue" float,"FirstValueA" int,"FirstValueB" int,"SecondValueA" int,"SecondValueB" int,"MultiCount" int)
- insert bulk CounterData("GUID" uniqueidentifier,"CounterID" int,"RecordIndex" int,"CounterDateTime" char(24) COLLATE SQL_Latin1_General_CP1_CI_AS,"CounterValue" float,"FirstValueA" int,"FirstValueB" int,"SecondValueA" int,"SecondValueB" int,"MultiCount" int)

Also I am not using SQL Native Client. I am using SQL Server ODBS driver to connect to DB.

I dont know how to solve this.

Thanks