We help IT Professionals succeed at work.

Unable to add job to database - ARCserve

tut404
tut404 asked
on
7,229 Views
Last Modified: 2011-08-18
Hi All,

My ACRServer backup Incomplete since last week, and error message as below:-

W3501
Unable to add job to database. (EC=-2005)

Why suddenly I have received above message? Please advise, anything wrong in ARCServe?

Can tell me the ARCserve technical support link? Maybe can post this question into ARCServe website.

Tut404  
Comment
Watch Question

Author

Commented:
One of the page allowe us post our question, I did submit my question before but I lose the link. Please advise.
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Yes Arcserve installed on C drive, disk space still have 42GB available. I do not understand the DB Purning? Can you explain more details?

Should not be permission or password expired issue, I didnt change any password and I still have use my pasword login server.

DB engine was START, but I dont know why when the backup start, the DB engine automatically STOP.

In log activities:-

E4104  Unable to login to database engine. (Database=, EC=2005)
W3501 Unable to add job to database. (EC=2005)
E5110 The database is no longer available.

Tut404
CERTIFIED EXPERT

Commented:
Check out the bottom of page 12 in the pdf I posted.  It has the E4101 error listed and suggests database corruption.  Page 13 then explains why this might happen and 13/14 goes on to explain how to try and fix it.  Please follow these instructions.

As to pruning:  By default, Arcserve keeps track of all events for the last 30 days.  This means restores in the last 30 days are 'immediate'.  After 30 days, the information is pruned - ie, deleted, from the database.  If you want to restore from 40 days ago, Arcserve no longer knows what's on the tape, so you have to MErge it - this reads the infor back into the database.  If you pruning job is on hold, then this data deletion doesn't happen, and eventually the DB can grow to its maximum size of about 36GB, after which no further entries cn be made and corruption may result.
Thus, check you have the prune job (created by default) and it is still able to run.  Otherwise create a new prune job and run it. Also check the DB size and if it's 36GB, after pruning run the defrg utility to reduce the DB size.
CERTIFIED EXPERT

Commented:
FRom same PDF:

"3 Initializing the VLDB Database without losing Media Pool information
Choose to initialize just the astpsdat and Asobject databases.
The astpsdat and Asobject database are the largest part of the BrightStor database and hold session information including files and directories backed up."

This is you ultimate fall-back.  Initialising a database basically deletes and re-creates it, thus losing all info.  Re-initialising the two DB's shown above will delete all infor about back-ups recently done, without removing other info (like job set-ups etc).  For restores, you would then need to do a merge first as mentioned before.  All new back-ups would of course start populating the DB again.

Commented:
Errors E4107 and W3501

If the following errors occur it means that the ARCserve log (asdblog) is full. If backups of the ARCserve database are being performed, the 'truncate log on checkpoint' option more than likely is disabled. Having this option disabled can produce the errors below during back ups, merges, or restores. If the log is full, dump the log with the dump statement or truncate it in the Edit Database area in the SQL Enterprise Manager. These errors can also be generated if there are no available user connections in SQL Server:

This is what the ARCserve log would show:

E4107 Unable to update job record. (EC=-1)

W3501 Unable to add job to database. (EC=-1)

This is what would correspond to this error in the SQL Error log, which is located at MSSQL\logs\error.log:

Author

Commented:
I did delete the rd.chk. raaaaaa.chg and rdm.chi from Database, but still having same problem.

How do I re-create the Purge job (create by default)?
CERTIFIED EXPERT

Commented:
I've not used Arcserve since version 6 (except for the odd restore), but when you a create a job you should be able to choose the type: backup, restore, pruning or merge.

did you also try the dbcheck command to see if the database is corrupted or not?
CERTIFIED EXPERT

Commented:
I checked my test machine:
Go to Server Admin (the console with traffic lights)
Click Admin/Configuration.  Click the Database Engine tab.  Set as required (default 30 days) and check the 'submit prune job' option.  click ok.
A DB prune job is now created (or modified if already exists)

Author

Commented:
Hi All,

I didnt try the dbcheck command yet, do you think uninstall and reinstall ARCserve in server can solved my problem?

And also delete the ARCserve folder in C Drive.

Please advice.

Tut404

Commented:
If All of the above solutions provided fail  only then  you can give a try by reinstalling arcserve

Reps
CERTIFIED EXPERT

Commented:
RE-install seems a bit drastic and won't provide you with a reason WHY it's failed, so if it happens again you're none the wiser.

Seems to me the problem is almost certainly the database - either there's a permissioning issue; one or more of the databases are full; or, the database is corrupt.

Following each of the points in previous posts should allow you to determine which this is.
eg - if there's a permissioning issue, the service probably wouldn't start.
if DB is full, run the prune and defrag will fix
if DB is corrupt, DBcheck will tell you and DBfix will fix it.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.