| Description | I use 1.5.0-Snapshot, I use oracle as hub, sqlserver as spoke, I insert a raw into hub's table test1, this raw was symed to spoke's table test1. seens fine so far, then I update hub's same raw, the exception come: WARN - IncomingBatchService - Retrying batch 00000-545 ERROR - DataLoaderService - Failed to load batch 00000-545 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SET IDENTITY_INSERT AMP_Test1 ON]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: IDENTITY_INSERT is already ON for table 'DB1.dbo.sym_trigger'. Cannot perform SET operation for table 'AMP_Test1'. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(S QLStateSQLExceptionTranslator.java:111) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.transla te(SQLErrorCodeSQLExceptionTranslator.java:322) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:429) at org.jumpmind.symmetric.db.mssql.MsSqlDbDialect.prepareTableForDataLoad(MsSqlDbDialect.java:111) at org.jumpmind.symmetric.load.csv.CsvLoader.setTable(CsvLoader.java:202) at org.jumpmind.symmetric.load.csv.CsvLoader.isMetaTokenParsed(CsvLoader.java:169) at org.jumpmind.symmetric.load.csv.CsvLoader.load(CsvLoader.java:140) at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy18.load(Unknown Source) at org.jumpmind.symmetric.service.impl.DataLoaderService$1.doInTransactionWithoutResult(DataLoaderService.java:289) at org.springframework.transaction.support.TransactionCallbackWithoutResult.do InTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadBatch(DataLoaderService.java:284) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataAndReturnBatches(DataLoaderService.java:200) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadData(DataLoaderService.java:104) at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:67) at org.jumpmind.symmetric.job.PullJob.doJob(PullJob.java:35) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:78) at java.util.TimerThread.mainLoop(Timer.java:512) at java.util.TimerThread.run(Timer.java:462) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: IDENTITY_INSERT is already ON for table 'DB1.dbo.sym_trigger'. Cannot perform SET operation for table 'AMP_Test1'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(UnknownSource) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(UnknownSource) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(UnknownSource) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(UnknownSource) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(UnknownSource) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(UnknownSource) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.jav a:264) at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInSt atement(JdbcTemplate.java:422) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) ... 26 more |
|---|