ocum 7.2p1 custom report import failure

[DevoidB]

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!

[Ontapforrum]

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!

[DevoidB]

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. 

[Ontapforrum]

I agree. Thanks!