How to stop Mail fetching before starting the application services in UAT ?

How to stop Mail fetching before starting the application services in UAT ?

1. When the application services are stopped, navigate to the bin folder [ServiceDesk Plus – MSP Home] \ bin in the command prompt and execute the startDB.bat 65432

2. Now navigate go to [ServiceDesk Plus – MSP Home] \ pgsql \ bin and execute psql.exe -U postgres -p 65432 -d servicedesk

3. Now you should be connected to the database. For MSSQL, connect to the SQL studio.

4. Execute the below queries one by one :
update outgoingmailserver set HOSTNAME ='ALPHA';
update outgoingmailserver set ALTERNATEHOSTNAME='BETA';
update incomingmailserver set HOSTNAME ='XYZ';
update TASK_INPUT set admin_status='4';

In very old builds - update TASK_INPUT set OPERATIONAL_STATUS=’his needs to be used)

5. Now start the application services and check.

                  New to ADSelfService Plus?

                    • Related Articles

                    • How to stop Mail fetching before starting the application services ?

                      Use case: When you restore the data in your test environment or trying to migrate to a new server, once the restore is done, the application if started will have emails being fetched in the new server/Test server which you would not wish to. Hence ...
                    • Mail Fetching - Error while processing attachment and inline image.

                      Issue During the process of fetching emails, attachments are dropped as a result of the presence of directory traversal characters. Furthermore, an issue arises when processing inline images, this particular error related to inline images results in ...
                    • Mail fetching - deleted flag issue

                      This message will be thrown, when you have provided a shared mailbox. The concept here is, SDP MSP reads the mail from the configured mailbox and adds it as a request. During the time, if some other application fetches the mail from the same mailbox ...
                    • Mail fetching issue: Fetching stops when mail sent from unapproved user (with huge description)

                      Issue : Mail fetching stops when mail sent from an unapproved user Issue found in Build number : 14200 Issue fixed in Build number : 14300 Issue ID: 20438 Error trace: ...
                    • Monitor Mail Fetching schedule

                       We have a workaround for checking the status of mail fetching (start or stopped). However, we do not have an option to start or stop fetching remotely.  We can integrate "Applications Manager" with SDP MSP and we can do regular monitoring (as per ...