3 answers
- 210
Hello, Vedant Kulkarni , since your Exalate for Snow is hosted on Exalate infrastructure, then in order to have a publi-public connection, your Jira
https://jira-sdesk.pp.s2-eu.x.com/sdesk
Should also be publicly available.
Unfortunately, even if I navigate in my browser to this Jira URL:You may work this around by establishing a public-private connection by:
- initiating the connection from SNOW,
- clicking the "I don't have URL" button
- accepting the invitation on the Jira side
Please, let me know if this helps.
Happy Exalating!- Vedant Kulkarni
Serhiy Onyshchenko , now we are able to sync data from SNOW to Jira but we are able to sync the Summary field only. We are trying to sync some entities from SNOW to some custom fields in Jira but getting errors as below:
Cannot set property 'value' on null object
We are trying to set fields values from SNOW as:-
if(entity.tableName == "incident") { replica.key = entity.key replica.summary = entity.short_description replica.customFields.customfield_10203."ServiceNow for ADM" = entity.service_offering."ServiceNow for ADM" }
Serhiy Onyshchenko do we have any documents which explain how to sync entities with Jira Custom Fields?
- Vedant Kulkarni
Serhiy Onyshchenko, we are able to share the data from SNOW to Jira. Now we are currently working on syncing the data from Jira to SNOW. So, we are trying with following Sync rules but incidents are getting created in SNow, Could you please confirm whether we are doing it correctly.
Jira Outgoing Sync:
replica.issuetype = issue.issuetype replica.summary = issue.summary replica.service_offering = issue.customFields."Service type" replica.priority = issue.priority replica.urgency = issue.customFields."customfield_10115" replica.impact = issue.customFields."customfield_10109" replica.assignment_group = issue.customFields."Assignment Group"
SNOW Incoming Sync:
if(firstSync) { entity.tableName = "incident" entity.u_type = "Incident" entity.short_description = replica.summary entity.service_offering = replica.service_offering.value entity.assignment_group = replica.assignment_group.value }
Thanks
- Serhiy Onyshchenko
Hello, Vedant Kulkarni , since your original question about UnknownHost was resolved, might I ask you to create a new question related to sharing data from SNOW to Jira, please?
Feel free to ping Mariia Onyshchenko with the link, I'll make sure to answer. - Vedant Kulkarni
Serhiy Onyshchenko , here is the link for the new question: Jira to SNow syncs are failing
Add your comment... - 10-1
Thanks for the response Serhiy Onyshchenko . Can you try with this URL: https://jira-sdesk.pp.s2-eu.capgemini.com. This is the correct URL
Seems that we cannot make this URL a Public URL, but I will cross-check internally about this and will get back to you.
Below is the approach we tried initially:
We were able to establish the connection in the following way:
- We had created a new invitation In Jira Exalate
- Then accepted the invitation on the SNow Exalate side
- Is this approach right?
- Which instance will be private or public? in our case seems like SNow is Public and Jira is Private, I think so.
Please correct us if we are doing anything wrong.
Thanks
Add your comment... - 10-1
Hello There, We tried again with basic sync rules from SNow to Jira but still we are getting the same error.
Outgoing Sync From SNow:
if(entity.tableName == "incident") { // replica.key = entity.key replica.summary = entity.short_description //replica.description = entity.description //replica.attachments = entity.attachments //replica.comments = entity.comments //replica.state = entity.state }
Incoming Sync For Jira:
if(firstSync) { issue.projectKey = "JTST" // Set type name from source issue, if not found set a default issue.typeName = "Task" } issue.summary = replica.short_description
error:
2022-04-04 07:08:50,623 [ERROR] from application.services.replication.request.RequestProcessorService in scala-execution-context-global-41 - Exception occurred while processing sync request ID `4`, remote event `6648` number `1` for remote issue urn `JTST-2`, connection `JiraBusinessSD_to_SNowSD`. com.exalate.api.exception.bug.rest.RestTransportBugException: Unexpected error occurred while communicating with destination side. Exception when posting sync response from sync request `4` for sync event `6648` to `https://jira-sdesk.pp.s2-eu.x.com/sdesk` <a href="https://docs.idalko.com/exalate/x/vQKOAQ" target='_blank' rel='noopener noreferrer'>Generate an exalate support.zip file</a> and contact support. at com.exalate.error.services.BugExceptionCategoryService.generateRestExalateTransportBugException(BugExceptionCategoryService.scala:265) at com.exalate.error.services.ExalateRestErrorResponseCategoryService.$anonfun$categorizeNetworkAndRestResponseException$4(ExalateRestErrorResponseCategoryService.scala:36) at scala.Option.getOrElse(Option.scala:189) at com.exalate.error.services.ExalateRestErrorResponseCategoryService.categorizeNetworkAndRestResponseException(ExalateRestErrorResponseCategoryService.scala:36) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient$$anonfun$postSyncRequest$3.applyOrElse(SyncResponsesClient.scala:54) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient$$anonfun$postSyncRequest$3.applyOrElse(SyncResponsesClient.scala:50) at scala.concurrent.Future.$anonfun$recoverWith$1(Future.scala:417) 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: java.net.UnknownHostException: jira-sdesk.pp.s2-eu.x.com: Name or service not known at java.base/java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(InetAddress.java:929) at java.base/java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1515) at java.base/java.net.InetAddress$NameServiceAddresses.get(InetAddress.java:848) at java.base/java.net.InetAddress.getAllByName0(InetAddress.java:1505) at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1364) at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1298) at play.shaded.ahc.io.netty.util.internal.SocketUtils$9.run(SocketUtils.java:159) at play.shaded.ahc.io.netty.util.internal.SocketUtils$9.run(SocketUtils.java:156) at java.base/java.security.AccessController.doPrivileged(Native Method) at play.shaded.ahc.io.netty.util.internal.SocketUtils.allAddressesByName(SocketUtils.java:156) at play.shaded.ahc.io.netty.resolver.DefaultNameResolver.doResolveAll(DefaultNameResolver.java:52) at play.shaded.ahc.io.netty.resolver.SimpleNameResolver.resolveAll(SimpleNameResolver.java:81) at play.shaded.ahc.io.netty.resolver.SimpleNameResolver.resolveAll(SimpleNameResolver.java:73) at play.shaded.ahc.org.asynchttpclient.resolver.RequestHostnameResolver.resolve(RequestHostnameResolver.java:50) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.resolveAddresses(NettyRequestSender.java:357) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequestWithNewChannel(NettyRequestSender.java:300) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequestWithCertainForceConnect(NettyRequestSender.java:142) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequest(NettyRequestSender.java:113) at play.shaded.ahc.org.asynchttpclient.DefaultAsyncHttpClient.execute(DefaultAsyncHttpClient.java:241) at play.shaded.ahc.org.asynchttpclient.DefaultAsyncHttpClient.executeRequest(DefaultAsyncHttpClient.java:210) at play.api.libs.ws.ahc.StandaloneAhcWSClient.execute(StandaloneAhcWSClient.scala:90) at play.api.libs.ws.ahc.StandaloneAhcWSRequest.$anonfun$execute$1(StandaloneAhcWSRequest.scala:216) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:52) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:51) at com.exalate.replication.services.transport.ExaToExaRequestFilterFactory.$anonfun$create$2(ExaToExaRequestFilterFactory.scala:28) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:52) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:51) at play.api.libs.ws.ahc.StandaloneAhcWSRequest.execute(StandaloneAhcWSRequest.scala:219) at play.api.libs.ws.ahc.AhcWSRequest.execute(AhcWSRequest.scala:264) at com.exalate.replication.services.transport.wrapper.LoggingWsRequest.post(LoggingWsRequest.scala:38) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient.postSyncRequest(SyncResponsesClient.scala:46) at com.exalate.replication.services.transport.v2.TransportService.$anonfun$sendSyncResponse$1(TransportService.scala:83) at scala.concurrent.Future.$anonfun$flatMap$1(Future.scala:307) ... 14 common frames omitted 2022-04-04 07:08:50,623 [ERROR] from application.services.error.ErrorHandler in scala-execution-context-global-41 - Handling general exception com.exalate.api.exception.bug.rest.RestTransportBugException: Unexpected error occurred while communicating with destination side. Exception when posting sync response from sync request `4` for sync event `6648` to `https://jira-sdesk.pp.s2-eu.x.com/sdesk` <a href="https://docs.idalko.com/exalate/x/vQKOAQ" target='_blank' rel='noopener noreferrer'>Generate an exalate support.zip file</a> and contact support. at com.exalate.error.services.BugExceptionCategoryService.generateRestExalateTransportBugException(BugExceptionCategoryService.scala:265) at com.exalate.error.services.ExalateRestErrorResponseCategoryService.$anonfun$categorizeNetworkAndRestResponseException$4(ExalateRestErrorResponseCategoryService.scala:36) at scala.Option.getOrElse(Option.scala:189) at com.exalate.error.services.ExalateRestErrorResponseCategoryService.categorizeNetworkAndRestResponseException(ExalateRestErrorResponseCategoryService.scala:36) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient$$anonfun$postSyncRequest$3.applyOrElse(SyncResponsesClient.scala:54) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient$$anonfun$postSyncRequest$3.applyOrElse(SyncResponsesClient.scala:50) at scala.concurrent.Future.$anonfun$recoverWith$1(Future.scala:417) 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: java.net.UnknownHostException: jira-sdesk.pp.s2-eu.x.com: Name or service not known at java.base/java.net.Inet4AddressImpl.lookupAllHostAddr(Native Method) at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(InetAddress.java:929) at java.base/java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1515) at java.base/java.net.InetAddress$NameServiceAddresses.get(InetAddress.java:848) at java.base/java.net.InetAddress.getAllByName0(InetAddress.java:1505) at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1364) at java.base/java.net.InetAddress.getAllByName(InetAddress.java:1298) at play.shaded.ahc.io.netty.util.internal.SocketUtils$9.run(SocketUtils.java:159) at play.shaded.ahc.io.netty.util.internal.SocketUtils$9.run(SocketUtils.java:156) at java.base/java.security.AccessController.doPrivileged(Native Method) at play.shaded.ahc.io.netty.util.internal.SocketUtils.allAddressesByName(SocketUtils.java:156) at play.shaded.ahc.io.netty.resolver.DefaultNameResolver.doResolveAll(DefaultNameResolver.java:52) at play.shaded.ahc.io.netty.resolver.SimpleNameResolver.resolveAll(SimpleNameResolver.java:81) at play.shaded.ahc.io.netty.resolver.SimpleNameResolver.resolveAll(SimpleNameResolver.java:73) at play.shaded.ahc.org.asynchttpclient.resolver.RequestHostnameResolver.resolve(RequestHostnameResolver.java:50) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.resolveAddresses(NettyRequestSender.java:357) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequestWithNewChannel(NettyRequestSender.java:300) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequestWithCertainForceConnect(NettyRequestSender.java:142) at play.shaded.ahc.org.asynchttpclient.netty.request.NettyRequestSender.sendRequest(NettyRequestSender.java:113) at play.shaded.ahc.org.asynchttpclient.DefaultAsyncHttpClient.execute(DefaultAsyncHttpClient.java:241) at play.shaded.ahc.org.asynchttpclient.DefaultAsyncHttpClient.executeRequest(DefaultAsyncHttpClient.java:210) at play.api.libs.ws.ahc.StandaloneAhcWSClient.execute(StandaloneAhcWSClient.scala:90) at play.api.libs.ws.ahc.StandaloneAhcWSRequest.$anonfun$execute$1(StandaloneAhcWSRequest.scala:216) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:52) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:51) at com.exalate.replication.services.transport.ExaToExaRequestFilterFactory.$anonfun$create$2(ExaToExaRequestFilterFactory.scala:28) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:52) at play.api.libs.ws.WSRequestExecutor$$anon$2.apply(WSRequestFilter.scala:51) at play.api.libs.ws.ahc.StandaloneAhcWSRequest.execute(StandaloneAhcWSRequest.scala:219) at play.api.libs.ws.ahc.AhcWSRequest.execute(AhcWSRequest.scala:264) at com.exalate.replication.services.transport.wrapper.LoggingWsRequest.post(LoggingWsRequest.scala:38) at com.exalate.replication.services.transport.v1.rest.SyncResponsesClient.postSyncRequest(SyncResponsesClient.scala:46) at com.exalate.replication.services.transport.v2.TransportService.$anonfun$sendSyncResponse$1(TransportService.scala:83) at scala.concurrent.Future.$anonfun$flatMap$1(Future.scala:307) ... 14 common frames omitted 2022-04-04 07:08:56,758 [INFO] from application.services.replication.worker.SupportZipWorkerActor in application-akka.actor.default-dispatcher-7 - SupportZipWorkerActor:Generating support zip
Thanks,
Vedant
Add your comment...
Hi There,
We are trying to share data from SNow to Jira, but on every new connection, we are getting the below error. We did try with one-directional synching i.e. SNow to Jira. On the Jira end, there are no restrictions at the field level.
Outgoing Sync:
Incoming Sync:
We are trying to use default sync rules only, first to validate the summary field sync. However, we getting the below error at the SNow end only. No incoming connection at the Jira end.
Please suggest some workaround.
Thanks
Hello, Vedant Kulkarni , is your Exalate for ServiceNow hosted on-premise or in Exalate Cloud?
(in other words: what is your Exalate for ServiceNow URL)?
Regards, Serhiy.
Serhiy Onyshchenko , Exalate for ServiceNow is hosted in Exalate Cloud.
Exalate Cloud URL: https://snownode-ddek-kskq-wotl-scjc.exalate.cloud/connections
Host URL: sncapappsfrancetraining.service-now.com