[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sybase Error : 9519

Posted on 2010-09-14
3
Medium Priority
?
452 Views
Last Modified: 2012-05-10
Hi,
I get this error when I am uploading data into my database.

Number = 9519, severity = 18, state = 7.
Failed to update the identity pre-burn factor for field `%.*s' in table `%.*s'. Please re-try the operation or contact your SA for details

I checked the data that I uploaded, everything looks ok. Only few times, I get this error.
Is it related to performance issues.. let me know if you have faced any such error. Thanks.
0
Comment
Question by:Crazycrux
[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
3 Comments
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 33697825
What version of ASE are you running?

Sybase Tech Support says:

Error 9519 indicates possible corruption on the object's OAM page.

How to fix this problem:

bcp  out the data, drop, and recreate the table which would result in  getting a new OAM page; bcp in.  Run DBCC tablealloc (on the table) with  the fix option.

Apply the EBF for CR219537, fixed in V.11.9.2.4, 11.9.2.3 ESD #2, 12.0.0.1 ESD#2, and 12.5 GA.
Note that despite the wording above, you only have to do ONE of either bcp out/drop/recreate/bcp in, or dbcc tablealloc([table], full, fix), not both.
0
 

Author Comment

by:Crazycrux
ID: 33706384
Hi Joe,
I am using Sybase 12.5
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 200 total points
ID: 33706888
Hmm, the issue is supposedly resolved in your version. Anyway, either of the methods above will fix this for you.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

650 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