I have a lookup field on the OIM 11.1.1.5.0 create user page. The create user form was working fine and I was able to create users properly. However since today morning, suddenly I am getting a strange error whenever I click on the lookup field to select any value. The query for lookup has not been changed. Its the same as before. But this error keeps popping up on UI directly and then am not able to do anything unless I restart the browser.

The error is as follows:

ADF_FACES-60096:Server Exception during PPR, #8[[javax.el.ELException: java.lang.AbstractMethodError: prepareWhereClause
Caused by: java.lang.AbstractMethodError: prepareWhereClause
Can some one please help me out with this? The only change that I remember was I had changed OIMServer.jar file with another version but I have re-stored the original file which I had a backup of. But it still throws this error.Thanks,$id

error may occurs because your JDBC driver implements an older version of the JDBC API than the one included in your JRE.
As you said you have restored the proper version of OIMServer.jar. Make sure you have deleted the other OIMServer.jar from the file system.

Stop all the server including Admin/Weblogic server and then remove other OIMServer.jar from the file system if exist. now place the proper jar start all servers.

If not. just recall if you have changed any other jar. if so revert back those.

The error is still persisting. I created a new OIMServer.jar file having a few custom error messages which are invoked in my event handlers. I deleted the old OIMServer.jar file from the oim.ear folder in ORACLE_HOME/server/apps directory and placed my new file here. I have kept a backup of that old deleted file on another folder in the file system. I then restarted everything just like you said. Now whenever those particular validations fail, I get the error message that I have put in the new OIMServer.jar file meaning that this file has been picked properly. However the error above still occurs whenever I click on the user defined lookup field and click on Search button. I have cross checked the lookup query to ensure that it is proper by running it on the database as well. I am at a loss to understand the error now. Please guide me.

I increased the log level of the oracle.adfinternal to TRACE-32. I can see the following additional things in the logs after the 60096 exception that arises when I click on the Search button in the user role field:

I am not sure if the line in bold saying cannot find resource global.Lookup.UserRole is the root cause or not. But if it is, then any idea what might be causing it? Can it be related to the OIMServer.jar replacement I had done earlier?

I had overcome the previous error by replacing the OIMServer.jar file with an old backup. I migrated all the attributes from that environment to a new one and now I am again getting the error on the same field in the new environment. Can you please look into the below error and suggest how to overcome this one? I am not able to find much about this error seeing as it is a ADF Faces error to begin with. Please help me with this.

Error on UI console when I click on the Lookup UserRole in the Create User form and click on Search button:

java.lang.NoSuchMethodError: oracle/iam/platform/utils/lookup/plugin/CustomizableLookupQuery.prepareWhereClause(Loracle/iam/platform/utils/lookup/vo/AbstractLookupQueryVO;Ljava/util/ArrayList;Ljava/util/ArrayList;Ljava/util/ArrayList;)Ljava/lang/String;ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #4