Link to home
Start Free TrialLog in
Avatar of creativegenius786
creativegenius786

asked on

integrityerror in Executing SQL Statement exec

I am getting the following error from logs of my application

00:02:21 : [SQLDatabases] integrityerror in Executing SQL Statement exec sp_insertHour '<t><xdat><resid>17179</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17181</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17180</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17177</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17178</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17039</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17158</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17159</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17182</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17160</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17157</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat><xdat><resid>17183</resid><statid>152</statid><timeStamp>1315848600</timeStamp><avg>86400.000000</avg><min>86400.000000</min><max>86400.000000</max><count>1</count></xdat></t>', 'tblHour2011255' - [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__tblHour2011255__33380113'. Cannot insert duplicate key in object 'dbo.tblHour2011255'. in EXEC

how to fix this error
Error-log.txt
Avatar of MSSystems
MSSystems
Flag of South Africa image

You should delete the duplicate or change the table constraints for 'PK__tblHour2011255__33380113'
Avatar of creativegenius786
creativegenius786

ASKER

How to find the duplicates?
ASKER CERTIFIED SOLUTION
Avatar of MSSystems
MSSystems
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial