The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to register at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

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!

3 REPLIES 3

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!

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public