--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

>
> > --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@> wrote:
> >>
> >>> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@> wrote:
> >>>>
> >>>>> I am migrating FB 1.5 databases on a Linux box to FB 2.5 on a Windows server. All proceeded according to plan. However, I have one database that is complaining. I backed it up from the command prompt. I use IBExpert as my front end on the Windows machine, and use it to restore my databases.
> >>>>>
> >>>>> The sick database seems to function correctly, but will not restore from a backup. I can provide a log of the restore if someone would like to look at it.
> >>>>
> >>>> Any error message upon restore?
> >>>>
> >>>>
> >>>> --
> >>>> With regards,
> >>>> Thomas Steinmaurer
> >>>> http://www.upscene.com/
> >>>>
> >>> Plenty. I have the log
> >>
> >> Is it too long for posting it here?
> >>
> >> Usually the last part of the restore log including the error message
> >> should be sufficient.
> >>
> >> --
> >> With regards,
> >> Thomas Steinmaurer
> >> http://www.upscene.com/
> >>
> >
> > Here is a chunk that has the errors in it
> >
> > gbak: restoring column UNITS_PK
> > gbak: restoring column MULTIPLIER
> > gbak: restoring column PIECES
> > gbak: restoring column SUPPLIER_ORDER_NO
> > gbak:committing metadata for table ORDERS
> > gbak:error committing metadata for table ORDERS
> > gbak: ERROR:unsuccessful metadata update
> > gbak: ERROR: ORDERS
> > gbak: ERROR: Implementation of text subtype 65280 not located.
>
> This seems to be an inconsistency in Firebird 1.5 system tables, which
> strikes back when restoring under Firebird 2.
>
> Can you please run the following SQL on the 1.5 database?
>
> select
> rdb$collation_id
> , count(*)
> from
> rdb$relation_fields
> group by
> rdb$collation_id
>
>
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>

RDB$COLLATION_ID COUNT
322
-1 1
0 63