Details
-
Improvement
-
Resolution: Invalid
-
Minor
-
None
-
None
-
None
Description
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' ' at line 1,
sql: SELECT gmav.immediate_membership_id AS immediate_membership_id, gs.name AS stem_name, gm.subject_source AS subject_source_id, gm.subject_id, (select gg2.name from grouper_groups gg2 where 1!=1 and gm.subject_source='g:gsa' and gg2.id = gm.subject_id) as subject_identifier, gf.name as field_name FROM grouper_memberships_all_v gmav, grouper_members gm, grouper_stems gs, grouper_fields gf where 1!=1 and gmav.mship_type = 'immediate' AND gmav.immediate_mship_enabled = 'T' AND gmav.owner_stem_id = gs.id AND gmav.member_id = gm.id AND gmav.field_id = gf.id AND gf.type = 'naming' and ( gs.name = 'arizona.edu:dept:LAW' or gs.name like 'arizona.edu:dept:LAW:%' ) , ,
Error finding metadata for 'SELECT gmav.immediate_membership_id AS immediate_membership_id, gs.name AS stem_name, gm.subject_source AS subject_source_id, gm.subject_id, (select gg2.name from grouper_groups gg2 where 1!=1 and gm.subject_source='g:gsa' and gg2.id = gm.subject_id) as subject_identifier, gf.name as field_name FROM grouper_memberships_all_v gmav, grouper_members gm, grouper_stems gs, grouper_fields gf where 1!=1 and gmav.mship_type = 'immediate' AND gmav.immediate_mship_enabled = 'T' AND gmav.owner_stem_id = gs.id AND gmav.member_id = gm.id AND gmav.field_id = gf.id AND gf.type = 'naming' and ( gs.name = 'arizona.edu:dept:LAW' or gs.name like 'arizona.edu:dept:LAW:%' ) ' in database: 'grouperProd'
at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2306)
at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:309)
at edu.internet2.middleware.grouper.app.syncToGrouper.SyncToGrouperFromSql.sqlLoadAutoConfigureColumnsPrivilegeStem(SyncToGrouperFromSql.java:1221)
at edu.internet2.middleware.grouper.a