Regional Server

The CCMDB.mdb and our sent data are located on the Regional Server which is at STB.

what is Twister?

CCMDB staff at HSC will sometimes refer to the Regional Server as "Twister". This is because HSC uses a "door" (a gateway) with the sign "Twister" to access the Regional Server. However, this door also leads elsewhere (which might confuse the help desk), and the door is not used from other locations (which might confuse data collectors).

To avoid confusion, use the term Regional Server.

How to make a Shortcut

All PCs in the Critical Care and Medicine Database Program should have a shortcut to the regional server on their desktop. Here are the instructions to make a new one if one has gone missing.

1. find an empty spot on the desktop and right-click
2. mouse to "New", then click on "Shortcut"
3. copy and paste the full name of the regional server as per below into the "Type the location of the item" line and click "Next"
4. type "Regional Server" into the "Type a name for this shortcut" line and click "Finish"

Troubleshooting Regional Server

1 - Reboot

• If you can't access the regional server, the first thing to try is to re-boot.
  • The most common reason not to be able to access the regional server is something going wrong during the login process. Usually a re-boot will fix this.

2 - Call the eHealth ServiceDesk

• If a PC reboot does not fix your access to the regional server, call the eHealth ServiceDesk. Make sure you don't refer to the server as "Twister" to avoid confusion.
  • If a re-boot does not fix your problem it is because the problem is outside of your PC. It could be either a problem with the server itself or with the network connection to the server (the latter is common at Concordia). CCMDB IT Support cannot fix this, the problem will be fixed fastest if you call eHealth ServiceDesk.

Server / Share names

At all hospitals other than HSC, the Regional Server is accessed as

• \\sbghnwfs0102\nssvol1\shared\icu_Data_Collection\

At HSC, the regional server is usually accessed under

• \\Twister\icu\

It is now possible to access the regional server from HSC directly as at the other hospitals, but this is generally slower.

Requesting Access to the Regional Server

To request access to our share on the Regional Server an eHealth change request form needs to be completed, signed by the Data Collection Manager and emailed to the eHealth ServiceDesk. servicedesk@hsc.mb.ca

• Go here to obtain the latest ehealth change request form
  • on the top RIGHT of the WRHA eHealth services page, you will see a column labeled SERVICES.
  • half way down this column, you will see REQUEST FORMS and just below this, you will find the Add, Change, Move, Terminate (ACMT) form.

Support

The Regional Server is currently maintained by Lorne Mansky from eHealth. If there are problems accessing the regional server, contact the eHealth ServiceDesk, and they will generate a work order for Lorne.

Ongoing slow performance of the regional server

(4 Jun 09) I notified the eHealth ServiceDesk that the regional server has been slow over the last few days. They explained that the server is overtaxed and they are aware of it. They are hoping to re-boot it over the next few days, but with >1500 users this needs to be coordinated first. They are also looking at upgrading and moving people off this server to lighten its load.

What this means for us is that we will need to be extra careful to check that the server is up and responsive before synching. If it takes more than 5 seconds to bring up the regional server when you double-click on the link, consider synching another day.

2010-08-20 Post-PDA Archiving

I have backed up old files to CD and removed them from the Regional Server. We used to use about 2.7GB and now use about 780MB. Specifically:

• files frmACMT.doc, QA_Septic_dataReview_23Oct2009.xls, BRR_ver2.xls, BED REQUEST REVIEW.xls, AllDiagnoses_Procedure_LIST_October_26_09.xls
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\!audits whole directory, had not been used since Nov09
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\A_audits whole directory, had not been used since Apr 09
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Admin
  • Removing Computer & PDA Info, Documentation&Presentations, PHIA, Pump_audit_drug_list and sync_lister.bat
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\L_HanDBase removed whole directory
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Maintenance\Software
  • Removing ActiveSync, HanDBase, Sprite backup, TMS
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Output
  • Removed Backup of MDBs, Crash, pre-location-change, version with issues
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Programs
  • Removed zzold_* (renamed directories), tmp_checker.bas, 2006, 7 logs, batstart.bat, HSC_micu file, stbmicu file, vic_all_admdisch.mdb, MSysMEXSpecs.txt, WIKI_CCMDB_Change_Log_2009
  • Also copied all directories to file and cleaned out PDA data remnants
  • Removed master versions prior to 2010 and all Test_Trish versions
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\S_HanDBase removed whole directory
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\VAP_CLI_audit
  • Whole directory, there had been no updates to this since Oct 09
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ccmis_backup_CSRP
  • whole directory, no idea why it was even there…
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\DATA_CLEANING_for_SITES
  • whole directory, no idea why it was even there…
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ICU stuff
  • Whole directory, there had been no updates to this since Dec 09
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\MOVE Madness VIC
  • Whole directory, there had been no updates to this since April 08
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Output
  • Gra\audit backups folder, StB\audit backups and copy of audit file folder, and EditsCardiac.xls and STB cooling_arrest audit.xls files, test folder contents (deleted), Vic TESTs July 2009 and VIC tests July_2009 folders, 2 NEW_Med Worksheet data collection Nov 2007.xls file, HSC audit backups folder, files Copy of TASKS_1.MDB, Copy of TmpV2_1.mdb, Copy of PDA_Pending.mdb, deleted to shortcuts to the wiki from this directory as well
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\STB_UPDATES\Dec 1.09 UPDATED at STB
  • Audit, Dec 1.09 UPDATED at STB, Laura, X_OTHER_STB
• \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Documents
  • versions