Since version 6.0, changes to the security model handling mean that every event participant in your CMS database must have an associated e‑mail address. This particularly impacts participants in Web and Application Monitor events, for whom addresses were not previously stored.
Therefore, as part of the upgrade process, CA DataMinder assigns automatically-generated addresses to these participants. It then migrates all existing participant addresses, including these new ones, to the Wgn3UserAddressEx database table.
When the upgrade is complete, a final schema change is needed. Specifically, the database columns that identify participant addresses must be redefined as NOT NULL (participant address identifiers are now mandatory; previously, they were optional). This affects the AddressUID1 and AddressUID2 columns in the Wgn3EventParticipant table.
The schema change is the same for Oracle and SQL Server databases, but the implementation is more complex for SQL Server.
|
Copyright © 2012 CA.
All rights reserved.
|
|