This documentation supports the 18.08 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Database table verification

The database consistency checker verifies the following tables during server cache initialization:

Database tables that are checked

Table name Information reported
group_cache
  • Issue a warning if no groups are defined or if there is no administrator group
  • Flag any duplicated group ID that does not have the same group type as its duplicate. If the group ID also has the same group type then it is legal and the server shows multiple names for the same group. If group types differ, the server ignores the second group definition.
  • Verify that all values in the group_cache table are within the legal limits. For example, there are no group types that the system does not recognize.
arschema
  • Verify that all values in the arschema table are within legal limits.
  • Report any broken safeguards, if possible.
  • Report database operation failures.

Important:

The numFields column on the on arschema table is not in use. Do not delete the numFields column.

schema_group_ids
  • Warn about any schemas with no group lists.
  • Warn about any schemas with groups not in the group list.
  • Verify that all values in the schema_group_ids table are within legal limits.
  • Warn if a schema ID in the table does not correspond to an existing schema.
subadmin_group
  • Verify that all values in the subadmin_group table are within legal limits.
  • Warn if any schema ID in the table doesn't correspond to an existing schema.
schema_list_fields
  • Verify that all fields in the schema_list_fields table are valid.
schema_sort
  • Warn if a field in the schema_sort table is not in the list of fields retrieved by GetListEntry for the schema (in other words, verify that the value exists in the schema_list_fields table).
schema_index
  • Verify that all indexed fields for a schema exist.
schema_archive
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that all archived schema IDs exist.
schema_audit
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that all audited schema IDs exist.
schema_join
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that all schema IDs exist.
  • Verify that join members A and B exist.
schema_view
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that all schema IDs exist.
schema_vendor
  • Verify that all schema IDs exist.
schema_vui
  • Verify that all schema IDs exist.
  • Validate total number of VUIs defined for a schema against the numVuis defined in the arschema table for that schema.
field
  • Verify that all schema IDs exist.
  • Verify that the field count in the arschema table matches with number of fields for a schema in the field table.
join_mapping view_mapping vendor_mapping
  • Verify that the schemaIds and fieldIds referenced in the join_mapping, view_mapping, and vendor_mapping tables are legal.
field_int, field_real, field_char, field_diary, field_enum, field_enum_values, field_attach, field_dec, field_curr, field_table, field_column, field_view, field_display, and field_date
  • Verify that the schemaIds and fieldIds referenced in these tables are legal.
  • Verify qualifier values in the queryShort/queryLong.
field_dispprop
  • Verify that schemaIds and fieldIds in the field_dispprop table are legal.
arcontainer
  • Verify that the safeguards in the arcontainer table are legal.
arctr_group_IDs
  • Verify that the containerIds in the arctr_group_IDs table are legal.
arctr_subadmin
  • Verify that the containerIds in the arctr_subadmin table are legal.
cntnr_ownr_obj
  • Verify that the containerIds in the cntnr_ownr_obj table are legal.
arreference arcontainer
  • Verify that the containerIds in the arreference and arcontainer tables are legal.
filter_set, filter_push, filter_sql, filter_call, filter_serviceaction
  • Verify values in the queryShort/queryLong.
filter
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that safeguards in the filter table are legal.
filter_mapping
  • Verify that schemaIds referenced in the filter_mapping table are legal.
escalation
  • Verify that all values in the escalation table are within legal limits.
  • Verify qualifier values in the queryShort/queryLong.
  • Verify that safeguards in the escalation table are legal.
escal_mapping
  • Verify that all values in the escal_mapping table are within legal limits.
  • Verify that schemaIds referenced in the escal_mapping table are legal.
actlink
  • Verify qualifier values in the queryShort/queryLong.
actlink_mapping
  • Verify that schemaIds referenced in actlink_mapping tables are legal.
arreference arref_group_IDs
  • Verify that all values in the arreference and arref_group_IDs tables are within legal limits.
field_permissions
  • Verify that the schemaIds and fieldIds referenced in the field_permissions table are legal.
Was this page helpful? Yes No Submitting... Thank you

Comments