ASE 15.7 Job Scheduler won´t start again

[Former Member]

Hi,

we encoutered the following problem in our ECC6.0 / EHP5 on ASE 15.7 PL 122 System:

DBACockpit / Collector Configuration shows the warning "The ASE-Job Scheduler is not active". The log SID_JSAGENT shows the following entries:

00:11704:12104:2014/09/01 08:00:35.78 jamain  Opening jsagent connection.

00:11704:12104:2014/09/01 08:00:35.78 jamain  Agent will listen on <IP>

00:11704:12104:2014/09/01 08:00:35.78 jamain  SYB_JSAGENT waiting for connection

00:11704:12104:2014/09/01 08:00:36.72 jamain  Job Scheduler Agent connected with Job Scheduler Task on port 4903

00:11704:12104:2014/09/01 08:00:36.72 jamain  Initializing SYB_JSAGENT

00:11704:12104:2014/09/01 08:00:36.72 jamain  Allocating list resources.

00:11704:12104:2014/09/01 08:00:36.72 jamain  Allocating queue resources.

00:11704:12104:2014/09/01 08:00:36.72 jamain  Allocating thread resources.

00:11704:12104:2014/09/01 08:00:36.72 jamain  Initializing connection pool.

00:11704:12104:2014/09/01 08:00:36.99 jamain  Client message: ct_connect(): user api layer: external error: The connection failed because of invalid or missing external configuration data.

00:11704:12104:2014/09/01 08:00:36.99 jamain  ct_connect() failed.

00:11704:12104:2014/09/01 08:00:36.99 jamain  jsj_AddConxs: jsd_MakeConnection() failed for user jstask to server SID

00:11704:12104:2014/09/01 08:00:36.99 jamain  jsj_CreateConxPool: jsj_AddConxs() failed

00:11704:12104:2014/09/01 08:00:36.99 jamain  Initialization failed initializing connection pool

00:11704:12104:2014/09/01 08:00:36.99 jamain  Jsagent failed to handle INIT message.

00:11704:12104:2014/09/01 08:00:36.99 jamain  JS Agent aborting. Cancel all running jobs.

00:11704:12104:2014/09/01 08:00:36.99 jamain  Job Processing failed.

00:11704:12104:2014/09/01 08:00:36.99 jamain  JS Agent exiting.

Restarting the scheduler on ISQL doesn´t seem to work. Any ideas?

Many thanks & greetings

Vierengel Stefan

[former_member188883 · Accepted solution]

Hi Stefan,

Could you please check response in thread http://scn.sap.com/thread/3366873

Similar issue is discussed.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi,

thank you. Problem was solved by performing the following steps

1.     deleting the following file: DRIVE:\sybase\SID\OCS-15_0\ini\ocs.cfg

2.     Stop / Start Job Scheduler

         exec sybmgmtdb..sp_sjobcontrol '','stop_js'

        go

         exec sybmgmtdb..sp_sjobcontrol '','start_js'

        go

3.     Refresh DBACockpit

Greetings

Vierengel Stefan