Upgraded to 7.2.02 and working query now fails

This is for open discussion of APTARE StorageConsole Backup Manager

Upgraded to 7.2.02 and working query now fails

Postby gguenthe » Tue Feb 23, 2010 3:34 pm

SELECT nj.start_date,nj.policy_name,f.pathname,nj.kilobytes/1024/1024,nbr_of_files
FROM APT_V_NBU_JOB_DETAIL nj, APT_V_NBU_JOB_FILE f, APT_V_SERVER ns
WHERE nj.job_id=f.job_id
AND nj.policy_name like '%some_policy_name%'
AND nj.client_id=ns.server_id
AND nj.start_date >= sysdate -1
AND nj.summary_status is not null
order by nj.policy_name,nj.start_date

It used to work with no issues and now it returns 0 rows after the application was upgraded from 7.2.02.
gguenthe
 
Posts: 4
Joined: Fri Feb 27, 2009 3:59 pm

Re: Upgraded to 7.2.02 and working query now fails

Postby will » Tue Mar 02, 2010 9:02 pm

Do the normal reports like "Job Summary" show current backup jobs? The problem may be that the agent was not upgraded successfully and isn't reporting any new data to the portal.
will
 
Posts: 40
Joined: Fri May 16, 2008 10:07 am


Return to Backup Manager Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron