What does it mean if my AppWorx job aborts?

Overview

This article describes the three main causes for a job to abort and provides examples for each.

Information

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:

...GURJOBS=/opt/appworx-output/prod
The current date/time stamp is: 13-May-2008 12:29:50
/opt/oracle/client_homes/10.2/bin/sqlplus
ERROR:
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.
FILEID:112381
FILEID:112382
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
/opt/oracle/client_homes/10.2/bin/sqlplus
got it
ONE_UP=100495
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
Program=/opt/code/banner/payroll/test/exe/pwpltim
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
FILEID:112335
Program Failed to execute properly ..... program aborting
one_up_is 100495