otherJob.testDailyEmail.class = edu.internet2.middleware.grouper.app.loader.NotificationDaemon

otherJob.testDailyEmail.emailBodyTemplate = hello \u0024{subject_name},\n\

 \n\

This many people have issues\u003A \u0024{size(listOfRecordMaps)}\n\

 \n\

\u0024\u0024for (var recordMap \u003A listOfRecordMaps) {__NEWLINE__ Record subject ID\u003A \u0024{recordMap.get('subject_description')}__NEWLINE__\u0024\u0024}

otherJob.testDailyEmail.emailListGroupName = test\u003AtestNotifications

otherJob.testDailyEmail.emailSubjectTemplate = People who need training

otherJob.testDailyEmail.emailSummaryOnlyIfRecordsExist = true

otherJob.testDailyEmail.emailSummaryToGroupName = test\u003AemailAddressAdmins

otherJob.testDailyEmail.emailType = summary

otherJob.testDailyEmail.populationType = groupMembership

otherJob.testDailyEmail.quartzCron = 0 03 5 * * ?

java.lang.RuntimeException: Error finding metadata for 'select subject_id from grouper_memberships_lw_v where 1!=1 and group_name = ? and list_name = 'members'  and subject_source = ? order by subject_id' in database: 'grouper'

	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

	at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)

	at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

	at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)

	at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)

	at edu.internet2.middleware.grouperClient.util.GrouperClientCommonUtils.createRuntimeExceptionWithMessage(GrouperClientCommonUtils.java:478)

	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:485)

	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:320)

	at edu.internet2.middleware.grouper.app.loader.NotificationDaemon$2.callback(NotificationDaemon.java:296)

	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)

	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)

	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)

	at edu.internet2.middleware.grouper.app.loader.NotificationDaemon.run(NotificationDaemon.java:126)

	at edu.internet2.middleware.grouper.app.loader.OtherJobBase$2.callback(OtherJobBase.java:443)

	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)

	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)

	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)

	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:394)

	at edu.internet2.middleware.grouper.app.loader.OtherJobBase.execute(OtherJobBase.java:378)

	at edu.internet2.middleware.grouper.app.loader.GrouperDaemonJob.execute(GrouperDaemonJob.java:57)

	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)

	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

Caused by: java.lang.RuntimeException: sql: select subject_id from grouper_memberships_lw_v where 1!=1 and group_name = ? and list_name = 'members'  and subject_source = ? order by subject_id, 

	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2696)

	at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata.retrieveQueryMetadataFromDatabase(GcTableSyncTableMetadata.java:379)

	... 15 more

Caused by: org.postgresql.util.PSQLException: No value specified for parameter 1.

	at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:346)

	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)

	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)

	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)

	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)

	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:137)

	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)

	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2691)

	... 16 more