Solved

Sybase, Can't start Js agent

Posted on 2009-07-14
2
1,936 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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now