Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2299
  • Last Modified:

Sybase, Can't start Js agent

Hi,
I'm trying to start my job scheduler agent, but its always returned me error, how do I triubleshoot and get to know which user I assigned for start up this agent ?


1> use sybmgmtdb
2> go
1> sp_js_wakeup 'start_js',1
2> go
(return status = 1)
1>


Here is the error found in server.log

00:00000:00020:2009/07/14 21:59:07.29 kernel  Installed Job Scheduler sequencer code version 0.27 - 27 tokens
00:00000:00020:2009/07/14 21:59:08.43 kernel  Job Scheduler Task state set to running, startcount 2.
00:00000:00020:2009/07/14 21:59:09.42 kernel  Job Scheduler Task connected with Agent on port 5012
00:00000:00020:2009/07/14 21:59:09.42 server  Error: 571, Severity: 16, State: 1
00:00000:00020:2009/07/14 21:59:09.42 server  Invalid user specified, password left unchanged.
00:00000:00020:2009/07/14 21:59:09.59 kernel  Job Scheduler Task lost its Agent connection (No error)
00:00000:00020:2009/07/14 21:59:15.54 kernel  Job Scheduler Task failed (re)connecting to its Agent (No error)
00:00000:00020:2009/07/14 21:59:15.56 kernel  Job Scheduler Task state set to stop
0
motioneye
Asked:
motioneye
1 Solution
 
Kamaraj SubramanianApplication Support AnalystCommented:
I found a couple solved cases at sybase.com that are similar to what you're seeing (though they are on ASE 12.5.x and
not ASE 15.0.1).

Each of the cases recommends running dbcc checkcatalog. If checkcatalog reports any problems you can then a) run dbcc
checkcatalog's fix option or b) drop and recreate any (faulty) indexes reported by checkcatalog.

If you don't know which database the error was generated from then you should run dbcc checkcatalog in all databases.

Since you appear to have some corruption you may want to look at running a full set of dbcc's against all of your
databases at some point. (If you go this route I'd suggest setting up and configuring a dbccdb database.)

source : http://www.mydatabasesupport.com/forums/sybase/240620-invalid-column-length-value-must-between-0-5-a.html
0
 
motioneyeAuthor Commented:
Hi,
How do you know my error appears as related to corruption? I really thought this might something to do with user account use to start Js_agent, but my problem is I do not know which account/use used to start this agent...
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now