Sybase Error : 9519

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.
CrazycruxAsked:
Who is Participating?
 
Joe WoodhousePrincipal ConsultantCommented:
Hmm, the issue is supposedly resolved in your version. Anyway, either of the methods above will fix this for you.
0
 
Joe WoodhousePrincipal ConsultantCommented:
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
 
CrazycruxAuthor Commented:
Hi Joe,
I am using Sybase 12.5
0
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.

All Courses

From novice to tech pro — start learning today.