Improve company productivity with a Business Account.Sign Up

x
?
Solved

Sybase Error : 9519

Posted on 2010-09-14
3
Medium Priority
?
459 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
  • 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

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.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

With the functions here, you can parse, convert, and format back and forth between feet and inches and fractions and decimal inches - for normal as well as extreme values and with extreme precision.
Read this article to learn how to migrate data from SharePoint to SharePoint Online account. The entire process of SharePoint migration is described in detail.
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…

595 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