You are seeing the following Oracle errors in the *declt* log for the failed compare:
000: running sql statement : (de_select_prepare_to_fetch,L1532)
000: select rowid, "BMF_TRACKING_ID", "BMF_TRACKING_ID_SERV", "ACCOUNT_NO", "BILL_REF_NO", "BILL_REF_RESETS", "ORIG_BILL_REF_NO", "ORIG_BILL_REF_RESETS", "AMOUNT", "GL_AMOUNT", "DISTRIB_ORDER", "STATUS", "TRANS_DATE", "CHG_DATE", "CHG_WHO", "BMF_TRANS_TYPE", "CURRENCY_GAIN_LOSS", "CURRENCY_CODE", "OPEN_ITEM_ID", "LATE_FEE_STATUS" from "ARBORADM"."BMF_DISTRIBUTION" order by 2, 3, 11
000: Oracle Error 1114: ORA-01114: IO error writing block to file %s (block # %s)
000: Error 1114 calling OCIStmtExecute (de_select_prepare_to_fetch,L1561)
000: Error 1 calling de_select_prepare_to_fetch in de_batch_setup
Compare is failing on target due to space issues.
Compare is running into Oracle error ORA-01114. Here is the description of the Oracle error:
ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.
Shareplex compare process uses temporary segments in database and one needs to correct the underlying space issue. Once these corrective steps are taken, Compare should be able to run successfully barring any other error for which Support can be contacted.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center