Finding An Appworx Process Responsible for a Result

Overview

On occasion a result needs to be investigated.  In this case, the request was like:

An email with the subject: Privileged Housing letters needed was received that had some data that seemed incorrect.  From that email, I can determine that it comes from "awhrdg@harding.edu" at 7 am in the morning. Can you tell where I can find the query that this "Privilege Housing letters needed" email relies on to determine who should be included in the list? I suspect that it is in AppWorx somewhere.

So here are steps that could help:

  1. The sender being awhrdg@harding.edu is a good key.  Automated emails from awhrdg did come from AppWorx.  Argos emails will come from argos@harding.edu.  Others can come from a specific, hopefully generic system, account.
  2. Launch the AppWorx client (see the link below for installation instructions)
  3. Here you may have to be a little creative.  In  this case, I clicked the Jobs Selector icon 
  4. Then in the window, I looked for something that might indicate the job 
  5. I first typed %ph in the Search box because the code to manage privileged housing typically has PH in the name.  Unfortunately, this search only searches the job name.  Then I scrolled through and found "Do Privileged Housing Functions" in the Description column which seemed like a likely place to look.
  6. I double clicked that line and saw this page:
  7. The Application and Queue are clues, but the really useful information is circled.  That tells us that it is a shell script that runs it and it is located in the Banner code tree within the harding/sh folder and is named szpphap.shl

In other cases, if it is Banner data, it might work to get into the Banner code tree and use grep to find some text that might be in the result.

In other cases, it could be a Process Flow that is needed.  The steps are similar, just begin with the Process Flow icon

One useful note:  in .shl scripts that run against Banner, you will likely see a command $SQLHRDG.  That is defined (somewhere I forget) to be

sqlplus saturn/<pasword>@hrdg 

which is done to avoid having the password visible in the jobs and to allow for changing it with a much smaller number of change points.

Related Categories

Installing the Appworx Client on Windows

 

Print Article