.svg)
The following are general issues that might occur when you use PowerSchool SIS.
In this article
- Errors were found during plugin installation. The version number of this plugin is a less-recent version than the currently installed plugin.
- Errors were found during plugin installation. Plugin configuration is invalid.
- This plugin requests access to fields that are invalid or blacklisted
- Declared columns do not match actual number of columns
- Can't parse SQL
- Unexpected character
- 404: Query not found
Configuring PowerSchool integration involves installing the GG4L Data Sync plugin and connecting it to the GG4L School Passport system. During this process, you may encounter various issues and this article provides troubleshooting tips to help resolve them.
Plugin installation issues
The following provides troubleshooting steps for errors and issues that you might encounter when working with GG4L Data Sync plugin in PowerSchool SIS.
Errors were found during plugin installation. The version number of this plugin is a less-recent version than the currently installed plugin
This message indicates that the version number in the plugin.xml file has not been updated. This is not an error, so you can continue with the plugin update without contacting GG4L Customer Support.
Errors were found during plugin installation. Plugin configuration is invalid.
This error might occur when edutone.named_queries.xml file is unpacked and installed instead of the archived version. To resolve this issue, install the archived file of the GG4L Data Sync plugin.
This plugin requests access to fields that are invalid or blacklisted. The plugin cannot be enabled until these conflicts have been resolved.
This error appears when there is an invalid or incorrect table name or field in your PowerSchool instance. Make sure that there are no typos in the table and field names you are using. If everything correct, that is the specified table does not exist in your instance. To resolve this, find the correct names of table and field in PowerSchool SIS. Then, contact GG4L Support and provide them with these values to request an update for your GG4L Data Sync plugin.
Declared columns do not match actual number of columns
This error occurs when the declared number of columns does not match the actual number of columns in your data. To resolve this issue, please contact the GG4L Support for assistance.
Can't parse SQL
This error occurs due to a syntax issue in the SQL query. Please contact the GG4L Support for assistance.
Unexpected character
This error indicates that there is a syntax issue in the query file. Please contact GG4L Support to make changes to the GG4L Data Sync plugin.
404: Query not found
This error is displayed in School Passport Sync Errors log. It appears when the plugin ZIP has been unpacked and only plugin.xml file was installed. This file grants access to the fields but does not contain the necessary queries for import into GG4L School Passport. To resolve this issue, install the archived file of the GG4L Data Sync plugin.
PowerSchool data sync issues
The following provides troubleshooting steps for errors and issues that you might encounter when syncing data with PowerSchool SIS.
Error while executing PowerQuery
This error occurs when Staff, Students, or Contacts entities were not imported during the initial sync with PowerSchool SIS or were deleted after the plugin update.
To find this message:
- In School Passport, go to the History > PowerSchool app.
- Click Audit Data.
- In Search for URL, enter the entity name.
- Choose the first URL (
https://<domain>/ws/schema/query/sso.passport.<entityName>.get_<entityName>?page=1
- Go to Response Body.
To resolve this issue, please contact GG4L Support to request an update for your GG4L Data Sync plugin.
403: No access to the field
plugin.xml file. To resolve this issue, please contact GG4L Support to request an update for your GG4L Data Sync plugin.
Parameter 'guid' culd not be null for roster type
This error occurs when some attribute mappings have been removed. Make sure that all required attribute mappings are configured in School Passport.
Caution:
If you are not an advanced user, please do NOT change Attribute Mappings. Instead, please contact GG4L Support for assistance.
Data flow has critical error
This error happens due to incorrect attribute mapping. Make sure that all attribute mappings are correctly configured.
Caution:
If you are not an advanced user, please do NOT change Attribute Mappings. Instead, please contact GG4L Support for assistance.
Unknown property -> externalExpression
This happens when you attempted to change the Expression to the External Expression attribute. This changes require editing GG4L Data Sync plugin with co-teachers. To resolve this issue, please contact GG4L Support.
