UNEXPECTED ENGINE ERROR: 74(81)

Products

• Mainframe Software Manager (Chorus Software Manager)

Issue/Introduction

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)

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

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                            
/*