Administering NEOSYS Server: Difference between revisions

From NEOSYS Technical Support Wiki
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
[[Closing NEOSYS services]]
== Starting NEOSYS Services ==
=== Automatic Ways ===
NEOSYS processes are configured to start early in the morning when the server restarts after a windows upgrade.
We also schedule the process to start at windows startup in case of any unforseeable server restarts.
Depending on which datasets and how many processes of that dataset are to be started are configured in the System Configuration File of NEOSYS, the appropriate number of processes will be automatically started once the initial dataset is started.


[[Clearing File Locks]]
=== Manual Ways ===
Run the Schedule task which is configured to start the dataset required.
Directly double click on the STARTDATASET.cmd file to start the required dataset.


[[Scheduling a reboot of the server]]
== Closing NEOSYS Services ==
=== Two automatic ways ===
*NEOSYS services will automatically initiate a database integrity check, “backup” and close down at 2am by default.


[[Renaming a database name or code]]
To change the time of the automatic process do


[[Dealing with Unexpected Shutdowns]]
F5 ED DEFINITIONS
 
*line 3 is the minimum time to start the backup and shutdown (default 7500 ie 02:00)
*line 4 is the maximum time to start the backup and shutdown (default 7800 ie 02:05)
*both times must be in seconds past midnight
 
Press F5 and type
PRINT ICONV(’02:00’,’MTH’) to calculate this easily
 
*NEOSYS will automatically close down during the upgrade procedure.
 
=== Three manual ways ===
Warning: NEOSYS services do not shutdown automatically on server shutdown so you need to use one of these methods before shutting down or rebooting a server.
#To close individual services, press Esc three times on a service and then ctrl+C once or twice. Repeat for each service that you want to close. <br>This can only be done if you can actually see the services on the screen but the services will not be visible if they were started by scheduled tasks while administrator was not logged in to the server … unless you login as /console with remote desktop. <br>
#To close all services for one site/neosys installation, use the NEOSYS Support Menu – Stop/Restart NEOSYS <br>Currently this has no option to stop the services for any other neosys sites/installations on the same server<br>
#To close all services for all sites and installations of NEOSYS under a particular folder, use NEOSYS maintenance (or any other program) to create and then delete a GLOBAL.END file in the parent folder of all the neosys installations. eg if the installations are located in x:\hosts\clientcode\neosys etc then create and delete a file called x:\hosts\GLOBAL.END <br>''Procedure'':
#*In NEOSYS Maintenance press F5 to get a NEOSYS command prompt
#*Type ED DOS ..\..\GLOBAL.END and press Enter <br>(use ED DOS GLOBAL.END instead if you only want to close the services of the current site)
#*Press F9 to create the GLOBAL.END file
#*Wait until the processes close. Should be almost immediate.
#*Press alt+D twice to delete the GLOBAL.END file otherwise Neosys services will refuse to start
 
== Restarting NEOSYS Services ==
To Restart NEOSYS services you should:
#First STOP the NEOSYS services on the server [[Closing_NEOSYS_services#CLOSING_NEOSYS_SERVICES|Stopping NEOSYS Services]]
#Then START the services again using instructions at [[Closing_NEOSYS_services#STARTING_NEOSYS_SERVICES|Starting NEOSYS Services]]
 
''Note -'' Restarting of Processes can be done when the users are logged into NEOSYS as it is not noticed by the user.
 
==Clearing File Locks==
Due to many reasons, while a user is working on a document in NEOSYS, the window/system may hang and he might close the window. However NEOSYS doesn't know as to when the user has closed the window and locks the file and will release it after 10 minutes of consecutively not getting a response. The user meanwhile would get a message that the document is currently open.
 
Sometimes, a user might keep a document open in a window and might lock & leave his workstation, and as such the file is locked by NEOSYS, till he releases the document.
 
As such, we can use this command to release the filelock/s:
 
