Note
We've packed up and moved from Confluence to Discourse to bring you a better, more interactive space. Out of courtesy we didn't migrate your user account so - you will have to signup again
The Exalate team will be on holiday for the coming days - returning Jan 4
Enjoy & stay safe
I am having serious issues trying to sync dates. SN has a field called due_date that we are trying to sync to due date in Jira. I am getting a cannot cast object error.
Error Detail Message:
Cannot cast object '01/03/2022 16:20:59' with class 'java.lang.String' to class 'java.util.Date'
Error line: 34
Error Stack Trace
com.exalate.api.exception.script.ScriptException: Cannot cast object '01/03/2022 16:20:59' with class 'java.lang.String' to class 'java.util.Date' at com.exalate.error.services.ScriptExceptionCategoryService.categorizeProcessorAndIssueTrackerExceptionsIntoScriptExceptions(ScriptExceptionCategoryService.scala:40) at com.exalate.processor.ExalateProcessor.executeProcessor(ExalateProcessor.java:57) at com.exalate.replication.services.processor.CreateReplicaProcessor.$anonfun$executeScriptRules$2(CreateReplicaProcessor.scala:118) at scala.util.Try$.apply(Try.scala:213) at com.exalate.replication.services.processor.CreateReplicaProcessor.executeScriptRules(CreateReplicaProcessor.scala:116) at com.exalate.replication.services.processor.CreateReplicaProcessor.$anonfun$createHubReplica$2(CreateReplicaProcessor.scala:68) at scala.concurrent.Future.$anonfun$flatMap$1(Future.scala:307) at scala.concurrent.impl.Promise.$anonfun$transformWith$1(Promise.scala:41) at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64) at akka.dispatch.BatchingExecutor$AbstractBatch.processBatch(BatchingExecutor.scala:56) at akka.dispatch.BatchingExecutor$BlockableBatch.$anonfun$run$1(BatchingExecutor.scala:93) at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:85) at akka.dispatch.BatchingExecutor$BlockableBatch.run(BatchingExecutor.scala:93) at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:48) at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(ForkJoinExecutorConfigurator.scala:48) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) Caused by: javax.script.ScriptException: javax.script.ScriptException: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '01/03/2022 16:20:59' with class 'java.lang.String' to class 'java.util.Date' at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:158) at java.scripting/javax.script.AbstractScriptEngine.eval(AbstractScriptEngine.java:264) at com.exalate.processor.ExalateProcessor.execute(ExalateProcessor.java:98) at com.exalate.processor.ExalateProcessor.executeProcessor(ExalateProcessor.java:55) ... 19 more Caused by: javax.script.ScriptException: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '01/03/2022 16:20:59' with class 'java.lang.String' to class 'java.util.Date' at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:320) at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:155) ... 22 more Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '01/03/2022 16:20:59' with class 'java.lang.String' to class 'java.util.Date' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.continueCastOnSAM(DefaultTypeTransformation.java:415) at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.continueCastOnNumber(DefaultTypeTransformation.java:329) at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:243) at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:2744) at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:3809) at org.codehaus.groovy.runtime.InvokerHelper.setProperty(InvokerHelper.java:217) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.setProperty(ScriptBytecodeAdapter.java:496) at Script320.run(Script320.groovy:34) at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:317) ... 23 more
This was originally raised via support but I was asked to post here:
The error you are receiving seems to be a configuration problem we use a community site at community.exalate.com to discuss the configuration of the synchronization.
Kindly raise the question there, we will be responding shortly, the advantage is that other people can benefit from the effort.
i have the same with issue.created=replica.created. From Zendesk to Jira Cloud
Hi Robert Horan
What the error is stating is that the object being tried to pass to into the field is a String, while the field is expecting a Date format data, you can make this conversion the following way:
https://docs.idalko.com/exalate/x/BwCwB
Hope this is helpful,
Cheers,
Daniel
Hi Daniel,
I have that document but it didn't help. I don't know enough about this tool to make that work. What needs to be added to the incoming/outgoing sync for ServiceNow? Jira?
According to https://docs.idalko.com/exalate/display/ED/How+to+synchronize+a+Due+Date+field+in+Jira+Cloud
Outgoing sync
To send the Due date use the code below
replica.due = issue.due
Incoming sync
To apply the received Due Date value on your side add the code below
issue.due = replica.due
It's not clear to me how or even where this fits in. There could be multiple date fields, not to mention date and time fields.