2015-04-18 16:33:24,074 INFO [post] [IncomingBatchService] [post-job-1] Retrying batch 000-715670
2015-04-18 16:33:24,136 INFO [post] [DefaultDatabaseWriter] [post-job-1] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="cards">
		<column name="id" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="mssql2005" type="int identity" size="10"/>
		</column>
		<column name="code" required="true" type="BIGINT" size="19">
			<platform-column name="mssql2005" type="bigint" size="19"/>
		</column>
		<column name="type" required="true" type="INTEGER" size="10">
			<platform-column name="mssql2005" type="int" size="10"/>
		</column>
		<column name="expiry_date" type="TIMESTAMP" size="16">
			<platform-column name="mssql2005" type="smalldatetime" size="16"/>
		</column>
		<column name="restricted_by" type="VARCHAR" size="20">
			<platform-column name="mssql2005" type="varchar" size="20"/>
		</column>
		<column name="people_id" type="INTEGER" size="10">
			<platform-column name="mssql2005" type="int" size="10"/>
		</column>
		<column name="card_number" type="SMALLINT" size="5">
			<platform-column name="mssql2005" type="smallint" size="5"/>
		</column>
		<column name="issued" required="true" type="BIT" size="1" default="0">
			<platform-column name="mssql2005" type="bit" size="1"/>
		</column>
		<foreign-key name="FK_cards_cardtypes" foreignTable="cardtypes">
			<reference local="type" foreign="card_type_id"/>
		</foreign-key>
		<foreign-key name="FK_cards_locations" foreignTable="locations">
			<reference local="location" foreign="loc_id"/>
		</foreign-key>
		<foreign-key name="FK_cards_people" foreignTable="people">
			<reference local="people_id" foreign="id"/>
		</foreign-key>
		<unique name="IX_cards_code">
			<unique-column name="code"/>
		</unique>
		<index name="IX_cards_people_id">
			<index-column name="people_id"/>
		</index>
	</table>
</database>
2015-04-18 16:33:24,136 INFO [post] [SqliteDatabasePlatform] [post-job-1] Running alter sql:
CREATE TABLE "cards"(
    "id" INTEGER NOT NULL PRIMARY KEY  AUTOINCREMENT,
    "code" INTEGER NOT NULL,
    "type" INTEGER NOT NULL,
    "expiry_date" TIMESTAMP,
    "restricted_by" VARCHAR,
    "people_id" INTEGER,
    "card_number" INTEGER,
    "issued" INTEGER DEFAULT 0 NOT NULL,
    FOREIGN KEY ("type") REFERENCES "cardtypes" ("card_type_id"),
    FOREIGN KEY ("location") REFERENCES "locations" ("loc_id"),
    FOREIGN KEY ("people_id") REFERENCES "people" ("id")
);
CREATE UNIQUE INDEX "IX_cards_code" ON "cards" ("code");
CREATE INDEX "IX_cards_people_id" ON "cards" ("people_id");

2015-04-18 16:33:24,136 WARN [post] [JdbcSqlTemplate] [post-job-1] [SQLITE_ERROR] SQL error or missing database (unknown column "location" in foreign key definition).  Failed to execute: CREATE TABLE "cards"(
    "id" INTEGER NOT NULL PRIMARY KEY  AUTOINCREMENT,
    "code" INTEGER NOT NULL,
    "type" INTEGER NOT NULL,
    "expiry_date" TIMESTAMP,
    "restricted_by" VARCHAR,
    "people_id" INTEGER,
    "card_number" INTEGER,
    "issued" INTEGER DEFAULT 0 NOT NULL,
    FOREIGN KEY ("type") REFERENCES "cardtypes" ("card_type_id"),
    FOREIGN KEY ("location") REFERENCES "locations" ("loc_id"),
    FOREIGN KEY ("people_id") REFERENCES "people" ("id")
)
2015-04-18 16:33:24,136 ERROR [post] [DefaultDatabaseWriter] [post-job-1] Failed to alter table using the following xml: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="cards">
		<column name="id" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="mssql2005" type="int identity" size="10"/>
		</column>
		<column name="code" required="true" type="BIGINT" size="19">
			<platform-column name="mssql2005" type="bigint" size="19"/>
		</column>
		<column name="type" required="true" type="INTEGER" size="10">
			<platform-column name="mssql2005" type="int" size="10"/>
		</column>
		<column name="expiry_date" type="TIMESTAMP" size="16">
			<platform-column name="mssql2005" type="smalldatetime" size="16"/>
		</column>
		<column name="restricted_by" type="VARCHAR" size="20">
			<platform-column name="mssql2005" type="varchar" size="20"/>
		</column>
		<column name="people_id" type="INTEGER" size="10">
			<platform-column name="mssql2005" type="int" size="10"/>
		</column>
		<column name="card_number" type="SMALLINT" size="5">
			<platform-column name="mssql2005" type="smallint" size="5"/>
		</column>
		<column name="issued" required="true" type="BIT" size="1" default="0">
			<platform-column name="mssql2005" type="bit" size="1"/>
		</column>
		<foreign-key name="FK_cards_cardtypes" foreignTable="cardtypes">
			<reference local="type" foreign="card_type_id"/>
		</foreign-key>
		<foreign-key name="FK_cards_locations" foreignTable="locations">
			<reference local="location" foreign="loc_id"/>
		</foreign-key>
		<foreign-key name="FK_cards_people" foreignTable="people">
			<reference local="people_id" foreign="id"/>
		</foreign-key>
		<unique name="IX_cards_code">
			<unique-column name="code"/>
		</unique>
		<index name="IX_cards_people_id">
			<index-column name="people_id"/>
		</index>
	</table>
</database>
2015-04-18 16:33:24,136 ERROR [post] [DataLoaderService] [post-job-1] Failed to load batch 000-715670 because: [SQLITE_ERROR] SQL error or missing database (unknown column "location" in foreign key definition)
org.jumpmind.db.sql.SqlException: [SQLITE_ERROR] SQL error or missing database (unknown column "location" in foreign key definition)
	at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288)
	at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279)
	at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:434)
	at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:344)
	at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107)
	at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:204)
	at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:177)
	at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:508)
	at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:167)
	at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
	at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:65)
	at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64)
	at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:204)
	at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:200)
	at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:170)
	at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:116)
	at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(DataLoaderService.java:820)
	at org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(StagingDataWriter.java:75)
	at org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(AbstractProtocolDataWriter.java:220)
	at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:130)
	at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.java:430)
	at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:267)
	at org.jumpmind.symmetric.service.impl.PullService.execute(PullService.java:135)
	at org.jumpmind.symmetric.service.impl.NodeCommunicationService$2.run(NodeCommunicationService.java:317)
	at org.jumpmind.symmetric.service.impl.NodeCommunicationService.execute(NodeCommunicationService.java:331)
	at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:105)
	at org.jumpmind.symmetric.job.PullJob.doJob(PullJob.java:39)
	at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:177)
	at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:224)
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (unknown column "location" in foreign key definition)
	at org.sqlite.core.DB.newSQLException(DB.java:890)
	at org.sqlite.core.DB.newSQLException(DB.java:901)
	at org.sqlite.core.DB.throwex(DB.java:868)
	at org.sqlite.core.NativeDB.prepare(Native Method)
	at org.sqlite.core.DB.prepare(DB.java:211)
	at org.sqlite.jdbc3.JDBC3Statement.execute(JDBC3Statement.java:60)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
	at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
	at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:358)
	at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:344)
	at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:432)
	... 34 more
2015-04-18 16:33:24,277 INFO [post] [PullService] [post-job-1] There was a failure while pulling data from main:000:000.  1 rows and 1 batches were processed