1 row insert in specific table timeout

I have an ASP web application which has been running for the past 2 years with no problems. Today it started giving a timeout error when inserting 1 row into a table. Other inserts into tables are running fine.

Error: -2147217871 / [Microsoft][ODBC SQL Server Driver]Timeout expired / Microsoft OLE DB Provider for ODBC Drivers

Related SQL statement: insert into pchldr (plcyid_ph, lastname_ph, firstname_ph, address1_ph, address2_ph, city_ph, state_ph, zip_ph, county_ph) values (137305,'TEST','TEST','test','test','test','TS','55555','Test')

Description: [Microsoft][ODBC SQL Server Driver]Timeout expired
Help context: 0
Help file:
Native error: 0
Error number: -2147217871
Error source: Microsoft OLE DB Provider for ODBC Drivers
SQL state: S1T00

Any thoughts on what could cause this simple insert to start failing all of the sudden? The table has a Key on an ID field and only about 22K records in it.
Who is Participating?
PAQed with no points refunded (of 500)

EE Admin
Sham HaqueSenior SAP CRM ConsultantCommented:
could be that a constraint is being violated by new inserts:

check for the following:
unique or check constraint
primary key
foreign key
field size

try copying the table (use SELECT * INTO NEW_TABLE WHERE 1=0)
and try your same insert against the new table
what is the data type of your zipcode column. you are entering '55555' which is a string. if the datatype of that column is INT. then you wont be able to enter. you sould remove the quotes ( just 55555)..
check for this
There is probably another insert transaction in progress that is blocking additional inserts.  Find that transacation and commit, rollback, or kill it.  I would start by looking at the locks that are being held on the table in question.
What is so difficult that the geniuses in Redmond can't simply return an error that means something?  Is their networking software that bad that they can't decipher the real error?   Any other endeavour in the world would have failed miserably, if it weren't for the criminal use of advertising promotion by MSFT, they would(should) have gone down as well.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.