SAPTOOLS.DBH_* running into Error on ERP EHP5 7.02

[Former Member]

Hi,

We recently upgraded ERP 6.0 System to EHP5 SP6;

db2 stored procedure invoke via db2 invoke db2sap is also done.

SAPTOOLS other functionalities working fine.

But when we open Webdynpro of DBACOCKPIT WEBGUI and we try to implement template of Data Collection Framework; Following saptools routines fail; Please help! I beleive it is a some kind of bug with DBACOCKPIT and latest Corrections still dont cover those as we have already implemented SAP Note# 1558958.

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_DB_COLLECT", the SPECIFIC name "DBH_DB_COLLECT

> already exists in the schema or module. LINE NUMBER=1463.

> SQLSTATE=42710

Database error -456

Database error -456 at EXE

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_TBSP_COLLECT", the SPECIFIC name

> "DBH_TBSP_COLLECT" already exists in the schema or module.

> LINE NUMBER=1096. SQLSTATE=42710

Database error -456

Database error -456 at EXE

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_BP_COLLECT", the SPECIFIC name "DBH_BP_COLLECT

> already exists in the schema or module. LINE NUMBER=678.

> SQLSTATE=42710

Database error -456

Database error -456 at EXE

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_MEMORY_COLLECT", the SPECIFIC name

> "DBH_MEMORY_COLLECT" already exists in the schema or module.

> LINE NUMBER=779. SQLSTATE=42710

Database error -456

Database error -456 at EXE

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_TABLE_COLLECT", the SPECIFIC name

> "DBH_TABLE_COLLECT" already exists in the schema or module.

> LINE NUMBER=2509. SQLSTATE=42710

Database error -456

Database error -456 at EXE

> SQL0456N In the definition of routine

> "SAPTOOLS.DBH_RSRC_COLLECT", the SPECIFIC name

> "DBH_RSRC_COLLECT" already exists in the schema or module.

> LINE NUMBER=825. SQLSTATE=42710

Database error -456

Thanks & Regards,

Sanjay Sahita

[Former Member]

Hi All,

Had same issue. But we corrected it from cockpit.
Going to Configuration->Data Collection Framework->collector configuration.

Go to database in Data collector section .
Display<-> Change
Click on Repair.
It is doing the needful change
Try it.

[steffen_siegmund]

Hi Sanjay Sahita,

have you already implemented SAP Note 1456402?

For each DBA Cockpit related issue it is always a good idea to implement this SAP Note. It is a master note and implements all available fixes.

If the issue still exists, open an SAP message.

Best regards,

Steffen Siegmund

[Former Member]

Hi Steffen, Yes we have SAP Note# 1456402 already but is version 46; I will try reimplementing latest version available i.e. Version 48 in coming Maintenance Break. If issue still persists; I will open an OSS; Thanks for the response.

I will keep posted how it ends up.

BR,

Sanjay

[MarcinOzdzinski]

Hi

Had same issue after upgrading Solman 7.01 to 7.1

Cant execute Database Extractor Setup due to error "SQL0456N  In the definition of routine "SAPTOOLS.DBH_DB_COLLECT", the SPECIFIC name "DBH_DB_COLLECT" already exists in the schema or module.  LINE NUMBER=1463."

Any hints?

Regards

Marcin

[bernhard_grusie]

Hello Marcin

Did you implement / update SAP Note 1456402? This note is a correction collection. Known problems are fixed with this note. If it did not help open an oss message.

Best regards

Bernhard