Error in RDI back-end setup occured Solution Manager 7.1 DBACOCKPIT

[anc13n7]

Hi,

I was trying to schedule the data collector for LOCK EVENTS. The error message is the same as above. But drilling down i came across following message

Database: <SID>

caused by

Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT

Kernel Error ID:

DB Error: Yes

SQL Code: 204-

SQL Message: SQL0204N "SAPTOOLS.LOCK_EVENT" is an undefined name. LINE NUMBER=298. SQLSTATE=42704

DB Object Exists: No

Duplicated Key: No

Internal Error: 5

Invalid Cursor: No

Unknown Connection: No

Connection Closed: No

Ive got no clue whatsoever how to overcome this problem. 1456402 is already implemented.

Apart from that following notes are also in the system

1598074

1654250

1816097

1817052

1817567

1820785

1824256

1828601

1833064

System specs

SAP SOLUTION MANAGER 7.1 SP 08

Managed System:EHP6 FOR SAP ERP 6.0

Both of them are running with DB6 : 09.07.0007 on RHEL6.

For further clarification ive attached the error log from the DBACOCKPIT in text file.

Regards,

Haroon

Error_log_DCM.txt.zip

[hugo_amo]

Hi Haroon,

Do you have the latest version of the note 1456402 (version 61) implemented?

Could you follow the steps mentioned in note 1660405 to deactive and recreate SAP_LOCK_EVENTS?

Regards,

Hugo

[anc13n7]

Hi Hugo,

Thanks for the reply. Yes its v.61 and ive already tried out the setps of 1660405 as well. Dint quite help me.

Another thing that made me scratch my head was the ownership of DCM that resides with the solution manager and not the managed system itself. Is it normal?

Regards,

Haroon