We are trying to extract the data from azure blob ...
# troubleshooting
s
We are trying to extract the data from azure blob storage using tap-spreadsheets-anywhere extractor and loading it to local machine using target-csv loader below is my meltano.yml file version: 1 default_environment: dev project_id: c6750c09-214e-4641-bf13-8e02e7d89f30 environments: - name: dev - name: staging - name: prod plugins: extractors: - name: tap-spreadsheets-anywhere variant: ets pip_url: git+https://github.com/ets/tap-spreadsheets-anywhere.git config: tables: - path: azure://d0s-proto/ name: e pattern: .*\.csv start_date: '2023-11-20T110253Z' key_properties: [] format: csv loaders: - name: target-csv variant: singer-io pip_url: target-csv config: destination_path: C:\meltano-project1 I'm getting below error, please suggest how to resolve this. BrokenPipeError: [WinError 109] The pipe has been ended Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() │ 573 │ │ │ except OSError as exc: │ │ 574 │ │ │ │ if exc.winerror in (_overlapped.ERROR_NETNAME_DELETED, │ │ 575 │ │ │ │ │ │ │ │ │ _overlapped.ERROR_OPERATION_ABORTED): │ ╰──────────────────────────────────────────────────────────────────────────────────────────────────╯ BrokenPipeError: [WinError 109] The pipe has been ended Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() │ 574 │ │ │ │ if exc.winerror in (_overlapped.ERROR_NETNAME_DELETED, │ │ 575 │ │ │ │ │ │ │ │ │ _overlapped.ERROR_OPERATION_ABORTED): │ ╰──────────────────────────────────────────────────────────────────────────────────────────────────╯ BrokenPipeError: [WinError 109] The pipe has been ended Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() ╰──────────────────────────────────────────────────────────────────────────────────────────────────╯ BrokenPipeError: [WinError 109] The pipe has been ended Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() Exception ignored in: <function BaseSubprocessTransport.del at 0x000002C596FD91C0> Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close Traceback (most recent call last): File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 126, in del self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close self.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_subprocess.py", line 104, in close proto.pipe.close() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\proactor_events.py", line 109, in close self._loop.call_soon(self._call_connection_lost, None) File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 761, in call_soon self._check_closed() File "C:\Users\E109887\AppData\Local\Programs\Python\Python311\Lib\asyncio\base_events.py", line 519, in _check_closed raise RuntimeError('Event loop is closed') RuntimeError: Event loop is closed
e
Hi @Sai krishna Guduru. What command did you run?
s
Hi @Edgar Ramírez (Arch.dev) Thank you for your prompt response. I ran below command. meltano run tap-spreadsheets-anywhere target-csv