Grouper Users - Open Discussion List

["Gettes, Michael" <>]

I am trying to continue down the path of making use of the realtime loader 
and I am having a SQL error.  I have turned up logging to DEBUG on 
edu.internet2.middleware.grouper.app.loader but I am not getting any useful 
output other than what is below.  How can I better see the actual statement 
creating the error?  I get the impression my loaderJob SQL is being wrapped 
by something else and that’s failing but I can’t see what is actually failing.

Pointers appreciated.

/mrg

daemon_1    | 2018-07-13T20:34:30.176376217Z 
grouper-api;grouper_error.log;dev;build-2;2018-07-13 16:34:30,175: 
[DefaultQuartzScheduler_Worker-7] ERROR 
GrouperLoaderIncrementalJob.runJob(336) -  - Error running job
daemon_1    | 2018-07-13T20:34:30.176434695Z java.lang.RuntimeException: 
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 '@SHIBPRD_pub p, Role_List RL where 
p.ARP_PAR_UFID = r.ROLEUSER and r.rolename=RL' at line 1,
daemon_1    | 2018-07-13T20:34:30.176444634Z 1 callables out of problem count 
1 had problems running outside of threads!
daemon_1    | 2018-07-13T20:34:30.176450505Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.processOneRow(GrouperLoaderIncrementalJob.java:720)
daemon_1    | 2018-07-13T20:34:30.176455791Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.access$000(GrouperLoaderIncrementalJob.java:73)
daemon_1    | 2018-07-13T20:34:30.176460452Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob$1.callLogic(GrouperLoaderIncrementalJob.java:286)
daemon_1    | 2018-07-13T20:34:30.176464931Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob$1.callLogic(GrouperLoaderIncrementalJob.java:281)
daemon_1    | 2018-07-13T20:34:30.176469333Z    at 
edu.internet2.middleware.grouper.util.GrouperCallable.tryCallablesWithProblems(GrouperCallable.java:51)
daemon_1    | 2018-07-13T20:34:30.176473956Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.runJob(GrouperLoaderIncrementalJob.java:308)
daemon_1    | 2018-07-13T20:34:30.176478163Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.execute(GrouperLoaderIncrementalJob.java:94)
daemon_1    | 2018-07-13T20:34:30.176483959Z    at 
org.quartz.core.JobRunShell.run(JobRunShell.java:202)
daemon_1    | 2018-07-13T20:34:30.176488543Z    at 
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
daemon_1    | 2018-07-13T20:34:30.176493674Z Caused by: 
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 '@SHIBPRD_pub p, Role_List RL where 
p.ARP_PAR_UFID = r.ROLEUSER and r.rolename=RL' at line 1
daemon_1    | 2018-07-13T20:34:30.176499131Z    at 
sun.reflect.GeneratedConstructorAccessor99.newInstance(Unknown Source)
daemon_1    | 2018-07-13T20:34:30.176503352Z    at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
daemon_1    | 2018-07-13T20:34:30.176509368Z    at 
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
daemon_1    | 2018-07-13T20:34:30.176514977Z    at 
com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
daemon_1    | 2018-07-13T20:34:30.176519375Z    at 
com.mysql.jdbc.Util.getInstance(Util.java:387)
daemon_1    | 2018-07-13T20:34:30.176540322Z    at 
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
daemon_1    | 2018-07-13T20:34:30.176545670Z    at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
daemon_1    | 2018-07-13T20:34:30.176550501Z    at 
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
daemon_1    | 2018-07-13T20:34:30.176555287Z    at 
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
daemon_1    | 2018-07-13T20:34:30.176560002Z    at 
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
daemon_1    | 2018-07-13T20:34:30.176565012Z    at 
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
daemon_1    | 2018-07-13T20:34:30.176570002Z    at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
daemon_1    | 2018-07-13T20:34:30.176575144Z    at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
daemon_1    | 2018-07-13T20:34:30.176579983Z    at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
daemon_1    | 2018-07-13T20:34:30.176585062Z    at 
edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.processOneRow(GrouperLoaderIncrementalJob.java:601)
daemon_1    | 2018-07-13T20:34:30.176590460Z    ... 8 more