Re: Table load fails - "Cannot close blob"

Paul Kiesel (kiesel@vishnu.ueci.com) wrote: : Gentleman and Ladies, : On a nightly basis we are unloading data from one table on a remote : system, transmitting the data to our local system, and loading the : data into an analogous table on our local system. : The following error is recevied when loading the local table with : data from a remote database : <deletia> : Checking table status, in fact only 31972 rows have been loaded, : there should be ~ 50000 rows. : We have checked the load file for missing column delimiters, corrupt data, : etc, and have found nothing appearing out of order. Paul: Check your online.log. I'll bet you're either running out of locks or are getting into a long transaction. The error messages that come back when this happens are not always helpful and are often red herrings. If you're getting either of these problems, do the load with DBLOAD, not LOAD. Good Luck, Joe : Paul Kiesel : CADD /CAE - Information Systems : Raytheon Engineers, Phila, Pa, USA : Voice 215-422-3598 : E-Mail : kiesel@vishnu.ueci.com -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9896 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Sept '94 from Prentice Hall! (Informix Press, ISBN 0-13-124314-1) ===========================================================================