This solution is to be performed by an Administrator Issue: Employee requests a password reset for the Employee Purchase Program FYI:    Every debco employee should have a shortcut to the employee purchase app on their desktop.    S:\solomon\DotNetApps\EmployeePurchase\EmployeePurchaseApp.exe    If its the employees first time logging into the Employee Purchase Program, they can create a password themselves.  Solution: Step 1. Find out the employees Solomon ID. If they don't know it, they should speak with their manager. It is NOT their Windows or Solomon username.  Step 2. Connect to DEBCOSQL and launch SQL Server Management Studio  Step 3. Sign in using credentials found in LastPass Step 4. Click on "New Query" Step 5. Change database from master to DEBCO Step 5. See if the employee already has a password set up by ruining the following query.  If the CustPassword field has a value advise the Employee the Username:  SPETGANG E Password : contents of the CustPassword field declare @CustID varchar(15),  @Password varchar(15) set @CustID = 'CUSTOMER SOLOMON ID' SELECT     CustID, UserID, PSPassword, CustPassword, Enabled, CustNbr FROM         xDBCustID WHERE     (CustID = @CustID) Step 6. If the employee needs the password set use the script below.  declare @CustID varchar(15),  @Password varchar(15) set @CustID = 'CUSTOMER SOLOMON ID' set @Password = 'PASSWORD YOU CREATE'   UPDATE xDBCustID SET CustPassword = @Password WHERE (CustID = @CustID)   SELECT     CustID, UserID, PSPassword, CustPassword, Enabled, CustNbr FROM         xDBCustID WHERE     (CustID = @CustID) Step 7. Advise the customer of the credentials  Username: Customer Solomon ID Password: Password you created

This is to be performed by an Administrator  NOTE: If you are required to perform this on a terminal server such as RDSHDC01 or RDSHDC02 disable any new connections to the terminal server and then make sure all users log off the terminal server before installing.  Issue: Install or re-install Solomon. Solution: Step 1. Launch run a Command Prompt as an administrator Step 2. Mount S: with command net use s: \\debcobag.com\dfs\solomon-programs Step 3: Navigate and run setup.exe from s:\solomon\wrkstn\ The install is simple, keep clicking next until in begins the install. Setup will then hang for 5-10 min (see figure 1) then complete. Figure 1

These solutions are to be performed by an Administrator Below is a list of common Solomon issues and the solution for each. Issue 1: System Message 20223 Cannot load the frmBinLotSerial control into the VBA project Cannot enter customization mode.  or Cannot load the frmKitExplode control into the VBA project. Cannot enter customization mode Solution: Reinstall Solomon - See "Installing Solomon (Debco)" Article ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Issue 2: User has VBA errors when accessing Solomon Programs Solution 1: Close Solomon Delete all files and folders from the following locations C:\temp  c:\windows\temp  C:\Users\username\AppData\Local\Temp (you may not be able to empty 100% of these folders)  Restart Solution 2: Reinstall Solomon - See "Installing Solomon (Debco)" Article

Issue: Users will advise they are not getting Shippers in Solomon. Example: Solution: Log into the SOLADMIN user on DEBCOSOL server using screen connect and clear any errors that have popped up. Make sure to watch the screen for a min or so to make sure no more errors pop up.

Issue: Complaints are coming in that Solomon is slow or not working and the website is slow. Check: Check DEBCOSQL CPU percentage. If its running high perform the following: If the CPU is not running high, this is not the solution for your problem.  Solution Step 1 - Stop DEBCOWEB in IIS a. Sign into DEBCOWEB b. Launch Internet Information Services (IIS) c. Right click DEBCOWEB d. Click Stop Step 2 - Reload Website Catalogue (if you need help with this, Eli, Natasha or Billy are familiar with the process) a. using ScreenConnect connect to DEBCOSOL which will have an active user session under for 'SolAdmin' a. Open Solomon  b. Click on Inventory c. Under Web Site, Launch Web Catalog  d. Click on Re-Load Catalogue Step 3 - Start DEBCOWEB in IIS a. Sign into DEBCOWEB b. Launch Internet Information Services (IIS) c. Right click DEBCOWEB d. Click Start