Lock table overflow error on Production but not Development
Posted on 2007-12-05
I have several SSIS jobs that import data from a Progress 9.1D database. The last job I built runs fine with in Visual Studio 2005, where I designed it,
It also runs fine from my Developer version of SQL 2005, and it will run fine if I execute my package directly from my Production Integrated Services server, but I get
a table lock error when I try to run it from my production Job Agent. Here is the Error
Executed as user: OGI\sqlAdmin. ...rsion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:38:11 PM Error: 2007-12-05 13:38:36.64 Code: 0xC0047062 Source: Data Flow Task Script Component 1  Description: System.Data.Odbc.OdbcException: ERROR [HY000] [MERANT][ODBC PROGRESS driver][PROGRESS]Lock table overflow, increase -L on server (915) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32 outputIDs, PipelineBuffer buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90 wrapper, Int32 outputs, Int32 outputIDs, IDTSBuffer90 buffers, IntPtr ppBufferWirePacket) End Error Error: 2007-12-05 13:38:36.64 Code: 0xC0047038 Source: Data Flow Task DTS.Pipeline Description: SSIS Error Code DTS_E... The package execution fa... The step failed.
I think it's a bogus error because if Progress was the problem, it would give me the same error from my development box. Both ODBC Drivers are set up identically. The Production box runs in a Cluster environment.
Any help or insight would be greatly appreciated.