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
Release : 1.0
SQLite is using the default temporary directory of the environment and there was not enough space available.
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)