I think the image posting is not allowed here to display. Below is the error message I see: Note I have 2.75 GB free disk space. *** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch failed SQL Message : -901Unsuccessful execution caused by system error that does notpreclude successful execution of subsequent statements Engine Code : 335544675Enginne Message : sort errorNo free space found in temporary directoriesoperating system directive WriteFile failedThere is not enough space on the disk.
On Monday, 8 June 2015 10:28 AM, "Robert martin r...@chreos.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: Hi I don't know what the error message is, you didn't include it! but it is likely your join is wrong and returning one of every detail record for every header (i.e. 78000 * 3000 records !) Check your query and make sure the detail records are linked to the master correctly (i.e. JOIN detail d ON d.ForeignkeyField = m.primarykeyfield) Post your SQL if you cant see the cause :) Cheers Rob On 8/06/2015 4:49 p.m., Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > There is enough free disk space (2.75 GB) available. > > > > On Monday, 8 June 2015 10:08 AM, "Vishal Tiwari vishuals...@yahoo.co.in > [firebird-support]" <firebird-support@yahoogroups.com> wrote: > > > Hi All, > I am running one SQL in that Master table has 78 thousand plus records > and detail table has 4 Laks and 3 thousand plus records. I have used > Inner Join on the primary key of Master table with the column in the > Detail Table. > When I execute with small size database, but with this database when I > run SQL using Flamerobin, I get below error. > Please help. > > With Best Regards. > Vishal > > [Non-text portions of this message have been removed] > > ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links