Previous page

Next page

Fixing core keys invalid errors

Invalid key errors use the error code COREFIELD. Invalid key errors generally occur if core keys are invalid in makeup tables.

This topic shows an example of an invalid core field and how to correct it.

Example

Audit log information:

Checking table 'CourseCourseResource'...

Executing rule 'Core fields valid'...

Found 1 violations for Core field CourseCode

Error code: [COREFIELD] - CourseCourseResourceID:1, CourseCode is NULL.

In this example, the Course Course Resources makeup table contains a record that does not have a Course Code.

To correct this problem:

  1. Navigate to the Course Course Resources makeup table.
  2. Customise columns and display the Course Course Resource ID column.

    In this example, the record with the Resource ID of "1" is invalid, so you must delete it.

  3. Delete the record from the makeup table in SQL Server Management Studio.

    Important: If unsure about deleting a record, please contact PayGlobal Support.

Topic: 33992