java.sql.SQLSyntaxErrorException: Unknown column 'taskresult0_.live' in 'field list'

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi,

I am getting the below error after upgradation from IIQ8.1 to IIQ 8.1p2.

java.sql.SQLSyntaxErrorException: Unknown column ‘taskresult0_.live’ in ‘field list’

Can some one help in this?

2

Have you run the Database upgrade scripts? This is detailed in the README for 8.1p2, specifically line 3 of the installation instructions:

Installation Instructions:

  1. Stop the application server (or the IdentityIQ application
    if supported by the application server).

  2. Un-jar the IdentityIQ patch in the IdentityIQ installation
    directory.

  3. Using a database client, execute the
    upgrade_identityiq_tables-8.1p2 DDL script in WEB-INF/database
    that is appropriate for your database type. The database scripts are
    cumulative, so you will receive errors for the schema changes that have
    already been applied in previous patches.

  4. Apply the patch by using a command line interface to execute the command
    iiq patch 8.1p2 from the WEB-INF/bin directory.

  5. Start the application server (or the IdentityIQ application if
    supported by the application server).

3

Thanks Christian!

It was fixed. I had forgot to run iiq patch 8.1p2 and also updated the IdentityExtended.hbmxml and LinkExtended.hbm.xml where I had added some new columns.

4

Good stuff, glad it’s fixed.