Estimated reading: 7 minutes

Under [Admin]->[Tools]->[System] utilities for the administrationcan be started.

Temporary content

Refresh temporary field content

For performance reasons, the number of links or multiple selections of a record is temporarily stored as a numeric value. If there is a discrepancy, the values can be recalculated. (Example: The value displayed is ‘2 entries’ even though there are 3 links). Depending on the size of the database, this function can take some time.

Recalculate failed thumbnails

All documents and images used by Image Magick will get an error flag in the LIMBAS database if there is a problem with the conversion. Thereby preventing a renewed attempt to convert the file. You can reset the error flag, if you want to try and convert the files again (for example with a newer (or older) ImagMagick Version). The conversion will only take place when needed and when the respective file is used.

Delete temporary thumbnails

This function deletes all temporary stored thumbnails in the TEMP directory of LIMBAS. All image thumbnails will be recreated on demand.

Delete temporary text files

This function deletes all temporarily stored ‘Indexing Text’ files in the TEMP directory of LIMBAS. All ‘Indexing Text’ files will be recreated on demand.

Database functions

Check foreign keys for links

For data integrity, ‘Foreign Keys’ are created, for all links created in LIMBAS. If a ‘Foreign Key’ is missing (because it was deleted or not yet completely imported) it can be recreated. Only links created by LIMBAS are taken into account. This function can also be used to check the integrity of existing data.

Check indexing

All of the indexes required by the system are tested and rebuilt if necessary, including the indices for linked tables.

Check database procedures

All of the procedures required by the system are checked and created new if necessary. LIMBAS needs procedures, among other things, for the link calculations or the simulation of field types that are not supported by some databases. (z.B TIME & MSSQL)

Check LIMBAS Trigger

For the temporary field contents of links LIMBAS uses database triggers. These triggers can be regenerated if they malfunction or after an import. If the trigger function is not supported by the database, this functi

Check database sequences

All sequences required by the system are checked and rebuilt if necessary. Sequences are used for the assignment of unique IDs. A corresponding sequence table, which normally begins with 1, is created automatically after you create a table in LIMBAS. This function is useful after importing a table or in cases where the sequence table was not used to create an ID or not updated.

Rights Management

Refresh menu rights

All functions available in LIMBAS are managed through the table ‘LMB_ACTION’. When changes are made to this table or a new version of the table is imported (after a LIMBAS update) the function ‘Refresh Menu Rights’ updates the rights for all groups. All new functions will be added to the authorization system, but must be adjusted for each group depending on the need.

Refresh table and field rules

‘Table- and Field rules’ in LIMBAS are managed by system tables. These system tables can be very large depending on the application. When modifying tables, e.g. adding fields, it is possible to skip the update of these system tables for a faster performance. The ‘Table- and Field rules’ can be refreshed separately. This refresh is also needed after importing a new table. Without the corresponding ‘Table- and Field rules’ the new table would not be visible. All new tables or fields will be added to the ‘Table- and Field rules’, but must be adjusted for each group depending on the need.

Reset data record rights

For the selected table, all rights of the data record can be reset to zero. The rights can then be set by the administrator or ‘Super User’. A prerequisite is that the option ‘Data Rights’ is enabled for this table.

Recalculate data record rights

All rights of the data record can be recalculated for the selected table.

The group rights of the current user are used as a template. Prerequisite is that the option ‘data record rights’ is enabled for this table. Existing rights are not modified.

User settings

Synchronize folder structure

The folder ‘My documents’ exists by default for every LIMBAS User. This function checks that a folder ‘My documents’ exists for every user, and automatically creates it, if it is missing. It also checks for the presence of the necessary System folders for reports and table links.

Delete user settings

User’s individual settings for tables and links, or the File Manager are stored in LIMBAS system tables. When the original data schema changes, such as after the removal of a field, these settings can become inconsistent. This function resets all personal View Settings. These include:

  • group divisions (Record View /Edit)
  • Show fields in links (Record View /edit)
  • Show fields in file manager (File Manager list)

Match up snapshot tables

Snapshots of tables include, among others, the information regarding which fields of a table should be displayed. The snapshot should be saved anew if one or more fields are deleted or the rights removed. This function attempts to match all snapshots on the current field definitions and removes no longer existing fields from the snapshot.

Update.htaccess / ./htpasswd

A user specific file directory is created for each user registered in LIMBAS, where, for example, files or user-specific settings are stored. To prevent, external users or unauthorized LIMBAS users accessing these directories they are password protected. The access protection is implemented with.htaccess/.htpasswd-files in the user directories. These files must be adjusted when the folder structure is changed. This function rewrites all .htaccess files. This is useful when moving the LIMBAS installation to a different path or with other access issues. If the environment variable ‘clear_password’ is set, this will also reset the password. Otherwise the password of a user has to be updated (saved new) in the user administration of LIMBAS.

Delete all sessions

Deletes all current ‘PHP Sessions’ of LIMBAS. Useful if changes to the system are made which should be immediately accessible to all active users.

Deactivate all users

Deactivates all existing users except the Super admin (user ID 1). If users currently logged-on to LIMBAS need to be blocked, the session must be deleted also. (see ‘Deleting all sessions). A message can be displayed after login, to inform the user about the reason for the locked system.


Rebuild file system tables

The LIMBAS file system consists of the tables LDMS_FILES, LDMS_META and LDMS_STRUCTURE. This ‘Rebuild file system tables’ function deletes the entire folder structure and all file metadata and attempts to restore the original state. Files in the folder ‘UPLOAD’ will not be deleted but they can no longer be addressed with their original name. This can be used, for example, for a reset of the DMS system after a cloning of an instance of LIMBAS.

Rebuild workflow tables

As well as the file system the workflow system tables can be recreated. This deletes all existing workflows and workflow information.

Reset Database