?
Solved

SQL Server Internal Error. Text manager cannot continue with current statement.

Posted on 2005-03-08
2
Medium Priority
?
1,329 Views
Last Modified: 2013-12-03
I noticed that this question has been posted already but the answer does not apply to my situation

I need your help getting this problem solved.

There is an Intranet application (developed in asp) that is used very often to upload images and executive summaries to our sql server 2000 with service Pack 3.

While this data is being uploaded, users sometimes close the browser or open a new one.
The application fails and I got this error message.

SQL Server Internal Error. Text manager cannot continue with current statement. v
via email

I have not been able to find useful information...

1) Is this error critical? why does it happen?
2) How can I solve it?

Any help will be appreciated thanks!
0
Comment
Question by:pimplicado
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
ptjcb earned 1500 total points
ID: 13489791
Images are managed by the Text Manager in SQL Server. SQL Server uses eight types of disk pages, one of them is text/image pages. All user data except for text, ntext, and image datatypes are stored on data pages. These types store large objects (up to 2GB each for text or binary data), can use a separate collection of pages. A pointer identifies the starting page and the offset of the text/image data.

Without knowing the error number - it is probably 7102 with a severity of 20 and state of 0

Severity Level 20: SQL Server Fatal Error in Current Process

These messages indicate that a statement has encountered a problem. Because the problem has affected only the current process, it is unlikely that the database itself has been damaged.

Severity.
The severity indicates how serious the error is. Errors with a low severity, such as 1 or 2, are information messages or low-level warnings. Errors with a high severity indicate problems that should be addressed as soon as possible.

State code.
Some error codes can be raised at multiple points in the source code for SQL Server. For example, an "1105" error can be raised for several different conditions. Each place the error code is raised assigns a unique state code. A Microsoft support engineer can use the state code from an error to find the location in the source code where that error code is being raised, which may provide additional ideas on how to diagnose the problem.

***
Try to capture the SQL Server error number. I would guess that because the connection has been broken the process of writing the image to disk has been interrupted.

0
 

Author Comment

by:pimplicado
ID: 13491298
Yes this is the error number that I got

DESCRIPTION:      Error: 7102, Severity: 20, State: 0

So is there any way to avoid getting this error?


Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question