Solved

Sybase, Can't start Js agent

Posted on 2009-07-14
2
2,054 Views
Last Modified: 2012-05-07
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
Comment
Question by:motioneye
2 Comments
 
LVL 23

Accepted Solution

by:
Kamaraj Subramanian earned 500 total points
ID: 24850620
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
 

Author Comment

by:motioneye
ID: 24850714
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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The business world is becoming increasingly integrated with tech. It’s not just for a select few anymore — but what about if you have a small business? It may be easier than you think to integrate technology into your small business, and it’s likely…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question