Sybase Ase Patch update Error

[former_member341093]

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,

[hans-juergen_schwindke · Accepted solution]

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

[former_member341093 · Accepted solution]

Hi Juergen

Thanks for the reply do you want me to paste the logs cause i have read it and didn't find any clue.

But Logs are big plus i don't think it will fit here.

By the way i have extended the Database and its file but  still remains.

Kindly guide help to resolve this issue.

Best Regards

[hans-juergen_schwindke · Accepted solution]

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