Possible cause: The compareset table contains hundreds of columns, which results in the DA agent creating a large select query string. This query string can be sufficiently large that the database server does not have enough internal stack space to process the query.
Use any one of these solutions:
- Increase the stack space in the database server using the Adaptive Server stored procedure, sp_configure.
- If the DA server configuration parameter db_hash_ase_ignore_null is set to false, set it to true; this decreases the size of the select query string.
- Create two new comparesets, each of which compares one distinct half of the database table, then create two new comparisons to replace your current comparison, so the database table is fully compared using the two comparesets in two phases.