On Tue, Jun 3, 2014 at 6:28 PM, Shawn Heisey <s...@elyograg.org> wrote:
> On 6/3/2014 3:04 AM, Aniket Bhoi wrote: > > I changed the value of removeAbandoned to false,this time the indexing > > failed due to a different exception: > > <snip> > > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection > > reset > > This is really the same error, but now the dataimport handler actually > sees the connection reset, rather than a higher level problem. > > Something somewhere closed the connection. If you have increased > maxMergeCount to at least 6 and turned off removeAbandoned, then I have > no idea what is happening. Perhaps the SQL Server itself has a very low > inactivity timeout value. > > Thanks, > Shawn > > I changed the indexing query in dataconfig to index data for the last 6months.That seemed to worked.Why is then failing if I index the whole data load.Something to do with the same stale connection being used in the connection pool or are the threads not sufficient ??.