Our Investment Allocation job fails intermittently, in bg-ca log we have the error:
ERROR 2019-10-01 09:02:30,846 [Dispatch Investment Allocation (Our_name) : XXXXXXX (tenant=clarity)] niku.njs (clarity:admin:12518493__F8E035E1-4CC6-4072-8EE7-1F356DBDD7E0:Investment Allocation (Our_name)) Error executing job: 5008003
java.lang.RuntimeException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
at com.niku.projmgr.service.staffing.job.InvestmentAllocationJob.scheduledEventFired(InvestmentAllocationJob.java:100)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:657)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01461: can bind a LONG value only for insert into a LONG column
Release : All supported Clarity releases