Database error 1450... [1450] TCP Provider: Insufficient system resources exist

Question

Database error 1450... [1450] TCP Provider: Insufficient system resources exist

Techboy-427295

Mr or Mrs. 500

Points: 503
More actions
February 25, 2008 at 8:33 am

#179417

I am running a SAP system with MS SQL 2005 SP1 and occasionally get this error:
Database error 1450 at SEL access to table ZTAB258
[1450] TCP Provider: Insufficient system resources exist to
complete the requested service.#[1450] Communication link
failure
which causes the running job to fail as it cannot access the table.
In the event log, the errors are reported as Event ID 16421 but I have not been able to find out what this Event ID means (I have looked on Google, Microsoft and SAP websites).
Any ideas?
Thanks.
Paul

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jdgonzalez@jdandrachel.com Hall of Fame Points: 3161 More actions · Answer 1

I've received that error in the past, but it's always been in the context of backing up a DB. In our case, it was a processor that was being maxed out even though it was a quad proc server. I'll look for the KB article and post it if I find it.

Techboy-427295 Mr or Mrs. 500 Points: 503 More actions · Answer 2

Thanks for your reply.

When we get it, the CPU and RAM are at normal levels. Also it is during normal operation, not during a backup.

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Check for system resources like RAM, CPU, disk, cache, etc. one them is being hevily used. you can do a perfmon to collect the data and analyze for the results.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Key DBA SSCertifiable Points: 6029 More actions · Answer 4

Paul,

I did a little digging and found this reference ...

http://www.sqlservercentral.com/Forums/Topic131319-5-1.aspx#bm132085

which refers to a KB article:

Backup program is unsuccessful when you back up a large system volume

http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

... The errors reported in the KB seem similar, but seem to occur when running backups. Hopefully it will get you passed your error.

There is a blog posting regarding the Operating System error 1450, which seems to be related to file fragmentation ...

http://mimrsh.blogspot.com/

... Just another possibility to check into.

Keep us posted on your status.

Hope This Helps,

"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Techboy-427295 Mr or Mrs. 500 Points: 503 More actions · Answer 5

Thanks Damon,

I have actually seen http://support.microsoft.com/default.aspx?scid=kb;en-us;304101

The only problem is that we have only seen the issue twice, so we won't know if anything we do actually will actually fix it or not. I am now kind of wanting the issue to come up more often before I implement a fix... 🙂

The KB article mentions 2 registry values.

The first does not exist on our servers.

The HEX value of the second is currently 0 on our servers.

The error in the blog http://mimrsh.blogspot.com/ is interesting. Our data is stored on a managed SAN so should not be overly-fragmented (on a SAN fragmentation is expected - data stored on multiple drives for parallel read/write) but I will talk to our storage team.

Many thanks.

Paul

ben.phillips SSC Journeyman Points: 75 More actions · Answer 6

Hi Paul, we have the same message on our SAP system.

Did you get it resolved?

Any help much appreciated.

Kind regards

Ben