Job scheduler error

[Amarnath]

Hi Experts,

I am unable to schedule backups from DBA cockpit and I am seeing continious error logs in SID.LOG AND SID_JSAGENT.LOG.

All the databses as well as table spaces are free.

I have restarted job scheduler but no luck. Please advice.

SID.LOG

00:0008:00000:00188:2015/08/11 04:31:30.72 kernel  Initializing Job Scheduler Task

00:0008:00000:00188:2015/08/11 04:31:30.75 kernel  Installed Job Scheduler sequencer code version 0.29 - 29 tokens

00:0006:00000:00188:2015/08/11 04:31:31.12 kernel  Stale Job Scheduler Agent found on port 4907 . ASE will shutdown and restart the agent.

00:0006:00000:00188:2015/08/11 04:31:31.12 kernel  Job Scheduler Task state set to running, startcount 1849.

00:0006:00000:00188:2015/08/11 04:31:31.13 kernel  Job transition "SET COMPLETED" for calloutid 734392 got incorrect state 0

00:0006:00000:00188:2015/08/11 04:31:31.13 kernel  Job Scheduler Task lost its Agent connection (No error)

00:0008:00000:00188:2015/08/11 04:32:01.08 kernel  Job Scheduler Agent is in inconsistent state.

00:0008:00000:00188:2015/08/11 04:32:01.09 kernel  Job Scheduler Task state set to stop

00:0008:00000:00188:2015/08/11 04:32:01.09 kernel  Initializing Job Scheduler Task

00:0008:00000:00188:2015/08/11 04:32:01.11 kernel  Installed Job Scheduler sequencer code version 0.29 - 29 tokens

00:0006:00000:00188:2015/08/11 04:32:01.48 kernel  Stale Job Scheduler Agent found on port 4907 . ASE will shutdown and restart the agent.

00:0006:00000:00188:2015/08/11 04:32:01.48 kernel  Job Scheduler Task state set to running, startcount 1850.

00:0006:00000:00188:2015/08/11 04:32:01.49 kernel  Job transition "SET COMPLETED" for calloutid 734392 got incorrect state 0

00:0006:00000:00188:2015/08/11 04:32:01.49 kernel  Job Scheduler Task lost its Agent connection (No error)

SID_JSAGENT.LOG

00:03108:03104:2015/08/11 04:54:38.68 jamain  SYB_JSAGENT waiting for connection

00:03108:03104:2015/08/11 04:54:39.04 jamain  Job Scheduler Agent connected with Job Scheduler Task on port 4907

00:03108:03104:2015/08/11 04:55:08.98 jamain  -> JS: Task/Agent connection terminated.      

00:03108:03104:2015/08/11 04:55:08.98 jamain  Job Scheduler failed to receive communication buffer while reading message type.

00:03108:03104:2015/08/11 04:55:08.98 jamain  Connection to Job Scheduler task terminated unexpectedly with error -4

00:03108:03104:2015/08/11 04:55:08.98 jamain  SYB_JSAGENT waiting for connection

Thanks & Regards,

Amarnath

[Johan_sapbasis]

Hi Amarnath,

Can you confirm all your database connections are configured and working correctly.

Go to tcode DBACOCKPIT->

On the first page where you system configuration highlight the system and click test connection.

You should get result:

SID Database connection +++SYBADM established successfully Details

DBACOCKPIT -> System Landscape -> Database connections -> Expand Sybase remote connections

Highlight connection name should be +++SYBADM is your username specified sapsa?

Kind Regards,

Johan

[Amarnath]

Hi Johan,

Everything seems to be fine but the same error of job scheduler is repeating in the SID.log and SID_JSAGENT.log.

Even I tried many times to restart the Job scheduler but no luck. Please advice.

Best Regards,

Amarnath

[Johan_sapbasis]

Hi Amarnath,

Which SP level did you decide on?

I see the note you found statyes a minimum of this:

For Sybase ASE 15.7 SP51 and below, apply Service Pack for Sybase ASE 15.7 SP110 or ASE 157 SP121

Kind Regards,

Johan

[Amarnath]

Hi Johan,

We are planning to go for SP 134. Is that advisable? Or should we go for SP135?

Best Regards,

Amarnath

[Johan_sapbasis]

Hi Amarnath,

I also follow the same strategy as you latest minus one. But in this case still you are still on 15.7 review what is fixed in SP135 and decide if you can live without those fixes. Otherwise apply the latest.

Refer to note 2073343 - SYB: Release information for SAP Sybase ASE 15.7 SP13x and review the attached cover letters for example Check cover letter 15-7-135_coverletters.zip which includes the details for each different OS and what is fixed.

But it seems the recommendation for 15.7 is to go SP135.

Kind Regards,

Johan

[former_member142598]

Hello Amarnath,

It will be useful to have your ASE version and NW version when you post a question.

Can you please let us know what you are using?

From the ASE errorlog and JSAGENT log file, it looks like ASE fails to connect to Job Scheduler Agent.

Thank you.

- Gek

[Amarnath]

Hi Gek,

I am in ASE 15.7 SP-50. I got to know the job scheduler went in infinite loop in this note 2001487.

Can you please suggest me the temporary solution before upgrading the SP level. Is there any quick work around possible for this?

Best Regards,

Amarnath

[former_member142598]

Hello Amarnath,

Great work in finding the sap note!

Yes, you will have to upgrade to the fixed version or even better to the latest version of ASE15.7 SP135 which is out or  ASE 16.0 SP01 PL01 which is out. Please check out the SAP note 1554717: SAP release information for customers deploying SAP on (Sybase) ASE.

Hope this helps.

- Gek