cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

OpsCenter SQL query | An unknown exception has occurred

Hi All,

I am running below query to get SLP images pending for date wise for last 3 days

SQL Query:

select b.imageid,DATEFORMAT(cast(UTCBigintToNOMTime(a.writeStartTime) as DATETIME), 'yyyy-mm-dd') as "Write Time",b.copystate,b.copytype,cs.name CopyState,ut.name CopyType from domain_slpimage a
join domain_slpimagecopy b on a.id=b.imageid
JOIN lookup_CopyState CS ON CS.id = b.copystate
join lookup_StorageServiceUsageType ut on ut.id = b.copytype
where b.copytype in (1,3) and b.copystate in (1,2) and DATEDIFF(day,UTCBigIntToNomTime(a.writeStartTime), GETDATE()) <=3

Output.

imageidWrite TimecopystatecopytypeCopyStateCopyType
Image Name120/08/201611Not StartedDuplication
Image Name222/08/201611Not StartedDuplication

 

Same query is working fine for my DR server, but in primary am getting "An unknown exception has occurred".

Kindly help on this.

2 Replies
Highlighted

Re: OpsCenter SQL query | An unknown exception has occurred

Check your OpsCenter Versions between locations

Highlighted

Re: OpsCenter SQL query | An unknown exception has occurred

Both location has 7.7.2 version, 

Tags (1)