Hi @proharikg, This is by design. You cannot refresh Custom Objects cache from here. When you do certain operations such as publish or synchronize in custom fields, the caches will be refreshed automatically via application logic and the time is updated here. Ideally, the option to refresh it from here should be disabled to avoid any confusions. However, if you want to explicitly refresh Custom Objects cache due to some reason, you can do it by manually running following PL/SQL Block. BEGIN Install_Tem_SYS.Installation_Support('REFRESH_CUSTOMOBJECTS', NULL); END; This is the method IFS installer uses to refresh Custom Objects cache during delivery installations and reconfigurations. Hope this helps! Thank you so much Charith, regards,Hari
Hi @proharikg , As far as I know it is a design limitation but once you synchronize the custom objects, the database will be cleared and redeploy the custom fields. Then when you do the reload configuration, the necessary client caches will changed. Therefore, it won’t be an issue when adding a custom object. Thanks & best Regards, Wimali Thank you Wimali
Hi @proharikg, It depend on your environment settings and configurations you use. But in general terms I would recommend below points to check before and after the refresh whether it has the same parameters. batch queue configuration delivery differences (installed Components window) system parameters, plsqlap environment tab & IFS Connect Configurations License Management window information Connect server’s listener port (Setup IFS Connect window) database backup method configuration and archive logs parameters undo tablespace names oracle directory names and paths These are the basic which came to my mind to be verified after the database refresh and this is what we follow as a standard as well. But there's a catch if you are using customized tables and information on the environment those need to be verified as well. Hope this clears your question! If this comment satisfies you please mark it as the best answer so others will also get benefited from this post. Hi Ragav,
Hi Akshaya,Not sure for the version you refer in screenshot.Please check if below highlighted is checked in.IFS APPS 10+UPD8 Best Regards,Hari
Hi @proharikg, It is most likely that enough heap memory is not allocated to the Integration Server, although this might not be the case all the time. However, if the report is fetching a huge amount of data, heap space errors could be thrown if there isn’t enough memory allocated. The best way to investigate this would be to a obtain a heap dump when the error occurs and analyze it to find out if there really is a problem with the allocated memory or if there is any other problem leading to this. Once that is done, you can increase the heap memory or take any other necessary corrective action. If you need to increase the heap size, you can do it from IFS MWS Admin Console in IFSAPP10 Hope this helps! Thank you Charith
Hi @chajash ,It is possible through quick report (need to use ‘UNION ALL’ and ‘WITH’ clause). I have done that before and it was working. WITH T AS (SELECT PROD_FAMILY, NO_of_Parts, Total_inv_value from view1) SELECT * FROM T UNION ALL SELECT SUM("Total_inv_value"),'TOTAL','' FROM T Best Regards,Hari
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.