Re: Causes of Tablespace Overflow

I wrote: -> -> ... ->Recently, I have had occasion to create a new report which is simply a set ->of account statements. All of the account statements are created correctly, ->except one (admittedly a rather large one... but I have much more complex ->and long reports which work), which always bombs with the message: -> ->Program stopped at "otrasumlar.4gl", line number 115. ->SQL statement error number -567. ->Cannot write sorted rows. ->SYSTEM error number -141. ->ISAM error: TBLspace table overflow -> ->I am trying to find out if anyone can give me any clues as to what causes ->tablespaces to be created. I have looked at all relevant entries I can ->find in the manuals. I have talked to Tech Support. They tell me just ->to up the max tablespaces limit since they can't give me a better clue as ->to why so many are being created. I have already upped the max tablespaces ->parameter in my onconfig file from 2000 to 3000 to attempt to solve this ->problem, and I am not comfortable just throwing resources at it. Thanks to the suggestions of those who responded, I was able to narrow my problem down to a rather large union. It was actually doing a "union" where a "union all" would have sufficed. Since the "union all" doesn't try to delete any duplicate entries, it doesn't create all the extra temp tables apparently needed to run this "union". At any rate, thanks to all who responded! Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (970) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (970) 491-1205