===To clear ALL file locks===
 
F5
CLEARFILE LOCKS
 
===To clear selective file locks===
 
#NEOSYS Menu, Support, List of Documents in Use
#Maintenance mode (F5)
#type the following command but replace "filename" and "key" with something from the List of Documents in Use
 
DELETE filename*key
 
== Scheduling a reboot of the server ==
 
Add a new scheduled task called "shutdown and restart" to run "one time
only" at 3:30am the next day.
 
The program is called c:\windows\system32\shutdown.exe but you have to add
the -r option in advanced properties to make the system restart as well.
 
This is useful for rebooting when software such as AVG antivirus requires a
reboot.
 
[[Image:reboot1.jpg]]
 
 
[[Image:reboot2.jpg]]
 
 
[[Image:reboot3.jpg]]
 
 
[[Image:reboot4.jpg]]
 
== Renaming a database name or code ==
 
A request to rename a database name or code may come from a client when they change their company name or break off an existing merger/partnership and if the old name exists in the database name or code which needs to be changed due to legal issues.
 
A database name is a non-unique identifier in a NEOSYS installation and is an antonym for the database code and is usually the legal name of the client. Renaming a database name involves compulsorily renaming the database code too. There isn't an escape from renaming the database code, however you can rename the database code back to the original one after you have done the procedure below.
 
