State Reporting

Book Creator
Add this page to your book

Book Creator
Remove this page from your book

The Level 1 Errors tab is used to view and print a listing of selected errors that occurred in various domains/entities when the API interface files begin processing into the TEA database.

NOTE: ASCENDER does not control the content of these errors as they are standard API Response Codes. A full list of codes can be found on API Response Codes.

View and print errors:

A list of domains and entities is displayed along with the number of errors associated.

Select ❏ next to the domains (rows) to be included in the report. If multiple domains are selected, the report prints in dependency order (Domain > Entity), which is the same order used in the Ed-Fi error log.

Field	Description
Domain	Displays the Ed-Fi domain name where the error(s) occurred (e.g. Education Organization).
Entity	Displays the entity within the Ed-Fi domain where the error(s) occurred (e.g. LocalEducationAgency).
Number of Errors	Displays the number of errors that occurred within the entity.

❏ Click Print. The report is displayed with the error details as reported by TEA. The report includes key details for each entity within the domain; however, some endpoints may or may not be populated depending on the error (for example, if a domain fails the endpoints depending on that domain will not populate).

NOTE: If included in the report, the Action Type column displays the expected action of the record that was sent to the Operational Data Store (ODS):

I - Insert
U - Update
D - Delete

TSDS Level 1 Errors Guidance

Application Programming Interface (API) Error Response Codes

API Error Response Codes Guidance

API Error Response Codes Guidance

HTTP Code	Example Message	How to Fix
400	Validation of 'RESOURCE' failed. FIELD is required.	An element of the JSON that is required is missing and needs to be added. Required fields are marked with '*' in swagger https://api.ed-fi.org/v6.1/docs/swagger/index.html?urls.primaryName=Resources
400	'RESOURCE' failed. 'RESOURCE' reference could not be resolved.	A resource that was referenced from an entity does not yet exist: load the dependency resource first. See https://techdocs.ed-fi.org/display/ODSAPIS3V61/Resource+Dependency+Order
401	Unauthorized	Unauthorized. The request requires authentication. The OAuth bearer token was either not provided or is invalid/expired.
403	Authorization denied. The claim does not have any established relationships with the requested resource	Likely Causes: 1. Your API credentials are not associated with the proper EducationOrganization or Namespace. See information under the section of this guide on “Authorization”. 2. The API cannot tie the resource you are creating or updating to a “root” entity for which you are authorized. For example, you may be trying to update a Student, but if that student is not enrolled (via StudentSchoolAssociation) the request will fail, as the API cannot determine that your client is authorized. 3. When the record is person-based (e.g., Attendance, Grades, Section Associations), it usually means the Student, Staff, or Parent record is not in the ODS so the records being sent for that person cannot be created.
409	A natural key conflict occurred when attempting to create a new resource 'RESOURCE' with a duplicate key.	The Ed-Fi API has a natural key system alongside a standard REST ID system. This error is often protecting against the erroneous creation of a duplicate record in the API. Unique Key Violation, referential errors: particularly anything that doesn't involve people or EdOrgs.
409	The resource (or a subordinate entity of the resource) cannot be deleted because it is a dependency of the 'RESOURCE' entity	The resource that the application is attempting to delete is referenced from another entity. Delete the other dependent entity first.

TSDS Level 1 Errors

TSDS Level 1 Errors - Load Order

Load Order

