Skip to Content
0

ASE, Job Scheduler doesn't work fine

Apr 22, 2017 at 05:03 PM

152

avatar image

Hi,

in a productive ASE box, used as SAP ECC database I've got a strage case, Job Schduler.... does't work randomily... sometime works fine for days/weeks and sometime stop to works after few day from startup. The only way to solve this issue is stop/strat ASE because the command (exec sybmgmtdb..sp_sjobcontrol '','stop_js') doesn't works, it stay in running for hours... endless running:

The last SID_JSAGENT:

Confidential property of Sybase, Inc.
Copyright 1987, 2015
Sybase, Inc. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.

This software contains confidential and trade secret information of Sybase,
Inc. Use, duplication or disclosure of the software and documentation by
the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and Sybase, Inc. or other written
agreement specifying the Government's rights to use the software and any
applicable FAR provisions, for example, FAR 52.227-19.
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:04300:04728:2017/04/16 17:30:55.79 jamain Opening jsagent connection.
00:04300:04728:2017/04/16 17:30:55.79 jamain Agent will listen on 10.2.5.250
00:04300:04728:2017/04/16 17:30:55.79 jamain SYB_JSAGENT waiting for connection
00:04300:04728:2017/04/16 17:30:56.76 jamain Job Scheduler Agent connected with Job Scheduler Task on port 4903
00:04300:04728:2017/04/16 17:30:56.79 jamain Initializing SYB_JSAGENT
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating list resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating queue resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Allocating thread resources.
00:04300:04728:2017/04/16 17:30:56.79 jamain Initializing connection pool.
00:04300:04728:2017/04/16 17:30:57.04 jamain Server message: Changed database context to 'master'.

00:04300:04728:2017/04/16 17:30:57.04 jamain Server message: Changed database context to 'sybmgmtdb'.

00:04300:04728:2017/04/16 17:30:57.05 jamain Server message: Changed database context to 'master'.

00:04300:04728:2017/04/16 17:30:57.05 jamain Server message: Changed database context to 'sybmgmtdb'.

00:04300:04728:2017/04/16 17:30:57.06 jamain Server message: Changed database context to 'master'.

00:04300:04728:2017/04/16 17:30:57.06 jamain Server message: Changed database context to 'sybmgmtdb'.

00:04300:04728:2017/04/16 17:30:57.07 jamain Server message: Changed database context to 'master'.

00:04300:04728:2017/04/16 17:30:57.07 jamain Server message: Changed database context to 'sybmgmtdb'.

00:04300:04728:2017/04/16 17:30:57.07 jamain Creating global context.
00:04300:04728:2017/04/16 17:30:57.08 jamain SYB_JSAGENT ready.

From DBACOCKPIT we can't run scheduling such as transaction log dump or backup so sometimes trlog is full :-(

If I try to schedule a command the page stay..... in endless running

It's a Windows 2012 R2 with MSCS, it happens on all nodes. It is ASE 15.7.0.136 release.

I've already try to set "job scheduler tasks" = 25 but without success.

Have you got any idea? Do you know any check to try to solve this issue?

Thank you.

slggs.png (4.6 kB)
amvfr.png (12.8 kB)
qzelt.png (6.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Madhvi Pai
Apr 24, 2017 at 11:41 PM
0

Hi Ganimede,

Are there any accompanying errors in the ASE errorlog when JS stops in this manner?

Also, as a side, is this a Hyper-V env? If yes, then it will help to confirmthat Hyper-V's virtual network adapter TCP/IP settings have both IPv4 and IPv6 enabled.

Thanks,

Madhvi Pai

SAP Product Support

Share
10 |10000 characters needed characters left characters exceeded
Ganimede Dignan Apr 26, 2017 at 03:33 PM
0

Hi Madvhi,

no particularly error:

It's not a Hyper-V box, it's an MSCS based on two IBM Flex system, ipv6 is disabled on LAN device and also on HB device:


iesxc.png (14.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Ganimede Dignan May 03, 2017 at 11:30 AM
0

Today, again... same situation :-(

Share
10 |10000 characters needed characters left characters exceeded