Replication Error 
Author Message
 Replication Error

AIX 4.2.1, UDB 5.2, fp9, update anywhere replication, control
information on target server.  I've seen an odd error a couple times in
the IBMSNAP_APPLYTRAIL table

APPLY_QUAL STATUS LASTRUN(DATE) LASTRUN(TIME) TARGET_TABLE SQLCODE
APPERRM

REFQUAL -1 03/06/2000 06:33:55 VALIDATION_IDS -911 ASN1001E: "The Apply
program encountered an SQL error. ERRCODE is 380103, SQLSTATE is 40001,
SQLCODE is -911, SQLERRM is 2, SQLERRP is SQLRITA , server name is
SHUKSAN2, table name is ASN.IBMSNAP_PRUNCNTL."

Which means there was a deadlock timeout on the ASN.IBMSNAP_PRUNCNTL
table for the Apply Qualifier "REFQUAL" and the target table
"VALIDATION_IDS".  Replication errors are typically explicit but very
indirect, the true cause is usually hidden.  How could the
ASN.IBMSNAP_PRUNCNTL table get in a deadlock?  The table in question is
not in two different replication agreements.

Thanks in advance,

Tom Remmers
University of Washington
Software Engineer



Fri, 23 Aug 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Replication Error: ASN0506E - Could not attach to Replication Comm Message queue

2. Help needed for Replication error HR -2147012867 Native Error 28037

3. error 605 - mssql7.0(replication error)

4. How to get replication error logged as an error in the Event Viewer | Windows Application Log

5. Error during merge replication :- Error Message-The process could not bulk copy

6. Replication error - Operating system error 5 ?

7. Replication error 08001 - General network error

8. How to find replication error code?

9. SQL Server 6.5 Replication Error Message

10. replication error

11. Replication error 29045


 
Powered by phpBB® Forum Software