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

JIRA | Anna Nicotera | 2 years ago
  1. 0

    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

    JIRA | 2 years ago | Anna Nicotera
    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
  2. 0

    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

    JIRA | 2 years ago | Anna Nicotera
    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
  3. 0

    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

    JIRA | 2 years ago | Anna Nicotera
    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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    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

    JIRA | 2 years ago | Anna Nicotera
    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
  6. 0

    Error with db2 query using jdbc

    Stack Overflow | 5 years ago | Ready Cent
    com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10413][10940][3.62.56] **Literal replacement parsing failed for procedure call to DB2 for z/OS**. Failing SQL text Call Call SYSPROC.SPNAME('2011-06-13','23.34.45.123456','EG2813B','1111111111','SDP',' ','N','1','377777777777777;BOKACB;BASICCCCC;KRISHNAAAA;01;344444444444444;BOK;BASIC;KRISHNA;02;','1;2;D;7;D;','1;REASON11;REASON12;2;REASON21;REASON22;D;3;REASON31;REASON32;4;REASON41;REASON42;D;0;;;D;',?,?,?,?,?). ERRORCODE=-4463, SQLSTATE=42601

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. IBM DB2
      gn.execute
      1. com.ibm.db2.jcc.am.ed.a(ed.java:676)
      2. com.ibm.db2.jcc.am.ed.a(ed.java:60)
      3. com.ibm.db2.jcc.am.ed.a(ed.java:103)
      4. com.ibm.db2.jcc.am.gn.h(gn.java:4034)
      5. com.ibm.db2.jcc.am.gn.a(gn.java:2987)
      6. com.ibm.db2.jcc.am.gn.e(gn.java:1029)
      7. com.ibm.db2.jcc.am.gn.execute(gn.java:1013)
      7 frames
    3. Liquibase Core
      Main.main
      1. liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
      2. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
      3. liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
      4. liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
      5. liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
      6. liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
      7. liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
      8. liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
      9. liquibase.Liquibase.update(Liquibase.java:200)
      10. liquibase.integration.commandline.Main.doMigration(Main.java:1044)
      11. liquibase.integration.commandline.Main.run(Main.java:175)
      12. liquibase.integration.commandline.Main.main(Main.java:94)
      12 frames