--- 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.
gbak:restoring table PARTS
gbak: restoring column PART_PICTURE
gbak: restoring column PART_PK
gbak: restoring column PART_DESCRIPTION
gbak: restoring column UNITS_PK
gbak: restoring column PART_NUMBER
gbak: restoring column PART_NAME
gbak:committing metadata for table PARTS
gbak:error committing metadata for table PARTS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PARTS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SUPPLIERS
gbak: restoring column SUPPLIER_PASSWORD
gbak: restoring column SUPPLIER_PK
gbak: restoring column SUPPLIER_NAME
gbak: restoring column SUPPLIER_CONTACT
gbak: restoring column SUPPLIER_WEBSITE
gbak: restoring column SUPPLIER_PHONE
gbak: restoring column SUPPLIER_CONTACT_EMAIL
gbak: restoring column SUPPLIER_FAX
gbak: restoring column SUPPLIER_LOG_IN
gbak: restoring column SUPPLIER_ADDRESS1
gbak: restoring column SUPPLIER_ADDRESS2
gbak: restoring column SUPPLIER_CITY
gbak: restoring column SUPPLIER_STATE
gbak: restoring column SUPPLIER_ZIP
gbak:committing metadata for table SUPPLIERS
gbak:error committing metadata for table SUPPLIERS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SUPPLIERS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table STATUS
gbak: restoring column STATUS_PK
gbak: restoring column STATUS_CATEGORY
gbak: restoring column STATUS
gbak:committing metadata for table STATUS
gbak:error committing metadata for table STATUS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE STATUS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table PARTS2SUPPLIERS
gbak: restoring column P2S_PK
gbak: restoring column PART_PK
gbak: restoring column SUPPLIER_PK
gbak:committing metadata for table PARTS2SUPPLIERS
gbak:error committing metadata for table PARTS2SUPPLIERS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PARTS2SUPPLIERS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SALES
gbak: restoring column SALES_NOTES
gbak: restoring column PAYMENT_DATE
gbak: restoring column SALES_PK
gbak: restoring column CUSTOMERS_PK
gbak: restoring column SALE_DATE
gbak: restoring column SHIPMENT_DATE
gbak: restoring column SHIPPING_METHOD_PK
gbak: restoring column PAYMENT_METHOD_PK
gbak: restoring column EMPLOYEE_PK
gbak: restoring column SALES_STATUS_PK
gbak: restoring column SHIPPED_TO_PK
gbak:committing metadata for table SALES
gbak:error committing metadata for table SALES
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SALES
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table ORDER_METHOD
gbak: restoring column ORDER_METHOD_PK
gbak: restoring column ORDER_METHOD
gbak:committing metadata for table ORDER_METHOD
gbak:error committing metadata for table ORDER_METHOD
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE ORDER_METHOD
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table EMPLOYEE
gbak: restoring column EMPLOYEE_PK
gbak: restoring column EMPLOYEE
gbak: restoring column INITIALS
gbak: restoring column LAST_NAME
gbak: restoring column FIRST_NAME
gbak:committing metadata for table EMPLOYEE
gbak:error committing metadata for table EMPLOYEE
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE EMPLOYEE
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table PAYMENT_METHOD
gbak: restoring column PAYMENT_METHOD_PK
gbak: restoring column PAYMENT_METHOD
gbak:committing metadata for table PAYMENT_METHOD
gbak:error committing metadata for table PAYMENT_METHOD
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PAYMENT_METHOD
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table UNITS
gbak: restoring column UNITS_PK
gbak: restoring column MULTIPLIER
gbak: restoring column NOTES
gbak: restoring column UNITS
gbak:committing metadata for table UNITS
gbak:error committing metadata for table UNITS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE UNITS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SHIPPING_METHOD
gbak: restoring column SHIPPING_METHOD_PK
gbak: restoring column SHIPPING_METHOD
gbak:committing metadata for table SHIPPING_METHOD
gbak:error committing metadata for table SHIPPING_METHOD
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SHIPPING_METHOD
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table STOCK
gbak: restoring column QUANTITY_PLACED_IN_STOCK
gbak: restoring column COST
gbak: restoring column NOTES
gbak: restoring column PAYMENT_METHOD_PK
gbak: restoring column STOCK_PK
gbak: restoring column ORDER_PK
gbak: restoring column PART_PK
gbak: restoring column DATE_PLACED_IN_STOCK
gbak: restoring column UNITS_PK
gbak: restoring column MULTIPLIER
gbak: restoring column PIECES
gbak:committing metadata for table STOCK
gbak:error committing metadata for table STOCK
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE STOCK
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table ITEMS_FOR_SALE
gbak: restoring column ITEM_PICTURE
gbak: restoring column ITEMS_PK
gbak: restoring column ITEM_DESCRIPTION
gbak: restoring column KIT
gbak: restoring column ITEM_TYPE_PK
gbak: restoring column ITEM_NUMBER
gbak:committing metadata for table ITEMS_FOR_SALE
gbak:error committing metadata for table ITEMS_FOR_SALE
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE ITEMS_FOR_SALE
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table PART_LISTS
gbak: restoring column QUANTITY
gbak: restoring column PARTS_LIST_PK
gbak: restoring column ITEMS_PK
gbak: restoring column PART_PK
gbak:committing metadata for table PART_LISTS
gbak:error committing metadata for table PART_LISTS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PART_LISTS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table CUSTOMERS
gbak: restoring column NOTES
gbak: restoring column CUSTOMER_TYPE_PK
gbak: restoring column CUSTOMERS_PK
gbak: restoring column SOURCE_PK
gbak: restoring column FIRST_DATE
gbak: restoring column NAME
gbak: restoring column EMAIL_ADDRESS
gbak: restoring column FIRST_NAME
gbak: restoring column LAST_NAME
gbak: restoring column COMPANY
gbak: restoring column PHONE
gbak: restoring column ADDRESS_1
gbak: restoring column ADDRESS_2
gbak: restoring column CITY
gbak: restoring column STATE_PROVINCE
gbak: restoring column POSTAL_CODE
gbak: restoring column COUNTRY
gbak:committing metadata for table CUSTOMERS
gbak:error committing metadata for table CUSTOMERS
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE CUSTOMERS
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table ITEM_TYPE
gbak: restoring column ITEM_TYPE_PK
gbak: restoring column ITEM_TYPE
gbak:committing metadata for table ITEM_TYPE
gbak:error committing metadata for table ITEM_TYPE
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE ITEM_TYPE
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SOURCES
gbak: restoring column SOURCES_PK
gbak: restoring column SOURCE
gbak: restoring column SOURCE_ACTIVE
gbak:committing metadata for table SOURCES
gbak:error committing metadata for table SOURCES
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SOURCES
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table PRICE_LIST
gbak: restoring column SUGGESTED_PRICE
gbak: restoring column PRICE_LIST_PK
gbak: restoring column ITEMS_PK
gbak: restoring column MIN_QUANTITY
gbak: restoring column PRICE_LIST_NAME_PK
gbak: restoring column MAX_QUANTITY
gbak:committing metadata for table PRICE_LIST
gbak:error committing metadata for table PRICE_LIST
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PRICE_LIST
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table CUSTOMER_TYPE
gbak: restoring column CUSTOMER_TYPE_PK
gbak: restoring column CUSTOMER_TYPE
gbak:committing metadata for table CUSTOMER_TYPE
gbak:error committing metadata for table CUSTOMER_TYPE
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE CUSTOMER_TYPE
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SALES_DETAIL
gbak: restoring column QUANTITY
gbak: restoring column PRICE
gbak: restoring column SALE_DETAIL_PK
gbak: restoring column SALES_PK
gbak: restoring column ITEMS_PK
gbak:committing metadata for table SALES_DETAIL
gbak:error committing metadata for table SALES_DETAIL
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SALES_DETAIL
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table SHIPPED_TO
gbak: restoring column IS_BILLING_ADDRESS
gbak: restoring column SHIPPED_TO_PK
gbak: restoring column CUSTOMER_TYPE_PK
gbak: restoring column SOURCE_PK
gbak: restoring column FIRST_DATE
gbak: restoring column NOTES
gbak: restoring column CUSTOMERS_PK
gbak: restoring column PHONE
gbak: restoring column NAME
gbak: restoring column EMAIL_ADDRESS
gbak: restoring column FIRST_NAME
gbak: restoring column LAST_NAME
gbak: restoring column COMPANY
gbak: restoring column ADDRESS_1
gbak: restoring column ADDRESS_2
gbak: restoring column CITY
gbak: restoring column STATE_PROVINCE
gbak: restoring column POSTAL_CODE
gbak: restoring column COUNTRY
gbak:committing metadata for table SHIPPED_TO
gbak:error committing metadata for table SHIPPED_TO
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE SHIPPED_TO
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table STATES
gbak: restoring column TAX_RATE
gbak: restoring column SHIPPING_COST
gbak: restoring column NAME
gbak: restoring column COUNTRY
gbak: restoring column CODE
gbak:committing metadata for table STATES
gbak:error committing metadata for table STATES
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE STATES
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring table PRICE_LIST_NAMES
gbak: restoring column PRICE_LIST_NAME_PK
gbak: restoring column PRICE_LIST_ACTIVE
gbak: restoring column PRICE_LIST_NAME
gbak:committing metadata for table PRICE_LIST_NAMES
gbak:error committing metadata for table PRICE_LIST_NAMES
gbak: ERROR:unsuccessful metadata update
gbak: ERROR: TABLE PRICE_LIST_NAMES
gbak: ERROR: Can't have relation with only computed fields or constraints
gbak:restoring generator GEN_SUPPLIERS_ID value: 17
gbak:restoring generator GEN_STATUS_ID value: 6
gbak:restoring generator GEN_PARTS_ID value: 15
gbak:restoring generator GEN_PARTS2SUPPLIERS_ID value: 18
gbak:restoring generator GEN_ORDERS_ID value: 143
gbak:restoring generator GEN_ORDER_METHOD_ID value: 5
gbak:restoring generator GEN_PAYMENT_METHOD_ID value: 4
gbak:restoring generator GEN_EMPLOYEE_ID value: 13
gbak:restoring generator GEN_SHIPPING_METHOD_ID value: 10
gbak:restoring generator GEN_SALES_ID value: 415
gbak:restoring generator GEN_UNITS_ID value: 7
gbak:restoring generator GEN_STOCK_ID value: 145
gbak:restoring generator GEN_ITEMS_FOR_SALE_ID value: 17
gbak:restoring generator GEN_PART_LISTS_ID value: 42
gbak:restoring generator GEN_Customers_ID value: 248
gbak:restoring generator GEN_SOURCES_ID value: 6
gbak:restoring generator GEN_CUSTOMER_TYPE_ID value: 8
gbak:restoring generator GEN_PRICE_LIST_ID value: 15
gbak:restoring generator GEN_PRICE_LIST_NAMES_ID value: 1
gbak:restoring generator GEN_SALES_DETAIL_ID value: 1433
gbak:restoring generator GEN_ITEM_TYPE_ID value: 3
gbak:restoring generator GEN_SHIPPED_TO_ID value: 276
gbak: committing metadata
gbak: restoring index PK_PRICE_LIST_NAMES
gbak: ERROR:invalid request BLR at offset 42
gbak: ERROR: table PRICE_LIST_NAMES is not defined
gbak: 1 records ignored
gbak: restoring index PK_STATES
gbak: ERROR:invalid request BLR at offset 46
gbak: ERROR: table STATES is not defined
gbak: 67 records ignored
gbak: restoring index RDB$PRIMARY7
gbak: ERROR:invalid request BLR at offset 135
gbak: ERROR: table SHIPPED_TO is not defined
gbak: 258 records ignored
gbak: restoring index PK_SALES_DETAIL
gbak: restoring index SALES_SALES_DETAIL
gbak: ERROR:invalid request BLR at offset 43
gbak: ERROR: table SALES_DETAIL is not defined
gbak: 1323 records ignored
gbak: restoring index PK_CUSTOMER_TYPE
gbak: ERROR:invalid request BLR at offset 35
gbak: ERROR: table CUSTOMER_TYPE is not defined
gbak: 8 records ignored
gbak: restoring index PK_PRICE_LIST
gbak: ERROR:invalid request BLR at offset 45
gbak: ERROR: table PRICE_LIST is not defined
gbak: 31 records ignored
gbak: restoring index PK_SOURCES
gbak: ERROR:invalid request BLR at offset 33
gbak: ERROR: table SOURCES is not defined
gbak: 7 records ignored
gbak: restoring index PK_ITEM_TYPE
gbak: ERROR:invalid request BLR at offset 31
gbak: ERROR: table ITEM_TYPE is not defined
gbak: 5 records ignored
gbak: restoring index RDB$PRIMARY6
gbak: ERROR:invalid request BLR at offset 126
gbak: ERROR: table CUSTOMERS is not defined
gbak: 238 records ignored
gbak: restoring index PK_PART_LISTS
gbak: ERROR:invalid request BLR at offset 37
gbak: ERROR: table PART_LISTS is not defined
gbak: 60 records ignored
gbak: restoring index PK_ITEMS_FOR_SALE
gbak: ERROR:invalid request BLR at offset 55
gbak: ERROR: table ITEMS_FOR_SALE is not defined
gbak: 32 records ignored
gbak: restoring index PK_STOCK
gbak: ERROR:invalid request BLR at offset 59
gbak: ERROR: table STOCK is not defined
gbak: 122 records ignored
gbak: restoring index PK_SHIPPING_METHOD
gbak: ERROR:invalid request BLR at offset 37
gbak: ERROR: table SHIPPING_METHOD is not defined
gbak: 10 records ignored
gbak: restoring index PK_UNITS
gbak: ERROR:invalid request BLR at offset 38
gbak: ERROR: table UNITS is not defined
gbak: 9 records ignored
gbak: restoring index PK_PAYMENT_METHOD
gbak: ERROR:invalid request BLR at offset 36
gbak: ERROR: table PAYMENT_METHOD is not defined
gbak: 4 records ignored
gbak: restoring index PK_EMPLOYEE
gbak: ERROR:invalid request BLR at offset 51
gbak: ERROR: table EMPLOYEE is not defined
gbak: 13 records ignored
gbak: restoring index PK_ORDER_METHOD
gbak: ERROR:invalid request BLR at offset 34
gbak: ERROR: table ORDER_METHOD is not defined
gbak: 5 records ignored
gbak: restoring index PK_SALES
gbak: restoring index CUSTOMER_SALES
gbak: ERROR:invalid request BLR at offset 57
gbak: ERROR: table SALES is not defined
gbak: 369 records ignored
gbak: restoring index PK_PARTS2SUPPLIERS
gbak: ERROR:invalid request BLR at offset 38
gbak: ERROR: table PARTS2SUPPLIERS is not defined
gbak: 35 records ignored
gbak: restoring index PK_STATUS
gbak: ERROR:invalid request BLR at offset 35
gbak: ERROR: table STATUS is not defined
gbak: 6 records ignored
gbak: restoring index PK_SUPPLIERS
gbak: ERROR:invalid request BLR at offset 115
gbak: ERROR: table SUPPLIERS is not defined
gbak: 23 records ignored
gbak: restoring index PK_PARTS
gbak: restoring index BY_PART_NAME
gbak: ERROR:invalid request BLR at offset 49
gbak: ERROR: table PARTS is not defined
gbak: 29 records ignored
gbak: restoring index PK_ORDERS
gbak: restoring index BY_PART_PK
gbak: ERROR:invalid request BLR at offset 104
gbak: ERROR: table ORDERS is not defined
gbak: 119 records ignored
gbak: restoring trigger PARTS_BI
gbak: restoring trigger SUPPLIERS_BI
gbak: restoring trigger STATUS_BI
gbak: restoring trigger PARTS2SUPPLIERS_BI
gbak: restoring trigger ORDERS_BI
gbak: restoring trigger ORDER_METHOD_BI
gbak: restoring trigger PAYMENT_METHOD_BI
gbak: restoring trigger EMPLOYEE_BI
gbak: restoring trigger SHIPPING_METHOD_BI
gbak: restoring trigger SALES_BI
gbak: restoring trigger UNITS_BI
gbak: restoring trigger STOCK_BI
gbak: restoring trigger ITEMS_FOR_SALE_BI
gbak: restoring trigger PART_LISTS_BI
gbak: restoring trigger SOURCES_BI
gbak: restoring trigger CUSTOMER_TYPE_BI
gbak: restoring trigger CUSTOMERS_BI
gbak: restoring trigger PRICE_LIST_BI
gbak: restoring trigger PRICE_LIST_NAMES_BI
gbak: restoring trigger SALES_DETAIL_BI
gbak: restoring trigger ITEM_TYPE_BI
gbak: restoring trigger SHIPPED_TO_BI
gbak: restoring privilege for user SYSDBA
gbak: restoring privilege for user SYSDBA