I am warehousing A/Rev records through oinsight (both running on Novell) into a sql 7 database on NT. The error occurs completely at random, ie : not every day ; on a different file every time ; beginning, middle or end of process. Any body encountered this before?
Kathleen,
Are you using the direct connection from OI to SQL 7? The connection is not stable (nor supported by Revelation). If you are connecting with the direct connection, switch to ODBC. The direct connection will only allow you to send a very small number of bytes to SQL at one time, and if you exceed this, it kills the connection to the database, so the next script returns the error "DBprocess dead or not enabled."