E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne
(Doc ID 944015.1)
Last updated on MARCH 16, 2020
Applies to:JD Edwards EnterpriseOne Address Book - Version 9.0 to 9.0 [Release 9.0]
JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.0 to 9.0 [Release 9.0]
Information in this document applies to any platform.
The purpose of JD Edwards' JDB Database Caching is for Data Integrity/Coherency and Performance Improvement. Since cache is written to Memory (RAM) it yields better performance (avoiding round trips to database) and it is Shared Cache (read-only cache) coherency problems are easily avoided (so this may cause Dirty/Phantom Reads) for data which are requested frequently/repeatedly.
This document will briefly explain frequently asked questions from an end-user's point of view. This document explains server (as response for a certain request) and client (issuing request) based on HTML client configuration.
For cache information and troubleshooting the different scenarios, causes and resolutions for caching issues in Server Manager, refer to <Document 866662.1> - Cache Information And Troubleshooting Caching Issues In Server Manager.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Questions and Answers|
|Q1. What is Environment Cache and what tables belong to this cache?|
|Q2. When is the JDB Database Cache Loaded?|
|Q3. When is the JDB Database Cache Used?|
|Q4. What kind of information is cached in JAS (Java Application Server)?|
|Q5. What kind of information is cached in Logic Server (where BSFNs and UBEs run)?|
|Q6. Are any other tables cached on the Server other than for object cache?|
|Q7. Can a custom Service Cache and/or Database Cache be defined?|
|Q8. Where to find information on Database Caching and Service Cache?|
|Q9. Is there a full list of tables for Database Cache and Service Cache?|
|Q10. How to refresh/ reset/ flush Database Cache and Service Cache?|
|Q11. How does it make use of the caching data in programming?|
|Q12. What does "cache can not be updated" mean?|
|Q13. What is the impact on applications if you remove any table (Ex: F0008) from F98613 and not re-add it?|
|Q14. How to determine whether a certain application is making use of cache or not?|
|Q15. How to trace Cache Manager through logging?|
|Q16. Can database cache be reset/flushed when multiple users are connected to a data source you want to reset?|
|Q17. What kind of BSFN/API will cache tables?|
|Q18. Is it possible to cache a certain range of data (not the entire table) in calling CacheTableForUBE?|
|Q19. Is there a way to force subsystem process/jobs to pick up changes to UDCs that occurred since the subsystem UBE was first submitted?|
|Q20. What is the memory area name in JDE?|
|Q21. Which are other types of caches used? Other Industry caches.|
|Q22. Will the data in table Company Constant (F0010) be cached?|
|Q23. What are the common errors you may get that are caused by uncompleted Cache Refreshing which is related to data in F0010?|
|Q24. How to debug when the issue appears to be caused by data in F0010?|
|Q25. How does the system make use of runtime cache when submitting a UBE to the Server?|
|Q26. Unable to see changes to tables F0006 and F0901 listed in P98613 after they are updated. Is there any impact to these tables if they are removed from P98613?|
|Q27. What does the message "System cache is full" in the server JDE.LOG mean?|
|Q29. What is JSP Cache and how to clear JSP Cache?|
|Q30. Can both JDBj Service Cache in JAS and Database Cache in Logic Server can be flushed even when these connection has active users associated?|
|Q31. In Tools Release 8.9, How can we clear single Database Table Cache (Say for F0010) ?|