🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #94

Trouble with array fields replication

#94
From: lex9999
Date: Thu, 13 Jul 2006 09:54
44 lines
2625 bytes
I use IBReplicator 2.1.8 (EVAL license) and Firebird 1.5.3 under
Windows XP SP2.
I've got error message trying to replicate inserts/updates made to
following table:

CREATE TABLE LUACCOM (
    LUID                  INTEGER NOT NULL,
    SUPPID                INTEGER,
    BROKERID              INTEGER,
    ARRDATE               DATE,
    ENDDATE               DATE,
    BUILDID               INTEGER,
    BUILDINGNAME          CHAR(35),
    RESORT                INTEGER,
    RESORTNAME            CHAR(35),
    RATING                CHAR(5),
    ROOMTYPECODE          CHAR(10),
    BOARDTYPECODE         CHAR(10),
    CONTRACTTYPE          CHAR(10),
    UPDATED               DATE,
    MAXOCC                CHAR(100),
    MINOCC                CHAR(100),
    REQUESTIFFULL         CHAR(1),
    FIXMARGINS            CHAR(1),
    CONTRACTORID          INTEGER,
    CODING                CHAR(36) [1:750,1:30],
    NOROOMS               INTEGER,
    ANYINCTRANS           CHAR(1),
    PRICES                DOUBLE PRECISION [1:750,1:210],
    BROCHUREPRICING       CHAR(1),
    BOARDTYPESET          CHAR(20),
    REQUESTINSIDERELEASE  CHAR(1)
);

ALTER TABLE LUACCOM ADD PRIMARY KEY (LUID);

Here is the text of the error message:
"ErrorNo: 32 - subscript out of bounds"

After removing fields CODING and PRICES from replication schema
replication works fine, but these fields are required.
Also table replicates if both fields contains NULL.

I think trouble is in array fields, but IBReplicator supports them.
Technical Details
Message-ID: <1152784483.060949.195380@s13g2000cwa.googlegroups.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s13g2000cwa.googlegroups.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: f89d7,a9d5c5c74163a5ef,start
X-Google-Attributes: gidf89d7,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s13g2000cwa.googlegroups.com!not-for-mail
From: lex9999@mail.ru
Newsgroups: borland.public.interbase.replication
Subject: Trouble with array fields replication
Date: 13 Jul 2006 02:54:43 -0700
Organization: http://groups.google.com
Lines: 45
Message-ID: <1152784483.060949.195380@s13g2000cwa.googlegroups.com>
NNTP-Posting-Host: 62.33.232.135
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152784489 32444 127.0.0.1 (13 Jul 2006 09:54:49 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 13 Jul 2006 09:54:49 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ru) Opera 8.50,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: s13g2000cwa.googlegroups.com; posting-host=62.33.232.135;
   posting-account=EAXtZg0AAACjLuLgnBHMPvb-BQZ6HBpf