Others

1. How to stop and start Jiffy Server ?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials

Steps to solve:

• Open putty and login to Jiffy server (IP and Port details).
• Login as root user.
Note : nginx (web server) should be running in the server (Please verify with the below command as ‘root’ user only.)
ps -ef | grep nginx

nginx -s quit (To stop)
nginx (To start)

• Next, change user to Jiffy app user and go to JIFFY_HOME folder.
su jiffyapp-usr
cd /opt/jiffy/
• Note: JIFFY_HOME = /opt/jiffy/ - This directory structure varies with respect to the client where JIFFY is installed/mounted.

• Stop Jiffy processes via supervisor
Supervisorctl stop all


• Run the supervisorctl status to confirm if everything stopped.
supervisorctl status


• Now, start the jiffy processes
/start_all.sh jiffy


• Check the supervisorctl status and all should have same uptime
supervisorctl status

2. How to stop and start Jiffy using JAM (Jiffy Admin Module)?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Jiffy Server jiffyapp-usr credentials

Steps to solve:

• Login to JAM URL web page.
• http:// :9002/login
User id - jam _admin / password - jam_admin


• Go to > left menu > Jiffy Admin > Jiffy Service Admin
• Click on ‘Stop Jiffy’ button
• All the process will be stopped


• To start click on ‘Start Jiffy’ button
• And now all the processes will be running.

3. What to do if you see “This site can’t be reached” page?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: putty, root access

Steps to solve:



• This means the web-server ‘nginx’ is down.

• We need to start the nginx
• Command to start : nginx
• And check if ‘nginx’ is running by : ps -ef | grep nginx


• After this check the Jiffy login page it should be up and running fine.

4. What to do if you see “502 Bad Gateway Error” message ? (for versions 2.7 and above)

Version: This solution is applicable for jiffy 2.7 and above versions.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Steps to solve:

• This error occurs when one or more jiffy processes is down/hung/stopped/not running status.
• Note: nginx (web server) should be running in the server, Please verify with below command:
• ps -ef | grep nginx

Detailed Steps:
• Open putty and login to Jiffy server (IP and Port details).
• Change the user to jiffyapp-usr and go to JIFFY_HOME folder.
• su jiffyapp-usr
Note: JIFFY_HOME -- usually it will be in /opt/jiffy folder. However, this differs from client-to-client and depends on the location where jiffy is installed/mounted.

• Run the supervisorctl command.
• supervisorctl status

• In normal scenario the supervisorctl status should look as below.


• In abnormal scenario:
• The uptime will be fluctuating for one or more processes.
• The status of the process will be like FATAL , NOT RUNNING etc.. even if the processes are running.


• In this case we need to follow the below steps to fix the issue.
• STOP JIFFY Processes
• ./stop_all.sh jiffy


• To ensure, all jiffy processes are stopped correctly, grep for independent processes as below:
• ps aux | grep -i JIFFY
• ps aux | grep -i java
• ps aux | grep -i python
• If you see any of the processes running kill them using their pid's (process id's)
• kill -9

• After this start all the jiffy processes.
• START JIFFY Processes
• ./start_all.sh jiffy
• Note: Before running the start script please make sure that you are still under jiffyapp-usr user and not as root user. Because root user will change lot of permissions and will cause many issues down the line.


• Next, run the supervisorctl command and check the "uptime" for couple of times to ensure that the processes are not restarting automatically. If there are any automatic restarts of any of the process, then we can see the uptime will be different from rest of the processes.
• supervisorctl status

• Now open jiffy webpage "http://ip address:8484/" and the login page should appear.

5. What to do if you see “502 Bad Gateway Error” message ? (for version 2.6)

Version: This solution is applicable for jiffy 2.6 version.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Steps to solve:

• This error occurs when one or more jiffy processes is down/hung/stopped/not running status.
• Note: nginx (web server) should be running in the server, Please verify with the below command: • ps -ef | grep nginx

Detailed Steps:
• Open putty and login to Jiffy server (IP and Port details).
• Change the user to jiffyapp-usr and go to 'conf' folder and start the gunicorn script in background.
• su jiffyapp-usr
• cd /ebs-volume01/JAM/conf/(Enter)
• nohup ./gunicorn.sh &
• Note: 'conf' folder structure differs from client-to-client and depends on the location where jiffy is installed.

• Next, start the JAM python script
• cd /ebs-volume01/JAM/JAM/(Enter)
• nohup python jiffy_start.py &

• Next, Login to JAM and start Jiffy
• URL --> --> click on 'Start Jiffy'.

• Next, start JLS --> first activate the environment and then run the jls python script.
• cd /ebs-volume01/jiffy/.JLS
• source /ebs-volume01/jiffy/.envs/jiffyEnv/bin/activate
• nohup python jls_server.py > /dev/null 2>&1 &

