Solved

Error when updating

Posted on 2014-04-09
6
177 Views
Last Modified: 2014-04-12
Getting the following

Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption.

When updating a table between 2 servers/databases.

Can't find a solution.

Any ideas?
0
Comment
Question by:JElster
6 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 39988482
Try ou some of below

1. Rebuild Indexex
2.update package 2 for SP2
3. parse the SQL statement the old fashioned way
Refer for more details
http://www.sqlservercentral.com/Forums/Topic287524-149-1.aspx
0
 
LVL 1

Author Comment

by:JElster
ID: 39988504
What does parse the sql statement the oldfashion way mean.
I rebuilt the indexes.. still same error
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 39988825
Did you run "DBCC CHECKDB"?  What were the results?
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 1

Author Comment

by:JElster
ID: 39988903
What am I looking for

CHECKDB found 0 allocation errors and 0 consistency errors in database
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39990438
Can you elaborate on your system and post the relevant code that is triggering the error?
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 39992216
Hmm, interesting.

I suggest flushing the procedure/statement cache for that db, since there may be an obsolete object definition being used somewhere.

You'll need to get the database_id for that db:

DBCC FLUSHPROCINDB(<database_id>);


Also, I'd refresh all views in the db -- it won't hurt, and it might, with some luck, help:

EXEC sp_refreshview 'viewname'
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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