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