Dear Eric

Thanks for the clue regarding queries.

I have just looked at the default set of queries I use 
(examples/sample-query.sql) and noticed statements like

# 5
:List all backups for a Client
*Enter Client Name:
SELECT DISTINCT Job.JobId as JobId,Client.Name as Client,
   FileSet.FileSet AS FileSet,Level,StartTime,
   JobFiles,JobBytes,VolumeName
 FROM Client,Job,JobMedia,Media,FileSet
 WHERE Client.Name='%1'
 AND Client.ClientId=Job.ClientId AND Job.Type='B'
 AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId
 AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId
 ORDER BY Job.StartTime;


Note the Job.JobStatus='T'  - need to change to (T,W) as you said.

I retract the that there is a problem with Bacula and warnings - it is 
the query !!

Sorry
Stephen Carr

Eric Bollengier wrote:
> Hello,
>
> On 23/01/2012 11:37, Stephen G Carr wrote:
>> Dear Eric
>>
>> I sent a later email and for got to add "Update" to the subject - the
>> migration of jobs with warnings do migrate to tape.
>>
>> I am using the "standard" queries - will look at the syntax but why is a
>> job shown in a Volume with warnings but not "visible" when querying the
>> client?
>
> Sorry, I don't understand where jobs are not visible, we might have a 
> display problem somewhere like in Bat or Bweb, but the core code 
> should handle everything properly.
>
> Bye
>
>
>> Thanks
>> Stephen Carr
>>
>> Eric Bollengier wrote:
>>> Hello Stephen,
>>>
>>> On 23/01/2012 09:08, Stephen G Carr wrote:
>>>
>>>> Dear All
>>>>
>>>> Have anyone had similar problems with 5.2.4 with backup warnings - the
>>>> MAJOR problem seems that the Backup is NOT added to the catalog and 
>>>> as I
>>>> backup clients to disc and migrate full backups to tape I suspect 
>>>> these
>>>> jobs will not be migrated - the jobs migration jobs run tonight.
>>>>
>>>
>>> I would be nice to not just "suspect" when you are reporting a 
>>> potential
>>> problem such as this one. Did you try to migrate new jobs? Did you get
>>> any problem related to Bacula?
>>>
>>>
>>>> I have reverted to 5.2.3 and reran the Full backups of those clients
>>>> with warnings.
>>>>
>>>> I accept there will be "dodgy" files on Windows clients but would 
>>>> prefer
>>>> the backup to treated as a valid backup with respect to adding it 
>>>> to the
>>>> Catalog and as a job valid for migration.
>>>>
>>>
>>> The Warning job status is treated like the Ok status. Unless you are
>>> writing your own queries to migrate jobs, you shouldn't have problems.
>>> So, if you are using a custom query, you can just replace JobStatus =
>>> 'T' by JobStatus IN ('T', 'W') as we did in other part of Bacula.
>>>
>>> Bye
>>>
>>>
>>
>> -- 
>> Stephen Carr
>> Computing Officer
>> School of Civil and Environmental Engineering
>> The University of Adelaide
>> Tel +618-8303-4313
>> Fax +618-8303-4359
>> Emailsgcarr AT civeng.adelaide.edu DOT au
>>
>> CRICOS Provider Number 00123M
>> -----------------------------------------------------------
>> This email message is intended only for the addressee(s)and
>> contains information that may be confidential and/or copyright.
>> If you are not the intended recipient please notify the sender
>> by reply email and immediately delete this email. Use, disclosure
>> or reproduction of this email by anyone other than the intended 
>> recipient(s) is strictly prohibited. No representation is made
>> that this email or any attachments are free of viruses. Virus
>> scanning is recommended and is the responsibility of the recipient.
>>
>
>

-- 
Stephen Carr
Computing Officer
School of Civil and Environmental Engineering
The University of Adelaide
Tel +618-8303-4313
Fax +618-8303-4359
Email sgcarr AT civeng.adelaide.edu DOT au

CRICOS Provider Number 00123M
-----------------------------------------------------------
This email message is intended only for the addressee(s)and 
contains information that may be confidential and/or copyright.
If you are not the intended recipient please notify the sender 
by reply email and immediately delete this email. Use, disclosure
or reproduction of this email by anyone other than the intended recipient(s) is 
strictly prohibited. No representation is made 
that this email or any attachments are free of viruses. Virus 
scanning is recommended and is the responsibility of the recipient.


------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users