App Server Shutting Down With CAUAJM_E_18018 Message in WAAE

book

Article ID: 193993

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

App Server shuts down with below error in as_server log.

 

[06/17/2020 03:31:36]      CAUAJM_E_18000 Database function call <ct_results> failed in <parseInternal> with return code: CS_CMD_FAIL
[06/17/2020 03:31:36]      CAUAJM_E_18016 Server: XXXXXX
[06/17/2020 03:31:36]      CAUAJM_E_18018 Server message: Message number(1105), Severity(17), State(3), Line(1), Message String: Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
[06/17/2020 03:31:36]      CAUAJM_E_18013 Event Server: <HPJSC01:AEDB_HPI>  Failed Query: <select j.joid, j.job_ver, jr.esp_lstatus, jr.esp_status, j.as_applic, j.has_condition, (datediff(ss,@S_1,j.create_stamp)+(select int_val from ujo_alamode where [email protected]_2)), j.description, s.last_end, j.as_group, j.box_joid, j.mach_name, (datediff(ss,@S_3,j.update_stamp)+(select int_val from ujo_alamode where [email protected]_4)), j.job_name, s.next_start, s.ntry, j.owner, s.run_num, s.last_start, s.status, s.run_machine, i.timezone, j.job_type, s.status_time, t.lineage, s.exit_code, j.has_resource, s.next_start_stamp from ujo_job j join ujo_sched_info i on i.joid = j.joid and i.job_ver = j.job_ver and i.over_num = j.over_num join ujo_job_status s on s.joid = j.joid and s.job_ver = j.job_ver join ujo_job_tree t on t.joid = j.joid left join ujo_job_runs jr on jr.run_num = s.run_num and jr.joid = s.joid and jr.ntry = s.ntry and jr.run_machine != @S_5 where j.joid>@I_6 and [email protected]_7 and [email protected]_8 and (s.status_time >= @I_9 or (datediff(ss,@S_10,j.update_stamp)+(select int_val from ujo_alamode where [email protected]_11)) >= @I_12 or (datediff(ss,@S_13,j.create_stamp)+(select int_val from ujo_alamode where [email protected]_14)) >= @I_15 or s.last_start >= @I_16 or s.last_end >= @I_17 or s.next_start >= @I_18) order by j.job_name <<'19700101','gmt_offset','19700101','gmt_offset','$$AGENT$$',0,1,1,1592335880,'19700101','gmt_offset',1592334742,'19700101','gmt_offset',1592301127,1592335881,1592335884,1592335885>>>
[06/17/2020 03:31:36]      CAUAJM_W_10900 The database monitoring system has detected a potential problem with the database.
[06/17/2020 03:31:36]      CAUAJM_I_10901 The database monitoring system is beginning validation of database connections.
[06/17/2020 03:31:36]      CAUAJM_E_10656 The database <XXXXXXXXX> has encountered a critical error. Please contact the database administrator.
[06/17/2020 03:31:36]      CAUAJM_E_40317 Unable to communicate with any database.  Shutting down.
[06/17/2020 03:31:36]      CAUAJM_I_10902 The database monitoring system has completed validation of database connections.
[06/17/2020 03:31:36]      CAUAJM_I_10903 The database monitoring system will resume monitoring for database problems.
[06/17/2020 03:31:36]      CAUAJM_I_30032 Client [CA WAAE API JNI:6484][13][XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX] [0xe6a290a0][06/17/2020 03:31:36.4067][0:XXXXXXXXXXXXXXXXXXXXXXXXXX> 1] API ID [299] execution completed. Total time: 0.256926 seconds.
[06/17/2020 03:31:38]      CAUAJM_I_30004 CA WAAE Application Server shutdown complete.
[06/17/2020 03:31:38]      CAUAJM_I_30000 CA WAAE Application Server exiting.

 

 

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

DBA need to take care of allocating more space to tempdb in the Database. The App server is just complaining about it and shutting down.

The official Sybase site states that "For most applications, make tempdb 20 to 25% of the size of your user databases to provide enough space for these uses."

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/X20133.htm