Activation failed due to "Failed to build rowmap" (18495)

Activation worked on demo table but failed with real config due to the following error:

06/27/06 15:22 Notice: New activation id 198 [sp_tconf/19604]
06/27/06 15:22 Notice: Oracle compatible parameter='9.2.0.5' [sp_tconf/19604]
06/27/06 15:22 Notice: Performing a checkpoint on instance(s) [sp_tconf(rom)/19604]
06/27/06 15:22 Error: 1 - Error logging onto database 12560 [sp_tconf(rom)/19604]
06/27/06 15:22 Error: Failed to build rowmap [sp_tconf/19604]
06/27/06 15:22 Config compilation completed: datasrc - o.PTD2; file - pwtr_rep
06/27/06 15:22 Bad config file: file - pwtr_rep; sp_tconf error - Failed to build rowmap, check event_log and rmp log for details.
06/27/06 15:22 Process exited sp_tconf (for o.PTD2) [pid = 19604] - exit(1)

It may not have enough disk space for the tablespace where shareplex_rowidmap resides or resource is busy and shareplex can not lock the table for analyzing row-chaining.

RESOLUTION:

For database on 9i/10g, this issue can be resolved by enabling supplemental logging so that shareplex activation will skip analyzing row-chaining and reduce activation time.

Perform the following steps:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
ALTER SYSTEM SWITCH LOGFILE

Then activate config again

sp_ctrl > activate config config_name

See solution 737 as well if you are on 8i database.