Compare fails with Errors: "Unable to allocate xxx bytes" and "Internal error: Error 1 in de_batc (4264136)

Compare fails with Errors: "Unable to allocate xxx bytes" and "Internal error: Error 1 in de_batc

Compare fails and event log reports the following errors:

"Process launched: sp_desvr (for verpd) [pid = 13829]
Notice: Opened Compare session log file /apps/quest/sp01/var/2998/log/verpd_desvr-13829- [sp_desvr(deq)/13829]
Notice: Oracle env - verpd:/apps/oracle/u001/product/9.2.0/verpd [sp_desvr(pdb)/13829]
Child process completed
Error: Unable to allocate 9640000 bytes (de_select_alloc_for_column_data,L1141) [sp_desvr(deq)/13829]
Error: Unable to allocate 9640000 bytes (de_select_alloc_for_column_data,L1141) [sp_desvr(deq)/13829]
Internal error: Error 1 in de_batch_setup, see verpd_desvr-13829-*.log [sp_desvr(deq)/13829]
Process exited sp_desvr (for verpd) [pid = 13829] - exit(0)"
*******************************************************************************************************
Error allocating 272 bytes for key_data in de_key_alloc_node
000: Error 1 calling de_key_alloc_node in de_key_add
000: Error 1 calling de_key_add in de_compare_client1 (2146)

This indicates a resource issue.

The SP_DEQ_BATCHSIZE parameter controls the batch size that SharePlex uses for the compare/repair function when the compare config or compare table command is issued. Reducing the size of the SP_DEQ_BATCHSIZE parameter on the source will reduce the memory requirements for compare and will allow it to run successfully.

Try reducing it from the default 10000 to 5000 as mentioned below and run the compare again.

On the source set the parameter via sp_ctrl:
sp_ctrl>list param all compare (check the setting for this parameter)
sp_ctrl> set param SP_DEQ_BATCHSIZE 5000
sp_ctrl> compare table......

To revert the parameter back to the original value:
sp_ctrl> set param sp_deq_batchsize 10000

For more Details about SP_DEQ_BATCHSIZE Parameter please refer the Shareplex Reference Guide.

If you are using Oracle 10G another work around would be to increase UNDO tablespace instead of decreasing SP_DEQ_BATCHSIZE.

The parameter SP_DEQ_BATCHSIZE has been deprecated in later versions of SharePlex and is replaced by the parameter SP_DEQ_MALLOC. Here is the description of the parameter SP_DEQ_MALLOC: SP_DEQ_MALLOC This parameter controls the fetch batch size. The batch size controls the number of rows that SharePlex selects at once for comparison. Larger batch sizes increase processing speed but require more memory. The value is divided equally by the number of compare threads to be used, and then the batch size is recalculated based on all column sizes added together. Default: 500 (MB) Range of valid values: 50 to 32,767 (MB) Takes effect: Immediately available for the next comparison. Please refer to knowledge base article # 124140 for differences in these two approaches for controlling the batch size of compare/repair.