A database code is a unique identifier per installation of NEOSYS. A complete note about database codes is available at [[Installing NEOSYS Service#Assigning database codes|Assigning database codes]]
 
#Renaming of a database has to be done when users have logged out of NEOSYS
#Take a backup of the database prior to the below steps
#Close all processes using the global.end method and do not rename until all steps are completed
#Open up Maintenance mode and login to the database you want to rename
#Go to General > Backup & Data Management > Create a new data set - from the drop down select the database you want to rename i.e. original database
#On the disk space requirements message, select YES
#Enter the name of the new database incase you are renaming the database name or else just type the original name here and hit enter
#Enter the new database code on the next screen and hit enter
#Select YES to start - it will start copying the existing database files to the new one
#Once complete, it will prompt you to login/switch to the new database, select Yes and from the dropdown select the new database and hit enter and login
#Once you have successfully logged in into the new database, go to General > Backup & Data Management > Delete a dataset - and select the old one and follow the instructions to delete it
#If you want to restore the database code to the original one, then follow steps 5 to 10 to create a new database with the original code.
#You can follow the same instructions if you want to rename the test database code as well
#Rename the global.end file to ensure that the processes will start again
 
After you have done the above steps to rename the database, ensure the following are completed (if you have renamed the database code back to the original one then you do not have to do the below steps):
 
#Rename the "start maindatabasecode.cmd" and "copy maindatabasecode to testdatabasecode.cmd" files to reflect the new database codes and test that they open up
#Delete the existing desktop shortcuts and re-create new one and test that they open up
#Reconfigure the Scheduled Tasks to reflect the new processes and test that they open up
 
 
==Dealing with Unexpected Shutdowns==
 
Client servers might experience unexpected shutdowns due to power failure, faulty UPS or other reasons at client site.
 
Support staff should escalate this issue to Client IT immediately and email them as shown in the sample along with screenshots as proof.
 
Unexpected shutdowns are noticed in Server logs usually after a failed backup or frequent server DOWN trends on Nagios. Support must pro-actively inform the client and get the issue FIXED which caused the unexpected shutdown. Ensure that client IT confirm the issue is resolved.
 
<b>Sample Email to client IT</b>
<pre>
Dear Team,
 
Yesterday there was an unexpected shutdown on the NEOSYS server. Unexpected shutdowns is a very serious issue and could lead to DAMAGED
files in NEOSYS. Fixing damaged files can be tedious, result in user downtime and worst case would be restoring from backup which could
result in loss of work for users.
 
If power failure is the issue, then the only solution is to buy a UPS with a CABLE and software that shuts down the server AUTOMATICALLY
when the UPS runs out of battery. This is the only correct and proper solution which everybody uses who has sophisticated computer systems
while power cuts are unavoidable.
 
Is there a UPS in place? Is the software that schedules shutdowns working properly?
Please update us on this issue.
 
Best Regards,
XXXX
 
</pre>
 
<b>Sample Screenshot</b>
[[File:Unexpected shutdown.png]]

Revision as of 11:13, 19 June 2014

Starting NEOSYS Services

Automatic Ways

NEOSYS processes are configured to start early in the morning when the server restarts after a windows upgrade. We also schedule the process to start at windows startup in case of any unforseeable server restarts. Depending on which datasets and how many processes of that dataset are to be started are configured in the System Configuration File of NEOSYS, the appropriate number of processes will be automatically started once the initial dataset is started.

Manual Ways

Run the Schedule task which is configured to start the dataset required. Directly double click on the STARTDATASET.cmd file to start the required dataset.

Closing NEOSYS Services

Two automatic ways

  • NEOSYS services will automatically initiate a database integrity check, “backup” and close down at 2am by default.

To change the time of the automatic process do

F5 ED DEFINITIONS 
  • line 3 is the minimum time to start the backup and shutdown (default 7500 ie 02:00)
  • line 4 is the maximum time to start the backup and shutdown (default 7800 ie 02:05)
  • both times must be in seconds past midnight

Press F5 and type

PRINT ICONV(’02:00’,’MTH’) to calculate this easily
  • NEOSYS will automatically close down during the upgrade procedure.

Three manual ways

Warning: NEOSYS services do not shutdown automatically on server shutdown so you need to use one of these methods before shutting down or rebooting a server.

  1. To close individual services, press Esc three times on a service and then ctrl+C once or twice. Repeat for each service that you want to close.
    This can only be done if you can actually see the services on the screen but the services will not be visible if they were started by scheduled tasks while administrator was not logged in to the server … unless you login as /console with remote desktop.
  2. To close all services for one site/neosys installation, use the NEOSYS Support Menu – Stop/Restart NEOSYS
    Currently this has no option to stop the services for any other neosys sites/installations on the same server
  3. To close all services for all sites and installations of NEOSYS under a particular folder, use NEOSYS maintenance (or any other program) to create and then delete a GLOBAL.END file in the parent folder of all the neosys installations. eg if the installations are located in x:\hosts\clientcode\neosys etc then create and delete a file called x:\hosts\GLOBAL.END
    Procedure:
    • In NEOSYS Maintenance press F5 to get a NEOSYS command prompt
    • Type ED DOS ..\..\GLOBAL.END and press Enter
      (use ED DOS GLOBAL.END instead if you only want to close the services of the current site)
    • Press F9 to create the GLOBAL.END file
    • Wait until the processes close. Should be almost immediate.
    • Press alt+D twice to delete the GLOBAL.END file otherwise Neosys services will refuse to start

Restarting NEOSYS Services

To Restart NEOSYS services you should:

  1. First STOP the NEOSYS services on the server Stopping NEOSYS Services
  2. Then START the services again using instructions at Starting NEOSYS Services

Note - Restarting of Processes can be done when the users are logged into NEOSYS as it is not noticed by the user.

Clearing File Locks

Due to many reasons, while a user is working on a document in NEOSYS, the window/system may hang and he might close the window. However NEOSYS doesn't know as to when the user has closed the window and locks the file and will release it after 10 minutes of consecutively not getting a response. The user meanwhile would get a message that the document is currently open.

Sometimes, a user might keep a document open in a window and might lock & leave his workstation, and as such the file is locked by NEOSYS, till he releases the document.

As such, we can use this command to release the filelock/s:

To clear ALL file locks

F5
CLEARFILE LOCKS

To clear selective file locks

  1. NEOSYS Menu, Support, List of Documents in Use
  2. Maintenance mode (F5)
  3. type the following command but replace "filename" and "key" with something from the List of Documents in Use
DELETE filename*key

Scheduling a reboot of the server

Add a new scheduled task called "shutdown and restart" to run "one time only" at 3:30am the next day.

The program is called c:\windows\system32\shutdown.exe but you have to add the -r option in advanced properties to make the system restart as well.

This is useful for rebooting when software such as AVG antivirus requires a reboot.

Reboot1.jpg


Reboot2.jpg


Reboot3.jpg


Reboot4.jpg

Renaming a database name or code

A request to rename a database name or code may come from a client when they change their company name or break off an existing merger/partnership and if the old name exists in the database name or code which needs to be changed due to legal issues.

A database name is a non-unique identifier in a NEOSYS installation and is an antonym for the database code and is usually the legal name of the client. Renaming a database name involves compulsorily renaming the database code too. There isn't an escape from renaming the database code, however you can rename the database code back to the original one after you have done the procedure below.

A database code is a unique identifier per installation of NEOSYS. A complete note about database codes is available at Assigning database codes

  1. Renaming of a database has to be done when users have logged out of NEOSYS
  2. Take a backup of the database prior to the below steps
  3. Close all processes using the global.end method and do not rename until all steps are completed
  4. Open up Maintenance mode and login to the database you want to rename
  5. Go to General > Backup & Data Management > Create a new data set - from the drop down select the database you want to rename i.e. original database
  6. On the disk space requirements message, select YES
  7. Enter the name of the new database incase you are renaming the database name or else just type the original name here and hit enter
  8. Enter the new database code on the next screen and hit enter
  9. Select YES to start - it will start copying the existing database files to the new one
  10. Once complete, it will prompt you to login/switch to the new database, select Yes and from the dropdown select the new database and hit enter and login
  11. Once you have successfully logged in into the new database, go to General > Backup & Data Management > Delete a dataset - and select the old one and follow the instructions to delete it
  12. If you want to restore the database code to the original one, then follow steps 5 to 10 to create a new database with the original code.
  13. You can follow the same instructions if you want to rename the test database code as well
  14. Rename the global.end file to ensure that the processes will start again

After you have done the above steps to rename the database, ensure the following are completed (if you have renamed the database code back to the original one then you do not have to do the below steps):

  1. Rename the "start maindatabasecode.cmd" and "copy maindatabasecode to testdatabasecode.cmd" files to reflect the new database codes and test that they open up
  2. Delete the existing desktop shortcuts and re-create new one and test that they open up
  3. Reconfigure the Scheduled Tasks to reflect the new processes and test that they open up


Dealing with Unexpected Shutdowns

Client servers might experience unexpected shutdowns due to power failure, faulty UPS or other reasons at client site.

Support staff should escalate this issue to Client IT immediately and email them as shown in the sample along with screenshots as proof.

Unexpected shutdowns are noticed in Server logs usually after a failed backup or frequent server DOWN trends on Nagios. Support must pro-actively inform the client and get the issue FIXED which caused the unexpected shutdown. Ensure that client IT confirm the issue is resolved.

Sample Email to client IT

 
Dear Team,

Yesterday there was an unexpected shutdown on the NEOSYS server. Unexpected shutdowns is a very serious issue and could lead to DAMAGED 
files in NEOSYS. Fixing damaged files can be tedious, result in user downtime and worst case would be restoring from backup which could 
result in loss of work for users.

If power failure is the issue, then the only solution is to buy a UPS with a CABLE and software that shuts down the server AUTOMATICALLY 
when the UPS runs out of battery. This is the only correct and proper solution which everybody uses who has sophisticated computer systems 
while power cuts are unavoidable.

Is there a UPS in place? Is the software that schedules shutdowns working properly?
Please update us on this issue.

Best Regards,
XXXX

Sample Screenshot Unexpected shutdown.png