Tracking client caches
To track these calls on a client, turn on client-side API logging by setting the ARAPILOGGING environment variables prior to the startup of the AR System client. The output is captured in arapi.log files and can be generated from any AR System server C-API client (For more information, see Knowledge Base article ID 20009823).
Client-side logging ( ARAPILOGGING=24 ) not only shows that the VFC API was called and resulted in an EXP API call, but also shows why the EXP was called.
For example, it detects if the forms are out of date or if the user information is modified.
The following entries from a sample client-side log show a VFC call:
vfc
Home Page
1244591344
1244591344
1244591344
1244591344
ARValidateFormCache results
Return Code: OK
Form Last Changed: 1244585158
Number Active Links: 2
Number Changed Active Links: 0
Changed Menu List: (0)
Groups Last Changed: 1244585157
User Last Changed: 1244585218
Changed Guide List: (0)
Status List: 0 items
Start Time: 1244647616.159000 (Wed Jun 10 2009 08:26:56)
Finish Time: 1244647616.174000 (Wed Jun 10 2009 08:26:56)
Elapsed Time: 0.015000
Home Page
1244591344
1244591344
1244591344
1244591344
ARValidateFormCache results
Return Code: OK
Form Last Changed: 1244585158
Number Active Links: 2
Number Changed Active Links: 0
Changed Menu List: (0)
Groups Last Changed: 1244585157
User Last Changed: 1244585218
Changed Guide List: (0)
Status List: 0 items
Start Time: 1244647616.159000 (Wed Jun 10 2009 08:26:56)
Finish Time: 1244647616.174000 (Wed Jun 10 2009 08:26:56)
Elapsed Time: 0.015000
You can also examine the SQL log for instances of CREATE VIEW and ALTER TABLE.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*