# RUN IN TRANSACTION error

**URL:** <https://community.neo4j.com/t/run-in-transaction-error/54574>\
**Category:** Cypher\
**Tags:** cypher\
**Created:** [April 8, 2022, 9:00am UTC](https://community.neo4j.com/t/run-in-transaction-error/54574 "2022-04-08T09:00:54Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![paolodipietro58](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/paolodipietro58/32/21045_2.png) [@paolodipietro58](https://community.neo4j.com/u/paolodipietro58)\
**Post date:** [April 8, 2022, 9:00am UTC](https://community.neo4j.com/t/run-in-transaction-error/54574/1 "2022-04-08T09:00:54Z")

</div>

Running neo4j Community server 4.4.5 on Ubuntu 20.04

I have the following query:

```auto
LOAD CSV WITH HEADERS FROM 'file:///asset_statuses.csv' AS row FIELDTERMINATOR ';'

call {
	WITH row

	CREATE (asset_statuses:AssetStatus)
			SET asset_statuses=row,
				asset_statuses.uuid=apoc.create.uuid()

			WITH asset_statuses,row

			MATCH (asset:Asset { id: row.asset_id})
			MERGE (asset)-[:HAS_STATUS]->(asset_statuses)

	} IN TRANSACTIONS OF 1000 ROWS

	RETURN row

```

I avoided `PERIODIC COMMIT` because it is discouraged and will be discontinued, but the query ì, which is (seems to be) exactly equal to the example, returns the following error:

```auto
Neo.DatabaseError.Statement.ExecutionFailed: A query with 'CALL { ... } IN TRANSACTIONS' can only be executed in an implicit transaction, but tried to execute in an explicit transaction.

```

Any suggestion?

---

<div class="post-metadata">

**Author:** ![dana\_canzano](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/dana_canzano/32/27392_2.png) [@dana\_canzano](https://community.neo4j.com/u/dana_canzano)\
**Post date:** [April 8, 2022, 10:35am UTC](https://community.neo4j.com/t/run-in-transaction-error/54574/2 "2022-04-08T10:35:01Z")

</div>

@paolodipietro58

are you running the query via the Neo4j Browser or bin/cypher-shell ? or some other client?

If run through the Neo4j Browser, preface the query with `:auto`

---

<div class="post-metadata">

**Author:** ![paolodipietro58](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/paolodipietro58/32/21045_2.png) [@paolodipietro58](https://community.neo4j.com/u/paolodipietro58)\
**Post date:** [April 8, 2022, 10:42am UTC](https://community.neo4j.com/t/run-in-transaction-error/54574/3 "2022-04-08T10:42:17Z")

</div>

I'm running via the Neo4j Browser. Where do I put `:auto`?

---

<div class="post-metadata">

**Author:** ![dana\_canzano](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/dana_canzano/32/27392_2.png) [@dana\_canzano](https://community.neo4j.com/u/dana_canzano)\
**Post date:** [April 8, 2022, 10:50am UTC](https://community.neo4j.com/t/run-in-transaction-error/54574/4 "2022-04-08T10:50:42Z")

</div>

@paolodipietro58

 ![auto](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/4/7/47766362b9a5df74653fb8cf523b9d8e723f93bd.png)

---

<div class="post-metadata">

**Author:** ![paolodipietro58](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/paolodipietro58/32/21045_2.png) [@paolodipietro58](https://community.neo4j.com/u/paolodipietro58)\
**Post date:** [April 8, 2022, 12:46pm UTC](https://community.neo4j.com/t/run-in-transaction-error/54574/5 "2022-04-08T12:46:22Z")

</div>

@dana_canzano Well, it run and load the data, but at the end it retured this error `ailed to execute 'postMessage' on 'DedicatedWorkerGlobalScope': Data cannot be cloned, out of memory.`.

It looks strange, as there is a lot of memory and the swap file has not been used.