F986113 Missing Records

magpie

Active Member
I've been able to query F986113 in Access and in the SQL Query Analyzer. The problem is, the most recent records that show up are from October, 2007, and back.

When I'm in 'View Subsystem Jobs/Records', I see many records from the last several days and months.

Can anyone tell me why these records aren't showing up in F986113, which I'm viewing through the server map data source (SVM810)?

Thanks, Maggie
 
Maggie,

I would check to make sure the datasource you are using in SQL QA is the same one that View Subsystem Jobs/Records is using. There can be a F986113 table for the System datasource and each Server Map. You should be able to verify that via OCM.

Hope that helps,
 
Hi Maggie,

Adding to what John said , you could also just get a debug log and get the exact query used when doing the find from the application screen. That will help you confirm if you are querying the right schema on the back end. You should be able to run the same query it self obtained from the debug log
 
Back
Top