Error: java.lang.NullPointerException when running Where Used Advanced Search


We are running Agile v9.3.3.

We have a simple  advanced search

Items>Parts    Where-used All Levels Latest Released Revision Only

Number Contains….  value prompt

The search has worked fine for over a year, then last week started giving error java.lang.NullPointerException when a user enters any component part #.

We also cannot run the Where Used Report anymore.
I have an SR into Oracle and they advised fixing some averify errors and clearing the server cache and restarting services.  I did that and still we get the error.

Any ideas on what is causing this and how to fix?

Thank you,


Add Comment
1 Answer(s)

Laura, it is possible that something in the database has gotten corrupt. Have all saved searches stopped working, or just this one?  If just this one, you might simply try recreating it and saving it with a slightly different name. I also recommend that you use Number Equals rather than Number Contains, unless that just won’t work for your users.  It runs quite a bit faster if you do that.


Agile Talent Answered on October 26, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.