topic Re: ocum 7.2p1 custom report import failure in Active IQ Unified Manager Discussions

ocum 7.2p1 custom report import failure

DevoidB — Fri, 03 Jan 2020 15:26:54 GMT

Hello,

Currently having trouble importing a simple custom report to ocum and getting the error "

2020-01-02 12:03:31 [FATAL] [default task-8] [ReportRestApiHandler:142] - Illegal arguments passed.
java.util.regex.PatternSyntaxException: Illegal/unsupported escape sequence near index 5
.*C:\SnapshotReserveOverage_2020-01-02_12_03_31-454.*"

Here is the query:

select cluster.name as Cluster, svm.name as svm, volume.name as Volume, volume.percentageSnapshotReserveUsed as "snapshot %"
from cluster
join aggregate
on aggregate.clusterid = cluster.id
join volume
on volume.aggregateid = aggregate.id
join svm
on svm.id = volume.svmId
where volume.name not like '%vol%' and volume.name not like '%root%' and volume.volType not like 'dp'
order by volume.percentageSnapshotReserveUsed desc

I am not the best at sql however i didnt think I had any illegal characters in the query, especially on line 5 which is just "join volume"

Would anyone be able to tell me what I am missing?

Thanks!

Re: ocum 7.2p1 custom report import failure

Ontapforrum — Sat, 04 Jan 2020 21:25:09 GMT

Hi,

I have not used custom reporting so can't really help you out. However, in case you are stuck and you don't hear on it from anyone on the sql query error, then my advise would be to upgrade your OCUM to 7.3 or higher version. As 7.2 has reached end-of-verion support (31-Jul-2019), hence NetApp will not officially help troubleshoot the issue.

I think there are number of improvements in 7.3 onwards and once you are on 7.3 you can directly upgrade to 9.5.

Some reference material:
NetApp OnCommand Unified Manager Reporting for ONTAP
https://www.netapp.com/us/media/tr-4565.pdf
https://www.youtube.com/watch?v=IcyZbjcs-sE&t=3s

Thanks!

Re: ocum 7.2p1 custom report import failure

DevoidB — Mon, 06 Jan 2020 17:30:34 GMT

Thanks for your reply! We are in the process of upgrading this year. however I dont believe the issue is with the version but moreso my syntax as the error would suggest. I will most certainly give this another shot after we upgrade to a more recent version of OCUM but that wont be for some months.

Re: ocum 7.2p1 custom report import failure

Ontapforrum — Mon, 06 Jan 2020 18:13:15 GMT

I agree. Thanks!