This article explains the necessary steps to get our applications back online if we lose CRMVS02 virtual machine.

Applications Recovery Procedures for VS02 Outage

 

Background

CRMVS02 contains several key servers which are critical to Walbec business operations. These include, but are not limited to:

 

Apex (SQL and APP)

CRMSQL1 – Has to do with Daily Job Reports, Report Server

CRMSQL2 – Has to Do with Daily Job Reports, Report Server, Lastrada

CRMSQL4 – Has to do with Kofax (E-mail invoices to CMIC automation)

E360 (SQL, APP, and TASKS)

HBSQL (HeavyBid)

HCSSFS (HCSS File Server)

HCSSTasks

HCSS Terminal Servers 6-10

HJSQL (HeavyJob)

RPTSVR (Report Server)

 

 

Recovery

If CRMVS02 goes down almost all of the systems will naturally recover. To be sure, it’s important to go through the servers individually to check as well as follow the below special instructions for specific applications. Essentially, most of the instructions are identical to logons we must perform for server checks.

 

Log Back on to Servers

We need to do this to allow certain services/network mappings to work.

 

HCSSTASKS

1. Launch the Remote Desktop Connection item
2. Select or type in HCSSTASKS in the Computer drop list field
3. Click the Connect button
4. Log in with the hcsstasksadmin account.
5. (If it appears) On the Important Notice! window, click OK
6. Close the Remote Desktop Connection window; do not logout
7. On the "Your remote session will be disconnected" message, click the OK button
    

E360TASKS

1. Launch the Remote Desktop Connection item
2. Select or type in e360tasks in the Computer drop list field
3. Click the Connect button
4. Log in with the e360tasksadmin account.
5. (If it appears) On the Important Notice! window, click OK
6. Close the Remote Desktop Connection window; do not logout
7. On the "Your remote session will be disconnected" message, click the OK button

HBSQL

1. Launch the Remote Desktop Connection item
2. Select or type in hbsql in the Computer drop list field
3. Click the Connect button
4. Log in with the hbsqladmin account.
5. (If it appears) On the Important Notice! window, click OK
6. Close the Remote Desktop Connection window; do not logout
7. On the "Your remote session will be disconnected" message, click the OK button

 

 

Special Case: HeavyJob Timecards

Restarting Boomi Listeners

1. In Boomi, go to Runtime Management
2. Select “boomiatom.crmanagement.com”
3. Click “Listeners”
4. Click “Restart” then “All Listeners”
5. Repeat for boomiatomtest.crmanagement.com (and dev if needed)

Re-initializing HJ Timecard Import

After restarting the Boomi listeners,

1. Navigate to \\hcssfs\hcss\production\heavyjob\ExportPayroll
2. Under each business unit folder, check for existing file called “CrewTimeHeader.csv”
3. Rename the file (can be as simple as “CrewTimeHeaderX.csv”
4. Rename the file back to “CrewTimeHeader.csv”
5. Repeat for each business unit folder.