SYBASE DBA COCKPIT ERROR

[jorge_velasquez]

Hi Experts,

After restore I have an error in tx DBA COCKPIT:

SQL Message: [ASE Error SQL4939]ALTER TABLE 'saptools..DBH_SNAP_ASEINSTANCE' failed. You cannot drop column 'SOURCE_HOSTNAME' because it is being used by an index. Drop the index 'DBH_SNAP_ASEINSTANCE~1' before dropping this column

Any clue?

[madhvi_pai]

ok, so sounds like a newer release of ASE did the trick - Thank you.

[sunny_pahuja2]

Hello,

Have you implemented SAP Note 1558958  - SYB: DBA Cockpit Correction Collection SAP Basis 7.02 / 7.30 after restore.

Thanks,

Sunny

[jorge_velasquez]

Hi Sunny,

Note 1558958 is not applicable, we are in the same SP version.

Regards.

[madhvi_pai]

Hi Jorge,

Were you able to get this resolved? The answer would be useful.

Thanks,

Madhvi Pai

[jorge_velasquez]

Hi,

Install the Service Pack following steps in SAP Note 1599814 "SYB: Installing Service Packs for Sybase ASE 15.7" if you run the database on UNIX/Linux or SAP Note 1607816 "SYB: Installing Service Packs for Sybase ASE 15.7" if you run the database on Windows.

Regards