# Uncategorized SQLException error

**URL:** <https://community.crossref.org/t/uncategorized-sqlexception-error/13106>\
**Category:** XML Deposit\
**Tags:** content-registration, deposit\_support, submission\_log\
**Created:** [27 January 2025 15:15 UTC](https://community.crossref.org/t/uncategorized-sqlexception-error/13106 "2025-01-27T15:15:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mklem](https://avatars.discourse-cdn.com/v4/letter/m/65b543/32.png) [@mklem](https://community.crossref.org/u/mklem)\
**Post date:** [27 January 2025 15:15 UTC](https://community.crossref.org/t/uncategorized-sqlexception-error/13106/1 "2025-01-27T15:15:44Z")

</div>

Received these errors this morning:

| **batch\_id:** | apsxref:b43df455-90c5-4ca0-ae30-e8a0003edda6 |
| --- | --- |
| **doi:** | 10.1103/PhysRevD.110.116017 |
| **msg:** | PreparedStatementCallback; uncategorized SQLException for SQL [insert into xref.general\_rels (CLAIMANT\_ID,CLAIMANT\_CITEID,CLAIMANT\_TYPE,DESCRIPTION,DELETED,RECORD\_UPDATED,TARGET\_CITEID,TARGET\_ID,TYPE) values (?, ?, ?, ?, ‘N’, ?, ?, ?, ?) on conflict do nothing]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block |
| **submission\_id:** | 1668582337 |

| **batch\_id:** | apsxref:e61fb3d5-d457-40aa-b5fa-d12161dc1b4e |
| --- | --- |
| **doi:** | 10.1103/PhysRevD.110.116026 |
| **msg:** | PreparedStatementCallback; uncategorized SQLException for SQL [insert into xref.general\_rels (CLAIMANT\_ID,CLAIMANT\_CITEID,CLAIMANT\_TYPE,DESCRIPTION,DELETED,RECORD\_UPDATED,TARGET\_CITEID,TARGET\_ID,TYPE) values (?, ?, ?, ?, ‘N’, ?, ?, ?, ?) on conflict do nothing]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block |
| **submission\_id:** | 1668581676 |

---

<div class="post-metadata">

**Author:** ![ifarley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.crossref.org/ifarley/32/44_2.png) [@ifarley](https://community.crossref.org/u/ifarley)\
**Post date:** [27 January 2025 19:12 UTC](https://community.crossref.org/t/uncategorized-sqlexception-error/13106/2 "2025-01-27T19:12:11Z")

</div>

Hello again @mklem ,

These are also errors on our end. I have rerun the submissions and both were processed successfully.

Warm regards,  
Isaac