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</re sid><stati d>152</sta tid><timeS tamp>13158 48600</tim eStamp><av g>86400.00 0000</avg> <min>86400 .000000</m in><max>86 400.000000 </max><cou nt>1</coun t></xdat>< xdat><resi d>17181</r esid><stat id>152</st atid><time Stamp>1315 848600</ti meStamp><a vg>86400.0 00000</avg ><min>8640 0.000000</ min><max>8 6400.00000 0</max><co unt>1</cou nt></xdat> <xdat><res id>17180</ resid><sta tid>152</s tatid><tim eStamp>131 5848600</t imeStamp>< avg>86400. 000000</av g><min>864 00.000000< /min><max> 86400.0000 00</max><c ount>1</co unt></xdat ><xdat><re sid>17177< /resid><st atid>152</ statid><ti meStamp>13 15848600</ timeStamp> <avg>86400 .000000</a vg><min>86 400.000000 </min><max >86400.000 000</max>< count>1</c ount></xda t><xdat><r esid>17178 </resid><s tatid>152< /statid><t imeStamp>1 315848600< /timeStamp ><avg>8640 0.000000</ avg><min>8 6400.00000 0</min><ma x>86400.00 0000</max> <count>1</ count></xd at><xdat>< resid>1703 9</resid>< statid>152 </statid>< timeStamp> 1315848600 </timeStam p><avg>864 00.000000< /avg><min> 86400.0000 00</min><m ax>86400.0 00000</max ><count>1< /count></x dat><xdat> <resid>171 58</resid> <statid>15 2</statid> <timeStamp >131584860 0</timeSta mp><avg>86 400.000000 </avg><min >86400.000 000</min>< max>86400. 000000</ma x><count>1 </count></ xdat><xdat ><resid>17 159</resid ><statid>1 52</statid ><timeStam p>13158486 00</timeSt amp><avg>8 6400.00000 0</avg><mi n>86400.00 0000</min> <max>86400 .000000</m ax><count> 1</count>< /xdat><xda t><resid>1 7182</resi d><statid> 152</stati d><timeSta mp>1315848 600</timeS tamp><avg> 86400.0000 00</avg><m in>86400.0 00000</min ><max>8640 0.000000</ max><count >1</count> </xdat><xd at><resid> 17160</res id><statid >152</stat id><timeSt amp>131584 8600</time Stamp><avg >86400.000 000</avg>< min>86400. 000000</mi n><max>864 00.000000< /max><coun t>1</count ></xdat><x dat><resid >17157</re sid><stati d>152</sta tid><timeS tamp>13158 48600</tim eStamp><av g>86400.00 0000</avg> <min>86400 .000000</m in><max>86 400.000000 </max><cou nt>1</coun t></xdat>< xdat><resi d>17183</r esid><stat id>152</st atid><time Stamp>1315 848600</ti meStamp><a vg>86400.0 00000</avg ><min>8640 0.000000</ min><max>8 6400.00000 0</max><co unt>1</cou nt></xdat> </t>', 'tblHour2011255' - [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__tblHour2011255__33380 113'. Cannot insert duplicate key in object 'dbo.tblHour2011255'. in EXEC
how to fix this error
Error-log.txt
00:02:21 : [SQLDatabases] integrityerror in Executing SQL Statement exec sp_insertHour '<t><xdat><resid>17179</re
how to fix this error
Error-log.txt
You should delete the duplicate or change the table constraints for 'PK__tblHour2011255__33380 113'
ASKER
How to find the duplicates?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok