Topology Load Failing

Products

• Topology

Issue/Introduction

Topology load (Extractor Aggregator)  job is failing with U100 abend:

$HASP395 TPLSERUN  ENDED - RC=0100                                                                               

The following messages appear in the joblog:

Exception in thread "main" com.ca.topology.smf.exception.SmfDataTransformerException: [errorCode=SDT110E, errorMessage='Failed to cr 
eate index']::SQL error code: 13 SQL state: null Cause: null Message: [SQLITE_FULL]  Insertion failed because database is full (data 
base or disk is full)                                                                                                                
 at com.ca.topology.smf.exception.SmfDataTransformerException.fromSQLException(SmfDataTransformerException.java:68)                  
 at com.ca.topology.smf.database.SqliteDatabaseLifecycle.afterLoad(SqliteDatabaseLifecycle.java:94)                                  
 at com.ca.topology.smf.SmfDataExtractorAggregator.extractAndAggregateData(SmfDataExtractorAggregator.java:102)                      
 at com.ca.topology.smf.SmfDataExtractorAggregator.main(SmfDataExtractorAggregator.java:57)                                          
Caused by: org.sqlite.SQLiteException: [SQLITE_FULL]  Insertion failed because database is full (database or disk is full)           
 at org.sqlite.core.DB.newSQLException(DB.java:1012)                                                                                 
 at org.sqlite.core.DB.newSQLException(DB.java:1024)                                                                                 
 at org.sqlite.core.DB.execute(DB.java:866)                                                                                          
 at org.sqlite.core.CoreStatement.exec(CoreStatement.java:80)                                                                        
 at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:46)                                                                  
 at com.ca.topology.db.DBOperations.updateBatch(DBOperations.java:272)                                                               
 at com.ca.topology.db.DBOperations.updateBatchFromResource(DBOperations.java:303)                                                   
 at com.ca.topology.smf.database.SqliteDatabaseLifecycle.afterLoad(SqliteDatabaseLifecycle.java:88)                                  
 ... 2 more                                                                                                                          

Environment

Release : 1.0

Cause

SQLite is using the default temporary directory of the environment and there was not enough space available. 

Resolution

The solution is to include the following statements in the extractor aggregator joblog and Topology API started task:

# Ensure that SQLite temporary files are all placed on the deploy zFS where
# we can control the free space
export TEMP=${APP_HOME}
export SQLITE_TMPDIR=${APP_HOME}

The members to be updated are:

Topology AP stc: CTPLOPTN(TPLBAENV)

Extractor Aggregator job: CTPLOPTN(TPLBEENV)