Troubleshooting WebSphere Commerce Analyzer: Replication setup fails
If you get en error during replication setup, the most common problem is that a previous WebSphere Commerce Analyzer configuration (either full or partial) has not been cleaned up, and the setup process isn't capable of managing the existing assets.
When WebSphere Commerce Analyzer tries to set up replication, it creates a set of capture control tables and replication source tables in the WebSphere Commerce Server database. It also creates apply control tables and replication target tables on the WebSphere Commerce Analyzer data mart database.
If you are reconfiguring or reinstalling WebSphere Commerce Analyzer, first remove these tables from the old setup within the WebSphere Commerce database.
(AIX)(Linux)(Solaris)(Windows) Drop all tablespaces and bufferpools like 'WCA%' and like 'TSS%' Drop the ASN and REPL schemas (or whatever you named the replication schema)
Drop all tablespaces like 'WCA%'
Using SQLPlus, run \wca\bin\oracle\drop_sql.sql
For more details you can check the log directory, looking at all files like rep_CREATE*.log. Search for the following:
"1" errorIf you see anything indicating that an asset already exists, follow the above procedure. After correcting the errors, click Apply on the replication setup panel again.
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.