Hi All Our production server is a Win 64 massive ram memory Firbierd 3 64bits, and our development server is a VM on Win 32 with Fb 3 (32 bits)
When we backup the database from the production x64 server, and try to retore it on the win32 server we usually get the following message: Attempt to set in database number of buffers which is out of acceptable range ... We know why it happens, because the production database has set the cache databae pages to half a million pages. However on Win 32 the limit is 132K cache pages. Is there any way to "force" the restore anyways and then set the DB cache pages to a reasonable number on the Win32 server? Else we need to modify in production the cache pages before running the backup, something we are trying to avoid. Thanks Fabian ----- Original Message ----- From: "Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]" <firebird-support@yahoogroups.com> To: <firebird-support@yahoogroups.com> Sent: Thursday, October 19, 2017 1:09 AM Subject: Re: [firebird-support] "Invalid Cursor State" Sean: It´s an executable procedure which returns a parameter. It´s not a selectable procedure. Its the kind of SP you invoke like "execute procedure ... returning values ..." while selectable ones are usually called as "select ... from stored_procedure_name" I´ve managed to fix my issue, anyway. Thanks! 2017-10-17 17:47 GMT-03:00 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] <firebird-support@yahoogroups.com>: > > > > > Dimitry: > I do it all the time ... (read output parameters from executable > procedures, using "call executable_sp" by ODBC). No issues with other SPs. > > > > <SL> Unless I missed something, your SP is missing the required SUSPEND to > make the SP selectable. > > > > > > Regards > > > > > > > > 2017-10-17 15:38 GMT-03:00 Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] <firebird-support@yahoogroups.com>: > > 17.10.2017 20:12, Jorge Andres Brugger jorge.brug...@gmail.com > [firebird-support] wrote: > > What am I doing wrong? > > You cannot fetch from non-select query. > > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > 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 > > > > > > > > > > > >
