I have an SQL2000 database running Gentran applications. I am seeing reports that the Schedule purge errors. Apparently this is because the transaction log is full.
However, if I alter either the DB size or Transaction log, using Enterprise manager, after about an hour they revert to the original. There are no hourly schedules running.
There has been an error on one of the processes on the ****** server. Some of the details are below, please take appropriate action thank you.
Details
Server Name:
*******
Error Type:
BUSINESS_PROCES S
Process Name:
Schedule_PurgeS ervice
Process ID:
3071362
Start Time:
12/13/10 1:38:56 PM
Current State:
COMPLETE
Status:
ERROR
eventType: Pool.PoolManage r.maxPoolSizeRe ached.3
ExceptionLevel: Exceptional
timestamp: 1292255318348
datetime: 2010.12.13 15:48:38 GMT
message: WARNING!!! Pool maximum size exceeded 1 times in 300000(ms). Consider increasing MaxSize on pool: mssqlPool_NoTra ns
subject: Pool (mssqlPool_NoTr ans) maximum size exceeded
However, if I alter either the DB size or Transaction log, using Enterprise manager, after about an hour they revert to the original. There are no hourly schedules running.
There has been an error on one of the processes on the ****** server. Some of the details are below, please take appropriate action thank you.
Details
Server Name:
*******
Error Type:
BUSINESS_PROCES S
Process Name:
Schedule_PurgeS ervice
Process ID:
3071362
Start Time:
12/13/10 1:38:56 PM
Current State:
COMPLETE
Status:
ERROR
eventType: Pool.PoolManage r.maxPoolSizeRe ached.3
ExceptionLevel: Exceptional
timestamp: 1292255318348
datetime: 2010.12.13 15:48:38 GMT
message: WARNING!!! Pool maximum size exceeded 1 times in 300000(ms). Consider increasing MaxSize on pool: mssqlPool_NoTra ns
subject: Pool (mssqlPool_NoTr ans) maximum size exceeded