cancel
Showing results for 
Search instead for 
Did you mean: 

[ASE Error SQL4939]ALTER TABLE 'saptools..DBH_MSG_LOG' failed

Former Member
0 Kudos

Hello Community,

We are in the process of configuring managed system configuration in solution manager 7.1 SPS8.

1. Under automatic configuration where the "database extractor setup" is configured. We have the following error.

NOTE*** SYBASE ASE 15.7,

Adaptive Server Enterprise/15.7/EBF 21521 SMP SP102 /P/x86_64/Enterprise Linux/

         ase157sp101/3445/64-bit/FBO/Sat Jul 13 02:28:53 2013

What tried so far:-

1. implement collective note 0001558958 SYB: DBA Cockpit Correction Collection SAP Basis 7.02 / 7.30

2. SAPSA is working fine. Checked both from sapgui-> dbacockpit-> switch gui-> select system-> test-> connection established-

3. isql -Usapsa -PXXXXX -SSID is also working fine.

ERROR:-

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

Exception CX_DBA_ADBC in program RAGS_SISE_ACTIVITY_JOB line 0
Kernel Error ID:
WP ID: 13
WP PID: 31439
SYSID: B1D
SY-SUBRC: 0
SQL statement: ALTER TABLE saptools..DBH_MSG_LOG DROP "SOURCE_HOSTNAME" WITH NO DATACOPY
Database: B1D
caused by
Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY
Kernel Error ID:
DB Error: Yes
SQL Code: 4939
SQL Message: [ASE Error SQL4939]ALTER TABLE 'saptools..DBH_MSG_LOG' failed. You cannot drop column 'SOURCE_HOSTNAME' because it is being used by an index. Drop the index 'DBH_MSG_LOG~1' before dropping this column.

DB Object Exists: No
Duplicated Key: No
Internal Error: 1
Invalid Cursor: No
Unknown Connection: No
Connection Closed: No

Appreciated if you can help.

Thanks & regards,

Sree

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi Kaligiri,

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.


Hope this helps.


Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

Thanks for your reply.

However, I understand that it is an issue with either permissions with particular table or to change the index of table to another field. In addition, we do not have sufficient documentation to prove that service pack update will be resolve the issue (Do we have any??? sorry for being Naive). So, as to convince the customers.

Thanks & regards,

Sree

former_member188883
Active Contributor
0 Kudos

H Kaligiri,

Refer thread https://scn.sap.com/thread/3457706.

Same issue has been resolved with Service pack update.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

Thanks for the response.

I will try on sandbox and will confirm the result to the community.

However, I am not convinced with SAP documentation. atleast we should be having information on what bugfixes are covered in what support packs, intermediate works arounds,...

Thank you once again.

Thanks & regards,

Sree

Former Member
0 Kudos

Hi Deepak,

the problem disappeared after 15.7 SP122 installation

Regards, Evgeniy