markd_mms escreveu:

> I'm trying to upgrade from 2 to 2.1 so I can use the mon$ tables but
> I'm not having much luck. I was running v2.0.1.12855 under XP and I
> created a backup of the database using gbak -v -t which didn't get any
> errors. I uninstalled that version and then installed
> v2.1.1.17910. Now when I run gbak -c -v to restore I
> eventually get...
>
> gbak:restoring data for table PRODUCT
> gbak: ERROR:Malformed string
> gbak: ERROR:gds_$send failed
> gbak:Exiting before completion due to errors
>
> the DDL (minus indexes and triggers) for the table is...
>
> CREATE TABLE PRODUCT (
> PRODUCTID INTEGER NOT NULL,
> TITLE VARCHAR(128) CHARACTER SET WIN1252 NOT NULL COLLATE WIN1252,
> UPPER_TITLE VARCHAR(128) CHARACTER SET WIN1252 NOT NULL COLLATE WIN1252,
> SORT_TITLE VARCHAR(128) CHARACTER SET WIN1252 NOT NULL COLLATE WIN1252,
> TITLE2 VARCHAR(256) CHARACTER SET WIN1252 COLLATE WIN1252,
> SYNOPSIS BLOB SUB_TYPE 1 SEGMENT SIZE 1 CHARACTER SET UTF8 COLLATE UTF8,
> IMAGE BLOB SUB_TYPE 2,
> SECTIONID SMALLINT NOT NULL,
> PRODUCTION_YEAR CHAR(4) CHARACTER SET WIN1252 COLLATE WIN1252,
> GENREID SMALLINT);
>
> I read in the release notes that blobs need to be fixed up after the
> ODS is updated to 11.1 but that would mean after restoring the
> database. Does anyone know what could be going wrong?
>

V2.0 was allowing malformed blobs, and it seems you have one in
SYNOPSIS. You can't restore the database in V2.1 and can't use the
metadata script in ODS 11.0!

So you will need to open (a copy) of this (ODS 11.0) database in V2.1
and fix the UTF8 blobs problems and backup later. You could see how
metadata script does it (using casts).


Adriano