add debug info on loader query that fails

I'm having some difficulty with a SQL loader job against an Oracle DB. Here is my SQL query:

SELECT distinct UIN AS subject_id

 FROM

 V_EMPEE_HIST_1

 INNER JOIN V_JOB_DETL_HIST_1 USING (EDW_PERS_ID)

 INNER JOIN V_EMPEE_PERS_HIST_1 USING (EDW_PERS_ID)

 WHERE

 HR_CAMPUS_CD = 'U'

 AND EMPEE_STATUS_CD = 'A'

 AND EMPEE_DATA_STATUS_DESC = 'Current'

 AND JOB_DETL_DATA_STATUS_DESC = 'Current'

 AND JOB_DETL_STATUS_DESC = 'Active'

 --AND JOB_DETL_CAMPUS_CD = '1'

 AND(JOB_DETL_EEO_SKILL_CD LIKE '6%'

 OR JOB_DETL_EEO_SKILL_CD LIKE '7%')

 AND PERS_CUR_INFO_IND = 'Y'

 ORDER BY

 UINLucky for me, the UIN is my subject_id in Grouper. This query runs just fine using TOAD or any other interface, but fails in Grouper with the following exception:java.lang.RuntimeException: Result has a null subject_id, please correct the query (maybe just filter where subject_id is not null)

	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.bulkLookupSubjects(GrouperLoaderResultset.java:203)

	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2996)

	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$1.runJob(GrouperLoaderType.java:168)

	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)

java.lang.RuntimeException: Problem with group: test:sqlloader:edw_test_craftstrades

	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:3242)

	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$1.runJob(GrouperLoaderType.java:168)

	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.lang.RuntimeException: Result has a null subject_id, please correct the query (maybe just filter where subject_id is not null)

	at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.bulkLookupSubjects(GrouperLoaderResultset.java:203)

	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2996)

	... 5 moreAdding the suggested "is not null" to my where clause does not make a difference. The logs are showing that it gets back a large quantity of results. Is there a way to enable logging at my JDBC driver level in my log4j properties? (edited)