[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1012
  • Last Modified:

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.
1 Solution
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.
PAQed with no points refunded (of 500)

EE Admin

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now