target MS SQL trigger problem
jmbienOct 18 2011 — edited Feb 13 2012Hi everyone,
I replicat a table from a sybase database to a MSSQL 2000 and MSSQL 2008 r2.
Each table on the target database has his own trigger on insert, update and delete (different on MSSQL 2000 and MSSQL 2008).
When i make a insert on the source table, the data is replicated on the 2 target databases.
when i make an update on the row previously created, the two replicats abend.
If I disable the trigger on the target table of the MSSQL databases, everything is ok.
Due to applicative fonctionalities, I need to enable the triggers on the target databases.
has anyone already encountered this kind of error ?
Here is the error in the replicat report :
2011-10-18 15:39:27 WARNING OGG-01004 Aborted grouped transaction on 'DBO.PERSONNE_PHYSIQUE', Database error 100 (No data found).
2011-10-18 15:39:27 WARNING OGG-01003 Repositioning to rba 125147 in seqno 38.
2011-10-18 15:39:27 WARNING OGG-01154 SQL error 100 mapping dbo.PERSONNE_PHYSIQUE to DBO.PERSONNE_PHYSIQUE No data found.
2011-10-18 15:39:27 WARNING OGG-01003 Repositioning to rba 125147 in seqno 38
best regards
Jmbien