FreeTDS Development Group

["Craig A. Berry" <craigberry AT mac.com>]

On Apr 27, 2010, at 2:38 PM, Brian Grellinger wrote:

> Hi,
>
> Using FreeTDS  v0.83.dev.20090104 on AIX
>
> We have a 4GL program that extracts data from a remote MSSQL database,
> extracts additional data from an Informix database, merges the 2 using
> temp tables, and outputs the results to a file.
>
> The MSSQL database is in a remote location accessed via WAN
> connection, the Informix database is on the local network.
> Sometimes it works OK, but most of the time we get this error:
>
> <
> Program stopped at 'o_maxfile.4gl', line number 101.
> SQL statement error number -6372 (-5242).
> [FreeTDS][SQL Server]An inconsistency was detected during an internal
> operation in database 'tempdb'(ID:2) on page (1:5935). Please
> contact technical support. Reference number 6.


That sure sounds like a problem on the server.  Have you run DBCC  
CHECKDB to discover and/or repair problems with tempdb on that instance?
________________________________________
Craig A. Berry
mailto:craigberry AT mac.com

"... getting out of a sonnet is much more
 difficult than getting in."
                 Brad Leithauser