Most CA SDM daemons and executables maintain a cache in dynamic memory of database records. This cache improves performance by eliminating the need to access the database when the required data is already available. CA SDM executables notify each other of database updates, so that the cache can always be kept up-to-date. However, there is no notification of updates from external utilities, such as pdm_userload, or third party database utilities. If new data is loaded into the database from one of these external sources, it is necessary to use the pdm_cache_refresh utility with the following syntax:
pdm_cache_refresh -t tablename
Keep in mind that the tablename is case sensitive. The table names are documented in the "Data Element Dictionary" part of the documentation.
pdm_cache_refresh -t call_req
Cannot get ddict col entry for 'id'
pdm_cache_refresh -t Call_Req