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.brugger@... [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' Sean@...
[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 sd@...
> [firebird-support] <firebird-support@yahoogroups.com>:
>
> 17.10.2017 20:12, Jorge Andres Brugger jorge.brugger@...
> [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
>
>
>
>
>
>
>
>
>
>
>
>