liquibase.exception.DatabaseException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • I have this changelog (see attached). It runs fine against MySQL and Oracle. Running on DB2 on zOs (I believe it is version 9 but not 100% sure). Since I am adding a primary key, liquibase generates a "REORG" command automatically and it does not work for zOs. Here is the output and error at the bottom. So the question is, is there a way for liquibase not to generate the "REORG" statement? DEBUG 2/2/15 11:17 PM: liquibase: Setting auto commit to false from true DEBUG 2/2/15 11:17 PM: liquibase: Computed checksum for 1422947837289 as 2961375d2cc7576268a3300ffe0e0d51 DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: select count(*) from FIA1Q15.DATABASECHANGELOGLOCK DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT LOCKED FROM FIA1Q15.DATABASECHANGELOGLOCK WHERE ID=1 DEBUG 2/2/15 11:17 PM: liquibase: Lock Database DEBUG 2/2/15 11:17 PM: liquibase: Executing UPDATE database command: UPDATE FIA1Q15.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKED BY = 'DG1LX9S1 (10.38.92.198)', LOCKGRANTED = TIMESTAMP('2015-02-02 23:17:17.823') WHERE ID = 1 AND LOCKED = 0 INFO 2/2/15 11:17 PM: liquibase: Successfully acquired change log lock DEBUG 2/2/15 11:17 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquib ase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 2/2/15 11:17 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://ww w.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/pa rser/core/xml/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT MD5SUM FROM FIA1Q15.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL INFO 2/2/15 11:17 PM: liquibase: Reading from FIA1Q15.DATABASECHANGELOG DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED, EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE FROM FIA1Q15.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Running Changeset:test.ch angelog.xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Changeset test.changelog. xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Reading ChangeSet: test.c hangelog.xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.CreateTableStatement@425ef7f2 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CREATE TABLE FIA1Q15.metadata (id VARCHAR(80) NOT NULL, value CLOB NOT NULL) INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Table metadata created DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.CreateTableStatement@6c9b3326 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CREATE TABLE FIA1Q15.preferences (id VARCHAR(80) NOT NULL, value CLOB NOT NULL) INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Table preferences created DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.AddPrimaryKeyStatement@413b3b7e DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: ALTER TABLE FIA1Q15.metadata ADD CONSTRAINT PK_METADATA PRIMARY KEY (id) DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.ReorganizeTableStatement@17beeea7 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata') SEVERE 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Change Set test.changelo g.xml::Preference-20150128-1::test failed. Error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lite ral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15 .metadata'). ERRORCODE=-4463, SQLSTATE=42601 liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacem ent parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for proce dure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=4 2601 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:103) at com.ibm.db2.jcc.am.gn.h(gn.java:4034) at com.ibm.db2.jcc.am.gn.a(gn.java:2987) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 11 more DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Release Database Lock DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Executing UPDATE database command: UPDATE FIA 1Q15.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Successfully released change log lock Unexpected error running Liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ER RORCODE=-4463, SQLSTATE=42601 SEVERE 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPRO C.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=42601 liquibase.exception.MigrationFailedException: Migration failed for change set test.changelog.xml::Preference-20150128-1::test: Reason: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lit eral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q1 5.metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Liter al replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15. metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) ... 6 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for proce dure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=4 2601 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:103) at com.ibm.db2.jcc.am.gn.h(gn.java:4034) at com.ibm.db2.jcc.am.gn.a(gn.java:2987) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 11 more
    via by Anna Nicotera,
  • I have this changelog (see attached). It runs fine against MySQL and Oracle. Running on DB2 on zOs (I believe it is version 9 but not 100% sure). Since I am adding a primary key, liquibase generates a "REORG" command automatically and it does not work for zOs. Here is the output and error at the bottom. So the question is, is there a way for liquibase not to generate the "REORG" statement? DEBUG 2/2/15 11:17 PM: liquibase: Setting auto commit to false from true DEBUG 2/2/15 11:17 PM: liquibase: Computed checksum for 1422947837289 as 2961375d2cc7576268a3300ffe0e0d51 DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: select count(*) from FIA1Q15.DATABASECHANGELOGLOCK DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT LOCKED FROM FIA1Q15.DATABASECHANGELOGLOCK WHERE ID=1 DEBUG 2/2/15 11:17 PM: liquibase: Lock Database DEBUG 2/2/15 11:17 PM: liquibase: Executing UPDATE database command: UPDATE FIA1Q15.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKED BY = 'DG1LX9S1 (10.38.92.198)', LOCKGRANTED = TIMESTAMP('2015-02-02 23:17:17.823') WHERE ID = 1 AND LOCKED = 0 INFO 2/2/15 11:17 PM: liquibase: Successfully acquired change log lock DEBUG 2/2/15 11:17 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquib ase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd' DEBUG 2/2/15 11:17 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://ww w.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.3.xsd is liquibase/pa rser/core/xml/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.3.xsd DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT MD5SUM FROM FIA1Q15.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL INFO 2/2/15 11:17 PM: liquibase: Reading from FIA1Q15.DATABASECHANGELOG DEBUG 2/2/15 11:17 PM: liquibase: Executing QUERY database command: SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED, EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE FROM FIA1Q15.DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Running Changeset:test.ch angelog.xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Changeset test.changelog. xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Reading ChangeSet: test.c hangelog.xml::Preference-20150128-1::test DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.CreateTableStatement@425ef7f2 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CREATE TABLE FIA1Q15.metadata (id VARCHAR(80) NOT NULL, value CLOB NOT NULL) INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Table metadata created DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.CreateTableStatement@6c9b3326 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CREATE TABLE FIA1Q15.preferences (id VARCHAR(80) NOT NULL, value CLOB NOT NULL) INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Table preferences created DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.AddPrimaryKeyStatement@413b3b7e DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: ALTER TABLE FIA1Q15.metadata ADD CONSTRAINT PK_METADATA PRIMARY KEY (id) DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing Statement: liqu ibase.statement.core.ReorganizeTableStatement@17beeea7 DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Executing EXECUTE databas e command: CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata') SEVERE 2/2/15 11:17 PM: liquibase: test.changelog.xml: test.changelog.xml::Preference-20150128-1::test: Change Set test.changelo g.xml::Preference-20150128-1::test failed. Error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lite ral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15 .metadata'). ERRORCODE=-4463, SQLSTATE=42601 liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacem ent parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for proce dure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=4 2601 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:103) at com.ibm.db2.jcc.am.gn.h(gn.java:4034) at com.ibm.db2.jcc.am.gn.a(gn.java:2987) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 11 more DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Release Database Lock DEBUG 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Executing UPDATE database command: UPDATE FIA 1Q15.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1 INFO 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: Successfully released change log lock Unexpected error running Liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ER RORCODE=-4463, SQLSTATE=42601 SEVERE 2/2/15 11:17 PM: liquibase: test.changelog.xml::Preference-20150128-1::test: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPRO C.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=42601 liquibase.exception.MigrationFailedException: Migration failed for change set test.changelog.xml::Preference-20150128-1::test: Reason: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lit eral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q1 5.metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Liter al replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15. metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) ... 6 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for proce dure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=4 2601 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:103) at com.ibm.db2.jcc.am.gn.h(gn.java:4034) at com.ibm.db2.jcc.am.gn.a(gn.java:2987) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 11 more
    via by Anna Nicotera,
  • When using liquibase against DB2 on z/OS, it only seems to work if the schema name is the same as user name, but since you can have many schemas under one database, and can have different users access the schemas, liquibase does not seem to use the username and always defaults to using the schema name as the user name. I see in the generated SQL things like "...**CREATE TABLE FOR USER CFANNA*..." Example: database is *DFI6* schema name is *CFANNA* username is *FIA1Q15* commandLine liquibase is: C:\liquibase3.3.2>liquibase --changeLogFile=test.changelog.xml --logLevel=debug --url="jdbc:db2://somehost:40600/DFI6" --username=FIA1Q15 --password=somepassword --defaultSchemaName=CFANNA migrate DEBUG 2/3/15 7:55 PM: liquibase: Connected to FIA1Q15@jdbc:db2://somehost:40600/DFI6 DEBUG 2/3/15 7:55 PM: liquibase: Setting auto commit to false from true DEBUG 2/3/15 7:55 PM: liquibase: Computed checksum for 1423022144363 as 92d309ed1af61a268a93e2b0343bcbe6 DEBUG 2/3/15 7:55 PM: liquibase: Create Database Lock Table DEBUG 2/3/15 7:55 PM: liquibase: Executing EXECUTE database command: CREATE TABLE CFANNA.DATABASECHANGELOGLOCK (ID INTEGER NOT N ULL, LOCKED SMALLINT NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DBCHGLOGLOCK PRIMARY KEY (ID)) Unexpected error running Liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQL ERRMC=FIA1Q15;*CREATE TABLE FOR USER CFANNA*;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 SEVERE 2/3/15 7:55 PM: liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLER RMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 liquibase.exception.LockException: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Er ror: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:215) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:154) at liquibase.Liquibase.update(Liquibase.java:186) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLST ATE=42501, SQLERRMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:87) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:188) ... 5 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=FIA1Q15;CREATE TABL E FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.gn.c(gn.java:2554) at com.ibm.db2.jcc.am.gn.d(gn.java:2542) at com.ibm.db2.jcc.am.gn.b(gn.java:1974) at com.ibm.db2.jcc.t4.cb.h(cb.java:224) at com.ibm.db2.jcc.t4.cb.b(cb.java:47) at com.ibm.db2.jcc.t4.q.b(q.java:38) at com.ibm.db2.jcc.t4.rb.h(rb.java:114) at com.ibm.db2.jcc.am.gn.fb(gn.java:1969) at com.ibm.db2.jcc.am.gn.a(gn.java:3065) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 10 more
    via by Anna Nicotera,
  • When using liquibase against DB2 on z/OS, it only seems to work if the schema name is the same as user name, but since you can have many schemas under one database, and can have different users access the schemas, liquibase does not seem to use the username and always defaults to using the schema name as the user name. I see in the generated SQL things like "...**CREATE TABLE FOR USER CFANNA*..." Example: database is *DFI6* schema name is *CFANNA* username is *FIA1Q15* commandLine liquibase is: C:\liquibase3.3.2>liquibase --changeLogFile=test.changelog.xml --logLevel=debug --url="jdbc:db2://somehost:40600/DFI6" --username=FIA1Q15 --password=somepassword --defaultSchemaName=CFANNA migrate DEBUG 2/3/15 7:55 PM: liquibase: Connected to FIA1Q15@jdbc:db2://somehost:40600/DFI6 DEBUG 2/3/15 7:55 PM: liquibase: Setting auto commit to false from true DEBUG 2/3/15 7:55 PM: liquibase: Computed checksum for 1423022144363 as 92d309ed1af61a268a93e2b0343bcbe6 DEBUG 2/3/15 7:55 PM: liquibase: Create Database Lock Table DEBUG 2/3/15 7:55 PM: liquibase: Executing EXECUTE database command: CREATE TABLE CFANNA.DATABASECHANGELOGLOCK (ID INTEGER NOT N ULL, LOCKED SMALLINT NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DBCHGLOGLOCK PRIMARY KEY (ID)) Unexpected error running Liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQL ERRMC=FIA1Q15;*CREATE TABLE FOR USER CFANNA*;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 SEVERE 2/3/15 7:55 PM: liquibase: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLER RMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 liquibase.exception.LockException: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Er ror: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:215) at liquibase.lockservice.StandardLockService.waitForLock(StandardLockService.java:154) at liquibase.Liquibase.update(Liquibase.java:186) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLST ATE=42501, SQLERRMC=FIA1Q15;CREATE TABLE FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112) at liquibase.lockservice.StandardLockService.init(StandardLockService.java:87) at liquibase.lockservice.StandardLockService.acquireLock(StandardLockService.java:188) ... 5 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=FIA1Q15;CREATE TABL E FOR USER CFANNA;CFANNA.DATABASECHANGELOGLOCK, DRIVER=3.61.75 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.gn.c(gn.java:2554) at com.ibm.db2.jcc.am.gn.d(gn.java:2542) at com.ibm.db2.jcc.am.gn.b(gn.java:1974) at com.ibm.db2.jcc.t4.cb.h(cb.java:224) at com.ibm.db2.jcc.t4.cb.b(cb.java:47) at com.ibm.db2.jcc.t4.q.b(q.java:38) at com.ibm.db2.jcc.t4.rb.h(rb.java:114) at com.ibm.db2.jcc.am.gn.fb(gn.java:1969) at com.ibm.db2.jcc.am.gn.a(gn.java:3065) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 10 more
    via by Anna Nicotera,
  • IF you are using IBM DB2 9.7 database, following error is thrown when browsing security audit logs: 2011.03.10 01:23:12 DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997, SQLERRMC=63, DRIVER=3.61.65 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997, SQLERRMC=63, DRIVER=3.61.65 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.gn.c(gn.java:2554) at com.ibm.db2.jcc.am.gn.d(gn.java:2542) at com.ibm.db2.jcc.am.gn.a(gn.java:2034) at com.ibm.db2.jcc.am.hn.a(hn.java:6500) at com.ibm.db2.jcc.t4.cb.g(cb.java:140) at com.ibm.db2.jcc.t4.cb.a(cb.java:40) at com.ibm.db2.jcc.t4.q.a(q.java:32) at com.ibm.db2.jcc.t4.rb.i(rb.java:135) at com.ibm.db2.jcc.am.gn.gb(gn.java:2005) at com.ibm.db2.jcc.am.hn.qc(hn.java:3053) at com.ibm.db2.jcc.am.hn.b(hn.java:3838) at com.ibm.db2.jcc.am.hn.dc(hn.java:683) at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:657) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at com.ibm.db2.jcc.am.kn$$EnhancerByProxool$$5b7c2e02.executeQuery(<generated>) at org.jivesoftware.database.ProfiledConnection$TimedPreparedStatement.executeQuer y(ProfiledConnection.java:780) at org.jivesoftware.openfire.security.DefaultSecurityAuditProvider.getEvents(Defau ltSecurityAuditProvider.java:141) at org.jivesoftware.openfire.security.SecurityAuditManager.getEvents(SecurityAudit Manager.java:160) at org.jivesoftware.openfire.admin.security_002daudit_002dviewer_jsp._jspService(s ecurity_002daudit_002dviewer_jsp.java:190) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1216) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:74) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:50) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:78) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:164) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:425) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494) at org.eclipse.jetty.server.session.SessionHandler.handle(SessionHandler.java:182) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:93 3) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:362) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867 ) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:245) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.jav a:126) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConne ction.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:541) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:4 62) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Unknown Source) SQL statement which caused this is: SELECT msgID,username,entryStamp,summary,node,details FROM ofSecurityAuditLog ORDER BY entryStamp DESC Problem is not in SELECT itself, it is in datatypes used and cursor type requested: DB2 Error is: SQL0270N Function not supported (Reason code = "63") Error desc: 63 A column with a LOB type, distinct type on a LOB type, or structured type cannot be specified in the select-list of an insensitive scrollable cursor. USer response: 63 Modify the select-list of the scrollable cursor to not include a column with these types. Proposed fix: Try sensitive scrollable cursor instead and if it fails too, go for non scrollable cursor which should be good enough for selecting rows too.
    via by wroot,
  • IF you are using IBM DB2 9.7 database, following error is thrown when browsing security audit logs: 2011.03.10 01:23:12 DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997, SQLERRMC=63, DRIVER=3.61.65 com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-270, SQLSTATE=42997, SQLERRMC=63, DRIVER=3.61.65 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.gn.c(gn.java:2554) at com.ibm.db2.jcc.am.gn.d(gn.java:2542) at com.ibm.db2.jcc.am.gn.a(gn.java:2034) at com.ibm.db2.jcc.am.hn.a(hn.java:6500) at com.ibm.db2.jcc.t4.cb.g(cb.java:140) at com.ibm.db2.jcc.t4.cb.a(cb.java:40) at com.ibm.db2.jcc.t4.q.a(q.java:32) at com.ibm.db2.jcc.t4.rb.i(rb.java:135) at com.ibm.db2.jcc.am.gn.gb(gn.java:2005) at com.ibm.db2.jcc.am.hn.qc(hn.java:3053) at com.ibm.db2.jcc.am.hn.b(hn.java:3838) at com.ibm.db2.jcc.am.hn.dc(hn.java:683) at com.ibm.db2.jcc.am.hn.executeQuery(hn.java:657) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100) at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57) at com.ibm.db2.jcc.am.kn$$EnhancerByProxool$$5b7c2e02.executeQuery(<generated>) at org.jivesoftware.database.ProfiledConnection$TimedPreparedStatement.executeQuer y(ProfiledConnection.java:780) at org.jivesoftware.openfire.security.DefaultSecurityAuditProvider.getEvents(Defau ltSecurityAuditProvider.java:141) at org.jivesoftware.openfire.security.SecurityAuditManager.getEvents(SecurityAudit Manager.java:160) at org.jivesoftware.openfire.admin.security_002daudit_002dviewer_jsp._jspService(s ecurity_002daudit_002dviewer_jsp.java:190) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1216) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:74) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:50) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:78) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:164) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:425) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494) at org.eclipse.jetty.server.session.SessionHandler.handle(SessionHandler.java:182) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:93 3) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:362) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867 ) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:245) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.jav a:126) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConne ction.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:541) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:4 62) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Unknown Source) SQL statement which caused this is: SELECT msgID,username,entryStamp,summary,node,details FROM ofSecurityAuditLog ORDER BY entryStamp DESC Problem is not in SELECT itself, it is in datatypes used and cursor type requested: DB2 Error is: SQL0270N Function not supported (Reason code = "63") Error desc: 63 A column with a LOB type, distinct type on a LOB type, or structured type cannot be specified in the select-list of an insensitive scrollable cursor. USer response: 63 Modify the select-list of the scrollable cursor to not include a column with these types. Proposed fix: Try sensitive scrollable cursor instead and if it fails too, go for non scrollable cursor which should be good enough for selecting rows too.
    via by wroot,
    • liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Lit eral replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q1 5.metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.integration.commandline.Main.doMigration(Main.java:1044) at liquibase.integration.commandline.Main.run(Main.java:175) at liquibase.integration.commandline.Main.main(Main.java:94) Caused by: liquibase.exception.DatabaseException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Liter al replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15. metadata'). ERRORCODE=-4463, SQLSTATE=42601 at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) ... 6 more Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.61.75] Literal replacement parsing failed for proce dure call to DB2 for z/OS. Failing SQL text CALL SYSPROC.ADMIN_CMD ('REORG TABLE FIA1Q15.metadata'). ERRORCODE=-4463, SQLSTATE=4 2601 at com.ibm.db2.jcc.am.ed.a(ed.java:676) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:103) at com.ibm.db2.jcc.am.gn.h(gn.java:4034) at com.ibm.db2.jcc.am.gn.a(gn.java:2987) at com.ibm.db2.jcc.am.gn.e(gn.java:1029) at com.ibm.db2.jcc.am.gn.execute(gn.java:1013) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314) ... 11 more
    No Bugmate found.