Hello,
We have a OIM scheduler Task whto handle expired Ids in the system. This task was running fine. But suddenly it stopped running as per its schedule.
When we checked the logs found the below exception. Help me please... We are using OIM 10g. SQL JDBC 2.0 and SQL server 2012
INFO [org.quartz.core.JobRunShell] Job DEFAULT.Expiration Task threw a JobExecutionException:
org.quartz.JobExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text [See nested exception: com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text]
at com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
at Thor.API.Security.LoginHandler.jbossLoginSession.runAs(Unknown Source)
at com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
* Nested Exception (Underlying Cause) ---------------
com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: varbinary is incompatible with text
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
thanks,