Morning all, We have a customer that is using a stored procedure in MSSQL2K on the client machine(WinXP-Sp2 Pro) to connect to their UniVerse 10.1.11 server (Win2K3-Sp1 standard) via an ODBC System DSN and the UVODBC 10.1a driver. The goal is to dump the data nightly into their data warehouse. We have installed test data (~8000x500 - approx. 4M fields), and they have scheduled the query. The query takes approx. 5 minutes to execute and return all of the data. We appear to run into an issue where the query executes fine 18 times, then will give this error in the MSSQL log on every subsequent query:
Job 'TH_MB_Test' : Step 2, 'Stage_UniVerse' : Began Executing 2005-09-26 16:00:02 Msg 7399, Sev 16: OLE DB provider 'MSDASQL' reported an error. [SQLSTATE 42000] Msg 7312, Sev 16: Error ID: 1 Severity: FATAL Facility: .] [SQLSTATE 01000] Msg 7300, Sev 16: OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ]. [SQLSTATE 01000] The issue is resolved by restarting the MSSQL service. The paging file and the MSSQL process' memory consumption increase with each query. We are wondering if anyone has previous experience with this type of setup, has encountered this issue, and/or can help us determine if it is an issue with the driver, the operating system, or MSSQL. Thanks, Robert Balousek Mortgage Builder Software, Inc. (248)304-0600 ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
