Resolving Create Unique Index UserGroup on OQ.UserGroup in Remote download


 Product(s):APM Implementation and Performance Management
 Version(s):7.14
 Environment:Remote Db
 Area:N/A
 Subarea:N\A

Problem

This happen when user receives an error on the download to the remote: CREATE UNIQUE INDEX UserGroup ON OQ.UserGroup;

Solution

The error is caused by 2 records remaining in the delivered database which should not be there. to resolve;

1) restore the delivered remote database
2) delete the contents of oq.usergroups
3) backup the delivered remote database
4) replace the delivered database with your backup. The database name should be RemoteInstall, the logical file names should be 'Ivara' and 'Ivara_log'. The backup file name should be remoteinstall.bak for this to function and placed on the server where the remote packager will be executed

Note : Development mentioned that there were two rows that were accidentally in the delivered remote install databases and are now removed from the main install database. They further checked the remote install and the rows are no longer there.


See Also

SR - 7001231368