SAP Knowledge Base Article - Preview

2155753 - Job Scheduler hits error 2601 "Attempt to insert duplicate key..." in sybmgmtdb..js_jobs and is not active - SAP ASE for Business Suite

Symptom

After restarting SAP ASE, error 2601 is raised on the js_jobs table in the sybmgmtdb database :

server  Error: 2601, Severity: 14, State: 6
server  Attempt to insert duplicate key row in object 'js_jobs' with unique index 'js_jobs_6080021662'
kernel  Job Scheduler: IS_ISQL_BAS failed [ insert sybmgmtdb..js_jobs (job_id, job_type, job_owner, job_created, job_name) values (2147483647, 0, 'FAKE_JSUSER', '23:59', 'FAKE_JSJOB') ]
kernel  Job Scheduler failed to insert into table js_jobs table
kernel  Job Scheduler incorrect or damaged database 'sybmgmtdb'
kernel  Job Scheduler: IS_ISQL_BAS failed [ insert sybmgmtdb..js_jobs (job_id, job_type, job_owner, job_created, job_name) values (2147483647, 0, 'FAKE_JSUSER', '23:59', 'FAKE_JSJOB') ]
kernel  Job Scheduler failed to insert into table js_jobs table
kernel  Job Scheduler incorrect or damaged database 'sybmgmtdb'
kernel  Job Scheduler: IS_ISQL_BAS failed [ insert sybmgmtdb..js_jobs (job_id, job_type, job_owner, job_created, job_name) values (2147483647, 0, 'FAKE_JSUSER', '23:59', 'FAKE_JSJOB') ]
kernel  Job Scheduler failed to insert into table js_jobs table
kernel  Job Scheduler incorrect or damaged database 'sybmgmtdb'
kernel  Job Scheduler: IS_ISQL_BAS failed [ insert sybmgmtdb..js_jobs (job_id, job_type, job_owner, job_created, job_name) values (2147483647, 0, 'FAKE_JSUSER', '23:59', 'FAKE_JSJOB') ]
kernel  Job Scheduler failed to insert into table js_jobs table
kernel  Job Scheduler incorrect or damaged database 'sybmgmtdb'


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

CR775297, CR#775297, 775297 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

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

Search for additional results

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