API tools faq
paste
Advertisement
Guest User

get sippeer with term host

a guest
Apr 27th, 2015
192
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.12 KB | None | 0 0
raw download clone embed print report
  1. SELECT sip.id AS sip_peer_id,pips.idprofile_ips AS ip,pips.port AS port,p.name AS attribute_name,p.value AS attribute_value FROM sippeer AS sip JOIN sippeer_term_gateway_xref AS gateway ON sip.id = gateway.sippeer_id LEFT JOIN profile_ips AS pips ON gateway.gateway = pips.idprofile_ips LEFT JOIN profiles AS p ON pips.profile_id = p.profile_id WHERE sip.site_id = 709 AND sip.id = 500334 ORDER BY ip,port
  2. 2015-04-27 12:02:54,822 [SipPeerWorkerThread-1] INFO jdbc.sqlonly.228 - select premise_trunks from sippeer_premise_trunks where sippeer_id = 500334
  3. 2015-04-27 12:02:54,822 [SipPeerWorkerThread-1] INFO jdbc.sqlonly.228 - SELECT * FROM sip_peer_line_option_capability WHERE sippeer_id = 500334
  4. 2015-04-27 12:02:54,823 [SipPeerWorkerThread-1] INFO jdbc.sqlonly.228 - SELECT * FROM vw_account_product_feature WHERE account_id = 12346227 AND product_name = 'DedicatedPrivateNetworkTopology'
  5. 2015-04-27 12:02:54,825 [SipPeerWorkerThread-1] ERROR com.inetwork.common.requesthandler.AbstractRequestHandler.79 - Unhandled exception thrown! errorId: 682fa3ca-b5ea-4146-a0f4-f7c347181e0e, Request: HubSipPeerRequest{requestType=RETRIEVE, accountId=12346227, payload=HubSipPeer{peerId=500334, isDefaultPeer=false}, requestId=0d520b9d-7a51-4890-90c8-02d8094be51e, siteId=709}
  6. java.lang.NullPointerException: null
  7. at com.inetwork.common.model.sippeer.AbstractSipPeerRetrievalService.generateTerminationHosts(AbstractSipPeerRetrievalService.java:104) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  8. at com.inetwork.common.model.sippeer.AbstractSipPeerRetrievalService.generateSipPeer(AbstractSipPeerRetrievalService.java:85) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  9. at com.inetwork.common.model.sippeer.SipPeerRetrievalService.findSipPeer(SipPeerRetrievalService.java:39) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  10. at com.inetwork.sippeer.model.handler.ProductSpecificSipPeerRequestHandler.handleRetrieveRequestWithSingleResponse(ProductSpecificSipPeerRequestHandler.java:173) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  11. at com.inetwork.sippeer.model.handler.ProductSpecificSipPeerRequestHandler.handleRetrieveRequestWithSingleResponse(ProductSpecificSipPeerRequestHandler.java:25) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  12. at com.inetwork.common.requesthandler.SingleResponseRequestHandler.handleRetrieveRequest(SingleResponseRequestHandler.java:45) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  13. at com.inetwork.common.requesthandler.SingleResponseRequestHandler.handleRetrieveRequest(SingleResponseRequestHandler.java:21) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  14. at com.inetwork.common.requesthandler.AbstractRequestHandler.handle(AbstractRequestHandler.java:57) ~[SipPeer-0.0.1-SNAPSHOT.jar:na]
  15. at com.inetwork.common.requesthandler.MessageProcessor.processMessage(MessageProcessor.java:35) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  16. at com.inetwork.common.worker.IrisWorkerService.processMessage(IrisWorkerService.java:29) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  17. at com.inetwork.common.worker.WorkerService.handleMessage(WorkerService.java:33) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  18. at com.inetwork.common.messaging.container.IrisMessageListener.onMessage(IrisMessageListener.java:34) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  19. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:799) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  20. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:690) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  21. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.access$001(SimpleMessageListenerContainer.java:82) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  22. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$1.invokeListener(SimpleMessageListenerContainer.java:167) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  23. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.invokeListener(SimpleMessageListenerContainer.java:1241) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  24. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.executeListener(AbstractMessageListenerContainer.java:660) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  25. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.doReceiveAndExecute(SimpleMessageListenerContainer.java:1005) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  26. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.receiveAndExecute(SimpleMessageListenerContainer.java:989) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  27. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.access$700(SimpleMessageListenerContainer.java:82) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  28. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$AsyncMessageProcessingConsumer.run(SimpleMessageListenerContainer.java:1103) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  29. at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]
  30. 2015-04-27 12:02:54,826 [SipPeerWorkerThread-1] INFO com.inetwork.common.requesthandler.RespondingRequestHandler.87 - Request unsuccessfully processed: HubSipPeerRequest{requestType=RETRIEVE, accountId=12346227, payload=HubSipPeer{peerId=500334, isDefaultPeer=false}, requestId=0d520b9d-7a51-4890-90c8-02d8094be51e, siteId=709}
  31. com.inetwork.common.exception.IrisException: errorCode=1010, errorDescription=Something unexpected happened and has been logged (id=682fa3ca-b5ea-4146-a0f4-f7c347181e0e). Please contact Bandwidth support with this error ID to resolve the issue with our development team.
  32. at com.inetwork.common.requesthandler.AbstractRequestHandler.handleException(AbstractRequestHandler.java:80) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  33. at com.inetwork.common.requesthandler.AbstractRequestHandler.handle(AbstractRequestHandler.java:66) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  34. at com.inetwork.common.requesthandler.MessageProcessor.processMessage(MessageProcessor.java:35) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  35. at com.inetwork.common.worker.IrisWorkerService.processMessage(IrisWorkerService.java:29) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  36. at com.inetwork.common.worker.WorkerService.handleMessage(WorkerService.java:33) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  37. at com.inetwork.common.messaging.container.IrisMessageListener.onMessage(IrisMessageListener.java:34) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  38. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:799) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  39. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:690) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  40. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.access$001(SimpleMessageListenerContainer.java:82) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  41. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$1.invokeListener(SimpleMessageListenerContainer.java:167) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  42. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.invokeListener(SimpleMessageListenerContainer.java:1241) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  43. at org.springframework.amqp.rabbit.listener.AbstractMessageListenerContainer.executeListener(AbstractMessageListenerContainer.java:660) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  44. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.doReceiveAndExecute(SimpleMessageListenerContainer.java:1005) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  45. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.receiveAndExecute(SimpleMessageListenerContainer.java:989) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  46. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer.access$700(SimpleMessageListenerContainer.java:82) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  47. at org.springframework.amqp.rabbit.listener.SimpleMessageListenerContainer$AsyncMessageProcessingConsumer.run(SimpleMessageListenerContainer.java:1103) [SipPeer-0.0.1-SNAPSHOT.jar:na]
  48. at java.lang.Thread.run(Thread.java:745) [na:1.7.0_67]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!