Comprehensive data protection for all workloads
Post Reply
chriswu
Novice
Posts: 6
Liked: never
Joined: Jan 20, 2012 9:32 am
Full Name: Christopher Wu
Contact:

Jobs missing

Post by chriswu »

Hi Guys,

Not sure why but all of a sudden all my jobs have gone missing in the job section.

I have got lots of backup and replication jobs and i'm not sure why they have all gone missing all of a sudden.

Has anyone ever experienced this or knows how to fix this?
foggy
Veeam Software
Posts: 21137
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Jobs missing

Post by foggy »

Christopher, what about SQL DB connectivity, could you verify whether it is available?
chriswu
Novice
Posts: 6
Liked: never
Joined: Jan 20, 2012 9:32 am
Full Name: Christopher Wu
Contact:

Re: Jobs missing

Post by chriswu »

Hi, it looks to be ok i don't see any issues with connectivity. The service is up.

What do you recommend? I find it strange that its suddenly gone missing...........and it is very worrying aswell
tsightler
VP, Product Management
Posts: 6034
Liked: 2859 times
Joined: Jun 05, 2009 12:57 pm
Full Name: Tom Sightler
Contact:

Re: Jobs missing

Post by tsightler »

Perhaps obvious, but my recommendation is to open a support case for investigation.
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Jobs missing

Post by Gostev »

May be the SQL server was rolled to an earlier point in time?
davehux
Novice
Posts: 5
Liked: never
Joined: May 19, 2011 9:24 am
Contact:

Re: Jobs missing

Post by davehux »

This has happened to me twice now. I am on 6.0.0.181 (64bit)

It's when I've gone into 'Jobs' to check the progress of a slow running (intensive) job. The jobs can be there one moment, and gone the next. There is never a problem when going into Jobs when the server is idle, but once they've gone, they don't come back, even after rebooting the server.

Recreating the job and mapping the backup location gives the 'This location is already in use by xxxxxxx job...'
Vitaliy S.
VP, Product Management
Posts: 27364
Liked: 2794 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Jobs missing

Post by Vitaliy S. »

Hi Dave, do you have a support case opened for that?
davehux
Novice
Posts: 5
Liked: never
Joined: May 19, 2011 9:24 am
Contact:

Re: Jobs missing

Post by davehux »

No - I was looking on here first, just to see if it was a known problem, before logging a call
ZachW
Enthusiast
Posts: 68
Liked: 10 times
Joined: Aug 02, 2011 6:09 pm
Full Name: Zach Weed
Contact:

Re: Jobs missing

Post by ZachW »

Please create a ticket so that support can get you squared away.
davehux
Novice
Posts: 5
Liked: never
Joined: May 19, 2011 9:24 am
Contact:

Re: Jobs missing

Post by davehux »

Ticket logged - 5179126
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Jobs missing

Post by Gostev »

There is a known UI bug that after certain sequence of actions, all backup jobs may start showing as SureBackup jobs instead. So, they do not actually disappear, but are just displayed incorrectly. Our support has a script that fixes this issue. I should probably include this in the Known Issues topic.
ChrisL
Enthusiast
Posts: 47
Liked: 6 times
Joined: Mar 21, 2011 12:04 pm
Full Name: Chris Leader
Contact:

Re: Jobs missing

Post by ChrisL »

Had this myself just the other day, most of the jobs simply disappeared from the list for no good reason. I say 'most' as I did have two old jobs that I've disabled but not yet deleted, for recently decommissioned VMs, and these jobs remained in the list while the active scheduled jobs had disappeared.

Quick phonecall to Veeam to open a ticket, and a few minutes later (thanks to Zach) had a Powershell script to run to reset the jobs back from SureBackup jobs to normal backup jobs. All back now and running happily again.

Interesting to hear from Gostev that this is a known bug after running a 'certain sequence of actions'. I'm wondering now what I did to do this, as far as I know I've not used the UI for some time but maybe one of my colleages was poking around in my absence.

Also a little curious why the two unscheduled jobs remained in the list.
ISExpress
Influencer
Posts: 16
Liked: never
Joined: Jun 27, 2011 1:50 pm
Full Name: ISExpress
Contact:

Re: Jobs missing

Post by ISExpress »

Hi

We seem to be having the same issue as well. We also just updated to the latest service pack (SP3) last week.

