Skip to Content

Sybase Ase Patch update Error

Dear Experts,

I am facing an unusual error, While updating our database from patch 100 to 135 of Sybase ASE.

Kindly help me to resolve this issue.

I have tried to resize the disk but its not allowing me plus giving some other error which is sybmgmtdb is not valid identifier.

I have also tried to increase the sybmgmtdb from dbacockpit which was successfull but when tries to run the update command it gives me the same about screen shot error.

Waiting for your prompt response.

Best Regards,

sybasse Error.png (44.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 14, 2015 at 09:35 AM

    Hi,

    maybe you can find some additional information in ASE-15_0\init\logs. There you should find a log file (or more if you've tried more often) belonging to the current date. Maybe this file contains some helpful information.

    Best regards,

    Juergen

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      my initial idea was to search the log for any messages regarding sybmgmtdb or other messages that might block the upgrade process.

      Anyhow could you execute a statement on command line (isql):

      sp_helpdb sybmgmtdb

      go

      This will give us the exact size of data and log parts of the database.

      Then you should re-try the upgrade. If it fails with the same error message as before, you can extend the database:

      alter database sybmgmtdb on <put_your_data_device_here> = 12

      go

      This will increase the data part of the database by 12 MB.

      Best regards,

      Juergen

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.