Thanks to the post from ittybittyproblem (Thanks!) I figured out how
to monitor the script (OnStatement event).

I was then able to determine that the script crashes on this query:

CREATE TABLE RPL$<<IND_NME>>$Q (
RPL$Q_KEY RPL$<<IND_NME>>$Q_KEY_DM NOT NULL,
RPL$Q_TYP RPL$<<IND_NME>>$Q_TYP_DM NOT NULL,
<<SRC_OLD_KEY_Q>>
<<SRC_KEY_COL_Q>>
<<SRC_BLA_COL_Q>>
CONSTRAINT RPL$<<IND_NME>>$Q_PK
PRIMARY KEY ( RPL$Q_KEY )
);

Does this information help explain to you what the problem may be?
Any ideas on what exactly I am forgetting to do, that would lead to
it crashing on this?

My other question is:

Question 3. Is there something I need to set that I am not setting
in the RPL$_IND table? For completeness's sake I have included my
RPL$_IND configuration and the structure of my test database tables
to be replicated.

DATABASE FIELDS WITH VALUES ASSIGNED IN RPL$_IND:
RPL$IND_NME is set to 'TREFER'
RPL$SRC_TBL_NME is set to 'RPTLOG'
RPL$SRC_KEY_CLS is set to 'TREFER'
RPL$SRC_CLS is set to
'TCUST,SESSIONID,SESSIONDT,AMOUNT'
RPL$SRC_ADD_EXP is set to 'A'
RPL$SRC_UPD_EXP is set to '(OLD.SESSIONDT <>
NEW.SESSIONDT)'
RPL$LOG is set to 'T'
RPL$STATUS is set to 'I'
RPL$DST_DEL_EXP is set to '(0=1)'
RPL$DST_TBL_SRC is set to 'RPTLOG'
RPL$DST_TBL_CREATE is set to 'T'
RPL$DST_TBL_NME is set to 'RPTLOG'
RPL$DST_KEY_CLS is set to 'TREFER'
RPL$DST_CLS is set to
'TCUST,SESSIONID,SESSIONDT,AMOUNT'
NULL FIELDS:
RPL$SRC_TRG_DEC_VAR
RPL$SRC_TRG_INS_Q,
RPL$SRC_TRG_UPD_Q,
RPL$SRC_TRG_DEL_Q,
RPL$SRC_PRC_DEC_VAR,
RPL$SRC_PRC_VAR_INIT,
RPL$SRC_PRC_SRC_Q,
RPL$SRC_PRC_SRC_FULL

For reference to the above mentioned fields (if even relevant) here
are the source and destination db tables

SOURCE TABLE RPTLOG
RECREATE TABLE RPTLOG
(
TREFER VARCHAR( 15)
CHARACTER SET NONE NOT NULL COLLATE NONE,
TCUST INTEGER,
SESSIONID INTEGER,
SESSIONDT TIMESTAMP,
AMOUNT FLOAT
);

DESTINATION TABLE RPTLOG
RECREATE TABLE RPTLOG
(
TREFER VARCHAR( 15)
CHARACTER SET NONE NOT NULL COLLATE NONE,
TCUST INTEGER,
SESSIONID INTEGER,
SESSIONDT TIMESTAMP,
AMOUNT FLOAT
);




--- In IBObjects@yahoogroups.com, "robert_p_levy"
<robert_p_levy@y...> wrote:

> Hi. I'm trying to set up a replication system using IBO's IB_RPL
> package. The place where I encounter a problem is in loading the
> metadata for the databases that keep track of what is to be
> replication from source to destination. More specifically, a query
> contained in the script scSRCLoadMeta script executes and is
> incorrect somehow so the program crashes, and therefore the

metadata

> has not yet been completely generated.
>
> My question: What are some typical reasons the scSRCLoadMeta script
> may crash? The only reason I can think of is that maybe there are
> some required fields in RPL$_IND I am missing. So far I haven't

been

> able to pinpoint the problem.
>
> Any suggestions will be very helpful!
>
> Thanks,
> Rob