EVENT LOG FOR SITE RPJ Most recent activity to be listed first. First line of each entry lists date, time and who is reporting. Subsequent lines of each entry aligned under Time column. Do not use tabs, only spaces. Date Time Who What -------- ----- -------- ----------------------------------------------- 07/01/2002 11:19 Dave Last week, Carter discovered that two RPJ data files, submitted to the PTAGIS3 database, had not in fact been loaded to the database (good eye, Carter!). After some expert sleuthing on his part, Carter discovered a mechanistic problem (a bug) with a temporary table that cased that table, and all dependent processes(!), to fail when there are more than ~8500 unique tag codes in a single data file. In fact that was the case with these two files, RPJ02091.E and RPJ02091.G, both from 4/1/02. The temporary solution was to manually edit the files, breaking them into smaller chunks of data. I did so, and successfully loaded all data to PTAGIS3, with the following results. select first_obs_file, count(*) from obs_site where obs_site='RPJ' and first_obs_file=last_obs_file and (first_obs_file like 'RPJ02091.E%' or first_obs_file like 'RPJ02091.G%') group by first_obs_file +------------+-------------+ |first_obs_fi|col2 | +------------+-------------+ |RPJ02091.E1 | 4464| |RPJ02091.E2 | 3703| |RPJ02091.E3 | 705| |RPJ02091.G1 | 2061| |RPJ02091.G2 | 3264| |RPJ02091.G3 | 2252| |RPJ02091.G4 | 2592| |RPJ02091.G5 | 2842| +------------+-------------+ Reprocessing these RPJ data files added 21,883 new, unique tag codes to PTAGIS3. I have searched for other RPJ data files containing large numbers of unique tags, from both 2001 and 2002. All of these files appear to be correctly and fully instantiated in the PTAGIS3 database. 04/23/2002 08:46 Dave I disabled RPJ file checking in etc/sites. 04/23/2002 07:36 Brett_Tu Dean Park and Mark Owens from Biomark shut down and removed the Rapid River system on 4/22/02. The remaining fish in the raveway were seined through the readers prior to shut down. The last file for RPJ in 2002 is RPJ02112.D 04/16/2002 13:20 bbeckley Spoke with Ralph Steiner, hatchery manager. He stated that most of the fish have left the facility and he will be crowding on the 22nd or 23rd to remove all remaining fish. Checked system and it is working correctly. Brian Beckley. 04/13/2002 15:10 acarson@ 02:TestTagFailure: Test tag failure due to fish exiting coil while timer tag fired. 04/09/2002 16:14 Brett_Tu I performed the weekly maintenance for RPJ on 4/09/02. All eight readers read the stick tags. Reader 02 signal level was about 20 to 40 percent. I quieted it down to about 3 to 7 percent by tightening the nut on the load resistor on the analog board. I turned on the diagnostic test tag to the readers to get a hit rate. Readers 01 and 02 were achieving hit rates only in the 20 to 40 percent range. I tuned them a little and they both jumped to 100% hit rate. Readers 03 through 08 didn't appear to need any tuning. I found the missing data file RPJ02083.C on the backup computer. However it was completely blank. Evidently nothing was saved to the hard disk for this file before the suspected power outage that day. The water going over the overflow readers was higher than it should be. The overflow reader was almost completely submerged. Ralph the hatchery manager said that it is very difficult to consistently maintain the water level for the pond we are monitoring and still provide enough flow to make the fish want to leave. He said fish from the other ponds are already all gone. He plans to seine the remaining fish out of the monitored pond in about two weeks. The overflow antennas may be submerged for the rest of the monitoring period, but they will keep a board over the top of the antennas to force the fish to go through the antennas instead of over the top. 04/09/2002 06:39 darren@p 01:TestTagFailure,02:TestTagFailure: Test tag failure due to fish exiting during firing of timer tag. 04/06/2002 21:28 acarson@ 05:TestTagFailure: Mass quantitiy of fish exiting causing test tag failures. 04/06/2002 21:26 acarson@ 04:TestTagFailure: Mass quantitiy of fish exiting causing test tag failures. 04/06/2002 21:25 acarson@ 03:TestTagFailure: Mass quantitiy of fish exiting causing test tag failures. 04/06/2002 21:23 acarson@ 02:LowExcCurrent,02:TestTagFailure: Mass quantitiy of fish exiting causing test tag failures. 04/06/2002 21:22 acarson@ 01:TestTagFailure: Mass quantitiy of fish exiting causing test tag failures. 04/05/2002 07:37 Carter_S From: "Brett Turley" For some reason file RPJ02083.C does not exist on the backup computer in either the data or archive directory. The primary computer crashed and I haven't been able to get into it to see if the file exists in it. I am sending the crashed computer to Scott L. in Kennewick to see if he can recover the file. The next file (RPJ02083.D) did not start until 11:27. It should have started at 09:00. So, either there was a power outage, or someone from the hatchery got in and was playing with the computer. Either way the .C file should still exist.????? On another note, Dave emailed me a list of other files that haven't been sent from RPJ: RPJ02077.D RPJ02078.E RPJ02091.C RPJ02092.I RPJ02092.J I retrieved them from RPJ and emailed them to the PTAGIS database. So they should all be there. If you have any questions, let me know. 04/04/2002 09:39 Brett_Tu I arrived at RPJ with a new computer to replace the locked-up PC1. I installed the PC, and tested its dial up connection. Everything works well. I also dialed into PC1 with PC2 using PC Anywhere to make sure PC1 was accessible with PCAnywhere. Monday afternoon (4/1/02) the hatchery crew lowered the water in the pond by taking a board out from underneath the overflow coils (05, 06, 07, 08). However, the pond wasn't lowering fast enough and the overflow coils were completely submerged. I talked to Nicki and Ralph about that. They wanted to lower the water so the fish would leave faster. They went back out and adjusted the antenna so the coils were no longer submerged. When I left there was 2-3 inches of water flowing over the overflow antenna. The coils were probably submerged for for 10 to 12 hours. Reader 02 current was at 1.1 amps, so I shut it down and resoldered a resistor to the analog board. I turned the reader back on after the repair and the current jumped to 1.9 amps. The reader was down for 4 minutes from 15:51 to 15:55. I brought some closed cell foam from the Biomark office and stuffed it in between the outflow antenna and the concrete wall at coils 05 and 08 where pit-tagged fish could hide and prevent the reader from detecting other pit-tagged fish. I tested all the readers with the test tag and checked diagnostics. I uploaded files RPJ02091.D through RPJ02092.H from PC2 to ptagis. I set both computers to data file RPJ02092.I. I set the computers up so PC1 will send data to ptagis and PC2 to archive only. 04/04/2002 09:15 Brett_Tu I arrived at Rapid River hatchery for the weekly RPJ maintenance. PC1 was locked up and not collecting data. After trying several times to re-boot the computer. Scott Livingston told me to reload Windows. I couldn't reload Windows without the machine locking up. Scott L. configured a new computer and told me he would send it next day air to the Biomark office. I uploaded files RPJ02088.A through RPJ02091.B from PC2 to PTAGIS. I checked the readers diagnostics and reader 02 current was low at 1.1 amps. I tried tuning it but I could not increase the current. It still read the test tags, so at least is still able to detect tags. One thing I noticed on reader 05 was that fish were getting in between the antenna and the concrete wall and sitting there effectively disabling that coil from reading other fish passing through it. I chased them out with the test tag stick, and thought I would bring some closed cell foam or something from the shop to fill in that gap so fish couldn't get in there. This is probably why coil 05 was reading fewer fish than the other outflow antennas as Sean Casey pointed out. I planned to return to RPJ on 4/2/02 to install the new computer. 04/04/2002 08:41 Don_Warf From: "Brett Turley" I downloaded the missing files from the RPJ backup computers and sent them to Dave Marvin. I checked the ptagis database this morning and they are now there. 04/01/2002 12:10 Scott_Li The primary computer is very sick and looks to have a serious hardware failure or conflict in some way that could not be resolved over the telephone. Computer is not stable and has proven to be unreliable. Reconfigured a replacement PC and over noght shipping it to Biomark for replacement tomorrow, 4/2/02. Sent missing database files to PTAGIS from PC2. This situation in entirety will be resolved tomorrow. 03/29/2002 17:25 acarson@ 01:TestTagFailure: Fish in the field while timer tag was fired. 03/29/2002 17:21 acarson@ 02:TestTagFailure: Will check coil at next site visit 04/01/02. Coil is still reading fish and test tags. Appears to be fish in the field when timer tag fired. 03/29/2002 15:12 Scott_Li Also, UPS's will be installed on PC1 and 2 during the maintenence visit.. 03/29/2002 15:10 Scott_Li Rapid River will not be submitting data files until Monday, April 1, possably sooner, due to a Dial-up Networking problem. The situation is that if the computer is rebooted, the password dialog box within the dial-up PPP connection will not retain the password to login into the ISP even when told to 'Save Passwd'. Action items to correct this problem is, delete all *.pwl files in windows dir. uninstall the OEM version of Dial-up networking, reinstall Win98SE version of Dial up Net, install client ' Windows family logon, Every attempt was made repair this situation via remote control. Called site for assistance but no one was available to help. New information on the cause of this problem has been made available , Biomark will be at RR for a general Maint check on Monday and to help facilitate with the reconfiguration. 03/27/2002 14:06 acarson@ 04:TestTagFailure: Raw data files show fish in area when timer tag fired. 03/27/2002 14:02 acarson@ 02:LowExcCurrent,02:TestTagFailure: Test tag was disconnected during testing of system. Low exciter current due to bad solder connection of load resistors on analog board. Re-soldered and re-tuned. 03/27/2002 14:00 acarson@ 01:TestTagFailure: Test tag was disconnected during testing of system. 03/26/2002 19:52 Anthony_ During site visit on 03/26/02 I discovered the exciter cables swapped for coils 01 and 02. This was noticed while running stick tests. While the system was being installed I believe the cables were swapped while determining a timer tag failure and did not get replaced to the proper transceiver after the problem was corrected. After returning exciter cables to the correct transceivers coil 02 was showing exciter current low alarms. This was traced to an intermittent solder connection at the load resistor. The exciter current level was fluctuating from .5, 1.1, and 1.9 amps. Analog modification to transceiver 2B, s/n 1007, was re-soldered and re-tuned. System was again tested with stick tag. By swapping the exciter cables the data as of 03/26/02 13:10:03 for coils 01 and 02 will also be swapped. The utility computer is able to connect with ctc.net but cannot find the server or DNS through Netscape. Frank Gifford with ctc.net is working on fixing the problem. I will continue to update his progress. 03/26/2002 17:15 Carter_S Anthony, Can you get the missing file (RPJ02083.C)? +--------------+---------------------+---------------------+-------------- -------+ | File | Opened | Closed | Gap | +--------------+---------------------+---------------------+-------------- -------+ | RPJ02083.D | 2002/03/24 11:26:00 | 2002/03/24 14:00:00 | -- | | RPJ02083.B | 2002/03/24 03:00:00 | 2002/03/24 06:00:00 | 19560 sec | 03/26/2002 07:15 acarson@ 04:TestTagFailure: Test tag failure due to another tag in the field while timer tag fired. 03/26/2002 07:14 acarson@ 04:TestTagFailure: Test tag failure due to another tag in the field while timer tag was fired. 03/24/2002 14:24 dlwarf@p 02:TestTagFailure: Activity while firing TT. 03/23/2002 13:16 dlwarf@p 02:TestTagFailure: Alarm due to activity during TT firing. 03/22/2002 11:47 acarson@ 02:TestTagFailure: Test tag failure due to another tag in area when timer tag fired. Fish was hanging around coils #02 and #04 for 2 minutes. 03/22/2002 11:13 acarson@ 07:TestTagFailure: Log files show other tags in the coil when timer tag was fired. 03/20/2002 11:48 scott COIL EFFICIENCY RESULTS for RAPID RIVER VOLITIONAL - OVERFLOW From: 19-mar-2002 00:00 To: 20-mar-2002 00:00 -------------------------------------------------- TOTAL MISSED ESTIMATED EFFICIENCY ------- ------- -------------------- Individuals 742 Coil 05 96 646 0.2 % Coil 06 243 499 0.2 % Coil 07 252 490 0.2 % Coil 08 154 588 0.2 % Coil 05 looks weak. Could be the tags p/min rate , Instantaneous Eff. report does not indicate that the monitor was not swamped with a slug of fish that would decrease the reading efficiency.. Will have Maint. personell look at this the next site visit if not sooner. 03/20/2002 06:51 acarson@ 08:TestTagFailure: Test tag failure accured while testing and tunning antenna. 03/19/2002 14:23 Scott_Li Reconfigured dialup networking configuration on PC1 . The user name and passwrd to the ISP was missing in the Dial networking properties. Not sure how this could happen but may be attributed to the software upgrade that took place the previous weekend. Irregardless, automated file transfers have been restored. Will monitor situation to ensure consistant uploads. 03/19/2002 08:43 Scott_Li PCA's to RPJ-PC1 to diagnose why the site has not uploaded files. See below snippet from log file. Called the ISP for this site and left a message to have their tech. support call Kenn. PTOC and help resolve this issue. Will Biomark will be on the site today, sometime this morning, will follow up on situation. Looks like the problem is at the ISP end. Establishing a Dial-up connection using 'ctcweb' phone book entry... Dial-up 03/19/02 08:13:28 INFO Open port:OK Dial-up 03/19/02 08:13:28 INFO Port opened:OK Dial-up 03/19/02 08:13:28 INFO Connect device:OK Dial-up 03/19/02 08:14:00 INFO Device connected:OK Dial-up 03/19/02 08:14:00 INFO All devices connected:OK Dial-up 03/19/02 08:14:00 INFO Start authentication:OK Dial-up 03/19/02 08:14:00 INFO Authenticate:OK Dial-up 03/19/02 08:14:32 INFO Disconnected:The port was disconnected by the remote machine. Dial-up 03/19/02 08:14:32 INFO The port was disconnected due to hardware failure. Sys 03/19/02 08:14:32 INFO Will attempt to connect again in 15 seconds, retry #2... Sys 03/19/02 08:14:47 INFO Establishing a Dial-up connection using 'ctcweb' phone book entry.. 03/18/2002 12:43 Dave On Monday, March 18, Ralph Steiner (RAPH Manager) reported that PTOC was here Friday and Saturday to repair the emigrant PIT-tag antenna. Final screens pulled as of this A.M. Release underway. 03/18/2002 11:10 scott This is the list of the new TimerTag codes for the Underwater Overflow Antenna that was installed on 3/16/02 3D9.1748CF5297 XX 01 3D9.1748CF5320 XX 02 3D9.1748CF4FD1 XX 03 3D9.1748CF527E XX 04 03/18/2002 10:46 Carter_S Timer tags added and re-mapped after monitor swap out: Coil 1: 3D9.1748CF5297 Coil 2: 3D9.1748CF5320 Coil 3: 3D9.1748CF4FD1 Coil 4: 3D9.1748CF527E Coil 5: 3D9.1748CF52D1 Coil 6: 3D9.1748CF538D Coil 7: 3D9.1748CF53B8 Coil 8: 3D9.1748CF54A3 03/18/2002 07:47 Carter_S Tags show up at rpj since the new monitor was installed. Are these timer tags? 3D9.1748CF4FD1 3D9.1748CF527E 3D9.1748CF5297 3D9.1748CF5320 3D9.1BF0DFE1E3 3D9.1BF13D5DAF 03/17/2002 16:04 scott Biomark replaced the underflow 3 coil antenna array on 3/16/02 with a 4 coil overflow array now referred to as the " Underwater Overflow" Antenna. Minimon interrogation software was upgraded to ver. 1.0.81 by Brett Turley. The software upgrade occured at ~ 0830 , 3/16 file sequence # 75.c but have not confirmed this information. Requested Biomark to insert markers in files when Minimon was shutdown and restarted after the upgrade in order to reference and track activity. Will follow up and post exact times of significant events for PTOC reference. Also, the user.exe and user32.dll files within windows/system dir. have been replaced to avoid the ghost button syndrome after making a dial-up networking connection. The upgrade to the facility looks to be fairly seamless and all configurations look correct but will PCA to PC1 and 2 to be sure. 03/17/2002 10:13 acarson@ 07:TestTagFailure: During installation of 4 coil underwater antenna a problem was found with the labeling of test tag cable. Test tag cables are now correctly labled and connected to the correct transceiver. 03/17/2002 10:03 acarson@ 03:BadExcFreq,03:BadOscFreq,03:LowExcCurrent: Alarms are associated with the underwater antenna that was removed 03/15/02. 03/17/2002 10:02 acarson@ 02:BadExcFreq,02:BadOscFreq,02:LowExcCurrent,02:TestTagFailure: Alarms are associated with the underwater antenna that was removed 03/15/02. 03/17/2002 10:00 acarson@ 01:BadExcFreq,01:BadOscFreq,01:LowExcCurrent: Alarms are associated with the underwater antenna that was removed 03/15/02. 03/15/2002 13:21 Carter_S Configuration changed due to failed coil and replacement... RPJ - RAPID RIVER VOLITIONAL RELEASE -------------------------------------------------------------------- -- Current Configuration -> Seq Nbr: 120 Main? N, Active? Y, Parallel_A_B? A, Poll? N Current Configuration: Seq Nbr 120 -> 15-Mar-02 To Present Comment: Underwater unit coil failed. Replaced underwater orifice with underwater U shaped antenna. Monitors in Sort_Str sequence: Nbr 1 -> UNDERWATER U-ANTENNA Mon_Ctgry_Str: RVR, Entry_Y_N? Y, Exit_Y_N? Y, Sort_Str: 1 (Coil,Controller): (01,05) (02,06) (03,07) (04,04) Nbr 2 -> OVERFLOW U-ANTENNEA Mon_Ctgry_Str: RVR, Entry_Y_N? Y, Exit_Y_N? Y, Sort_Str: 2 (Coil,Controller): (05,09) (06,0A) (07,0B) (08,08) 03/13/2002 11:06 Carter_S three coil underwater orifice antenna will be replaced with four coil underwater u-shaped antenna on Friday, March 15, 2002 to address bad coil issue. Thanks to Henry and Larry at Fish Passage Center for making spares available. --Carter 03/13/2002 10:52 Dave Ralph Steiner, RAPH hatchery manager reports: "... some antenna problem. Will not release PIT-tagged fish until Monday 3/18/02." 03/07/2002 10:54 Dave Ralph Steiner, the hatchery manager at RAPH, called to let us know that they'll start their volitional release from the central pond (the one with PIT tags) next Monday, March 11. The pond has 1.07M fish in it, of which ~185k are PIT-tagged. All fish will exit the pond through the PIT tag detectors. 03/06/2002 17:48 acarson@ 01:BadExcFreq,01:BadOscFreq,01:LowExcCurrent: Alarms occurred while working on Coil#2. All settings and status indicators returned to normal after testing. 03/06/2002 17:37 acarson@ 03:BadExcFreq,03:BadOscFreq,03:LowExcCurrent: Alarms occurred while working on Coil#2. All settings and status indicators returned to normal after testing. 03/06/2002 17:30 acarson@ 02:BadExcFreq,02:BadOscFreq,02:LowExcCurrent,02:TestTagFailure: During site visit 3/5/02 the current was back to its normal setting (.4-.5A) with no alarms. The alarms stopped seconds after the last "TestTagFailure" at 2002/03/04 15:41:31. All connections to the transceiver were secure and tested for intermittent contacts. I found no problems with the transceiver or antenna. I was unable repeat the cause of the alarms. All settings and status indicators have returned to the levels set during the final installation of the system. Prior to leaving site the "test stick" was used to confirm the antenna was reading tags and communicating to Minimon. I have not yet determined the problem but will continue to monitor and check for this condition during the next site visit 3/12/02. 03/06/2002 14:54 Dave PIT-tagged fish were first introduced into the main pond at Rapid River on February 6, 2002. 02/23/2002 11:54 darren@p 02:BadExcFreq,02:BadOscFreq,02:LowExcCurrent,02:TestTagFailure: It appears that maybe the coil or cable has failed. I don't know enough about the setup of this site. I will consult with Sean Casey and Scott Livingston and Anthony Carson to come up with a failure and a solution. 02/08/2002 12:52 Carter_S Turned on check file submission flag in etc/sites for PRJ. Also set file interrogation file type to minimon from multimon. 02/08/2002 10:37 Carter_S The following timer tags and coil associations were made For RPJ. Note: there were no existing timer tags associated With this site. 3D9.0EEEEEE57A RPJ 01 6 3D9.1BF0DB3F2B RPJ 02 0 3D9.1BF0DB4447 RPJ 03 0 3D9.1748CF52D1 RPJ 04 0 3D9.1748CF538D RPJ 05 0 3D9.1748CF53B8 RPJ 06 0 3D9.1748CF54A3 RPJ 07 0 02/08/2002 09:55 Carter_S Where did tag code 3D9.1748CF52D1 come from? I added it as a 'test_tag' today since it showed up hundreds of times when RPJ was installed yesterday. I removed it's associations from the obs_data table For yesterday, but it has apparently been used in previous years. Don't we have 'official' test tags we should use instead? ####End of Event Log for RPJ###