Community

Subscribe
Highlighted

vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Trying to discover our non-production vcenter to certify the WFA tool and hitting a really strange error...

It's not putting anything in the acquisition log file but I'm getting this in the wfa.log

----------------------------------------------------------------

2013-07-23 15:50:48,820 EDT ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (WorkManager(2)-69) Job CacheJob{, dataSourceId=DataSourceInfo{id=3, name='vSphere CD Cert', connectionDetails=ConnectionDetails{id=7, ip='comrcvcert.cert.mtb.com', port=443, userName='******', password='******'}, dataProviderType=DataProviderType{id=4, productType='VMware vCenter', productVersion='4.X, 5.0.X, 5.1', driverType='null'}}, schemeId=Scheme{id=2, name='vc'}, dataSourceName='vSphere CD Cert', schemeName='vc'} failed

com.netapp.wfa.cache.execution.CacheException: Failed running cache job (also failed to dump the databases - Failed to dump [wfa_staging, vc])

          at com.netapp.wfa.cache.job.CacheJobExecutorImpl.dumpStagingAreaAndThrow(CacheJobExecutorImpl.java:201)

          at com.netapp.wfa.cache.job.CacheJobExecutorImpl.execute(CacheJobExecutorImpl.java:87)

          at sun.reflect.GeneratedMethodAccessor401.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)

          at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor$InvocationContext.proceed(InvocationContextInterceptor.java:138)

          at com.netapp.wfa.common.stats.MethodInvocationStatsInterceptor.recordMethodInvocation(MethodInvocationStatsInterceptor.java:23)

          at sun.reflect.GeneratedMethodAccessor388.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:83)

          at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:70)

          at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:59)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)

          at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1175153858.invoke(InvocationContextInterceptor_z_fillMethod_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1175153858.invoke(InvocationContextInterceptor_z_setup_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)

          at org.jboss.ejb3.tx.TxInterceptor$NotSupported.invoke(TxInterceptor.java:92)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)

          at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)

          at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)

          at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)

          at $Proxy471.execute(Unknown Source)

          at com.netapp.wfa.cache.job.CacheJobExecutorMDB.onMessage(CacheJobExecutorMDB.java:35)

          at sun.reflect.GeneratedMethodAccessor400.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)

          at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor$InvocationContext.proceed(InvocationContextInterceptor.java:138)

          at com.netapp.wfa.job.backend.JobsExecutionInterceptor.wrapJobExecution(JobsExecutionInterceptor.java:63)

          at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:83)

          at org.jboss.ejb3.interceptors.aop.EJB3InterceptorInterceptor.invoke(EJB3InterceptorInterceptor.java:70)

          at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:59)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)

          at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1175153858.invoke(InvocationContextInterceptor_z_fillMethod_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1175153858.invoke(InvocationContextInterceptor_z_setup_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)

          at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:80)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.mdb.MessagingContainer.localInvoke(MessagingContainer.java:282)

          at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.delivery(MessageInflowLocalProxy.java:270)

          at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.invoke(MessageInflowLocalProxy.java:140)

          at $Proxy522.onMessage(Unknown Source)

          at org.jboss.resource.adapter.jms.inflow.JmsServerSession.onMessage(JmsServerSession.java:178)

          at org.jboss.jms.client.container.ClientConsumer.callOnMessageStatic(ClientConsumer.java:160)

          at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:831)

          at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect_z_handleRun_1175153858.invoke(SessionAspect_z_handleRun_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170)

          at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:86)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java)

          at org.jboss.jms.client.JBossSession.run(JBossSession.java:199)

          at org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:234)

          at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205)

          at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

          at java.lang.Thread.run(Thread.java:722)

