[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

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.
0
Crazycrux
Asked:
Crazycrux
  • 2
1 Solution
 
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
 
Joe WoodhousePrincipal ConsultantCommented:
Hmm, the issue is supposedly resolved in your version. Anyway, either of the methods above will fix this for you.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now