Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-03-14T16:03:49Z by SystemAdmin
Mel_Song
Mel_Song
2 Posts
ACCEPTED ANSWER

Pinned topic Db2 migration tool kit reported Exception in thread "main" java.lang.

‏2012-02-28T22:33:07Z |
I was running the IBM DB2 migration tool kit to migrate a sybase
database to db2.

The command "MTKMain.sh -config config_sybdb.xml_out -extract -
convert" reported Java errors as below.

Exception in thread "main" java.lang.StackOverflowError
at com.ibm.mtk.translation.source.common.grammars.NodeInfo.
setPosition(NodeInfo.java:107)
at com.ibm.mtk.translation.source.common.grammars.SrcAST.
initialize(SrcAST.java:76)
at antlr.ASTFactory.create(ASTFactory.java:196)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
identifier(TsqlParser.java:9451)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
simple_name(TsqlParser.java:19225)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.basis
(TsqlParser.java:19033)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
variable_expression(TsqlParser.java:18120)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
primary_expression(TsqlParser.java:17704)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
unary_expr(TsqlParser.java:17570)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
mult_expr(TsqlParser.java:17395)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
add_expr(TsqlParser.java:17246)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.expr
(TsqlParser.java:10414)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
cond_primary(TsqlParser.java:19755)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
not_expr(TsqlParser.java:19680)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
and_expr(TsqlParser.java:19628)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
or_expr(TsqlParser.java:19591)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
cond_expr(TsqlParser.java:12258)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
where_clause(TsqlParser.java:21982)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
update_stmt(TsqlParser.java:1842)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
tsql_stmt(TsqlParser.java:707)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25862)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25903)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25903)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25903)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25903)
at com.ibm.mtk.translation.source.tsql.grammars.TsqlParser.
pure_stmt_space_list(TsqlParser.java:25903)

This migration tool kit worked well on other sybase databases, so this error could be specific to the SQL statements in this sybase database.

Is this a known issue?
Updated on 2012-03-14T16:03:49Z at 2012-03-14T16:03:49Z by SystemAdmin
  • Mel_Song
    Mel_Song
    2 Posts
    ACCEPTED ANSWER

    Re: Db2 migration tool kit reported Exception in thread "main" java.lang.

    ‏2012-02-28T22:35:26Z  in response to Mel_Song
    More info about the the MTKMain.sh and the config file:

    cat MTKMain.sh

    #!/bin/sh
    java -Xmx1256m -classpath ".:antlr.jar:common.jar:mtk.jar:ifxjdbc.jar:
    ifxtools.jar:ifxlang.jar:ifxlsupp.jar:jt400.jar:jlpex11.jar:help.jar:
    jhall.jar:xmistore.jar:cwm.jar:orainfxtUDFs.jar:$CLASSPATH" com.ibm.mtk.
    MTKMain $*
    np2c6n6 /var/tmp/mtk.sa.20712 48$

    cat config_sybdb.xml_out

    <?xml version="1.0"?>

    <!DOCTYPE MTK SYSTEM "mtk.dtd">

    <MTK>

    <PROJECT

    NAME="LNQ_ITRISK.cedar" DIRECTORY="/var/tmp/mtk.sa.20712"

    SRCDBTYPE="SYBASE_ASE" TRGTDBTYPE="DB2LUW_V9.5">

    <SPECIFY_SOURCE>

    <EXTRACT EXTRACTTOFILE="source" SRCUSR="sa" SRCPWD="to7v">

    <JDBC_CONNECTION

    IP="10.173.29.116" PORT="8481"

    ></JDBC_CONNECTION>

    <DATABASE NAME="cedar" ENTIREDATABASE="Y"></DATABASE>

    </EXTRACT>

    </SPECIFY_SOURCE>

    <CONVERSIONS>

    <CONVERSION>

    <CONVERT SRCSQLFILES="source.src"></CONVERT>
    <GENERATE_DATA_TRANSFER_SCRIPTS></GENERATE_DATA_TRANSFER_SCRIPTS>

    <DEPLOY_TO_TARGET

    TRGTDBNAME="myDB2mig" TRGTUSR="db2user"

    TRGTPWD="db2password" DBLOCATION="remote"

    ></DEPLOY_TO_TARGET>

    </CONVERSION>

    </CONVERSIONS>

    </PROJECT>

    </MTK>
    • SystemAdmin
      SystemAdmin
      708 Posts
      ACCEPTED ANSWER

      Re: Db2 migration tool kit reported Exception in thread "main" java.lang.

      ‏2012-03-14T16:03:49Z  in response to Mel_Song
      Please send a mail to mtk@us.ibm.com and someone will get back to you.

      This forum is for IBM Data Movement Tool which is different than MTK.