Hi,

We are storing the information of user who run the report from our system in a focus table. Later, we will write a adhoc report against that focus table to generate a report monthly to get the user list.

We have issue with the adhoc report as it's not pulling the record after Apr 2009. The focus table seems like adding the record but the adhoc report not picking it up. My question is, is there any limitation of focus table size? Is that the cause for this issue?

Please let me know.

Thanks

This message has been edited. Last edited by: Kerry,

Hard to tell from the little you posted. Some things to start with:

Are you using SU? (You should) Is the SU 'machine' always up?

Use REBUILD to check the integrity of the Focus file.

What do ? FDT and ? FILE show for the file? -- Is the number of segmnt instances and segment pages reasonable looking.

Run a report to get the distribution of requst-entries by date. Any suspicious-looking spikes? Are recods stored with a blank/zero dat? If it cuts off at a particular date-value, see what changed around that date.

Are you sure that the Modify that updates the Focus file is MATCH'ing and INCLUDE'ing on the appropriate kays and with appropriate date infomation? (Or is it a Maintain?)

Are you sure it is updating the correct copy? -- check the USE.

Something else to check: Are you sure that the dates are in the correct format, both in the file and being passed by the adhoc request?

Another thing to check is that you are USE ing the correct file. Do you have more than one copy and if so are you updating the one that you think you are updating?

T

Like Tony said "that you are USE ing the correct file..." There could be another file by the same name in your APP PATH

Keep in mind that, if you do put the focus database under the control the of the SU, a license for the SU/Database Server is required.