How-to - Fees and Billing Utility Prerequisites for release

Guide for the prerequisites of installing a new release as part of Fees and Billing Utility support.

 Instructions

1.Download the release package from SFTP extract using password provided by Merit.

Using below credential.

releases.sftp.cognizantproducts.com

Port 22

MER_HSBC_UAT_User2

Kt.(7]yHEF_'`Ln

MER_HSBC_PROD_User2

bN45[FZ64vUU!<u

2. Stop IIS

3. Take back up of PROD database ie. ETD_PROD and MERIT_PROD using below query:

(Run the query using Merit credential)

exec msdb.dbo.rds_backup_database

       @source_db_name='database_name',

        @s3_arn_to_backup_to='arn:aws:s3:::bucket_name/file_name_and_extension',

        @overwrite_S3_backup_file=1,

        @type='full';

Source bucket in Prod account - nonprod-data-backup-and-restore  ( If you upload any data automatically files get copied in Non-prod account s3 bucket ( uat-database-restore )

You can check the status using below query:

exec msdb.dbo.rds_task_status @db_name='( databasename )';

4. After taking the backup restore the databse in UAT Environment using below query

exec msdb.dbo.rds_restore_database

@restore_db_name='database_name',

@s3_arn_to_restore_from='arn:aws:s3:::bucket_name/bakup_file'

5. Restart IIS

6. Change the connection string using the below steps:

You have the database connection details

You have the password for the destination database.

Follow below steps and change the details of the INI files
Note: Before you change any of the INI files, make sure to back them up in case you want to refer back to previous values

a. Go to the <Basepath>\INSTALL\ folder and open the SHARED.INI file

b. Look for the line starting with "CMEC1"===> which follows with the database connection string

c. Change the User, Server values to the new UAT database (Do not change the password, Leave it as Enc.[BDBPASSWORD])

d. Above this line, you should find another line starting with " CMEC0"===> and there will be a string starting with ENCMODE2: . This is the old encrypted password. Replace this string with the new encrypted password string generated above

e. Save and close the SHARED.INI

7. Run <BASEPATH>INSTALL\CLIENT\CM*.EXE to start up the system. 

Enter the administrator login credentials and Click OK to logon to the system bypassing Single sign-on (only for Testing/installation purposes). Call Merit at [phone] if you do not know the username and the password.

8. You will get a log in progress and then will get the below sequence of messages. Click OK to both to continue.

9. Click on the Cross button on top right corner to close the progress dialog below to continue

10. On the main dialog go to Setup > System parameters

If you get below sequence of messages, Click OK to both to continue

If you get below message anywhere, click on No

11.Click on button ‘Change System Category’ on the top

12. On the next dialog, check on the option ‘Confirm change system Category’.

13. Click OK on the below Dialog

14. Check the option ‘CLIENT_UAT’ and click OK.

Find the Parameter Str.[BPATH] and confirm the CLIENT_UAT column has the correct value and make sure it ends with ‘\’. If not, double click on the record to update the value. Update the field CLIENT_UAT on the edit dialog and click OK to save

15. Click OK to save the changes. Click OK to the System parameters dialog as well to save and exist.

16. Go to File> Exit to log out from CM

Logon again and make sure that you can logon to the system without any error messages such as below

17. Check if the system user has the database access

For that login to the database using administrator credential and go to security then login then select the system user.

Right click on the system user and check if the database has db owner access.

18. Check the thick client and website is working fine and check all the services is stopped.

19. Start the release using instruction provided by Merit.

 Related articles