I have TDM 10.2.0 HF1 instance running on Windows 2016, configured a job to execute data domain profiling on Source SQL server 2014 DB. It went successful for few tables and failed for few tables with below error.
SEVERE: [RR_4035] SQL Error [FnName: Fetch Optimize -- [Microsoft][ODBC Driver Manager] Function sequence error].
SEVERE: [BLKR_16034] ERROR: Fetch failed.
has anyone faced this issue before, any inputs\solution would be much appreciated.
Maybe you could re-structure those profiling jobs such that the "packets" (numbers of tables to profile, numbers of records per profile, and so on) of work are smaller than right now. That might help; profiling is CPU-intensive work, so performing "smaller" profiling jobs will less likely exhaust system resources.