Logged with Veeam so we'll see what they come back with.

Checked our SQL server and the reporting shows the jobs are still in there and the SQL has an active connection to our Veeam box.

Possibly related to the bug that was mentioned??
framar
Lurker
Posts: 1
Liked: never
Joined: Mar 30, 2012 3:57 pm
Contact:

Re: Jobs missing

Post by framar »

I've encountered the same problem. All my jobs moved to Surebackup jobs and i can't do anything with them. Can i have the powershell script people are talking about?

Thank you.
foggy
Veeam Software
Posts: 21137
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Jobs missing

Post by foggy »

Please open a support case to get the fix, as explained above.
BHickok
Lurker
Posts: 1
Liked: never
Joined: Dec 30, 2011 3:03 pm
Full Name: Bob Hickok
Contact:

Re: Jobs missing

Post by BHickok »

I have the same issue. All jobs moved to SureBackups, appear corrupt if I try to open their properties as they are. Just installed the latest Veeam v6 SP about 2 weeks ago.
Right in the last few days of tax season, so dozens of workers at 24/7 so not the best time to have backups and replication cease. Hoping the PowerShell script you describe will get it all fixed quickly and easily.
clarkus978
Lurker
Posts: 1
Liked: never
Joined: May 08, 2012 9:57 pm
Full Name: Clark Edwards
Contact:

All Backup/Replica Jobs Removed

Post by clarkus978 »

[merged]

This is the second time this has occurred...

The jobs will run fine for months, but today I opened Veeam to make a configuration change...all the jobs go missing. Last time this happened I recreated all of the jobs, but I don't want this to happen for a third time.

If I look under backups, all of my jobs are still there and it shows the creation time, etc. It shows the same for my Replica jobs under Replicas.

Where are my jobs going? Is there a way to re-import them? Can I create a new job and point it to the backup/replication files?

Thank you
Platform1
Influencer
Posts: 13
Liked: never
Joined: Jul 19, 2011 12:14 pm
Full Name: Scott Cooney
Contact:

Re: Jobs missing

Post by Platform1 »

Has this been added to the sticky 'known issues' thread yet? It's happened to us twice on different backup servers and Veeam CS have informed us it is a bug due to be fixed in the next patch. I'd be interested to know when that's coming out?

The solution which worked was provided by customer service, is as follows:

1. Make a backup of Veeam DB
2. Stop all Veeam services, open MS SQL Management Studio and execute this script against the Veeam DB:

Code: Select all

GO
IF OBJECT_ID ('SbJobTR', 'TR') IS NOT NULL
   DROP TRIGGER SbJobTR;
GO
CREATE TRIGGER SbJobTR
ON [dbo].[BJobs]
FOR UPDATE AS
if exists(select * from BJobs, inserted, deleted where ((BJobs.id=inserted.id) AND (inserted.type = 3) AND (deleted.type <> 3)))
begin
   raiserror ('MUTATED TO SB JOB!', 16, 1)
   rollback
end
GO
Rerun the job to test.
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Jobs missing

Post by Gostev »

There will be no next patch, but next release only - sometimes within 1 month from now.
Tanako
Lurker
Posts: 1
Liked: never
Joined: Mar 13, 2012 10:09 am
Full Name: Tanako
Contact:

Re: Jobs missing

Post by Tanako »

Hi all. If someone have few jobs like me, I've solved the problem as follows:

1- Make a backup of Veeam DB
2- Open Veeam SQL DB with MS SQL Management Studio
3- Open dbo.BJobs table
4- Inside you will found the missed jobs. Set type field on 0
5- Yours jobs will apear at Veeam Jobs screen but you will need to reactivate "Run the job automatically" at the schedule tab and choose again the storage options
Sethbartlett
Veteran
Posts: 282
Liked: 26 times
Joined: Nov 10, 2010 6:51 pm
Full Name: Seth Bartlett
Contact:

Re: Jobs missing

Post by Sethbartlett »

There is also a powershell script that will correct the Job options from your job logs so you do not have to re-do your settings.
Skype: Sethbartlett88 - Make sure to label who you are and why you want to add me ;)
Twitter: @sethbartlett
If my post was helpful, please like it. Sometimes twitter is quicker to hit me up if you need me.
Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 109 guests