# Capstone 2 Extracting remote data

**URL:** <https://forum.kx.com/t/capstone-2-extracting-remote-data/14015>\
**Category:** Academy Support\
**Tags:** kx-academy, imported\
**Created:** [July 31, 2024, 6:21pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015 "2024-07-31T18:21:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpandza](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/jpandza/32/128_2.png) [@jpandza](https://forum.kx.com/u/jpandza)\
**Post date:** [July 31, 2024, 6:21pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/1 "2024-07-31T18:21:45Z")

</div>

[https://learninghub.kx.com/forums/topic/capstone-2-extracting-remote-data](https://learninghub.kx.com/forums/topic/capstone-2-extracting-remote-data)

Hi, I'm trying to get recertified for the developer courses and I'm currently working on capstone 2. I'm having some issues with the IPC portions of the project, namely 1.4, 1.5 and 1.6. After running _ps -ef | grep 5010 in the terminal,_ I see no evidence of the 'Reference data process' being active. After running _refServiceHandle: hopen `::5010_ or any permeations of that command, I get the error:

```
evaluation error:

hop. OS reports: Connection refused
```

Otherwise, I’m not sure what is wrong with my commands in the ‘extracting remote data’ portion of the capstone:  
1.4 refServiceHandle: hopen `::5010  
1.5 refServiceHandle “getOptionsRef[uniqueOpts]”

Thank you in advance for the help.

---

<div class="post-metadata">

**Author:** ![mmcparland](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/mmcparland/32/54_2.png) [@mmcparland](https://forum.kx.com/u/mmcparland)\
**Post date:** [August 1, 2024, 12:56pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/2 "2024-08-01T12:56:04Z")

</div>

Hi @jpandza

When you say you ran "_ps -ef | grep 5010"_ in the terminal, can you share a screenshot of where exactly ?

All code should be ran in KX Developer, in either the scratchpad or the rendered markdown file.

Many thanks,

Megan

---

<div class="post-metadata">

**Author:** ![jpandza](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/jpandza/32/128_2.png) [@jpandza](https://forum.kx.com/u/jpandza)\
**Post date:** [August 1, 2024, 1:43pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/3 "2024-08-01T13:43:10Z")

</div>

Hi Megan,

Please see screenshot below. After opening the capstone for the first time, I run the setup command and use the scratchpad as suggested, then I proceed with the first couple of questions, but when I finally get to connecting to port 5010, the connection is refused. Then I open a new tab, choose the terminal option and enter this to see if 5010 is in use. I assume there's an additional command I must have missed or failed to execute before. Thanks,

Jaka

---

<div class="post-metadata">

**Author:** ![mmcparland](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/mmcparland/32/54_2.png) [@mmcparland](https://forum.kx.com/u/mmcparland)\
**Post date:** [August 1, 2024, 2:25pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/4 "2024-08-01T14:25:26Z")

</div>

Hi @jpandza

So after running the **./setup.sh** command in the terminal, go back to Launcher and click 'KX Developer'.

This will launch an instance of the capstone titled 'funds\_capstone'. Open this up and inside you will find the the project.md file. All code must be ran within the scratchpad or the rendered markdown file for you to pass.

If you have any questions about this, please feel free to reach out.

Many thanks,

Megan

---

<div class="post-metadata">

**Author:** ![jpandza](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/jpandza/32/128_2.png) [@jpandza](https://forum.kx.com/u/jpandza)\
**Post date:** [August 1, 2024, 4:39pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/5 "2024-08-01T16:39:45Z")

</div>

Hi Megan,

After following your steps and running the code in scratchpad, I was still met with the "Blocked" error message on a simple calculation.

---

<div class="post-metadata">

**Author:** ![mwoods](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/mwoods/32/35_2.png) [@mwoods](https://forum.kx.com/u/mwoods)\
**Post date:** [August 7, 2024, 9:53am UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/6 "2024-08-07T09:53:15Z")

</div>

@jpandza The Blocked message is correct, the capstone has been setup such that process 5010 is restricted in that it only allowes calls to 2 APIs as detailed in the instructions.

---

<div class="post-metadata">

**Author:** ![diwan.work1902](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/diwan.work1902/32/128_2.png) [@diwan.work1902](https://forum.kx.com/u/diwan.work1902)\
**Post date:** [August 17, 2025, 11:32pm UTC](https://forum.kx.com/t/capstone-2-extracting-remote-data/14015/7 "2025-08-17T23:32:04Z")

</div>

Hi @mwoods @jpandza I am facing the same issue, running below-  
refServiceHandle:hopen `::5457  
uniqueOpts: select distinct option\_id from trade  
refServiceHandle(`getOptionRef;uniqueOpts)
