Errors in Publishing Data

When data is being published to the state, errors may occur as the data transmission gets rejected by the state ODS. The categories on the DEX Dashboard on the Publish Data table are arranged such that errors on one line may propagate downward as dependencies. You must always work from top to bottom when addressing issues. Records with dependencies or errors can be viewed on the category's review page.

Review Page

To access the review page:

1. Click either the Review or Errors button next to the category. 

2. On the Review page, select a view option from the Choose Category pop-up menu. Examples of the selections available may include but are not limited to:

   1. Statistical Summary - provides cumulative statistics for all publishing operations for the selected category. The columns displayed are Total Processing, Total Missing Data, Total Dependencies, Total Publishing, Total Errors, Last Update, and Total Published.

   2. Published - provides a detailed list of the data successfully published to the state ODS. When demographic data is published, the system automatically requests a Unique Identifier (State Number), when needed, for the demographic record to be published. The columns displayed are based on the category type but will always include the Last Publish Date, Publishing ID, and Resource ID.

   3. Dependencies - provides a detailed list of records that cannot be published to the state ODS because it is dependent on other data sequencing. The columns displayed are based on the category type but will always include the Dependency, Last Publish Date, and Publishing ID.

   4. Errors - provides a list of errors for the selected category. This will display information that is relevant to the category including the Error Code, Message Detail, Publishing ID, and Resource ID. 

3. Select the resource view from the Choose Data View pop-up menu.

4. Click Clear Cache located on the bottom right of the Results panel to ensure that you are not looking at old data and attempting to fix a problem that no longer exists.

Sometimes certain cells on the table may be clickable for additional information. In some cases, you will get the failed JSON payload or the error returned, and in other cases, you will get a link to the relevant student. When linked to a student, navigate to the Data Exchange Publishing link on the left navigation menu. This will give you access to more detailed error information and you are more likely to find JSON payloads and/or Resource Details tables to help identify missing or problematic data. Additionally, you can export the data results to an Excel spreadsheet.

Diagnostic Viewer

Another way to diagnose publishing errors is to check if any errors are being logged within the Diagnostic Viewer Information by navigating to System Setup and clicking Data Exchange. Make sure to click on the Clear Cache button located on the bottom-right of the page to ensure you are seeing the most current data log.

Common Errors

Below are some common errors that can occur and how to resolve them.