SAP Knowledge Base Article - Preview

3570827 - Solution Manager database extractor setup and repair fails with error SQL19090 - SAP ASE for BS

Symptom

  • When performing Solution Manager database extractor setup and repair
  • ASE error 19090 is retuned to DBA Cockpit:

    SQL Message: [ASE Error SQL19090]Procedure sp_sjobcreate, @option='sname= jname=SP_DBH_HADR_RAT,server=SID', the option name or value is missing or invalid.
  • When trying to 'Repair All' in DBA Cockpit, it fails with the below messages:

    Exception CX_DBA_DBH_SETUP in class CL_DBA_DBH_SETUP_CTRL method INSTALL_INTERNAL line 313
    Kernel Error ID: 
    ...
    Message: Error while scheduling data collector

    caused by

    Exception CX_DBA_TASK_SCHEDULER in class CL_SYB_TASK_SCHEDULER method IF_DBA_TASK_SCHEDULER~SCHEDULE_TASK line 136
    ...
    Routineschema: saptools.
    Routinename: SP_DBH_HADR_RAT
    Message: Unable to schedule procedure 'SP_COLLECT_DBH_HADR_RAT'!

    caused by

    Exception CX_DBA_ADBC in program SAPMHTTP line 0
    ...
    SQL statement: sybmgmtdb..sp_sjobcreate

    caused by
    Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY
    ...
    DB Error: Yes
    SQL Code: 19090
    SQL Message: [ASE Error SQL19090]Procedure sp_sjobcreate, @option='sname= jname=SP_DBH_HADR_RAT,server=SID', the option name or value is missing or invalid.
    ...


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) for Business Suite.
  • SAP Solution Manager (SOLMAN) - All versions.

Product

SAP Adaptive Server Enterprise all versions ; SAP Solution Manager all versions

Keywords

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.