?
Solved

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

Posted on 2005-03-08
2
Medium Priority
?
1,502 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
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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Suggested Courses

616 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