Domain Name	Resource/Entity
Education Organization Domain	EducationServiceCenter LocalEducationAgency School SSAOrgAssociationExt(TX)
Student Identification and Demographics Domain	Parent Student StudentParentAssociation
School Calendar Domain	Calendar CalendarDate Session
Staff Domain	Staff StaffEducationOrganizationAssignmentAssociation StaffEducationOrganizationEmploymentAssociation StaffSchoolAssociation
Enrollment Domain	StudentSchoolAssociation StudentEducationOrganizationAssociation StudentEducationOrganizationResponsibilityAssociation
Restraint Event Domain Entity	RestraintEventExtension
Finance Domain	ActualExt BudgetExt PayrollExt SharedServiceArrangementExt
Discipline Domain	Disciplinelncident StudentDisciplinelncidentAssociation DisciplineAction
Student Application Domain	StudentApplication
Teaching and Learning Domain	CourseOffering Section StaffSectionAssociation StudentSectionAssociation
Student Academic Record Domain	CourseTranscript StudentAcademicRecord
Alternative and Supplemental Services Domain	Program StudentCTEProgramAssociation StudentLanguageInstructionProgramAssociation StudentSpecialEducationProgramAssociation StudentTitleIPartAProgramAssociation
Prior Year Leaver Domain	PriorYearLeaver PriorYearLeaverParents PriorYearLeaverStudentParentAssociation
Assessment Domain	Assessment Student Assessment
Student Cohort	Cohort StaffCohortAssociation StudentCohortAssociation

TSDS Level 1 Errors - Education Organization Domain

Education Organization Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'School' failed.\n\tSchoolGradeLevels requires at least one object in the collection.\n.”}	Check Low and High Grade Level.
409 CONFLICT {message: “A natural key conflict occurred when attempting to create a new resource 'EducationOrganization' with a duplicate key”}	Verify the value entered in the ESC County District Number field is the district number for the ESC, not the district number for the LEA.
409 CONFLICT {message: “The value supplied for the related 'educationServiceCenter' resource does not exist.”}	Verify the value entered in the ESC County District Number field is the district number for the ESC, not the district number for the LEA.

TSDS Level 1 Errors - School Calendar Domain

School Calendar Domain

Error Message	Issue
409 CONFLICT {message: “The value supplied for the related 'calendar' resource does not exist.”}	Calendar date does not associate with a calendar.
400 BAD_REQUEST {message: “Validation of 'CalendarDate' failed. Validation of 'Extensions' failed. CalendarDateExtension (TX): The field SchoolDayOperationalMinutes must be between 0 and 600.”}	Review Calendar Operational Minutes.

TSDS Level 1 Errors - Student Identification and Demographics Domain

Student Identification and Demographics Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'Parent' failed.\n\tValidation of 'ParentAddresses' failed.\n\t\tParentAddress[0]: AddressTypeDescriptorId is required.\n\t\tParentAddress[0]: PostalCode is required.\n\t\tParentAddress[0]: StreetNumberName is required}.	Street name, street number, and the parent's postal code are required fields that are missing.
400 BAD_REQUEST {message: “Validation of 'Parent' failed.\n\tValidation of 'ParentAddresses' failed.\n\t\tParentAddress[0]: AddressTypeDescriptorId is required.\n”}.	Parent Street name information is missing.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'ParentUniqueId' value.”}	Check the ODS to see if the Parent is loaded.
400 BAD_REQUEST {message: “Validation of 'Parent' failed. FirstName is required.”}	Parent's first name is missing.
400 BAD_REQUEST {message: “Unable to resolve value “uri:/tea.texas.gov/AsOfStatusLastDayEnrollmentDescriptor#B” to an existing “AsOfStatusLastDayEnrollmentDescriptor” resource.”}	AsOfStatus must be 'H' or “I'.
400 BAD_REQUEST {message: “Validation of 'Student' failed. Unable to resolve value 'uri:/tea.texas.gov/CrisisEventDescriptor#10' to an existing 'CrisisEventDescriptor' resource.”}	Value must be valid in C178- CrisisEvent.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'StudentUniqueId' value.”}	—-
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Student' was not found.”}	Student was not loaded to ODS.
400 BAD_REQUEST {message: “Validation of 'StudentParentAssociation' failed. Parent reference could not be resolved.”}	Parent was not loaded to ODS.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'ParentUniqueId', 'StudentUniqueId'”}	Parent/student are not associated together.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'StudentUniqueId' value.”}	Student or parent was not loaded to ODS.

TSDS Level 1 Errors - Teaching and Learning Domain

Teaching and Learning Domain

