CA Service Management

Expand all | Collapse all

HOW TO REPLACE TESTING(With customized data) MODS FOLDER TO DEVELOPMENT(newly created)

  • 1.  HOW TO REPLACE TESTING(With customized data) MODS FOLDER TO DEVELOPMENT(newly created)

    Posted 06-08-2017 11:19 AM

    How to replace MODS folder with existing MODS from testing to development.

    Please guide me the steps for the same ?

    Is it so , if we will simply replace MODS test environment to development environment by replacing it?

    How it can be done please guide.



  • 2.  Re: HOW TO REPLACE TESTING(With customized data) MODS FOLDER TO DEVELOPMENT(newly created)

    Broadcom Employee
    Posted 06-08-2017 12:03 PM

    If you are dealing with just form customizations, you can copy the NX_ROOT\SITE\MODS folder between environments.  After copying the folder, you can run the following commands:

     

    pdm_webcache -b

    pdm_webcache -H

     

    If you also have schema/MDB customizations, there is more steps involved.



  • 3.  Re: HOW TO REPLACE TESTING(With customized data) MODS FOLDER TO DEVELOPMENT(newly created)

    Posted 06-08-2017 01:37 PM

    Thanks Paul...

    yes we too have schema/MDB customizations...

    Please guide further steps...



  • 4.  Re: HOW TO REPLACE TESTING(With customized data) MODS FOLDER TO DEVELOPMENT(newly created)

    Broadcom Employee
    Posted 06-08-2017 03:09 PM

    The following steps should help you:

     

    1. Run a SQL Restore and restore the MDB from your current  SDM environment to the new SDM environment. Ensure to set the option to “OVERWRITE entire database” when restoring.
    2. After the SQL restore is complete you must run the stored procedure in SQL to fix the orphaned users – which are created when restoring a db from one SQL instance to another: sp_change_users_login 'AUTO_FIX','ServiceDesk'
    3. In the new SDM environment, run pdm_configure –DO NOT SELECT TO LOAD DEFAULT DATA **In the configuration wizard when you click “next” at the database section you might see a pop up a box saying that “this database was previously configured by …… are you sure you want to configure it” you will click “Yes” here – this is only because you restored the MDB from a different environment.
    4. After pdm_configure completes, start Web Screen Painter (also called WSP) and log in
    5. Go to Tools > Schema Designer
    6. Click on any table on the tree on the left
    7. Put an “X” in the description field for that table on the right
    8. Go to File > Save
    9. Close the Schema Designer window
    10. In the main WSP window, click File > “Save and Publish”
    11. Click OK on the dialog boxes
    12. Exit out of WSP and close all WSP windows and browser windows
    13. Run: pdm_halt –w (this stops all SD Services)
    14. Run: pdm_publish (this will merge the schema and load the correct schema files)
    15. Copy the NX_ROOT\site\mods directory from the current SDM environment and and put in place in the new SDM environment  
    16. Run another pdm_configure – again DO NOT SELECT TO LOAD DEFAULT DATA
    17. After configuration is complete – start service desk services if not started