OOTB Update PCP and Find Provider not returning search results
Hello! I have installed Pega731 and the frameworks to support Pega Customer Service for Healthcare v731. In the Interaction Portal, I try to search for a PCP - either by Update PCP or Find Provider, I get the response - No results found. Please revise your search. In the log file, this is what I see:
You need to go back to the stack trace (you only show the top) that starts like this:
com.pega.pegarules.pub.runtime.LibraryFunctionNotFoundException: Failed to find instance 'GetGeoCoordinates--(String)' of type Rule-Utility-Function defined in 'google_geocodes'
The problem is not that the RUF GetGeoCoordinates is missing -- the problem is that it was missing AT THE TIME THAT THE CALLING RULE (which you don't show) was being compiled. Once a rule gets compiled with an RUF error in it, that rule does not get recompiled just because the RUF then exists. The error is actually then physically and permanently present in the compiled code. You need to force recompilation of whatever the calling rule is.
If it is a rule you own in a non-locked ruleset, you can just call revalidateAndSave on the calling rule.
If not a rule you own, you can go to the SMA tool and look for the calling rule in the VTABLE (under advanced). You'll need to open the XML of the calling rule to figure out the key for this VTable utility, but, once you do, you can then delete the compiled Java, first from memory, then from the database. After you do this, the next reference will generate a successful recompilation. (Certain I/O rules like sections and harnesses are not in the VTABLE, but chances are the rule of interest is not one of these exceptions.) Remember that in a multi-node system, the VTable utility operates on only one node at a time.
Hello! On the SR, I was working with this ID - FetchProvidersUsingES. I have attached the stack trace and the VTable options in the SMA. What cache tables need to be truncated (or rows deleted)? Am I on the right track? Also, I have attached the screen prints from the SMA.