skellner
10,615 Views

I tried several actions but none of them worked. Installation to WFA 4.0, reset scheme. If I do a clean install and add the data source it works. However, I can't import my workflows. It throws an error every time. From a 3.1P2 installation I can't even export my workflows. And everytime I restore my last successful db backup the error returns. So I'm stuck at the moment. Unfortunately the logs are not showing which table is having the duplicate key. We need this running again asap as we are doing all of our daily work with workflows. So I anybody has an idea how to get rid of this error in the database I appreciate it. Thanks in advance.

 

wfa_acquisition.log:

Caused by: com.netapp.wfa.util.SqlShellException: <localhost> Failed to load from 'C:\Program Files\NetApp\WFA\jboss\standalone\tmp\wfa\localhost-storage.snapshot-386163981397160180.dump' into wfa_staging.storage_snapshot
    at com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:216) [common-0.5.jar:]
    at com.netapp.wfa.cache.execution.TableProcessorImpl.extractFromFiles(TableProcessorImpl.java:124) [cache-0.5.jar:]
    at com.netapp.wfa.cache.execution.ETLRunner.loadFromExtractedFiles(ETLRunner.java:121) [cache-0.5.jar:]
    at com.netapp.wfa.cache.execution.ETLRunner.loadFromExtractedFilesGlobalizeAndLoad(ETLRunner.java:80) [cache-0.5.jar:]
    at com.netapp.wfa.cache.job.CacheJobWorkerImpl.loadFromExtractedFilesGlobalizeAndLoad(CacheJobWorkerImpl.java:38) [cache-0.5.jar:]
    at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source) [:1.8.0_72]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_72]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_72]
    at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
    at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
    at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407)
    at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.2.6.Final.jar:2014-10-03 10:05]
    at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273) [wildfly-ejb3-8.2.0.Final.jar:8.2.0.Final]
    ... 194 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '2147483647' for key 'PRIMARY'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_72]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_72]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_72]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [rt.jar:1.8.0_72]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:389) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.Util.getInstance(Util.java:372) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1618) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549) [mysql-connector-java-5.1.35.Commercial.jar:5.1.35]
    at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
    at com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:203) [common-0.5.jar:]
    ... 232 more