# Import Data Failure using COPY CLI

**URL:** <https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758>\
**Category:** General\
**Created:** [September 7, 2022, 11:43pm UTC](https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758 "2022-09-07T23:43:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tyuengithub](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/tyuengithub/32/561_2.png) [@tyuengithub](https://forum.yugabyte.com/u/tyuengithub)\
**Post date:** [September 7, 2022, 11:43pm UTC](https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758/1 "2022-09-07T23:43:05Z")

</div>

Hi,  
I’m using CLI “copy” to import data, but getting the below error

**Command**  
cqlsh ybyte-server01 -e "copy matchingstage.strongkeyNewTestV2 FROM ‘matchingstage.strongkey.20220907.csv’ with delimiter=‘|’ and header=true and NUMPROCESSES=2 AND INGESTRATE=25000 "

**Error Message:**  
:1:Failed to import 20 rows: ServerError - Transaction expired or aborted by a conflict: 40001 (pgsql error 40001) (transaction error 1), will retry later, attempt 1 of 5  
:1:Failed to import 20 rows: ServerError - Transaction expired or aborted by a conflict: 40001 (pgsql error 40001) (transaction error 1), will retry later, attempt 1 of 5

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [September 8, 2022, 10:58am UTC](https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758/2 "2022-09-08T10:58:05Z")

</div>

@tyuengithub can you try with our fork ycqlsh [ycqlsh - YCQL shell for YugabyteDB | YugabyteDB Docs](https://docs.yugabyte.com/preview/admin/ycqlsh/) ?

---

<div class="post-metadata">

**Author:** ![tyuengithub](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/tyuengithub/32/561_2.png) [@tyuengithub](https://forum.yugabyte.com/u/tyuengithub)\
**Post date:** [September 9, 2022, 12:03am UTC](https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758/3 "2022-09-09T00:03:10Z")

</div>

Hi Dorian,

I don’t have access to server and my laptop’s OS is Window. Hence, I don’t have the yugabyte install where I can fork ycqlsh.

Regards,  
Tommy

---

<div class="post-metadata">

**Author:** ![dorian\_yugabyte](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.yugabyte.com/dorian_yugabyte/32/206_2.png) [@dorian\_yugabyte](https://forum.yugabyte.com/u/dorian_yugabyte)\
**Post date:** [September 9, 2022, 7:38am UTC](https://forum.yugabyte.com/t/import-data-failure-using-copy-cli/1758/4 "2022-09-09T07:38:59Z")

</div>

> [@tyuengithub](#):
>
> I don’t have access to server and my laptop’s OS is Window. Hence, I don’t have the yugabyte install where I can fork ycqlsh.

Please install yugabyte and try it with ycqlsh.