Caused by: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException: <localhost> Failed to load from 'D:\NetApp\WFA\jboss\server\default\tmp\wfa\lun.csv' into wfa_staging.vc_lun

          at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:77)

          at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)

          at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)

          at org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)

          at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)

          at org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)

          at $Proxy467.loadFromExtractedFilesGlobalizeAndLoad(Unknown Source)

          at com.netapp.wfa.cache.job.CacheJobExecutorImpl.runETL(CacheJobExecutorImpl.java:109)

          at com.netapp.wfa.cache.job.CacheJobExecutorImpl.execute(CacheJobExecutorImpl.java:82)

          ... 126 more

Caused by: com.netapp.wfa.util.SqlShellException: <localhost> Failed to load from 'D:\NetApp\WFA\jboss\server\default\tmp\wfa\lun.csv' into wfa_staging.vc_lun

          at com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:212)

          at com.netapp.wfa.cache.execution.TableProcessorImpl.extractFromFiles(TableProcessorImpl.java:117)

          at com.netapp.wfa.cache.execution.ETLRunner.loadFromExtractedFiles(ETLRunner.java:116)

          at com.netapp.wfa.cache.execution.ETLRunner.loadFromExtractedFilesGlobalizeAndLoad(ETLRunner.java:75)

          at com.netapp.wfa.cache.job.CacheJobWorkerImpl.loadFromExtractedFilesGlobalizeAndLoad(CacheJobWorkerImpl.java:34)

          at sun.reflect.GeneratedMethodAccessor415.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)

          at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)

          at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)

          at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:601)

          at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1175153858.invoke(InvocationContextInterceptor_z_fillMethod_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)

          at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1175153858.invoke(InvocationContextInterceptor_z_setup_1175153858.java)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)

          at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)

          at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)

          ... 147 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '-1499422296' for key 'PRIMARY'

          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

          at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

          at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)

          at com.mysql.jdbc.Util.getInstance(Util.java:381)

          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)

          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)

          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)

          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)

          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)

          at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)

          at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)

          at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)

          at com.netapp.wfa.util.SqlShell.loadFromFile(SqlShell.java:199)

          ... 181 more

----------------------------------------------------------------

This is ESXi 5.1 and WFA 2.0.1.23.8

Anything else I've seen on this duplicate entry stuff looks are all much older versions and look to have been resolved.

Any of these Java failures make any sense?

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

tflammger,

       You must be having Luns presented to your ESX hosts using FCP. This is is known issue in WFA for VC Datasource. This bug has already been identified and its fix should be available in the next WFA release which is expected very soon.

      Till then we regret your inconvenience.

warm regards,

Abhishek Sinha

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Yeah, most of our environment is running on Fibre Channel; we just recently started to explore NFS for vmware which ironically is the reason I'm excited about WFA. I was hoping to use WFA to deploy 88 NFS datastores without using the extremely slow, tedious, and crash happy VSC plugin. The bugs in the current release keep getting in my way though, really sad news that a stable version wont be available soon enough to help me out this time.

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Don't fret.

WFA 2.1 RC1 is literally around the corner, and the release is due in several weeks (Way into single digits :-))

Feel free to leave to contact me directly with your details, we might be able to share RC1...

Yaron

yaronh@netapp.com

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Any wait is too much wait through, I needed it working this week.

As for the RC, our vm admins won't be thrilled with the idea of scripts hitting their environment from non-GA code.

So I"ll just torture myself with VSC and wait for a stable release.

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Yaron,

Did this get fixed? I'm still getting this error in 2.1.

Phil

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Phil,

      This issue is fixed in 2.1. Are you sure your's is a 2.1 and not 2.0.1?

Failure in WFA2.0.1

Successful acquisition of the same VC in WFA2.1

warm regards,

Abhishek

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Abhishek,

Apparently not. Also see it in the 2.2 beta.

Error occurring in 2.1.

Error in the 2.2 beta.

Re: vc datasource: Duplicate entry '-1499422296' for key 'PRIMARY'

Hi Phil,

     Looks like this is your lab setup. Could you kindly send me an email with details of your vCenter ?

We will check this and let you know what the problem and quick workaround if any.

Regards

adai