nuodb / migration-tools

Migration tools for NuoDB
http://nuodb.github.com/migration-tools/
BSD 3-Clause "New" or "Revised" License
27 stars 10 forks source link

load step outputs exception without any explanation of what went wrong or it was just a fixed error #10

Closed akshah123 closed 11 years ago

akshah123 commented 11 years ago

After I ran the load step, I see following exception message outputted several times. After the output, the script keeps going. Message does not indicate exactly what caused the problem or if the problem caused data not to be imported.

After the script finishes, not all data was imported. All tables have some data but several tables don't have all the data they should have.

24-01-2013 15:50:22 (ERROR) (com.nuodb.migration.jdbc.query.StatementTemplate.execute(StatementTemplate.java:60)) - Failed executing statement callback
java.lang.IllegalArgumentException: Illegal group reference
        at java.util.regex.Matcher.appendReplacement(Matcher.java:725)
        at com.nuodb.migration.jdbc.query.SimpleStatementFormatter.format(SimpleStatementFormatter.java:58)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$PreparedStatementInvocationHandler.invokeExecute(StatementLoggingConnectionProvider.java:248)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider.invokeStatementExecute(StatementLoggingConnectionProvider.java:119)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$StatementInvocationHandler.invoke(StatementLoggingConnectionProvider.java:194)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$PreparedStatementInvocationHandler.invoke(StatementLoggingConnectionProvider.java:231)
        at $Proxy2.executeUpdate(Unknown Source)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:207)
        at com.nuodb.migration.load.LoadJob$2.execute(LoadJob.java:192)
        at com.nuodb.migration.load.LoadJob$2.execute(LoadJob.java:189)
        at com.nuodb.migration.jdbc.query.StatementTemplate.execute(StatementTemplate.java:57)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:182)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:161)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:131)
        at com.nuodb.migration.load.LoadJob.execute(LoadJob.java:101)
        at com.nuodb.migration.load.LoadJob.execute(LoadJob.java:87)
        at com.nuodb.migration.job.SimpleJobExecutor.execute(SimpleJobExecutor.java:103)
        at com.nuodb.migration.cli.run.CliRunJob.run(CliRunJob.java:56)
        at com.nuodb.migration.cli.run.CliRunJob.run(CliRunJob.java:49)
        at com.nuodb.migration.cli.CliHandlerSupport.handleRun(CliHandlerSupport.java:179)
        at com.nuodb.migration.cli.CliHandlerSupport.handleOptionSet(CliHandlerSupport.java:127)
        at com.nuodb.migration.cli.CliHandler.boot(CliHandler.java:55)
        at com.nuodb.migration.bootstrap.Bootstrap.boot(Bootstrap.java:80)
        at com.nuodb.migration.bootstrap.Bootstrap.main(Bootstrap.java:135)

Another execption at the end:

 24-01-2013 16:11:47 (ERROR) (com.nuodb.migration.jdbc.query.StatementTemplate.execute(StatementTemplate.java:60)) - Failed executing statement callback
java.lang.IndexOutOfBoundsException: No group 1
        at java.util.regex.Matcher.start(Matcher.java:374)
        at java.util.regex.Matcher.appendReplacement(Matcher.java:748)
        at com.nuodb.migration.jdbc.query.SimpleStatementFormatter.format(SimpleStatementFormatter.java:58)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$PreparedStatementInvocationHandler.invokeExecute(StatementLoggingConnectionProvider.java:248)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider.invokeStatementExecute(StatementLoggingConnectionProvider.java:119)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$StatementInvocationHandler.invoke(StatementLoggingConnectionProvider.java:194)
        at com.nuodb.migration.jdbc.connection.StatementLoggingConnectionProvider$PreparedStatementInvocationHandler.invoke(StatementLoggingConnectionProvider.java:231)
        at $Proxy2.executeUpdate(Unknown Source)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:207)
        at com.nuodb.migration.load.LoadJob$2.execute(LoadJob.java:192)
        at com.nuodb.migration.load.LoadJob$2.execute(LoadJob.java:189)
        at com.nuodb.migration.jdbc.query.StatementTemplate.execute(StatementTemplate.java:57)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:182)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:161)
        at com.nuodb.migration.load.LoadJob.load(LoadJob.java:131)
        at com.nuodb.migration.load.LoadJob.execute(LoadJob.java:101)
        at com.nuodb.migration.load.LoadJob.execute(LoadJob.java:87)
        at com.nuodb.migration.job.SimpleJobExecutor.execute(SimpleJobExecutor.java:103)
        at com.nuodb.migration.cli.run.CliRunJob.run(CliRunJob.java:56)
        at com.nuodb.migration.cli.run.CliRunJob.run(CliRunJob.java:49)
        at com.nuodb.migration.cli.CliHandlerSupport.handleRun(CliHandlerSupport.java:179)
        at com.nuodb.migration.cli.CliHandlerSupport.handleOptionSet(CliHandlerSupport.java:127)
        at com.nuodb.migration.cli.CliHandler.boot(CliHandler.java:55)
        at com.nuodb.migration.bootstrap.Bootstrap.boot(Bootstrap.java:80)
        at com.nuodb.migration.bootstrap.Bootstrap.main(Bootstrap.java:135) 
tazija commented 11 years ago

The issue fixed in JdbcLoggingConnectionProvider