LB 3.0.2 against DB2: Error with preConditions not tableExists

General Discussion
1

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:


   

       

           

               

           

       

    […]

       

           

               

           

           

               

           

           

               

           

           

           

               

           

       

    […]

   

   

       

           

               

           

       

        META

       

           

           

       

   


[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’: 

[updateDatabase]           ./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.  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 .


This LB script works fine with LB LB 2.0.1.


Kind regards,

Frank

2

Hi there,


Martin

3

Great, thanks for the update.


Nathan