# LB 3.0.2 against DB2: Error with preConditions not tableExists

**URL:** <https://forum.liquibase.org/t/lb-3-0-2-against-db2-error-with-preconditions-not-tableexists/2341>\
**Category:** General Discussion\
**Created:** [August 1, 2013, 8:02pm UTC](https://forum.liquibase.org/t/lb-3-0-2-against-db2-error-with-preconditions-not-tableexists/2341 "2013-08-01T20:02:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![franksch\_lb](https://avatars.discourse-cdn.com/v4/letter/f/9de053/32.png) [@franksch\_lb](https://forum.liquibase.org/u/franksch_lb)\
**Post date:** [August 1, 2013, 8:02pm UTC](https://forum.liquibase.org/t/lb-3-0-2-against-db2-error-with-preconditions-not-tableexists/2341/1 "2013-08-01T20:02:00Z")

</div>

Hi all,

we have tested LB 3.0.2 (using Ant 1.8.2) with our scripts (in order to upgrade from LB 2.0.1) against DB2 v9.7.0.5 and found an error:

&nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; […]

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; […]

&nbsp; &nbsp;

&nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; META

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp; &nbsp; &nbsp;

&nbsp; &nbsp;

[updateDatabase] INFO 01.08.13 14:41:liquibase: Reading from LB\_TEST.DATABASECHANGELOG

[updateDatabase] INFO 01.08.13 14:41:liquibase: Marking ChangeSet: ./build/all-Structure-Init-Create.xml::changeSet.1::Author::(Checksum: 7:ecb0afc6682ca603f904ebfc4ef8eea3) ran despite precondition failure due to onFail=‘MARK\_RAN’:&nbsp;

[updateDatabase] &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ./build/sparda\_meta-create\_total.xml : Not precondition failed

[updateDatabase] SEVERE 01.08.13 14:41:liquibase: Change Set ./build/all-Structure-Init-Create.xml::changeSet.2::Author failed. &nbsp;Error: Error executing SQL CREATE INDEX LB\_TEST.IX\_TableA ON LB\_TEST.TableA(Column04, Column05): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LB\_TEST.TableA, DRIVER=4.7.85

[updateDatabase] liquibase.exception.DatabaseException: Error executing SQL CREATE INDEX LB\_TEST.IX\_TableA ON LB\_TEST.TableA(Column04, Column05): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LB\_TEST.TableA, DRIVER=4.7.85

_“SQLCODE=-204, SQLSTATE=42704, SQLERRMC=LB\_TEST.TableA”_ means that DB2 is missing table&nbsp;.

This LB script works fine with LB LB 2.0.1.

Kind regards,

Frank

---

<div class="post-metadata">

**Author:** ![un1384346908173r96id](https://avatars.discourse-cdn.com/v4/letter/u/a8b319/32.png) [@un1384346908173r96id](https://forum.liquibase.org/u/un1384346908173r96id)\
**Post date:** [August 1, 2013, 8:02pm UTC](https://forum.liquibase.org/t/lb-3-0-2-against-db2-error-with-preconditions-not-tableexists/2341/2 "2013-08-01T20:02:00Z")

</div>

Hi there,

Martin

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [August 1, 2013, 8:02pm UTC](https://forum.liquibase.org/t/lb-3-0-2-against-db2-error-with-preconditions-not-tableexists/2341/3 "2013-08-01T20:02:00Z")

</div>

Great, thanks for the update.

Nathan
