Items Stuck in Publishing Queue

The Publishing queue is for items scheduled for writing or publishing into the ODS. If the number of items in the Publishing queue is not decreasing, it may be that PowerSchool has lost the connection to the ODS. 

Use the following steps to force PowerSchool to re-establish the necessary connections. You should see the Publishing queue start to decrease shortly after re-establishing the connections.

1. Navigate to Setup > System > Data Exchange > General Setup.
2. Set System Enabled to Off, then Save.
3. Wait a couple of minutes before. 
4. Set System Enabled to On, then Save.
5. Click Configure in the LEA Name section.
6. Run Test Connection  to verify connectivity, then Save.