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?
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.
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.