![]() Refer to the Management Reporter installation guides at Management Reporter 2012 for Microsoft Dynamics ERP: Installation, Migration, and Configuration Guides. ![]() Verify that the Management Reporter 2012 service account has the correct permissions on the SQL server and to the new database. ![]() Restore the Management Reporter 2012 database on the new SQL server. Sign in to SQL Server Management Studio on the new SQL server. Select Yes to the prompt Are you sure you want to remove 'Management Reporter 2012 Application Service'?. Select Yes to the prompt Are you sure you want to remove 'Management Reporter 2012 Process Service'?. In the navigation bar, select Management Reporter Services. Select Yes to the prompt Are you sure you want to remove the ERP Integration?. Select Remove to remove the ERP integration. In the navigation bar, select the name of the SQL server. Select Close on the Building Block Groups window.Įxit Management Reporter 2012 Report Designer. The default path on a Windows Server 2008 server is C:\Users\ \Documents\Management Reporter\Building Block Groups Also, select all Dimension Value Sets.Ĭhoose a location to save the. Select all building blocks to be exported on the Report Definitions, Row Definitions, Column Definitions, Reporting Tree Definitions tabs. Select the building block group to export. Under the Company menu, select Building Block Groups. You can do this by following these steps: The reports can be reimported if a failure were to occur. Start the Management Reporter 2012 Report Designer.Įxport each building block group. Record the name of the Service Account that is used.īack up the Management Reporter 2012 database recorded earlier in this topic. The database name will be listed after the SQL server name. Record the name of the database listed under the Database connection heading. Start the Management Reporter 2012 Configuration Console. Instead, a new database will be created by using the process here. If you are using a Management Reporter 2012 provider that uses the Dynamic Datamart (DDM) database, do not move the DDM database. The process for moving the Management Reporter 2012 database is as follows: The Management Reporter 2012 database is encrypted by using server-specific information, and cannot be backed up/restored without additional steps. (0x80131904): Please create a master key in the database or open the master key in the session before performing this operation.The 'pEncryptGeneralUserData' procedure attempted to return a status of NULL, which is not allowed. The operation could not be completed due to a failure on the server.Įrror message that is received in the Windows Event Viewer Application log: 1 oracle oinstall 4171 Dec 30 16:02 ewallet.This article provides a resolution for the The operation could not be completed that may occur when you restore a Microsoft Management Reporter 2012 database.Īpplies to: Microsoft Management Reporter 2012, Microsoft Dynamics AX 2009, Microsoft Dynamics SL 2011, Microsoft Dynamics GP Original KB number: 2744330 SymptomsĪfter you restore a Management Reporter 2012 database, you may receive the following error in the Management Reporter 2012 Report Designer: SQL> administer key management set key using tag 'master key' identified by "mypassword" with backup using 'masterbackup' 1 oracle oinstall 2555 Dec 30 16:01 ewallet.p12 SQL> !ls -l /u01/app/oracle/admin/MIN19_O71/wallet/tde SQL> administer key management set keystore OPEN identified by "mypassword" SQL> administer key management create keystore identified by "mypassword" SQL> alter system set tde_configuration="keystore_configuration=file" scope=both Total System Global Area 1073737800 bytes SQL> alter system set wallet_root='/u01/app/oracle/admin/MIN19_O71/wallet' scope=spfile Below is an example with your commands, where I did not use sqlnet.ora at all, because it is optional in 19c: SQL> !mkdir /u01/app/oracle/admin/MIN19_O71/wallet
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |