UNEXPECTED ENGINE ERROR: 74(81)

Document ID : KB000032894
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:
CA MSMMUF fails with:
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select EXECUTED_TASK_ID, PENDING_MSM_TASK_ID , AUDIT_ID from PEND_ACTION_EXEC_TASK_HIST where EXECUTED_TASK_ID = ?]; SQL state
[HY000]; error code [-117]; ca.datacom.db.DBSQLException: ca.datacom.db.DBSQLException: UNEXPECTED ENGINE ERROR: 74(81)

 

Environment:

z/OS, Datacom/AD, Tomcat

 

Cause:

Return Code 74 - OPEN ALLOCATION ERROR
Reason code 81 - An error occurred during the dynamic allocation of an area. The area probably was not cataloged


Resolution/Workaround:
This open allocation is saying that the database area/dataset for table PEND_ACTION_EXEC_TASK_HIST is not available.
Run the CXX report (REPORT AREA=CXX,DBID=4000) and use it to identify the dataset for this table which it will show is the hlq.AUD4000 dataset. Recover this dataset and start MSMMUF.

 

Additional Information:  

//STEP5D EXEC PGM=DBUTLTY,REGION=4M                   
//STEPLIB  DD DSN=MSMMUF.HLQ.CUSLIB,            
//            DISP=SHR                                   
//         DD DSN=MSMMUF.HLQ.CAAXLOAD,          
//            DISP=SHR                                   
//CXX      DD DSN=MSMMUF.HLQ.CXX,    
//            DISP=SHR                                   
//SYSIN    DD  *                                        
 REPORT AREA=CXX,DBID=4000                            
/*