Error Message	Issue
409 CONFLICT {message: “The value supplied for the related 'course' resource does not exist.”}	Course does not exist in ODS.
400 BAD_REQUEST {message: “Unable to resolve value 'uri:/tea.texas.gov/GradeLevelDescriptor#5' to an existing 'GradeLevelDescriptor' resource.”}	Grade level is missing leading 0.
409 CONFLICT {message: “The value supplied for the related 'session' resource does not exist.”}	Session does not exist in ODS.
400 BAD_REQUEST {message: “Validation of 'Section' failed. Validation of 'AggregateExtensions' failed. Validation of 'SectionSets (TX)' failed. SectionSet[0]: The field CTEHours must be between 1 and 3.”}	CTE Hours must be between '1' and '3'.
409 CONFLICT {message: “The value supplied for the related 'courseOffering' resource does not exist.”}	Course for section does not exist in course offering.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'SchoolId', 'StaffUniqueId'.}	Verify if Staff member is loaded to the ODS.
409 CONFLICT {message: “The value supplied for the related 'section' resource does not exist.”}	Section does not exist in ODS.
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Staff' was not found.”}	Student does not exist in ODS.
409 CONFLICT {message: “The value supplied for the related 'section' resource does not exist.”}	Section does not exist in ODS.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'SchoolId', 'StudentUniqueId'.”}	Student is not associated with School.

TSDS Level 1 Errors - Staff Domain

Staff Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'Staff' failed. Validation of 'StaffAddresses' failed. StaffAddress[0]: StreetNumberName property is part of the primary key and therefore its value cannot contain leading or trailing whitespace.”}	Review Staff address for leading or trailing blank space.
400 BAD_REQUEST {message: “Validation of 'StaffEducationOrganizationEmploymentAssociation' failed. Staff reference could not be resolved.”}	Verify if Staff member is loaded to the ODS.
400 BAD_REQUEST {message: “Validation of 'StaffEducationOrganizationEmploymentAssociation' failed. Validation of 'Extensions' failed. StaffEducationOrganizationEmploymentAssociationExtension (TX): The field NumberDaysEmployed must be between 1 and 3.”}	Value must be greater than 0.

TSDS Level 1 Errors - Enrollment Domain

Enrollment Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'StudentSchoolAssociation' failed. Student reference could not be resolved.”}	Student reference does not match with School.
409 CONFLICT {message: “The value supplied for the related 'calendar' resource does not exist.”}	Track does not match with calendar.
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Student' was not found.”}	Student does not exist in ODS.
400 BAD_REQUEST {message: “Validation of 'StudentEducationOrganizationAssociation' failed. Unable to resolve value 'uri:/tea.texas.gov/HomelessStatusDescriptor#1' to an existing 'HomelessStatusDescriptor' resource.”}	HomelessStatus value is not accepted by TEA.

TSDS Level 1 Errors - Student Academic Record Domain

Student Academic Record Domain

Error Message	Issue
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Student' was not found.”}	Student does not exist in ODS.

TSDS Level 1 Errors - Finance Domain

Finance Domain

Error Message	Issue
400 BAD_REQUEST {message: “Unable to resolve value 'uri:/tea.texas.gov/ProgramIntentDescriptor#32' to an existing 'ProgramIntentDescriptor' resource.”}	Program Intent value is not accepted by TEA.
400 BAD_REQUEST {message: “Unable to resolve value 'uri:/tea.texas.gov/ObjectDescriptor#3700' to an existing 'ObjectDescriptor' resource.”}	Object value is not accepted by TEA.
400 BAD_REQUEST {message: “Unable to resolve value 'uri:/tea.texas.gov/ProgramIntentDescriptor#30' to an existing 'ObjectDescriptor' resource.”}	Program Intent value is not accepted by TEA.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'StaffUniqueId' value.”}	Staff member does not exist in ODS.
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Staff' was not found.”}	Staff member does not exist in ODS.
400 BAD_REQUEST {message: “Validation of 'ContractedInstructionalStaffFTEExt' failed. The field TotalContractedInstrStaffFTE must be between 0.01 and 999.99.”}	TotalContractedInstrStaffFTE must be between 0.01 and 999.99.

TSDS Level 1 Errors - Alternative and Supplemental Services Domain

