$SumMIT Problems & Solutions

You get this error message when trying to run SumMIT with Oracle: "Sorry, the connection failed. Oracle error - 1017. Please check your userid and password."

To get an Oracle userid (or if you forget your Oracle password), contact:

• Diane Monahan at 3-6730 or dianem@mit.edu

You get this error message when trying to run SumMIT with Oracle: "Sorry, the connection failed. Oracle error 12154. MITOTG not found in tnsnames.ora file."

You need to update Oracle's TNSNames file.

(Windows) To update a Windows computer with the latest Oracle names file, go to the MIT Software Distribution for Windows web page; then download and install the TNSNames Updater.

(Mac) To update a Mac computer with the latest Oracle names file, go to the MIT Software Distribution for Mac web page; then download and install the TNSNames Updater.

The SumMIT logon window comes up, but the UserID and Password fields are oversized and don't fit on the screen.

You get this error message when trying to logon to ESandi or another SumMIT application

You get this error message when trying to run SumMIT with Oracle: "Sorry, the connection to the Mainframe has failed. The O7DAL extension was not found."

(Windows users) When you double click on a shortcut to one of the SumMIT application files (LBRs), Omnis7 opens, but no logon screen displays.

To display the logon screen, you need to use Open library... from the File menu on the menu bar.

To display the SumMIT logon screen directly after clicking on a shortcut, you need to enter information about the shortcut "target". To do so,

1. Right-click your SumMIT shortcut file;

2. In the menu that displays, select Properties (using a left-click);

3. Select the Shortcut tab;

4. In the Target field, type the path to the SumMIT LBR file that shortcut is to open, for example C:\SumMIT\Sumtime.lbr

   You can use the Find Target... button to determine where the LBR is on your drive (but you still need to type in the information, as double clicking on the LBR just opens it).

5. Click OK to save the target information and close the Properties windows.

( 12/17/02) When you try to (re)install Oracle, you get a message saying that "an error occurred communicating with the ftp server....Server response; error code = 103 - error resolving domain name".

Alternatively, Oracle is incompletely installed in the Oracle 7.3 folder - only the Network and Admin folders are present.

Note: The ftp server used by the installer has been eliminated, with the result that selecting Yes causes Oracle to download incompletely.

If you need help with this step, contact the Business Liaison Team at (617) 252-1177 or business-help@mit.edu

(Mac users with OS X)

When you try to run $SumMIT or Omnis7, they "unexpectedly quit" or experience a "shared library" problem.

You need to set Omnis 7, which is an application program in the SumMIT folder, to run in the "classic environment". To do so,

1. Find the Omnis 7 application in your SumMIT folder, and click on it once to highlight it.
2. Select Get Info, General Information from the File menu.
3. Click on Classic environment
4. Click on close box to exit Get Info window.

You should now be able to run $SumMIT.

• There is not enough memory on the user side,
• Cannot obtain Oracle version number,
• Omnis Oracle Extension not found,
• Oracle error - 1019

You get this message when trying to logon to $SumMIT with Oracle.

Your Oracle application is not working; it will not support SumMIT, BrioQuery, or COEUS.

The simplest solution is to reinstall Oracle.

(12/02) When installing Oracle, you need to answer NO towards the end of the installation, when asked if you are on the MIT network. Otherwise, Oracle is not properly installed

For further explanation, see the first error described in "Mac users" section.

(Mac users) SumMIT doesn't work; when you go to your Oracle folder, the Oracle Applications folder displays a file icon (rather than a folder icon).

As a result, your Oracle Applications folder does not open (so that Oracle cannot be tested).

1. In the Utilities folder of the Mac OS 9 CD, find Package First Aid.
2. Drag the "broken" Oracle Applications folder over the Package First Aid application.
   
   You should now be able to run SumMIT and/or test Oracle.

(Mac users) You double click to run one of your SumMIT files, but:

• your logon is not accepted (the logon screen shows a default Connection Type of "MIT Network"),
• the SumMIT error mentions "Mac TCP, DAL".

You may have more than one version of Omnis (the programming environment for SumMIT) on your workstation. If so, when you double click on a SumMIT file, an older version of Omnis is being run.

To run SumMIT, and then correct the situation on your workstation,

• (To run SumMIT) Double click on the application file, Omnis7, in your current SumMIT folder; from its File menu on the menu bar, select Open Library...; from the Select Library window, open the SumMIT file to run and login.
• (To fix workstation) Use File, Find... to find and delete old versions of the SumMIT folder; then your current SumMIT files should start up when you double click on them and login.

You get this message when you try to run the timesheet system, even though your payroll authorization has not changed.

On a Mac, SumTime (the Timesheet system) will not run unless the filename used is "SUMTIME.LBR" (but whether the letters are in upper or lower case doesn't matter).

If you changed the filename for any reason, you need to change it back in order for the Timesheet system to open.