2460661 - Jsagent not starting after DB restart and failing with js__sequencer_load | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2460661 - Jsagent not starting after DB restart and failing with js__sequencer_load

Symptom

JS_AGENT crash on startup .. stacktrace

JS_AGENT fails .. unable to reset .. unable to reinstall with installjsdb script.

00:0004:00000:00019:2017/02/23 18:03:31.45 kernel  Initializing Job Scheduler Task
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  Current process (0x3b001e) infected with signal 11 (SIGSEGV)
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  Address 0x0x00000000007a8c0a (js__sequencer_load+0x3e3), siginfo (code, address) = (1, 0x(nil))
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  **** Saved signal context (0x0x000000014ee7b600): ****
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  uc_flags: 0x0, uc_link: 0x(nil)
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  uc_sigmask: 0x416000 0xb 0x1 0x0
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  General Registers (uc_mcontext.gregs):
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       PC : 0x00000000007a8c0a (js__sequencer_load+0x3e3)
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel          RAX : (nil)  RBX : 0x000000044ba1b210
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel          RCX : 0x0000000000000010  RDX : 0x0000000000000004
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       RBP : 0x000000014ee7c2c0  RSP : 0x000000014ee7ba70
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       R8  : 0x000000044ba1b940  R9  : 0x000000000265d7c8
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       R10 : (nil)  R11 : (nil)
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       R12 : 0x000000044ba1b23c  R13 : 0x000000044ba1b21c
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       R14 : 0x0000000000000003  R15 : 0x0000000000000003
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       RDI : 0x000000044ba1b23c  RSI : 0x000000000000000c
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       RIP : 0x00000000007a8c0a  CSGSFS : 0xffff00000000e033
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       TRAPNO : 0x000000000000000e  ERR : 0x0000000000000006
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel       EFL : 0x0000000000010242
00:0004:00000:00019:2017/02/23 18:03:31.48 kernel  **** end of signal context ****
00:0004:00000:00019:2017/02/23 18:03:57.38 kernel  ************************************
00:0004:00000:00019:2017/02/23 18:03:57.38 kernel  SQL causing error : set nocount on
declare @sid int
declare @type int
declare @seqno int
declare @name varchar(32)
declare @sql varchar(1800)
select @sid = ssql_sid, @typ
00:0004:00000:00019:2017/02/23 18:03:57.38 kernel  ************************************
00:0004:00000:00019:2017/02/23 18:03:57.39 server  SQL Text: set nocount on
declare @sid int
declare @type int
declare @seqno int
declare @name varchar(32)
declare @sql varchar(1800)
select @sid = ssql_sid, @type = ssql_type, @seqno = ssql_seqno, @name = ssql_name, @sql = ssql_sql from js_seqsql where ssql_sid = 3
print ':#: %1! %2! %3! %4! %5!', @sid, @type, @seqno, @name, @sql
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  curdb = 31515 tempdb = 2 pstat = 0x10000 p2stat = 0x100100
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x0 p6stat = 0x1 p7stat = 0x10000
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  lasterror = 0 preverror = 0 transtate = 1
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  curcmd = 0 program =
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  extended error information: hostname:  login:
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x000000000163246b pcstkwalk+0x3a3()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x0000000001631f43 ucstkgentrace+0x263()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x000000000162deae ucbacktrace+0x50()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x000000000078b117 terminate_process+0xa97()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x0000000001681818 kisignal+0x31f()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  [Handler pc: 0x0x00000000007a8804 js__seqload_handler installed by the following function:-]
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x00000000007a8c0a js__sequencer_load+0x3e3()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  [Handler pc: 0x0x00000000007a8ff3 js__backout installed by the following function:-]
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x00000000007a934c js__sequencer_boot+0x336()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x00000000007acee4 js__chores+0x2b9()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  pc: 0x00000000007ae93d jobscheduler+0xc8()
00:0004:00000:00019:2017/02/23 18:03:57.39 kernel  end of stack trace, spid 19, kpid 3866654, suid 0


Read more...

Environment

SAP Adaptive Server Enterprise 15.7 SP136

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

JSAGENT ,  js__sequencer_load,  js__sequencer_boot , 808637 ,  775556 , 800942 , SAP ASE , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.