View Source

{kb-symptom}

File Restore can only be performed in batches of 30 to 40 files. Restoring more files generates the following errors:

{code}ERROR - The data in this BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be committed, its connection closed or it has been freed. {code}

and

{code}org.hibernate.exception.GenericJDBCException: could not execute query[SQL: 30000, XJ073] {code}

{kb-resolution}

The issue has been corrected in CDP 4.2.0. Up to 30,000 files located in a single directory can now be restored without problems.


{kb-related-articles}