Index Rebuild causing WP crash and dump

Document ID : KB000097083
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
We had rebuilded the indexes for all of the tables in our DB. During this process we had our WPs randomly crash and also dump. Though the system remained up, and we could see objects running, we did find that some just remained in the queue and did nothing else afterwards. We would like to know why this happened, and what can we do to prevent this in the future.
 
In the provided logs and traces there are error messages: 
 
12 - 20180405/160703.059 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1a92dd90 DB-HDBC: 1a976d30 
12 - 20180405/160703.059 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 
12 - 20180405/160703.059 - U00003592 UCUDB - Status: '' Native error: '22922' Msg: 'ORA-22922: nonexistent LOB value' 
12 - 20180405/160703.059 - U00003594 UCUDB Ret: '3590' opcode: 'INSR' SQL Stmnt: 'INSERT INTO ABLOB (ABLOB_AH_Idnr, ABLOB_Key, ABLOB_Content, ABLOB_OH_Idnr, ABLOB_Name, ABLOB_ModCnt, ABLOB_Type, ABLOB_ModDate, ABLOB_ReplaceVar, ABLOB_Version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' 
12 - 20180405/160703.059 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'INSR' time: '47:398.998.266' 
12 - 20180405/160703.059 - U00003525 UCUDB: ===> 'INSERT INTO ABLOB (ABLOB_AH_Idnr, ABLOB_Key, ABLOB_Content, ABLOB_OH_Idnr, ABLOB_Name, ABLOB_ModCnt, ABLOB_Type, ABLOB_ModDate, ABLOB_ReplaceVar, ABLOB_Version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' 
12 - 20180405/160703.153 - Access violation at 00007FFAFB4B1B8C on read 000000012E6EB040 

In the logfiles, 63584 time critical DB calls are found. 
Of which 54978 are for table ABLOB. 
Yes, there is a performance problem on this table. 
Environment:
Automation Engine 11.2.6+hf.1.build.1371
Resolution:
This issue was confirmed as a bug and will be fix in:
- Automation.Engine 12.2.0
- Automation.Engine 11.2.8
- Automation.Engine 12.1.3
- Automation.Engine 12.0.6 

Workaround: Restart WPs when it dump and continue working