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
|
Bug
Minor