aatams_sattag_dm fails on an empty schema

[jonescc]

aatams_sattag_dm can't be run on an empty schema causing problems for talend 7 testing (and testing in general).

craigj@6-nec-hob:~$ talend_liqui aatams_sattag_dm-aatams_sattag_dm
Going to process a total of '1' files
Processing slice with '1' files
Preparing file '___aatams_sattag_dm-aatams_sattag_dm___,___aatams_sattag_dm-aatams_sattag_dm___' in temp dir '/tmp/d20190507-15605-1bs8gr0'
DEL '/home/craigj/___aatams_sattag_dm-aatams_sattag_dm___' => '___aatams_sattag_dm-aatams_sattag_dm___'
'aatams_sattag_dm-aatams_sattag_dm': ["___aatams_sattag_dm-aatams_sattag_dm___"]
Executing '/usr/local/talend/jobs/aatams_sattag_dm-aatams_sattag_dm/java/aatams_sattag_dm_harvester/aatams_sattag_dm_harvester_run.sh --context_param paramFile="/usr/local/talend/jobs/aatams_sattag_dm-aatams_sattag_dm/etc/aatams_sattag_dm-aatams_sattag_dm.conf" --context_param base=/tmp/d20190507-15605-1bs8gr0 --context_param fileList=/tmp/harvester_file_list20190507-15605-24u2c5 --context_param logDir=/tmp/d20190507-15605-3h7v8l' for '["___aatams_sattag_dm-aatams_sattag_dm___"]'
INFO 7/05/19 8:39 AM:liquibase: Successfully acquired change log lock
INFO 7/05/19 8:39 AM:liquibase: Reading from aatams_sattag_dm.databasechangelog
INFO 7/05/19 8:39 AM:liquibase: Reading from aatams_sattag_dm.databasechangelog
INFO 7/05/19 8:39 AM:liquibase: Successfully released change log lock
FILE_INDEX_UPDATER - WARNING: ___aatams_sattag_dm-aatams_sattag_dm___ not found on indexINFO 7/05/19 8:39 AM:liquibase: Successfully acquired change log lock
INFO 7/05/19 8:39 AM:liquibase: Reading from aatams_sattag_dm.databasechangelog
INFO 7/05/19 8:39 AM:liquibase: Reading from aatams_sattag_dm.databasechangelog
SEVERE 7/05/19 8:39 AM:liquibase: Change Set changelog.xml::create_unique_index_on_summary_data::xhoenner failed.  Error: Error executing SQL CREATE UNIQUE INDEX unique_summary_data_idx ON summary_data(summary_id): ERROR: relation "summary_data" does not exist
liquibase.exception.DatabaseException: Error executing SQL CREATE UNIQUE INDEX unique_summary_data_idx ON summary_data(summary_id): ERROR: relation "summary_data" does not exist
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at liquibase.Liquibase.update(Liquibase.java:114)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.iPostgresqlDbUpdate_1Process(aatams_sattag_dm_harvester.java:2081)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.iUpdateIndex_1Process(aatams_sattag_dm_harvester.java:1463)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.tPostgresqlConnection_1Process(aatams_sattag_dm_harvester.java:1344)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.runJobInTOS(aatams_sattag_dm_harvester.java:5519)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.main(aatams_sattag_dm_harvester.java:5307)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "summary_data" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        ... 12 more
INFO 7/05/19 8:39 AM:liquibase: Successfully released change log lock
Exception in component iPostgresqlDbUpdate_1
liquibase.exception.MigrationFailedException: Migration failed for change set changelog.xml::create_unique_index_on_summary_data::xhoenner:
     Reason: liquibase.exception.DatabaseException: Error executing SQL CREATE UNIQUE INDEX unique_summary_data_idx ON summary_data(summary_id): ERROR: relation "summary_data" does not exist:
          Caused By: Error executing SQL CREATE UNIQUE INDEX unique_summary_data_idx ON summary_data(summary_id): ERROR: relation "summary_data" does not exist:
          Caused By: ERROR: relation "summary_data" does not exist
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at liquibase.Liquibase.update(Liquibase.java:114)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.iPostgresqlDbUpdate_1Process(aatams_sattag_dm_harvester.java:2081)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.iUpdateIndex_1Process(aatams_sattag_dm_harvester.java:1463)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.tPostgresqlConnection_1Process(aatams_sattag_dm_harvester.java:1344)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.runJobInTOS(aatams_sattag_dm_harvester.java:5519)
        at aatams_sattag_dm.aatams_sattag_dm_harvester_0_1.aatams_sattag_dm_harvester.main(aatams_sattag_dm_harvester.java:5307)
Caused by: liquibase.exception.DatabaseException: Error executing SQL CREATE UNIQUE INDEX unique_summary_data_idx ON summary_data(summary_id): ERROR: relation "summary_data" does not exist
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        ... 8 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation "summary_data" does not exist
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        ... 12 more
2019-05-07 08:39:02;W7sKWv;W7sKWv;W7sKWv;15611;AATAMS_SATTAG_DM;aatams_sattag_dm_harvester;_MOp9oJgmEeOMouHqP27dXg;0.1;Default;;begin;;

2019-05-07 08:39:06;W7sKWv;W7sKWv;W7sKWv;15611;AATAMS_SATTAG_DM;aatams_sattag_dm_harvester;_MOp9oJgmEeOMouHqP27dXg;0.1;Default;;end;failure;3874

Talend harvester aatams_sattag_dm-aatams_sattag_dm: 1 file(s)  FAILED
Aborting operation
craigj@6-nec-hob:~$