Received SQL error

Technical Support
,
1

I received an error from Crossref:

batch_id: apsxref:82eb80a2-48e9-4abc-83f6-0c14379496cb
doi: 10.1103/PhysRevD.111.094041
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: 1698678185

I assume this is an error we should not receive.

Should I try resending this DOI?

2

Hello, and thanks for your message.

Yes, that was definitely an error on our end. I re-ran submission 1698678185 now, to save you the trouble of having to resend it. It’s been reprocessed successfully now.

If you see any other submissions with a SQLException type error, resubmitting them does typically solve the problem. But, if it ever doesn’t, let us know, and we’ll ask our technical team to investigate further.

Best,
Shayn

1 Like