Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2757

grouper recent memberships loader has issues on mysql with case sensitive query labels (e.g. unix)

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.5.28
    • None
    • None

    Description

      2.5.27 i get this error when i run recentMemberships loader jobjava.lang.RuntimeException: Problem with query: select distinct gaaagv_groupName.value_string group_name, gpm.subject_id, gpm.subject_source subject_source_id from grouper_pit_memberships gpmship, grouper_pit_group_set gpgs, grouper_pit_members gpm, grouper_pit_groups gpg, grouper_pit_fields gpf, grouper_aval_asn_asn_group_v gaaagv_recentMemberships, grouper_aval_asn_asn_group_v gaaagv_groupName, grouper_aval_asn_asn_group_v gaaagv_includeEligible where gaaagv_recentMemberships.group_id = gaaagv_groupName.group_id and gaaagv_recentMemberships.group_id = gaaagv_includeEligible.group_id and gaaagv_recentMemberships.attribute_def_name_name2 = 'etc:attribute:recentMemberships:grouperRecentMembershipsDays' and gaaagv_groupName.attribute_def_name_name2 = 'etc:attribute:recentMemberships:grouperRecentMembershipsGroupName' and gaaagv_includeEligible.attribute_def_name_name2 = 'etc:attribute:recentMemberships:grouperRecentMembershipsIncludeCurrent' and gpmship.MEMBER_ID = GPM.ID and GPM.subject_source != 'g:gsa' and gpgs.FIELD_ID = GPF.ID and gpf.name = 'members'  and ((gaaagv_includeEligible.value_string = 'true' and gpmship.end_time is null and gpgs.end_time is null) or ((gpmship.end_time > (1000000 * (UNIX_TIMESTAMP() - (60*60*24*CONVERT(gaaagv_recentMemberships.value_string,UNSIGNED INTEGER)))) and gpgs.start_time < gpmship.end_time AND (gpgs.end_time is null or gpgs.end_time > gpmship.end_time))  OR (gpgs.end_time > (1000000 * (UNIX_TIMESTAMP() - (60*60*24*CONVERT(gaaagv_recentMemberships.value_string,UNSIGNED INTEGER)))) AND gpmship.start_time < gpgs.end_time and (gpmship.end_time is null or gpmship.end_time > gpgs.end_time)))) and gaaagv_recentMemberships.value_string REGEXP '^[0-9]+$' and gaaagv_groupName.value_string REGEXP '^.+:.+$' and gaaagv_includeEligible.value_string REGEXP '^(true|false)$'  and gaaagv_groupName.group_name = gpg.name and gpg.id = gpgs.owner_id and gpmship.owner_id = gpgs.member_id AND gpmship.field_id = gpgs.member_field_id and (gaaagv_includeEligible.value_string = 'true' or not exists (select 1 from grouper_memberships mship2, grouper_group_set gs2 WHERE mship2.owner_id = gs2.member_id AND mship2.field_id = gs2.member_field_id and mship2.member_id = gpm.source_id and gs2.field_id = gpf.source_id and gs2.owner_id = gaaagv_recentMemberships.group_id and mship2.enabled = 'T' ) ) ,  on db: DB: user: grouper, url: jdbc:mysql://az1-grouperdb-dev02.server.ufl.edu:3306/grouper?useSSL=false&serverTimezone=America/New_York&maxAllowedPacket=1073741824, driver: com.mysql.cj.jdbc.Driver    at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.<init>(GrouperLoaderResultset.java:497)    at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:448)    at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:465)    at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:345)    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'GPM.ID' in 'where clause'    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)    at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)    at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:327)    at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.<init>(GrouperLoaderResultset.java:465)    ... 5 more 

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist