University of Oregon

Job Scheduling FAQ

I'm getting the error "AwE-5009 RMI connection failure, check if RmiServer is running" when I try to log in to Applications Manager.

You log in to Applications Manager using your Duck ID username and password. However, Applications Manager will produce an error if any of the following special characters are included in your Duck ID password: $ ( ) * + - . ? [ \ ] ^ { | }. Please note that, although these characters are valid when logging in to other services that use the Duck ID, they may fail when used with Applications Manager.

There may be another problem when you get this error and that is that there may not be an entry in the /opt/AppWorx/ldap/appworx_ldap_map.txt file for your user id. Call the Technology Service Desk to see if this is the case.

Was this helpful?

Your rating: None Average: 2.6 (12 votes)
How can I change my Oracle login within Applications Manager?

Once you have successfully logged in to the Applications Manager application, you will need to set your Oracle password. Setting this password will ensure that you can run your jobs successfully. To set your Oracle login,

  • Select the Logins Icon from the toolbar or select Object Admin->Security->Logins

The Logins window will appear.

Select your login. It will be the same as your BANNER username. In this case, it’s joey. Then click the Edit button. The Logins details button is displayed.

The ONLY thing you need to change is the Password field contents. This password must match your BANNER password in order for you to run jobs. Type in your BANNER password. Notice that the "Check" button is greyed. This is normal behavior for this version of Applications Manager. Select OK.

Since you don't know if you've typed in your password correctly on this screen, we have provided a method for you to check your BANNER password before you start submitting jobs.

The way to check if your BANNER password is correct is to request the job CHECK_BANNER_CONNECTION. There are no prompts. If the job aborts and the log file appears to show "invalid username/password; logon denied", then you need to reset your BANNER password by following the steps above. If the job finishes and the log file indicates a successful connection, you are done and can start submitting jobs.

Was this helpful?

Your rating: None Average: 3.9 (11 votes)
Are all the output files saved on the Applications Manager server or my local hard drive?

All Applications Manager output files are stored on the Applications Manager servers.

Was this helpful?

Your rating: None Average: 4 (5 votes)
What does it mean if my job aborts?

There are a number of things that can cause a job to abort.

  • Invalid Oracle username or password
  • Wrong program type
  • Segmentation Fault

Other things can cause your job to abort too. Contact your programmer for more information.

An invalid username or password will appear in the Applications Manager log file like this:

The current date/time stamp is: 13-May-2008 12:29:50
ORA-01017: invalid username/password; logon denied
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where &ltlogon> ::= &ltusername>[/&ltpassword>][@&ltconnect_identifier>] | /
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where &ltlogon> ::= &ltusername>[/&ltpassword>][@&ltconnect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Could not log in to SQL*Plus.
Exiting with error (return code = 5)...

A program returning a bad error code may look like this in the Applications Manager log file:

...Non-zero error generated from running job. The program pwpwpld failed to run successfully.
Program Failed to execute properly ..... program aborting
one_up_is 100499
0 rows created.

A segmentation fault often looks like the following in the Applications Manager log file:

...The current date/time stamp is: 15-May-2008 14:16:52
got it
GURJOBS is /opt/appworx-output/test
bannerlis is /opt/appworx-output/test/pwpltim_100495.lis
bannerlog is /opt/appworx-output/test/pwpltim_100495.log
stdout is /opt/AppWorx/appwtest/out/o47821.00
Processing Command Line Count Parms C Wrapped
Parameter Count = 5
/opt/AppWorx/appwtest/exec/CMD_LINE_BANNER_CNT_C: line 307: 29625 Segmentation fault $program $db_login/$db_password@$net_connect "$PARM1" "$PARM2" "$PARM3" "$PARM4" "$PARM5" >>${command}_${one_up}.log 2>&1
Program Failed to execute properly ..... program aborting
one_up_is 100495

Was this helpful?

Your rating: None Average: 1 (4 votes)
Are the Applications Manager reports the same that I used to get off Daisy?

Yes, the output you get from Applications Manager is the same as the output that you used to get from DAISY. Some output has automatically been put into an Acrobat PDF format for you for easier readability and printing capability.

Was this helpful?

Your rating: None Average: 2.8 (4 votes)
What is the difference between my Applications Manager login and my Applications Manager Oracle login?

You log in to Applications Manager using one set of credentials. This consists of your username and password. Your username is the same as your BANNER username. Your password will be the same as your Duck ID password. In order for you to run Applications Manager jobs, you need to be able to connect to the BANNER databse. To do this, you set your Applications Manager Oracle login password to match that of your BANNER login password.

When you change your BANNER password, you must also change your Applications Manager Oracle login to match.

Was this helpful?

Your rating: None Average: 2.3 (3 votes)
Can I change the names of Applications Manager output files?

You cannot rename the files in Applications Manager. Applications Manager generates a unique sequence number that is then built in to the output files so they can be identified in Applications Manager as well as be uniquely identified on the Applications Manager servers. If you find that you absolutely need the name of an output file changed, you can "ftp" the output file from the "job details window->output files tab" to your desktop and rename it there.

Was this helpful?

Your rating: None Average: 3 (3 votes)
In Banner, can I change the modules/chains to be able to output as either lis or xls files?

# BANNER output files are by default listing (.lis) files. We have some modules/chains that produce XLS (Excel) output, but that usually is determined by a prompt value. If you have a need for an output that is required to be in Excel format, submit a service request and the folks at Information Services will see what can be done to get you the output you need.

Was this helpful?

Your rating: None Average: 3.3 (3 votes)
When I start Applications Manager I get a dialog box that says "The application's digital signature has an error. Do you want to run the application?" What does this mean?

The Short Answer
You must check the "Always trust content from this publisher" check-box and choose "Run".

The Detailed Answer (from Applications Manager)
When we build Applications Manager, the Java-based Applications Manager Client (and other Applications Manager Java code) is signed with a Java code-signing certificate which we renew annually. If you attempt to run a version of the Applications Manager Client that was signed with a certificate that has expired, you will receive this message. We renew the code-signing certificate every year, so the one we're currently using to sign the code is valid. We will renew it before it expires. That is why upgrading Applications Manager to a newer build would be another way (but not the recommended way) to resolve this problem. This isn't recommended because eventually, that certificate would expire too, and you would need to upgrade again to another, newer build made with a newer code-signing certificate.

Whether or not SSL is being used to encrypt the data is independent of this Java code-signing certificate. If you check the "Always trust..." box, SSL will continue to function normally and all Applications Manager network traffic will still be encrypted. The certificate that is expired does not affect the encryption of Applications Manager network traffic and it is not the same as an SSL Web Server Certificate, like the ones that allow users to make https connections to web servers for example.

The Java version on your PC matters because certain versions of the Java Runtime Environment have root certificates that have expired, so we have to try to rule this out as a cause. For more information on expired root certificates, go to Sun's web site.

In summary, we do renew our code-signing certificates and the one we are using to build at this time is current; you need to check the "Always trust..." box for Applications Manager programs; having a newer code-signing certificate will not have any effect on whether or not the data is encrypted; and the version of Java matters because some versions of Java have expired root certificates.

Was this helpful?

Your rating: None Average: 4 (2 votes)
If I have several jobs that run every day, can I set them up to run automatically "forever"?

Applications Manager has the capability to schedule modules/chains anytime, any day for as long as you want to run the job. Information Services restricted campus users from creating "schedules" on modules and chains due to volatility of the module set up. We have provided your security officers the ability to create chains that can be built with schedules so that your job(s) can be set up to run "forever". See your security officer if you would like a job to be scheduled.

Was this helpful?

Your rating: None Average: 2 (2 votes)
If I am currently using a DOS based program to FTP files to DAISY, am I going to have problems with my job?

DAISY is no longer available. If you need to "ftp" a file so that it can be loaded into BANNER, you need to use the BANNER form GWBLOAD to "secure copy" your file from your desktop computer to the Applications Manager server.

Was this helpful?

Your rating: None Average: 5 (2 votes)
If I have a job scheduled in the future and I change my Oracle password, will my scheduled job still run?

Yes. Any time you change your Oracle password within Applications Manager, it is saved within the Applications Manager repository database. Since your job is scheduled in advance, the job knows which login to use. When your job launches, the scripts in Applications Manager use that login object regardless of what the password is. When the login is referenced in these scripts it will pull the password from the repository database and make the necessary connection to Oracle.

Was this helpful?

Your rating: None Average: 4.5 (2 votes)
Does the list of jobs in the backlog view only show my jobs?

For the most of you, you will see only your jobs that you submit in Applications Manager. This means that only you will be able to see the output from your job. There are a few people who need to have access to see others' jobs for various reasons. In those cases, those people will be able to see others output.

Was this helpful?

Your rating: None Average: 3 (1 vote)
Is there a timeout or shutdown constraint in Applications Manager like there is in BANNER?

There is no timeout or shutdown constraint in Applications Manager. Once you are logged in, you are in until you log out.

Was this helpful?

Your rating: None Average: 5 (1 vote)
How do I find jobs that are no longer in the history pane of the Explorer window?

By default, Applications Manager keeps jobs in the "history" pane of the Explorer window for 60 minutes. If you want to find a job that has fallen out of the history pane, you must perform a filter scan to find your job. From the Explorer window, select Filter->History Query. In the History Query window, you can pick and choose what items to base your search query. The "Current Day" checkbox is automatically checked for you. Uncheck this if you want to base your search on a date range. Select the OK button. Applications Manager will return all jobs (up to 450 days ago) based on your query.

Was this helpful?

Your rating: None Average: 5 (1 vote)
In Applications Manager, can I change the font when I open an output file and have it remember it the next time I open an output file?

Unfortunately not. Applications Manager doesn't have that capability in version 8.0_P4.

Was this helpful?

Your rating: None Average: 4 (1 vote)
Can I type in a value instead of using the list of values for a prompt?

That depends on the prompt. If a prompt is set to allow changes, then yes, you may type in a value for that prompt. If the prompt is set so no changes are allowed, then you cannot even highlight the prompt value field. If the LOV button is highlighted, then you MUST pick a value from the list in order for the prompt value to be valid.

Was this helpful?

Your rating: None Average: 1 (1 vote)
How do I create a file association?

To create a file association perform the following:

  • From the main Applications Manager menu select Options->File Associations
  • In the Pattern Box, type in the extension of the file you want to associate (lis, pdf, xls, doc)
  • Click the "..." button next to the Application Box. Find the application that is associated with the entry you made in the Pattern Box. For example. Excel is usually found at C:\Program Files\Microsoft Office\Office\EXCEL.EXE
  • Select your choice for "Use": ASK, ALWAYS, or NEVER
  • Click the Add Button

Was this helpful?

Your rating: None Average: 4 (1 vote)
When I attempt to start Applications Manager from a newly downloaded client I get a dialog box with an error message and the application won't start. What does this mean?

This error typically means that you have cached versions the Applications Manager client. These cached files conflict with the updated client. To resolve these errors, you will need to clear your cache before installing the new client as follows:

  • Click Start > Run... >  In the Open: box type in javaws -viewer
  • Click 'OK' to open the Java Cache Viewer panel.

  • Select all APPWPROD, APPWTEST Applications Manager Client applications and click Delete (big red 'X').
  • Click 'Close' to close the Java Cache Viewer.

  • In the General tab of the Java Control Panel, click on 'Settings...'.

  • Click 'Delete Files...' if the button is enabled, then click 'OK' to delete files from the cache.

Was this helpful?

Your rating: None Average: 5 (1 vote)
How can Applications Manager process my data files?

You can transfer your data files to the Applications Manager server by using the banner form GWBLOAD. This form will let you browse your PC and automatically load your file to the Applications Manager server. When you launch a module or chain in Applications Manager, you can specify your data file from a list of values as a prompt value.

Was this helpful?

No votes yet
What are the format of the output files?

For BANNER jobs, you get a minimum of three output files

  1. Applications Manager log file
  2. Banner log file
  3. Banner lis file

You may get other files as well depending on the job you run. The format of your output file depends on the output generated. Generally speaking, most files are straight ASCII text files.

Was this helpful?

No votes yet
If I run the same job/module more than once, will I see a different set of output files?

Each "run" of a job/module produces its own unique set of output files. These output files are identified by an Applications Manager generated sequence number that is built into each output file.

Was this helpful?

No votes yet
Can I schedule a large job to run at an off peak time?

Absolutely so! You can schedule your job from the "Requests" window and enter the date and time in the Start Date and time fields. To have your job run on a scheduled basis, talk to your BANNER security officer and have them create a recurring schedule for you.

Was this helpful?

No votes yet
After I have uploaded my data file to the Applications Manager server using GWBLOAD and loaded the data into Banner, is there a way to do housecleaning?

Currently, there is no way to "clean up" files that have been loaded to the Applications Manager servers by you. There is an internal scheduled job to clean up files every 14 days.

Was this helpful?

No votes yet
Does Applications Manager affect my BANNER processes?

Applications Manager does not directly affect your BANNER processes. Consider these two separate applications. Applications Manager can be thought of an extension to BANNER in that it runs your jobs just like the old GUAPCTL BANNER form. There are cases where a BANNER form calls an Applications Manager job directly (especially in Financial Aid).

Was this helpful?

No votes yet