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.
SAP Knowledge Base Article - Preview