Error while scheduling data collector: Error adding routine 'SAPTOOLS.DBH_FWK_CLEANUP' to task scheduler

[Former Member]

Error Detail

Exception CX_DBA_ADBC in program RAGS_SISE_ACTIVITY_JOB line 0 Kernel Error ID: WP ID: 23 WP PID: 28977 SYSID: CR5 SY-SUBRC: 0 SQL statement: Database: CR5 caused by Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT Kernel Error ID: DB Error: Yes SQL Code: 444- SQL Message: SQL0444N Routine "*TASK_ADD" (specific name "SQL140704080729140") is implemented with code in library or path "...ib/function/SYSPROC.ADMIN_TASK_ADD", function "*" which cannot be accessed. Reason code: "4". SQLSTATE=42724 row=1 DB Object Exists: No Duplicated Key: No Internal Error: 1 Invalid Cursor: No Unknown Connection: No Connection Closed: No System Detail: Solman 7.1

ST    710    0010    SAPKITL710    SAP Solution Manager Tool SAP_BASIS    702    0013    SAPKB70213    SAP Basis Component Managed system: SAP CRM ABAP 7.0 SAP_BASIS    701    0005    SAPKB70105    SAP Basis Component SAP_ABA    701    0005    SAPKA70105    Cross-Application Component PI_BASIS    701    0005    SAPK-70105INPIBASIS    Basis Plug-In ST-PI    2008_1_700    0008    SAPKITLRD8    SAP Solution Tools Plug-In CRMLOY    700    0005    SAPK-70005INCRMLOY    CRM Loyalty Management 700 SAP_BS_FND    701    0005    SAPK-70105INSAPBSFND    SAP Business Suite Foundation SAP_BW    701    0005    SAPKW70105    SAP Business Warehouse LCAPPS    2005_700    0007    SAPKIBHD07    LC Applications (LCAPPS) 2005_700 Database DB2 db2level DB21085I  Instance "db2cr5" uses "64" bits and DB2 code release "SQL09016" with level identifier "01070107". Informational tokens are "DB2 v9.1.0.6", "s081007", "U817474", and Fix Pack "6". Activity detail: We are performing managed system configuration for CRM into Solman by using solman_setup transaction. While performing the Database Extractor Setup in step 8 we have observed above error. Action take at our end: 1. Clean the LMDB and restart the configuration. - no luck 2. Upgrade the hostagent at CRM - No luck 3. Update the SLD for CRM entry - no luck 4. implemented SAP notes: 875986    Note Assistant: Important notes for SAP_BASIS up to 702 1246964    Note Assistant: Master language of notes incorrect 1262653    SPAU: New object is deleted after note is reset 1309424    DB6: DBA Cockpit Correction Collection SAP Basis 7.01 / 7.11 1335017    DB6:"Remove Redundant Restrictions" can return wrong results 1349277    Note Assistant: Method cannot be implemented 1365677    Note Assistant: Runtime error MOVE_CAST_ERROR during implmtn 1372652    DB6: Short dump when viewing diaglog due to NULL bytes 1373957    DB6: CX_SY_CONVERSION_OVERFLOW in new EXPLAIN 1376543    DB6: OPTIONS parameters for backup jobs in DB13 1378499    DB6: CLI error CLI0112E with "REORGCK_ALL" job 1379260    DB6: Add BW query name as comment to SQL statements 1379346    DB6: Scheduling of data collectors fails 1381179    DB6: Incorrect values for 'number of objects in tablespace' 1382634    DB6: Unable to create view 'SAPTOOLS.DBH_TABCLASS' 1382996    DB6: Update of DPW Back-End in Monitored DBs does not work 1384238    DB6: Defect scheduler on DB2 9.1 FP7/FP8 for LUW on Linux 1387022    DBA Cockpit: Month displayed incorrectly in DB13C 1387297    DB6: SQL-Fehler 901 during RUNSTATS and REORGCHK 1397709    Ignore Dynpro element fields AGLT and ADEZ in SNOTE/CWB 1398258    DB6: Job REORGCK_ALL places load on package cache 1400843    DB6: Incorrect display of key fields in EXPLAIN 1412719    SNOTE: error when implementing enhancement implementations 1413008    DB6: SQL0206N in function module DB6_PM_LOCKSNAP 1414624    DB6: Performance views if database monitors are deactivated 1414626    DB6: Incorrect display of file system sizes of containers 1415680    Note Assistant: Incorrect status in subsequent systems 1421157    DB6: SQL error 204 when accessing table DBSTATC 1425487    SE24: Error regarding READ-ONLY for complex attributes 1426092    DB6: Incorrect DROPPED TABLE clause for tablespaces 1426480    DB2: Incorrect display of registry values for DPF systems 1427030    DB6: Container specifications for tablespaces not changeable 1429082    DB6: No REORG after deactivating compression 1429687    DB6: SQL cache performance 1438168    DB6: REORGCHK recommendations for indexes are missing 1444373    DB6: Loading the package cache with monitor functions 1449482    DB6: Error message 'Command LIST_DB2DUMP failed' 1451958    DBA Cockpit: Incorrect start time for jobs 1452197    DB6: SQL error 100 in job REORGCK_ALL 1452502    DBA Cockpit: Jobs are missing in central planning calendar 1455897    DB6: Display of data classes is not updated 1456379    DB6: No display of indexes in data classes 1460895    DB6: SQL0104N during creation of WLM threshold 1462415    DB6: SQL -444 error messages in system log 1462855    DB6: Incorrect database name in HA environment 1464800    DB6: SQL Commands executes automatically on system change 1464858    DB6: COMPUTE_BCD_OVERFLOW during EXPLAIN Test Execute 1469515    DB6: Runtime error GETWA_NOT_ASSIGNED_RANGE in SAPLSDB6MON 1485313    DBA Cockpit: Incomplete system entries after SLD import 1486972    DB6: Parameters for DB/DBM configuration cannot be changed 1489968    DBA: DBA Cockpit WebDynpro does not care about HTTPURLLOC 1496515    DB6: SQL error 1428N when starting the DBA Cockpit 1501130    DB6: SQL error 802 in DB6_DIAG_COUNT_TABLE_ENTRIES 1508074    RZ20: 'Connection' attribute does not report alerts 1509121    DBA Cockpit: Endless loop occurs when starting DBA Cockpit 1511803    DB6: DB_TABLE_DATA_READ does not return data 1521525    DB6: Table display is not sorted 1522617    DB6: Availability of BW-specific functions in DBA Cockpit 1532114    DB6: Too many locks when collecting table history 1536787    DBA Cockpit: WebDynpro Explain - LOADDATA requires a model 1542311    DB6: Runtime error BCD_OVERFLOW in auto maintenance display 1546866    DB6: Runstats_DBSTATC interprets runtime param. incorrectly 1551729    DB6: Incorrect number of key fields in EXPLAIN 1552812    DB6: Use of db2sap functions 1559699    DB6: Missing data in SQL cache display 1559967    DB6: SQL error 206 when collecting the table history 1563327    DB6: SQL error SQL0551N when accessing SYSSTAT.TABLES 1568800    DB6: Error when deleting alert messages 1569592    DB6: SQL error SQL0433N in EXPLAIN 1569669    DB6: Incomplete history for performance data 1571365    DB6: SQL error SQL0443N in alert monitoring of DPF system 1576094    DB6: Database error SQL1751N in partitioning wizard 1597281    DB6: Incorrect compression displays for tables 1599764    DB6: SQL error 1428 when calling transaction SM50 1602403    DB6: No VOLATILE attribute after RUNSTATS or REORG job 1613270    DB6: Runtime error DYNPRO_FIELD_CONVERSION in DBA cockpit 1615698    DBA Cockpit: Incorrect date selection in DB13C 1619084    DBA Cockpit: Runtime err MESSAGE_TYPE_X when alert displayed 1619636    DBA Cockpit: Daily scheduling is not deleted 1624436    DBA Cockpit: Errors when accessing SHM area CL_DBA_SHM_AREA 1639631    DBA Cockpit: Failed schedulings in DB13 1720495    Invalid deimplementation of obsolete notes by Snote tool Kindly suggest the correct solution to fix the issue.

[former_member188883]

Hi Bipin,

Please check solution from below SAP notes.

Note 1462415 - DB6: SQL -444 error messages in system log  ( SAP_BW 701 SP7 suggested)

Note 978319 - DB6: Incorrectly cataloged table functions

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Dear Deepak

Thanks for quick response.

Note 1462415 - DB6: SQL -444 error messages in system log  ( SAP_BW 701 SP7 suggested)

This is already implemented and updated in my 1st message.

Note 978319 - DB6: Incorrectly cataloged table functions

This note can not be implemented due to version issue.

Kindly suggest some more hints on top of what I already did.

Regards

Bipin

[former_member182505]

Hi

Could you please check the below link and note

IBM Knowledge Center

Thanks