Hi @Technical Toby / @James Ashmore,Do you have any sort of an idea with this issue?I have done everything as mentioned in below community post,How can I use IFS Scan it App in IFS Cloud?Appreciate if you could help me on this.Best Regards,Hashan
Hi @James Ashmore,Yes, Server URL accessible from browser. from scan it app also it redirects to login page once I enter the credentials I do get this error.
We have this java lookup error in odata pod, tried restarting the pod as well. but there are no any error records in the log file with the time we try to login.{"type":"liberty_message","host":"ifsapp-odata-69c8d7cb86-bb7b7","ibm_userDir":"\/opt\/ifs\/wlp\/usr\/","ibm_serverName":"defaultServer","message":"2023-03-23 10:43:29.531 ERROR 500 f2cc9db3-1541-49da-9161-87ac33ab501d com.ifsworld.fnd.provider.processor.FndErrorProcessor.processError() : Error Stack : Error while Custom Java lookup.\ncom.ifsworld.fnd.common.exceptions.ODataProviderIllegalStateException: Error while Custom Java lookup.\n\tat com.ifsworld.fnd.storage.invoker.JavaOperationInvoker.invokeOperation(JavaOperationInvoker.java:130)\n\tat com.ifsworld.fnd.storage.invoker.JavaOperationInvoker.invoke(JavaOperationInvoker.java:84)\n\tat com.ifsworld.fnd.storage.invoker.JavaActionInvoker.invoke(JavaActionInvoker.java:30)\n\tat com.ifsworld.fnd.storage.invoker.BpaInvokerWrapper.invoke(BpaInvokerWrapper.java:166)\n\tat com.if
I was going to do the same, Thank you James Cheers,Hashan
Hi This is an environment issue. What’s the exact version and SU level? Has this environment upgraded recently? Looks to me as DB deployment has not performed correctly where Native side Java IMPL are missing or a issue in ODP. Also try to re start ODP and take full logs. IFS Cloud 22R2 SU4App version: 23.3.820.0recently upgraded from APP9we have restarted the Odata pod and as mentioned above java lookup error is there in Odata pod. But its not occured in a time we try to login.Could you please let me know where exactly I could check Native side java IMPL in DB?
Can you please send the Odata POD logs showing Java IMPL download history. We have native java libraries stored in the database. Could be they are missing? Did you see any warnings in the DB deployment side? Hi Kapila,we couldnt see any warnings from DB deployment side.Herewith I have attached connect, odata and native-server pods log files.we could find some timeout errors in native-server logRegards,Hashan
If you run the below SQL, Do you see two records? SELECT * FROM fnd_java_implementations_tab WHERE MODULE = 'FNDMOB' No return valuesthis could be the issue then
Yes, you have got an issue in the environment / delivery or upgrade process. Do you know how the server upgrade went? did all other areas working fine? Hi Kapila,As per your input we were able to narrow down the issue a bit.We checked the build home and found out MobileAttachments.jar and MobileClientRuntime.jar are not available in following paths of the build home.MobileAttachments.jar | path => buil_home/server/lob/fndmob/javaimpl/MobileAttachmentsMobileClientRuntime.jar | path => buil_home/server/lob/fndmob/javaimpl/MobileClientRuntimesimply FNDMOB folder is not there under the following path,buil_home/server/lob/I downloaded the build_home again from build place and files are not available in newly downloaded build_home as well.Customer recently upgraded to 22R2 from IFSAPP9FNDMOB enabled in solution set.
Did you try to re build the environment/ may be clean build. if those files are not available means module has not been compiled. Hi Kapila,Yes, We have to try re-build and see. Will keep you update.
Hi @Lakmal As we don’t get any software preinstalled with OVA we won’t have much apart from some new security features and network changes on Ubuntu level with new appliances. Therefore, my opinion is we don’t need to apply new virtual appliances. I would suggest you get it installed in a separate server and check ubuntu uname and all. Then you will have an idea of the difference between two OVA versions.Anyway you must update the bootstrap and bootstrap binaries. Rename the current ifsroot folder. ex: ifsroot_old Extract the two new zips of bootstrap and bootstrap binaries. Replace the old ifsroot/config folder over newly extracted ifsroot/config folder. Replace everything except for the ifsroot/config/main_config.json and ifsroot/config/main_config.json.template files. And you will have to manually update the main_config.json file matching with old one. Run the main.ps1 with new changes. Refer the Initialize & Install steps in Management Server - Documentation. Refer followi
Hi @Lakmal As we don’t get any software preinstalled with OVA we won’t have much apart from some new security features and network changes on Ubuntu level with new appliances. Therefore, my opinion is we don’t need to apply new virtual appliances. I would suggest you get it installed in a separate server and check ubuntu uname and all. Then you will have an idea of the difference between two OVA versions. .. Hi Hashan, Thank you for the reply. The documents are for the release 22R1 and hope they are applicable for 22R2. Is there any guideline from IFS on OVA replacement during service update? Best regards, Lakmal Yes, They are applicable for 22R2You can find brief guideline in following IFS document.Install Middle Tier Server
Hi @Ben Monroe,Yeah, I used hostname and it was working in other environments. As you mentioned when I change it to IP address of the DB server it worked. Do you hav any sort of an idea what cause this issue? or is it a bug with 23R1?Thank you very much for the support 😊Best Regards,Hashan
Thank you Ben. If I find anything I’ll update here.
Hi @subslk ,is it from keycloak>clients>IFS_aurena>Advanced Settings? Best Regards,HashanD
Hi @subslk ,Thank you for the update.
Hi @SASIUS,I also have the same issue. Have you found anything related to this error?
Hi Krishna,Have you found any solution for this?
Hi Artha,Which user credentials you entered when installing the PrintAgent Service?
Hi All,We has the similar error for a customer and was able to solve by increasing DB parameter “open_cursors”.When generating reports or print jobs it could open several cursors and there could be several SQL statements running as there are plenty of reports/prints that need to be generated at once. Hence I suspected this issue occurs when a cursor is open but not closed during loop execution. However, this can occur when a recursive method (where a cursor exists) call exists inside a loop as well.Check the current value,SELECT value FROM v$parameter WHERE name = 'open_cursors'; And increase the value to higher than existing one.ALTER SYSTEM SET open_cursors = <VALUE_HIGHER_THAN_EXISTING> SCOPE=BOTH;Best Regards,Hashan
@paguin Hi Pankaj,Have you found a solution for this? or have you already dispatched a case to IFS?Best Regards,Hashan
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
