Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

Business Intelligence

Unassigned

P21 - Third Party App

Other Third Party App

IT - Technology

IT - P21

Accounts Payable

Credit Card "PO" Purchases

DGI Forms

Canada Requests

Payroll

Direct Deposit Change

Print...

How to Confirm Groves SISM is running

The alert that Groves SISM isn't running fires when files have been sitting in the import path for more than 30 minutes. If a file is large enough it could still be running but just takes longer than 30 min to import. to confirm the service is still running follow these steps:

1. RDP in to GISQL1

2. find the oldest import file in \\GISQL1\ImportFiles\

3. Copy the header files onto the desktop, open the copy and find the customer ID.

4. In SQL find the latest order from that customer ID.

5. For that order number find the number of lines. Wait 15 seconds and run the query again. If the number of lines increases than the service is running. If the number of lines doesn't change, perform the same test again but wait a minute.

6. If the service is running notify everyone on the email alert the service is running. If it stopped notify everyone of that as well. The service will have to be restarted. Any partially imported orders will need to be canceled. Any POs or Transfers created from those orders will also need to be canceled.

groves imports services sism

Creation date: 11/16/2022 9:59 AM Updated: 11/16/2022 9:59 AM

DataImage51.png

Files		Sort by Name Sort by Date
	DataImage51.png 727.1 KB