• Next, start 'Jiffy Expression User'
• su jiffyexp-usr(pwd:1234@jiffyexp-usr)
• cd /ebs-volume01/jiffy/expression/
• source /ebs-volume01/jiffy/expression/Jiffyexpenv/bin/activate (type source and pageup - this will automatically load the command if it was run previouly)
• export JIFFY_EXPRESSION_LOCATION="/ebs-volume01/jiffy/deploy/jiffy/uiscripts/precompile/expression/" (type export and pageup - this will automatically load the command if it was run previouly)
• ./start_expression.sh

• Now open jiffy webpage "http://ip address:8484/" and the login page should appear.

6. What to do if you get DB Connectivity issue/Connection refused on DB port 5432?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: putty, root access

Steps to solve:

• You will be seeing an error message like “Connection refused” for port 5432 as below:

• Login to putty, as ‘root’ user and check the postgres database status.
systemctl status postgresql-9.6
• You will see the status as ‘inactive’.


• To start the postgres database run below command:
systemctl start postgresql-9.6
• Next, check the status and it should show as “active”.


• Now login to Jiffy page and it should be up and running fine.
Note: In some case Jiffy server also might be down. So please refer “FAQ 1 : How to stop and start Jiffy server?” And follow the steps to bring it up.

7. How to stop and start Jiffy Client/Service?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Administrator access in the system.

Steps to solve:

• Go to the folder path where JiffyService is installed.
• Usually it will be in C:\jiffyservice
• You will see a .bat file named : StartJiffyService.bat
• Right click on this bat file > select ‘run as administrator’ and enter
• You will see the command prompt window which shows the Jiffy Service logs.
• To stop Jiffy Service, press ‘Ctrl+C’ in command prompt and close the window.

8. What to do when you see “502 Bad Gateway error” message?

9. How to create a new Jiffy Admin user??

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Steps to do:

• Open putty and login to Jiffy server.
• Change the user to jiffyapp-usr and go to JIFFY_HOME folder.
su jiffyapp-usr

• Note: JIFFY_HOME -- usually it will be in /opt/jiffy folder. However, this differs from client-to-client and depends on the location where jiffy is installed.

• Now activate the jiffy environment
source /opt/jiffy/.envs/jiffyEnv/bin/activate

• Change the directory to the src folder
(jiffyEnv) [root@localhost objects]# cd /opt/jiffy/deploy/jiffy/src/
• (jiffyEnv) [root@localhost src]#

• Run the command python manage.py setup_admin and provide all the details.
(jiffyEnv) [root@localhost src]# python manage.py setup_admin

Please enter Username:
Please enter Password:
Please confirm the Password:
Please enter Email:
Please enter the first name of the user:
Please enter the last name of the user:
Creating the admin user...
User is created with timezone as UTC.
Please update to correct user timezone by logging.

10. What to do when you see any of the Jiffy processes having a different uptime issue? Ex: gunicorn?

11. How to do new Python library installation for expression node?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Enough disk space to download the files.

Note: Before writing any python expression using expression/web node you have to install all python packages required by that expression in the expression environment.

Steps to install Python Packages in Windows Environment (Web Node)
1. Download all pip packages required for expression from [ https://pypi.python.org/pypi ]

2. Install pip packages at command prompt using the below command
pip install --no-index --find-links=file: package name.
Eg: pip install --no-index --find-links=file:/usr/share/localrepos/pypi-packages/ lxml

Steps to install Python Packages in Linux Environment (Expression Node)
1. Download all pip packages required for expression from [ https://pypi.python.org/pypi ]

2. Login to jiffy application server and copy all pip packages required for expression to server location /var/tmp/ using Winscp or JAM.

3. Switch to jiffy expression user using the su command
For example : su jiffyexp-usr

4. Activate jiffy expression environment using the below command
source /jiffy/expression//bin/activate
Eg: source /opt/jiffy/expression/jiffyexpenv/bin/activate

5. Install python packages using the below steps
pip install --no-index --find-links=file: pip package name
Eg : pip install --no-index --find-links=file:/usr/share/localrepos/pypi-packages/ lxml

12. How to access and query PostgresSQL(Jiffy) Database??

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Info: Using psql, we can generate a complete list of commands by using the \help command and access Jiffy app database and tables.

• Database parameter can be found in "$JIFFY_HOME/deploy/jiffy/src/SterlingTester/local_settings.py".

1. Connect to psql shell by using below command:
[root@localhost ~]# psql jiffyappdb jiffy_db_user [syntax => psql ]


2. To see the relations (tables, sequence) run "\d" in the shell


3. To see only relation of type Tables run "\dt" in the shell
e.g.


4. To See only relations of type Sequence run "\ds" in the shell
e.g.


5. Sample select queries.
e.g.

13. Where is ANT/Maven plugin JAR available for integration of Jenkins with Jiffy?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials, sufficient disk space to download the files.

Steps:

• Open putty as ‘root’ user.

• Jars are available in $JIFFY_HOME/deploy/jiffy/src/bin folder.
[root@localhost bin]# pwd
/opt/jiffy/deploy/jiffy/src/bin
[root@localhost bin]# ls -ltrh
total 196M
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 72M Oct 5 15:50 OReng-1.2.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 12M Oct 5 15:50 QR-1.0.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 26M Oct 5 15:50 jiffy-service-1.9.5.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 32M Oct 5 15:51 jiffy-service-manager-1.1.1.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 15M Oct 5 15:52 jiffy-ant-tasks-1.2.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 14M Oct 5 15:52 jiffy-tester-maven-plugin-1.2.jar
-rw-rw-r--. 1 jiffyapp-usr jiffyapp-usr 28M Oct 5 15:52 document-service-1.0.jar
[root@localhost bin]#

14. How to start an ‘Expression Service’ or ‘Expression Node’ ?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Steps to do:

• Open putty and login to Jiffy server.
• Change the user to jiffyapp-usr and go to JIFFY_HOME folder.
su jiffyapp-usr

Note: JIFFY_HOME -- usually it will be in /opt/jiffy folder. However, this differs from client-to-client and depends on the location where jiffy is installed.

Example of error message in expression Node --> [ root> JiffyData status="FAIL" message="Error in Manager - Details: Expression service is not available. Please contact JIFFY administrator"/ /root>

• Now go to expression directory:
cd /ebs-volume01/jiffy/expression/
>br> • Next source the activate
source /ebs-volume01/jiffy/expression/Jiffyexpenv/bin/activate(type source and pageup)

• Next export JIFFY_EXPRESSION_LOCATION
export JIFFY_EXPRESSION_LOCATION="/ebs-volume01/jiffy/deploy/jiffy/uiscripts/precompile/expression/"(type export and pageup)

• Now start the expression script.
./start_expression.sh

15. What to do if you see DB node error “Driver Not Found exception”?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, root access

Steps to do:

• Open putty and login to Jiffy server.

Info : For DB Node to work the corresponding DB driver should be placed in the server path.

• Go to Installation path.
cd /jiffy/oreng/lib
postgresql-9.4.1212.jar should be available.

If not available, kindly download and install it.

16. What to do if you get error “Syntax Error: ‘charmap’ codec cant decode byte ?

Version: This issue was seen in version 2.7.

Pre-requisites: Admin access in Jiffy application.

Steps to do: If you come across below error message as shown in screenshot please follow the steps as described below.
If still getting any issues after this, please contact jiffy-support@option3.io email id.


• Check the UI app configuration in mojo.
• If the 'Encoding' says 'windows-1252' - it will work fine with the normal character, but if it comes across any special characters like "&" or "@" in any fields , including password, it will throw the error as mentioned in the above screenshot.
• Hence change the app configuration in 'Encoding' mode as 'utf-8'.
• Below screenshot for reference:

17. What to do if under Task executions are not moving from ‘Scheduled’ to ‘Executing’ status ” ?

Version: This solution is applicable for all versions of Jiffy.

Pre-requisites: Putty, Jiffy Server jiffyapp-usr credentials.

Steps to do:

• Open putty and login to Jiffy server.
• Change the user to jiffyapp-usr and go to JIFFY_HOME folder.
su jiffyapp-usr

Note: JIFFY_HOME -- usually it will be in /opt/jiffy folder. However, this differs from client-to-client and depends on the location where jiffy is installed.

• Log in to linux server through putty and check the “supervisorctl status”.
• Everything should be up and running fine.
• Please refer FAQ:1 if you see any of the process having issues.


• If everything is running fine, check the 'Diskspace' in RabbitMQ link:
Please refer FAQ:5 for the steps.

• If diskspace is low in RabbitMQ, then scheduling processes will not run.
• For this we should delete some old log files and make some space.
• Login to putty and go to /var/log/rabbitmq
• Remove huge sized *.gzip log files

• This should solve the issue. But if disk space looks good then check the ‘Queues’ to see if there are high pending messages to be processed.
• Please refer FAQ:4 for the steps.

• If any of the queues are showing high numbers in 100+ messages, this means one of the jiffy processes is hung or having some issue.
• So try restarting all the processes:
ie., login to putty as jiffyapp-usr.
• Stop all the jiffy processes under user "jiffyapp-user": [jiffyapp-usr@localhost scripts]$ ./stop_all.sh
• . start all the jiffy processes and check the uptime : [jiffyapp-usr@localhost scripts]$ ./start_all.sh jiffy
• Please refer FAQ:1 for detailed steps.

• Now verify the queues in RabbitMQ , it should get cleared.
• If any of the processes are not running then stop and start that service alone.
• Refer FAQ:12 for the steps.

20. What to do when a Bot Freezes and Shuts Down Automatcially?

Do the below procedure if the following error message is displayed:

Check the Jiffy properties file.
• Go to C:\jiffyservice\jiffy.properties.
• Check the URL value. It should be : https://jiffytraining.option3.io:8484
• Ensure that the URL does not contain two "https"
• Save the jiffy properties file
• Restart the bot.