none
CTS flow error indexing large database RRS feed

  • Question

  • Hi,

    when we try to run a CTS flow, which is indexing a database with ~1.5 million records, we get the following error (after the flow reads around 25000 records):

    „Invocation of method Refres failed on all available service instances“ (as shown here http://imageshack.us/f/713/ctserror1.png/ ).

    If we try to wait for another 10 seconds, we get another error: „Object reference not set to an instance of an object.“ (as shown here http://imageshack.us/f/401/ctserror2.png/ ).

    FSIS is deployed on 4 different servers  – ESP, FSIS CTS, FSIS IMS and  FSIS admin servers.

    When we try to run the same CTS flow on another  FSIS server (our development server where ESP, CTS, IMS are all installed on the same machine), flow fails with a different exception (as shown here http://imageshack.us/f/821/ctserror3.png/ ):

    04/10/2012 08:07:06.816 Failing Cause: Evaluation failure. An evalution thread threw an exception.

    Exception type: Microsoft.Ceres.Evaluation.DataModel.EvaluationException

    Exception message: Evaluation failed in operator DatabaseReader of type DatabaseReader“

    Same flow was already used succesfully to index a different database server, do you know any reason why it would fail like this with another server?

    We are using SQL Server 2008.

    Thanks in advance!!

    Thursday, October 4, 2012 8:39 AM