If the Google Classroom Link is not showing up or not working for your Teachers, please check these items:


1. Account is any Teacher type account.  A Teacher Account is a Teacher or Substitute Teacher account and includes Active Directory Teacher accounts. UGN.UTY = ('teacher','adteacher','teachersub','adteachersub') 



2. The email they have in SSO.GEM is an active account in GSuite in their Teacher Domain. If the email is not present in SSO.GEM, then their UGN.EM must be an active account in GSuite their Teacher Domain.




3. Google Teachers must be cached.  GoogleTeachers_DB in the DistrictCache table.


4. The account in SSO.GEM or UGN.EM must be in the GoogleTeachers_DB cache.


5. The school they are currently logged into is selected in the Google Classroom config.


6. Teachers must be in the "classroom_teachers" group in the domain specified for "Teacher Domain" on the Google Integration Configuration page.


7. If they're using the Staff Integration also make sure the STF.EM is populated for the account to get properly linked from the STF table.



8. Ensure that the .p12 or .json file is the current and correct credential file for the service account that's being used, and that it's accessible by the Aeries Reporting service and all web servers which may need access.  See the Google Integration setup to ensure this file is in the correct location. 


9. If a teacher disables "Manage invite codes" for Google Classroom, Aeries will not be able to link to it.

 


NOTE: The New Year Rollover process will automatically disable the past year Google Integration by adding 'disabled' to the .json or .p12 file name in DPT.



If Teachers are having problems with Students showing up in their Classroom, check to see if Multiple Gradebooks are associated to a Classroom ID.

Elementary w/o MST

SELECT DISTINCT ID as GBK FROM GBO WHERE OV IN (SELECT G1.OV FROM GBO G1 INNER JOIN GBO G2 ON G1.OV = G2.OV

WHERE G1.DEL = 0 AND G2.DEL = 0 AND G1.OPN = 'Website_ExternalID' AND G2.OPN = 'Website_ExternalID' AND G1.ID <> G2.ID)


Schools with MST


SELECT DISTINCT SC,SE FROM MSS WHERE SV IN (SELECT M1.SV FROM MSS M1 INNER JOIN MSS M2 ON M1.SC = M2.SC AND M1.SV = M2.SV 

WHERE M1.DEL = 0 AND M2.DEL = 0 AND M1.NM = 'Website_ExternalID' AND M2.NM = 'Website_ExternalID' AND M1.SE <> M2.SE)

order by sc