Product(s):	Exor MapCapture (ESRI)
	Version(s):	04.05.02.02
	Environment:	Windows XP 64 bit
	Area:	MCI
	Subarea:	N\A

Problem

When running the batchfile manually I get the following error SDE Code (-9): Bad login
user.  This happens both in TST and Production. The scheduled  process keeps failing with the ESRI service is down message, but it is running.

Solution

Check if the SDE oracle account not expired and open ?

The error suggests that the user attempting to access the ArcSDE server does not have a valid login account on the ARCSDE host machine. When doing a bulk download of an MCI  asset is it saying esri SDE service Down - please contact your Administrator ?

Check the SDEBATDIR product option for the batch file location

To get batch files created query back %DEBUG% in Product Options form for the user and check values set to Y ,

Then repeat the download

Then look at the batch and log files to see what is gong on , on the server

Oracle Directories  form MCP_BATCHFILES should show you where they are.

It is the main highways owner account with the problem,

Looking at the batchfiles it shows username and passwords

Looks like the scheduled batch files are creating bat files with a different password to that produced when logged into the user and manually creating. The one with the correct password is working the one that has the wrong password is failing This reflects the error being displayed (-9).

Suggest  disabling the current process nos that is spawning the processes running then restarting it afresh to see if doing creates bat files  with the new password ....( I am not sure if that will work  or not ).
or
ether changing the password of mci_daily to highways to reflect what is in the scheduled batch job currently,
 or
create a new job logged in as MCI_DAILY with the new password if that works disable the old job.....

Note - Passwords for scheduled jobs don't usually change, if they do the impact should be assessed, jobs should be recreated if this is done,