Performance issue due to long running substitution variable
Document ID :
Last Modified Date :
Show Technical Document Details
CA Automic Applications Manager
Applications Manager uses the refresh thread for Substitution Variable resolution. This thread within the java RmiServer process is also responsible for:
Job refresh/status updates
Virtual day purge
If a subvar takes a long time to resolve, it can halt all the above processing until the subvar is resolved. This behavior can appear as if the master no longer processing any Jobs.
Below is an example from the RmiServer<timestamp>.log (debug enabled) showing a subvar taking almost 15 minutes to return (elapsed ms):
rfp0: .DBAccess: getSqlData(): sID-null OAE_UC4 query elapsed ms 846050 rows
Possible solutions are:
Avoid complicated sql in subvars
Move the sql within the subvar to a sql Job
Streamline the sql to return faster
Was this information helpful?