All new jobs submitted or updated go to a QUEUED status and are not being processed. You see the following errors in the RmiServer logs:
ErrorMsg: AwE-5001 Database Query Error (9/9/13 5:28 PM)
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "APPWORX.AW2", line 245
ORA-06512: at line 1
This exception stops the timer thread from any further processing, so no aw_launch_job's are run (meaning no new jobs submitted/updated).
Need to investigate what this procedure returns, how it is defined in your Oracle instance, and how it could have caused a numeric conversion error.
Therefore, using the above example we can see that it was failing on a procedure within the aw2.check_launched_jobs procedure so we would do the following:
1) From the AM Client go to the Database Browser
2) Select the Procedures Tab
3) Select Packages --> AW2 --> CHECK_LAUNCHED_JOBS
4) You should see a row similar to this:
# ARGUMENT_NAME IN_OUT Data Type Default
If you see something different in this table, you should contact Automic support to further troubleshoot this issue.
Contact Automic support to troubleshoot why your procedure is generating the ORA-06502 errors. Once the procedure is fixed, jobs should start processing normally.