| |
Results |
|
How do I move the report server database to a new database server?
|
Restore the backup to the new sql server with a new name like MarinerReportServer. Don't use the database called ReportServer if there is one on this box because you will probably get errors later about the encryption keys used by Report Server.
|
|
|
|
How to refresh a Mariner/PPM database in staging environment with the data from production
|
Make a backup of the production database , copy it to the staging MS SQL Server, and restore the database . Be sure to restore the database using the same database name as the existing staging database.
|
|
|
Environment_Settings.sql.txt
|
-- 1. Changes settings in the Environment Settings screen with the variables you supply below. -- 2. Turns off the email notifications by default -- To use just change the variables below with SET in front of them to match your own -- Run the .sql file against the database after you have it restored .
|
|
|
|
Try to create new report and the report type dropdown list says 1, 2, 3 instead of Investment, Resource, Administrative.
|
This can happen after restoring an accelerator database . Try restarting IIS and then attempt to create a report again.
|
|
|
|
After upgrade, login screen gives error "Length cannot be less than zero. Parameter name: length"
|
Restore the database to a pre-migrated copy. For example, if you are upgrading from Mariner 2008 R3 to PPM 2009 R1, restore the 2008 R3 database.
|
|
|
|
How to install a Mariner/Project Portfolio Management patch
|
Backup the application server Prepare a plan for restoring the Mariner/PPM database and application server from these backups Patch Steps:
|
|
|
|
How to upgrade a Mariner 6.2 installation to PPM 10.2
|
Backup the application server Prepare a plan for restoring the Mariner database and application server from these backups Upgrade Steps:
|
|
|
|
How to setup a Mariner/PPM staging environment for testing changes
|
Make a backup of the production database , copy it to the staging MS SQL Server, and restore the database . As mentioned above, many customers use the same MS SQL Server for production and staging. In that case, you would make a backup of the production database, and restore the database on the same MS SQL Server machine but give a different database name.
|
|
|
|
How to upgrade a Mariner 2008 R1, R2, R3, PPM 2009 R1, or PPM 2010 R1 installation to PPM 10.2
|
Backup the Mariner database and the Mariner DocStore database from SQL Server 2005. Install SQL Server 2008 (and SQL Server Report Server, if used) either on a new server or upgrade the existing one. If you're using a new SQL Server 2008 box restore the Mariner database and the Mariner DocStore database onto the new SQL Server 2008 box.
|
|
|
|
When logging into Mariner, user has error "Logon Failed: Unable to connect to database"
|
When logging into Mariner, user has error "Logon Failed: Unable to connect to database "
|
|
|
