16-channel tension test - problem solving page   

What you need to do to get Eddie's programs to read passports and compare various tension data:

1. copy all needed files to your computer
2. get copies of the four databases (Hampton, CERN, Indiana and Duke) and the Indiana Interface (called Production DB at IU).
3. install the ODBC connections
4. install the programs

What you need to do to update Eddie's programs to a newer version:

1. using the "settings/ add/remove programs" utility, remove the previous copy of the program
2. transfer all needed files to your computer as described below
3. install the programs as described below. You only need to run the "install" file from the installer directory, not the one for the SQL connections.

Instructions for all these steps are given below. If you have a better way or run into problems, please let me know.

Best way to transfer files:

• From Windows Explorer, access  ftp://hep.physics.indiana.edu/pub/eddmorri/
• Right-click on the TRT_Barrel_Wire_Tension folder, copy and paste it to your computer

To install Eddie's Labview programs on your machine:

• Run the install which is in the TRT_Barrel_Wire_Tension\Installer directory
• Run the setup which is in the TRT_Barrel_Wire_Tension\SQL\Install directory
• Set all six ODBC connections as described below: you'll need to have all databases available somewhere at your institute; contact Fred Luehring if you need help in organizing automatic transfer of all databases every night.
• Double click on TRT_Barrel_Wire_Tension Labview icon to run it
• The first time, you will be prompted for the lvanlys.dll library. (This might now be obsolete)
• All vi's can be run from the TRT  Barrel Wire Tension menu to compare various sets of Tension data.

To set the ODBC connections needed by Eddie's comparison VI programs:

• from the settings /control panel/ administrative tools / data sources (ODBC)
• under the "System DSN tab: click on "Add".
• select Microsoft Access Driver (*mdb) then click on "Finish".
• data source name: enter a nickname for the database. To get Eddie's comparison programs to run on 16-channel tension tester data, the nicknames should be: CERNDB, IndianaDB, DukeDB, HamptonDB and holesDB. 
• A 6th ODBC connection is needed: nickname: ProductionDB and this one should point to Indiana Interface.mdb.
• click on "Select..." and use the browser to select the desired database (with mdb suffix).
• repeat this for: CERN, IU, Duke, and Hampton databases (and holes DB for Eddie's vi's).

Basic info on how to use these programs:

• Click on the TRT Barrel Wire Tension program in the Program Files area to access all programs
• Make your selection using the tab and go button, then click on the black arrow to run the program after selecting site and module. 
• The first time the program is run in a session, you'll need to run the program twice to get the data.
• Each program has a tab on the main menu and some information on what it is going to do.
• Some programs allow comparison at one site, some between sites, some with single or 16-channel data
• You can rotate the surface plots by left clicking on the plot and holding it down, then gently move the mouse around. It takes some skills but Eddie pretends one can get used to it! 
• You can also zoom in and out using the wheel on the mouse for these surface plots
• You can change the sensitivity and cut-off of these comparisons, flip to back and front ends using the various buttons on the screen
• Make sure you are requesting data that exist. For example, early modules produced at IU won't have the 16-channel data available and CERN site won't have single wire data except for the few wires that will be reworked.
• when updates become avilable, use the settings/ control panel / add/remove programs menu to remove the old program cleanly, then download the new files and reinstall. No need to reinstall the SQL drivers, just the TRT Barrel Wire Tension files.

Using pscp to copy files from Indiana to get programs from Eddie's directory: (account needed at Indiana University)

• Install Putty on your machine for SSH ftp
• Get a Command prompt window starting from Start \ Programs \ Accessories \ Command Prompt
• type set PATH=C:\path\to\putty\directory;%PATH% in that window
• type pscp -r pgagnon@hep.physics.indiana.edu:/var/ftp/pub/eddmorri/TRT_Barrel_Wire_Tension C:\TRT_Barrel_Wire_Tension  This will copy recursively (i.e. including all sub-directories) all content of directory TensionMaster into folder TensionMaster on disk C.
• You will be prompted for pgagnon password on hep.physics.indiana.edu:
• Be patient: it takes for ever but has the recursive feature

If the transfer of one database fails or you want to get a fresh copy: (the scheduler runs the file ftp_CERN.bat every night. These commands are just a replica).

• Get a Command prompt window starting from Start \ Programs \ Accessories \ Command Prompt
• type set PATH=C:\path\to\putty\directory;%PATH% in that window
• type:

ftp southshore.physics.indiana.edu
user "TRT Database"
usual trt password... ask Fred L.
bin
lcd "C:\CERN Barrel DB"

cd "/DBServerF/Duke"
get "DukeDB2000.mdb"
cd "/DBServerF/Hampton"
get "HamptonDB.mdb" "HamptonDB2000.mdb"
cd "/DBServerF/TRT Database"
get "IndianaDB2000.mdb" 

General tips if you cannot get a good reading on one wire on the 16-channel tension tester:

• check to see if there is supposed to be a straw attached to that channel
• check to see if there is HV on the HV pad corresponding to this wire during normal scan
• make sure the module is properly seated on the loud speaker
• increase the "Output level" on the function generator
• increase the frequency range for the scan
• using Eddie's programs, check that wires located further away from the speaker have good readings

• Name: pauline
• Synopsis: cannot record data into DB due to some SQL error
• Date: Thursday, July 10, 2003
• Time: 18:52

Description

The error message is misleading and varies: it can say that there is a data format mismatch or things like that.

Logon to trt-barrel5 as administrator or pauline. Check the properties on CERNDB2000.mdb in CERN Barrel DB See if at least 7 or 8 names appear there, all having full access Note who has what kind of privileges and notify Pauline or Fred Luehring

To fix the problem: Un-check the tick mark about inheriting access rights from parent Say "yes" to the copy business Click on "Apply" Re-check the box about inheritance Click on Apply again OK

This problem is caused by the DB compression procedure that takes place every night. When compressing the DB, it creates a temporary file and then renames it CERNDB2000.mdb but for some obscure reason, the inheritance of privilieges is lost. This problem is under investigation.