error finding metadata when space in query

XMLWordPrintable

    • Type: Improvement
    • Resolution: Invalid
    • Priority: Minor
    • 2.5.44
    • Affects Version/s: None
    • Component/s: None
    • None

      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

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: