Subject trying to upgrade from 2.0 to 2.1
Author markd_mms
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?

Alternatively, is there any way of getting a list of all connected ip
addresses and process names using rdb$get_context? I tried
rdb$get_context('SYSTEM', 'CLIENT_ADDRESS") but it only ever returns 1
row.

TIA