Error during large RIS import

dstillman Zotero Team
This discussion was created from comments split from: OpenAlex Exports Names too long.
  • sdspieg
    Any updates on this?

    I have a much larger >500k OpenAlex API-exported json file that I converted programmatically to RIS AND to bibtex (and which I'd be happy to share with anaybody who'd want to check as - maybe - an 'edge case'). When I try to import them into Zotero, I get the following (report ID 666617473 - 1,118 records import correctly, the rest not). :Oh and also - does importing bibtex vs ris make a difference (in terms of speed/probability of correct importing)

    [JavaScript Error: "XML Parsing Error: syntax error
    Location: moz-nullprincipal:{cc6a82c2-0fb2-4b6a-afb6-3de040983f64}
    Line Number 1, Column 1:" {file: "moz-nullprincipal:{cc6a82c2-0fb2-4b6a-afb6-3de040983f64}" line: 1 column: 1 source: "Provider: OpenAlex"}]

    [JavaScript Error: "XML Parsing Error: syntax error
    Location: moz-nullprincipal:{4e0de979-7593-425a-9a4c-d11a45ca154e}
    Line Number 1, Column 1:" {file: "moz-nullprincipal:{4e0de979-7593-425a-9a4c-d11a45ca154e}" line: 1 column: 1 source: "Provider: OpenAlex"}]

    [JavaScript Error: "XML Parsing Error: syntax error
    Location: moz-nullprincipal:{00a2a60f-cdc5-432d-9f2b-99fb2c9f214b}
    Line Number 1, Column 1:" {file: "moz-nullprincipal:{00a2a60f-cdc5-432d-9f2b-99fb2c9f214b}" line: 1 column: 1 source: "Provider: OpenAlex"}]

    [JavaScript Error: "XML Parsing Error: syntax error
    Location: moz-nullprincipal:{42c0d1ab-5c3a-44a6-aa2a-484a74b846cc}
    Line Number 1, Column 1:" {file: "moz-nullprincipal:{42c0d1ab-5c3a-44a6-aa2a-484a74b846cc}" line: 1 column: 1 source: "Provider: OpenAlex"}]

    [JavaScript Error: "The connection to wss://stream.zotero.org/ has terminated unexpectedly. Some data may have been transferred."]

    [JavaScript Error: "WebSocket connection closed: 1006 "]

    [JavaScript Error: "Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]

    [JavaScript Error: "The connection to wss://stream.zotero.org/ has terminated unexpectedly. Some data may have been transferred."]

    [JavaScript Error: "item.isRegularItem is not a function" {file: "chrome://zotero/content/xpcom/retractions.js" line: 841}]

    [JavaScript Error: "WebSocket connection closed: 1006 "]

    [JavaScript Error: "Error: Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]

    [JavaScript Error: "Error(s) encountered during statement execution: FOREIGN KEY constraint failed [QUERY: INSERT INTO itemNotes (itemID, parentItemID, note, title) VALUES (?,?,?,?)] [PARAMS: 294490, 294489, "

    OpenAlex type: article → RIS: JOUR

    ", "OpenAlex type: article → RIS: JOUR"] [ERROR: FOREIGN KEY constraint failed]" {file: "chrome://zotero/content/xpcom/db.js" line: 705}]

    [JavaScript Error: "Error: Transaction timeout, most likely caused by unresolved pending work." {file: "resource://gre/modules/Sqlite.sys.mjs" line: 1140}]

    [JavaScript Error: "Error: Failed to load resource://gre/modules/PlacesDBUtils.sys.mjs" {file: "chrome://zotero/content/fileInterface.js" line: 397}]
    Zotero_File_Interface Zotero, version => 7.0.24 (x64), os => Windows 11 26100, locale => en-US, extensions =>
  • adamsmith
    edited September 1, 2025
    Not the same issue. The original issue occurs after a successful import. For you, it's somewhat hard to say from the above, but I'd guess either your database is corrupted or (and that would be my guess) you are just hitting performance limits. 500k items are at the outer limits of what Zotero can handle, it's definitely at the outer limits of what it can handle for a single import, so for a start I'd split the file up into 10 or so, which is easy withv ether format.

    I'd guess RIS uses a bit less resources on import. The quality should be similar
Sign In or Register to comment.