Alternative and Supplemental Services Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'StudentCTEProgramAssociation' failed.\n\tStudent reference could not be resolved.\n.”}	Verify that the student is loaded into the ODS.
400 BAD_REQUEST {message: “Validation of 'StudentLanguageInstructionProgramAssociation' failed. Student reference could not be resolved.”}	Verify that the student is loaded into the ODS.
400 BAD_REQUEST {message: “Validation of 'StudentSpecialEducationProgramAssociation' failed. Student reference could not be resolved. ”}	Verify that the student is loaded into the ODS.
400 BAD_REQUEST {message: “Validation of 'StudentSpecialEducationProgramAssociation' failed.\n\tUnable to resolve value 'uri:/tea.texas.gov/ToolOrAssessmentUsedDescriptor#01' to an existing 'ToolOrAssessmentUsedDescriptor' resource.\n.”}	Value must be valid in C320 - ToolOrAssessmentUsed.
400 BAD_REQUEST {message: “Validation of 'StudentSpecialEducationProgramAssociation' failed. Validation of 'AggregateExtensions' failed. Validation of 'StudentSpecialEducationProgramAssociationStudentResidentialFacilityAssociations (TX)' failed.”}	Review Residential Facility data.
400 BAD_REQUEST {message: “Validation of 'StudentTitleIPartAProgramAssociation' failed. Student reference could not be resolved.”}	Verify that the student is loaded into the ODS.
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Student' was not found.”}	Verify that the student is loaded into the ODS.

TSDS Level 1 Errors - Discipline Domain

Discipline Domain

Error Message	Issue
409 CONFLICT {message: “Access to the resource item could not be authorized because the 'Student' was not found.”}	Verify that the student is loaded into the ODS.
403 FORBIDDEN {message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'SchoolId', 'StudentUniqueId'.”}	Check if Schools are loaded, then check to see if the student with that specific, unique student ID is loaded for the specific School in the ODS.

TSDS Level 1 Errors - Prior Year Leaver Domain

Prior Year Leaver Domain

Error Message	Issue
400 BAD_REQUEST {message: “Validation of 'PriorYearLeaver' failed. FirstName is required.”}	Leaver student First Name is missing.
400 BAD_REQUEST {message: “Validation of 'PriorYearLeaver' failed. AsOfStatusLastFridayOctoberDescriptorId is required.”}	AsOfStatusLastFridayOctoberDescriptor is a required field and that information is missing.
400 BAD_REQUEST {message: “Validation of 'PriorYearLeaver' failed. Unable to resolve value 'uri:/tea.texas.gov/ExitWithdrawTypeDescriptor#80' to an existing 'ExitWithdrawTypeDescriptor' resource.”}	Value must be valid in C162 - ExitWithdrawType.
400 BAD_REQUEST {message: “The request is invalid.”,“modelState”: {“request. Id”: [“The value 'id' is not valid for Id.”],“request. BirthCity”: [],“request. BirthDate”: [“The value 'birthDate' is not valid for BirthDate”}	Leaver Birth City and Birth Date are required fields and are missing. Birth Date format is missing hyphen.

State Reporting

Sidebar

Table of Contents

View and print errors:

TSDS Level 1 Errors Guidance

Load Order

Education Organization Domain

School Calendar Domain

Student Identification and Demographics Domain

Teaching and Learning Domain

Staff Domain

Enrollment Domain

Student Academic Record Domain

Finance Domain

Alternative and Supplemental Services Domain

Discipline Domain

Prior Year Leaver Domain

Americans with Disabilities Act (ADA) and Web Accessibility

State Reporting

User Tools

Site Tools

Sidebar

Table of Contents

View and print errors:

TSDS Level 1 Errors Guidance

Load Order

Education Organization Domain

School Calendar Domain

Student Identification and Demographics Domain

Teaching and Learning Domain

Staff Domain

Enrollment Domain

Student Academic Record Domain

Finance Domain

Alternative and Supplemental Services Domain

Discipline Domain

Prior Year Leaver Domain

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility