Regional Server: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
m cleaned out link to Conc info
 
(48 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{{Discussion}}
The [[CCMDB.accdb]] and our sent data are located on the '''Regional Server'''
*NOTE: July 17, 2012 - ccmdb has not yet been moved over the server.  Tina was to look into some type of problem and then email all staff when move the new server location is a go.[[User:TOstryzniuk|Trish Ostryzniuk]] 15:08, 2012 July 17 (CDT)
* \\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION
There is a shortcut on all laptop desktops called "Regional Server" - please leave it called so all laptops are the same and covering collectors know what to look for.


The [[CCMDB.mdb]] and our sent data are located on the '''Regional Server'''  
'''''If you still have the old "Regional Server" shortcut please delete it.'''''
* '''\\sbghnwfs0102.ad.wrha.mb.ca\NSSVOL1\shared\icu_Data_Collection\'''
*New one will be '''\\ad.wrha.mb.ca\WRHA\REGIONWRHA\SHARED\ICU_DATA_COLLECTION'''
== New Regional Server ==
There have been ongoing problems with the regional server so eHealth has offered to move us onto a new server.
To move us over to the new server I need to first make sure all laptops can access this. Please do the following and let me know if you have any problems:
* go to the current regional server and double-click the link "'''copy_RegionWRHA_to_desktop'''"; this will put a shortcut labeled RegionWRHA onto the all users desktop on your laptop, i.e. all data collectors using the laptop should be able to see the shortcut
* double-click the shortcut;
** if it opens, please save some file with a name that lets me know that you and your laptop are able to access
** if you have problems accessing the new server, please contact Tina


Once I know everyone can see the new server I will move the contents of the regional server over and change your ccmdb.mdb to send to the new server.
== Troubleshooting Regional Server ==
If you can't access the regional server, ie the shortcut on your desktop doesnt' get you there, then:
=== 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]] ===
* 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.
* '''If a PC reboot does not fix your access to the '''regional server''', call the [[eHealth ServiceDesk]]'''. [[:Category:IT Support | CCMDB IT Support]] cannot fix this, the problem will be fixed fastest if you call [[eHealth ServiceDesk]].
** tell the helpdesk that "this is '''not a mapping issue''' because we access the server using the '''UNC name'''"
** if the server is running fine, and the network connection of your location to the rest of the WRHA is up, then the problem might be with the way your account is set up; the help desk might they want to check how access rights should be set up, refer them to the instructions to set up a Regional data collector, as written by '''[[Sandy Kroeger]]''' from eHealth.
 
== Requesting Access to the Regional Server ==
see [[Setting up a New Data Collector]]
 
== What if I am missing the shortcut ==
see [[Desktop install.bat]]
 
== Regional Server Dependencies ==
If the Regional Server changes locations all the automation accessing it needs to be updated:
* [[CCMDB.accdb]] - should be single location fix in in function regional_server now
* [[News and Backup]] batch file
* desktop shortcuts (see [[Laptop Setup]] for more info)
* Pagasa's [[:Category: Batch Files]]
* [[CCMDB Cleaner.mdb]]
 
== Related Articles ==
{{Related Articles}}
 
== Legacy Info ==
{{Collapsable
| always=Legacy Info
| full=
=== old regional server sbghnwfs0102 ===
Until 2012-08 we used a different regional server. After we had ongoing difficulties connecting to it eHealth moved us over to a new one. The old one was
* \\sbghnwfs0102.ad.wrha.mb.ca\NSSVOL1\shared\icu_Data_Collection\


After and only after that is done please delete the Regional Server shortcut.
Moving to Regional Server will discontinue using [[#Twister]] altogether, so please ensure you don't refer to Twister after this is implemented.


Moving to RegionWRHA will discontinue using Twister altogether, so please ensure you don't refer to Twister after this is implemented.
The old regional server was hosted at StBoniface; I don't think the new one is.


=== Migration Checklist ===
==== Migration Checklist ====
* ensure all have access; checklist is at \\ad.wrha.mb.ca\WRHA\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\zzzchecklist.txt
* ensure all have access; checklist is at {{Regionalserver|zzzchecklist.txt}}
* update [[Net use reg srv.bat]] (done, now maps to R: as well in case anyone had that hard-coded to the old regional server; needs to be rolled out with rest)
* update [[Net use reg srv.bat]] (done, now maps to R: as well in case anyone had that hard-coded to the old regional server; needs to be rolled out with rest)
* change how regional server is accessed by [[CCMDB.mdb]]
* change how regional server is accessed by [[CCMDB.accdb]]
** linked tables - done
** linked tables - done
** sending - done  
** sending - done  
* fix desktop shortcuts (output, timecards and supply order) (delete old ones) (this may be complicated by the fact that some collectors have renamed theirs)
* fix desktop shortcuts (output, timecards and supply order) (delete old ones) (this may be complicated by the fact that some collectors have renamed theirs)
** updated output folder, work hours and ordering shortcuts  
** updated output folder, work hours and ordering shortcuts  
* [["News and backup" batch file]] - make part of copy bat and download new one
* [[News and backup]] batch file - make part of copy bat and download new one
** updated both batstart.bat and backup.bat; new backup.bat will be rolled out automatically and new and cleaned up batstart.bat will be used in future installs. Shortcut should work with old batstart.bat.
** updated both batstart.bat and backup.bat; new backup.bat will be rolled out automatically and new and cleaned up batstart.bat will be used in future installs. Shortcut should work with old batstart.bat.
* added following to backup.bat:
* added following to backup.bat:
Line 36: Line 63:
* set up roll-over to run at next news-and-backup [[User:Ttenbergen|Ttenbergen]] 17:03, 2012 August 31 (CDT)
* set up roll-over to run at next news-and-backup [[User:Ttenbergen|Ttenbergen]] 17:03, 2012 August 31 (CDT)


The following bat files will need to be updated when moving to new server:
*Pagasa's Append.bat from twister to her C drive.
*Pagasa's StatusReport.bat which copies from twister to SAN (X drive).
== 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]]'''. It could be either a problem with the server itself or with the network connection to the server (the latter is common at [[:Category:Concordia Hospital Office | Concordia]]). [[:Category:IT Support | CCMDB IT Support]] cannot fix this, the problem will be fixed fastest if you call [[eHealth ServiceDesk]].
** when you talk to the helpdesk, make sure you '''don't call it "Twister"''' to avoid confusion
** tell the helpdesk that "this is '''not a mapping issue''' because we access the server using the '''UNC name'''"
** if the server is running fine, and the network connection of your location to the rest of the WRHA is up, then the problem might be with the way your account is set up; the help desk might they want to check how access rights should be set up, refer them to the instructions to set up a data collector, as written by '''Sandy Kroeger''' from eHealth.
== Requesting Access to the Regional Server ==
see [[Setting up a New Data Collector]]
== Support ==
The Regional Server is located at St Boniface and 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.
==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.
# find an empty spot on the desktop and right-click
# mouse to "New", then click on "Shortcut""
# copy and paste the '''[[#Server / Share names |full name of the Regional Server]]''' as per top of this article into the "Type the location of the item" line and click "Next".
# type "Regional Server" into the "Type a name for this shortcut" line and click "Finish"
== Legacy Info ==
=== Twister ===
=== Twister ===
CCMDB staff at HSC will sometimes refer to the '''Regional Server''' as "Twister". This is because HSC used to require 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).  
CCMDB staff at HSC will sometimes refer to the '''Regional Server''' as "Twister". This is because HSC used to require 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).  
Line 98: Line 95:
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\VAP_CLI_audit
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\VAP_CLI_audit
** Whole directory, there had been no updates to this since Oct 09
** Whole directory, there had been no updates to this since Oct 09
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ccmis_backup_CSRP  
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ccmis_backup_CSRP
** whole directory, no idea why it was even there…
** whole directory, no idea why it was even there…
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\DATA_CLEANING_for_SITES
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\DATA_CLEANING_for_SITES
** whole directory, no idea why it was even there…
** whole directory, no idea why it was even there…
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ICU stuff  
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\ICU stuff
** Whole directory, there had been no updates to this since Dec 09
** Whole directory, there had been no updates to this since Dec 09
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\MOVE Madness VIC
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\MOVE Madness VIC
Line 108: Line 105:
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Output
* \\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
** 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  
* \\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
** Audit, Dec 1.09 UPDATED at STB, Laura, X_OTHER_STB
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Documents
* \\sbghnwfs0102\NSSVOL1\shared\ICU_DATA_COLLECTION\Documents
** versions
** versions
}}


[[Category:IT Instructions]]
[[Category:IT Instructions]]
[[Category:eHealth]]

Latest revision as of 11:01, 21 April 2020

The CCMDB.accdb and our sent data are located on the Regional Server

  • \\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION

There is a shortcut on all laptop desktops called "Regional Server" - please leave it called so all laptops are the same and covering collectors know what to look for.

If you still have the old "Regional Server" shortcut please delete it.

Troubleshooting Regional Server

If you can't access the regional server, ie the shortcut on your desktop doesnt' get you there, then:

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

  • 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.
  • If a PC reboot does not fix your access to the regional server, call the eHealth ServiceDesk. CCMDB IT Support cannot fix this, the problem will be fixed fastest if you call eHealth ServiceDesk.
    • tell the helpdesk that "this is not a mapping issue because we access the server using the UNC name"
    • if the server is running fine, and the network connection of your location to the rest of the WRHA is up, then the problem might be with the way your account is set up; the help desk might they want to check how access rights should be set up, refer them to the instructions to set up a Regional data collector, as written by Sandy Kroeger from eHealth.

Requesting Access to the Regional Server

see Setting up a New Data Collector

What if I am missing the shortcut

see Desktop install.bat

Regional Server Dependencies

If the Regional Server changes locations all the automation accessing it needs to be updated:

Related Articles

Related articles:

Legacy Info

Legacy Info   

old regional server sbghnwfs0102

Until 2012-08 we used a different regional server. After we had ongoing difficulties connecting to it eHealth moved us over to a new one. The old one was

  • \\sbghnwfs0102.ad.wrha.mb.ca\NSSVOL1\shared\icu_Data_Collection\

Moving to Regional Server will discontinue using #Twister altogether, so please ensure you don't refer to Twister after this is implemented.

The old regional server was hosted at StBoniface; I don't think the new one is.

Migration Checklist

  • ensure all have access; checklist is at Regional Server\​zzzchecklist.txt\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\zzzchecklist.txt
  • update Net use reg srv.bat (done, now maps to R: as well in case anyone had that hard-coded to the old regional server; needs to be rolled out with rest)
  • change how regional server is accessed by CCMDB.accdb
    • linked tables - done
    • sending - done
  • fix desktop shortcuts (output, timecards and supply order) (delete old ones) (this may be complicated by the fact that some collectors have renamed theirs)
    • updated output folder, work hours and ordering shortcuts
  • News and backup batch file - make part of copy bat and download new one
    • updated both batstart.bat and backup.bat; new backup.bat will be rolled out automatically and new and cleaned up batstart.bat will be used in future installs. Shortcut should work with old batstart.bat.
  • added following to backup.bat:
    • make the batch file copy the new, fixed shortcuts
    • make the batch file copy the new Net use reg srv.bat
  • roll-over tested Ttenbergen 17:03, 2012 August 31 (CDT)
  • emptied old regional server except for what is needed for roll-over, put a shortcut to new one instead of old content
  • set up roll-over to run at next news-and-backup Ttenbergen 17:03, 2012 August 31 (CDT)

Twister

CCMDB staff at HSC will sometimes refer to the Regional Server as "Twister". This is because HSC used to require 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.

The actual address was \\Twister\icu\

Server name usage prior to changing to fully qualified domain name (FQDN)

The Regional Server used to be accessed as:

\\sbghnwfs0102\nssvol1\shared\icu_Data_Collection\

A lot of locations are still set up with this link. However, notably at the Vic this set-up no longer works. All new laptops will be set up with the new address, \\sbghnwfs0102.ad.wrha.mb.ca\NSSVOL1\shared\icu_Data_Collection\, which includes the domain name ".ad.wrha.mb.ca". The full address should work everywhere, but wherever there is no problem this is not an urgent thing to change.

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