|QUESTION:||My Scheduled reports, set to be run via NuVu Query, have not completed. I have logged onto the server hosting NuVu Query and the program appears to be running normally. What else do i need to check to allow reports to run?|
NuVu Query uses a socket server connection to allow the program to communicate with the ProStix database (which is normally installed on a separate Linux/Unix production server).
Sometimes the Socket connection running on the Linux/Unix production server gets a lock that prevents NuVu Query from being able to retrieve the data required for reports.
There are two specific script installed by Sterland, that can be run to stop and start the socket connection on the Linux production server, and clear the locks.
The process outlined below should only be performed by a System Administrator who is confident in using the Linux / Unix command line.
if you are not confident to perform the steps outlined below , then go to the Customer Support Portal and log a ticket for Sterland Support to perform these steps for you.
To stop then start the socket connection on the Linux server , perform the following:
1. Log into the Linux/Unix production server to display the Promenu. Take the option to drop back to the Unix Shell (a standard Promenu install has the option as number 10 on the Promenu)
If the operating system (O/S) is Unix (e.g IBM AIX) then switch to the root user id before running the following steps. If the operating system is Linux then preface all commands in the following steps with sudo
2. Stop the first socket server connection, using the relevant command for your operating system below.
For Unix O/S and as the root user
For Linux O/S
4. Check and ensure there are no "runaway" socketserver processes left after the stop scripts have been run
ps -ef|grep socketserver|more
in the example below the command has identified 3 socketserver processes with process ID's (PID) of 3639 , 3712 and 3755
6. Kill any "runaway" socketserver processes identified in previous step. if there were no 'runaways" identified , then go to the next step
For Unix O/S and as the root user)
kill -TERM 3639 (substitute 3639 with the actual PID identified in step 5)
For Linux O/S
sudo kill -TERM 3639 (substitute 3639 with the actual PID identified in step 5)
7. Restart the first socket server connection , using the relevant command for your operating system below.
For Linux O/S
A select few customer sites have multiple NuVu Query servers installed. Therefore there are multiple socket server connections running on the Unix/Linux servers to handle the communication between the NuVu Query Servers and the Progress Database.
In these instances Sterland has installed multiple stopsocket.sh and startbroker.sh scripts to allow the above process to be run for the multiple socket server connections.
IF THIS FAQ DOESN’T RESOLVE YOUR ISSUE:
Contact Sterland Support.