Sprezzatura FAQ Pages

You've asked the system to show you units for a learner or to print a report and it claims there are none there!

The most common cause of this is an indexing problem. To find the units for a learner the system doesn't trawl through all units on the system looking for those for a specific learner, rather it consults an index. If this index is out of date you won't get the information you require.

To fix this problem we must rebuild the index. To do this we choose AREV from the main menu, then DB Admin, then Indexes then Update.

This will display a popup with 6 choices. Choose 5 (rebuild index for one or more columns).

The Table Name is MODULE_STUDENTS so enter this and press . The system will now show you call indexes for the file. Choose the one that begins STUDENT_NO_AND_COURS and press return. This will highlight the line. Now press F9 and the index will rebuild, giving you an indication of progress on the status line. Note that the actual index name is STUDENT_NO_AND_COURSE_CODE_DATE but this is too big to display in full! This will take a short while (on our ultra fast machine here in the Sprezz office it takes over an hour so expect anything up to and over an hour!).

If this doesn't work then we may need to remove and readd the index, so remember the table name and index name and follow the link below on removing and readding an index. You will be removing and readding a BTREE index.

What is an index?

How do I remove and readd an index?

Jargon busters!

Click here to return to the main FAQs page