Hi all, a question from a french sybase newbie.

I have to work on replication using dbremote with Sybase SQL Anywhere 5.5.1. I can do this replication work , but every time, I use it I have within a delay non-defined, some messages with DELETE statement. I have also some errors like "Deleting corrupt messages" or "Missing message from <publish name>".

Well I work on it since 2 weeks and I don't understand why I have thoses messages. The DB are 100MB, I test it on LAN at work.

If someone has already done such a solution, could you help me.

Thank you.

Here are the scripts I user to initialyze :

Consolidated database and after remote database

create remote message type file address '\\\\192.168.1.114\replicat\siege';

grant connect to siege identified by siege;
grant publish to siege;
grant connect to ag990 identified by ag990;
grant remote to ag990 type file address '\\\\192.168.1.114\replicat\ag990' send every '00:10';

/************************************************/
/* creation d'une publication pour l'agence 990 */
/************************************************/

create publication exploitation990
(
table inter where inagence = '990',
table bon_com where agence_bdc = '990',
table botr where boagence = '990',
table standardiste where agence = '990',
table techni where tcagence = '990',
table client where clagence = '990',
table devis where dvagence = '990',
table estimatif where dvagence = '990',
table fourni where foagence ='990',
table fournisseurs where agence_fournisseur = '990',
table fourniture where agence_fo = '990',
table fplace where stagence = '990',
table fplacee where agence_fplace = '990',
table jpdn where agence = '990',
table objectifs,
table paragm where fmagence = '990',
table parago where paagence = '990',
table parags where psagence = '990',
table prime_detail where agence = '990',
table act_activite
);

create publication nomenclature990
(
table b_regles,
table banque,
table catalog,
table seuil,
table tarif,
table clotur,
table date_jour,
table famill,
table panne
);

create subscription to exploitation990 for ag990;
create subscription to nomenclature990 for ag990;

start subscription to exploitation990 for ag990;
start subscription to nomenclature990 for ag990;

synchronize subscription to exploitation990 for ag990;
synchronize subscription to nomenclature990 for ag990;

and the script for the remote database :

create remote type file address '\\\\192.168.1.114\replicat\ag990';


grant connect to ag990 identified by ag990;
grant connect to siege identified by siege;

grant publish to ag990;

grant consolidate to siege type file address '\\\\192.168.1.114\replicat\siege' send every '00:10';

create publication exploitation990
(
table inter,
table bon_com ,
table botr ,
table standardiste ,
table techni ,
table client ,
table devis ,
table estimatif ,
table fourni ,
table fournisseurs ,
table fourniture ,
table fplace ,
table fplacee ,
table jpdn ,
table objectifs,
table paragm ,
table parago ,
table parags ,
table prime_detail
);

create publication nomenclature990
(
table b_regles,
table banque,
table catalog,
table seuil,
table tarif,
table clotur,
table date_jour,
table famill,
table panne
);

create subscription to exploitation990 for siege;
create subscription to nomenclature990 for siege;

start subscription to exploitation990 for siege;
start subscription to nomenclature990 for siege;