hi,
sorry for late reply... was out of station.
i am still lost what to do.
here are more details:
1) I am using FB 1.5.2 SuperServer and IB 6.0.2 in my Development
Environment on WinXP SP2 machine (I only run one server at a time,
although I am able to run both using different ports).
2) I created a backup file (ACROSYS.GBK) from Production Environment
which runs IB 6.0.2 on Win2K Server machine.
3) I tried to restore this on my develoopment machine with IB 6.0.2
and did not suceed.
4) I also tried to retore with FB 1.5.2 and it did not work (I
renamed the GBK to FBK).
5) Both restores give the same problem.
6) This time I used tools to restote : IBOConsole and Workbench.
7) Using IBOConsole, the log says as follows:
Service started at 4/26/2005 11:02:27 AM
gbak: opened file D:\data\ACROSYS.FBK
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: created database D:\data\ACROSYS.FDB, page_size 8192 bytes
gbak: started transaction
gbak: restoring domain MATRIC_NO
gbak: restoring domain CLG_CODE
gbak: restoring domain CRS_CODE

--> then it works fine until

gbak: restoring data for table STUMST
gbak: 3632 records restored
gbak: restoring index RDB$PRIMARY7
gbak: restoring index I_CRSREGCRE_MATRIC_NO
gbak: restoring index I_CRSREGCRE_STR_CODE
gbak: restoring index I_CRSREGCRE_CRS_CODE
gbak: restoring data for table CRSREGCRE
gbak: 10000 records restored
gbak: 20000 records restored
gbak: 30000 records restored
gbak: 40000 records restored
gbak: 50000 records restored
gbak: adjusting an invalid decompression length from -96 to -36
gbak: 51607 records restored
gbak: do not recognize table attribute 0 -- continuing
gbak: do not recognize table attribute 0 -- continuing
gbak: do not recognize table attribute 0 -- continuing

--> and it prompts the message window with error code 336330798
and says string truncated.

With Workbench, log says:
gbak: opened file D:\data\ACROSYS.FBK
gbak: transportable backup -- data in XDR format
gbak: backup file is compressed
gbak: created database D:\data\ACROSYS.FDB, page_size 8192 bytes
gbak: started transaction
gbak: restoring domain MATRIC_NO
gbak: restoring domain CLG_CODE
gbak: restoring domain CRS_CODE

--> and works fine until

gbak: restoring data for table STUMST
gbak: 3632 records restored
gbak: restoring index RDB$PRIMARY7
gbak: restoring index I_CRSREGCRE_MATRIC_NO
gbak: restoring index I_CRSREGCRE_STR_CODE
gbak: restoring index I_CRSREGCRE_CRS_CODE
gbak: restoring data for table CRSREGCRE
gbak: 10000 records restored
gbak: 20000 records restored
gbak: 30000 records restored
gbak: 40000 records restored
gbak: 50000 records restored
ERROR: invalid request handle
gds_$send failed

But susprisingly, on Production Environment (Win2k Server & IB
6.0.2), restoring does not give any problem.

I beleive, it is related to some corruption in the data. I hope you
can help me out here.

Thanx
Feroz



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 01:30 AM 20/04/2005 +0000, feroz wrote:
>
>
> >hi,
> >helen, i apologise for posting this message in the wrong group
> >earlier.
> >i faced the problem as stated below...and here is the latest.
> >1) the problem occored in XP SP2 (i tried on two machines).
> >2) i tried restoring the same file on the server Win2K (where it

was

> >originbally created), there was no problem at all both on IB 6.0.2
> >and FB 1.5.2.
> >3) did not try any other OS.
> >
> >anyone has any idea.
>
> Then - for whatever reason - you may deduce that something is

going wrong

> on the XP machine. :-))
>
> The connection syntax that you provided previously was:
>
> > C:\Program Files\Firebird\Firebird_1_5\bin>gbak -USER SYSDBA -

PASSWORD

> masterkey -C ACROSYS20050416.GBK AAA.GDB
>
> All other possibilities apart, this is not a valid restore string,

since

> you have not provided any path specifications for either the

backup file or

> the database file that you are going to create. It might work

only if the

> backup file was actually in Firebird's \bin directory, and you

intended to

> write the database file into there too; but that is NOT a

recommended

> thing to do.
>
> So let's get that one sorted first.
>
> Let's suppose that your backup file is in c:\data\backups and you

have a

> directory named c:\data (already created) where you wish to

create the new

> database file.
>
> Then, the command for performing the restore should be:
>
> C:\Program Files\Firebird\Firebird_1_5\bin>gbak -c
> c:\data\backups\ACROSYS20050416.GBK c:\data\AAA.FDB -USER SYSDBA -

PASSWORD

> masterkey
>
> OK, amongst the other things, notice that the file suffix of the

database

> is ".FDB", not ".GDB". It is important NOT to have database file

names

> ending in ".GDB" on XP. Read the Firebird 1.0 and 1.5 release

notes about

> this. It is a well-published issue on XP.
>
> Now, if the backup still terminates with an exception, there are

other

> possibilities. We then need more information from you -

specifically,

> which MODEL of Firebird 1.5 you installed on the XP machine. If

it is

> Superserver then, in the Processes list of your Task Manager

display you

> will see the process "fbserver.exe" running. If it is Classic,

then you

> will see "fb_inet_server".
>
> If it is Classic, then you cannot use the local method for gbak.

You must

> use the Services Manager, which has a more complicated syntax.
>
> Please try and check these things and report back. If you get

exceptions,

> please copy and paste, to report as much information as possible.

You can

> copy text from the command window to the clipboard, by

highlighting the

> required text with your mouse and pressing Enter.
>
> ./heLen