Active IQ Unified Manager Discussions

WFA 2.0 OCUM Sybase polling failing

willwalsh4
3,403 Views

Getting the following error while trying to discover DFM storage objects. This was working previously, but is in a lab, so I'm not quite sure when/why it quit.

Below is the configuration (pretty straightforward). Below that is the log entries. I have obviously checked the password, changed the password, restarted WFA and DFM services, etc. Any

DFM details

2013-09-19 08:55:24,037 CDT INFO  [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (WorkManager(2)-82) Job CacheJob{, dataSourceId=DataSourceInfo{id=7, name='xxxxxx', connectionDetails=ConnectionDetails{id=7, ip='xxxxxx', port=2638, userName='xxxx', password='******'}, dataProviderType=DataProviderType{id=3, productType='OnCommand Unified Manager (DFM)', productVersion='4.0,5.0.X,5.1.X,5.2 7 Mode', driverType='SYBASE'}}, schemeId=Scheme{id=5, name='storage'}, dataSourceName='wldfm01', schemeName='storage'} started

2013-09-19 08:55:25,133 CDT ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (WorkManager(2)-82) Job CacheJob{, dataSourceId=DataSourceInfo{id=7, name='xxxxxxx', connectionDetails=ConnectionDetails{id=7, ip='xxxxxx', port=2638, userName='xxxx', password='******'}, dataProviderType=DataProviderType{id=3, productType='OnCommand Unified Manager (DFM)', productVersion='4.0,5.0.X,5.1.X,5.2 7 Mode', driverType='SYBASE'}}, schemeId=Scheme{id=5, name='storage'}, dataSourceName='xxxxxxx', schemeName='storage'} failed

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

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.GeneratedMethodAccessor1003.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.GeneratedMethodAccessor1002.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_972560634.invoke(InvocationContextInterceptor_z_fillMethod_972560634.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_972560634.invoke(InvocationContextInterceptor_z_setup_972560634.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 $Proxy502.execute(Unknown Source)

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

at sun.reflect.GeneratedMethodAccessor1001.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.GeneratedMethodAccessor1000.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_972560634.invoke(InvocationContextInterceptor_z_fillMethod_972560634.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_972560634.invoke(InvocationContextInterceptor_z_setup_972560634.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 $Proxy539.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_972560634.invoke(SessionAspect_z_handleRun_972560634.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: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source

at com.netapp.wfa.util.SqlShell.getConnection(SqlShell.java:1097)

at com.netapp.wfa.util.SqlShell.<init>(SqlShell.java:45)

at com.netapp.wfa.cache.execution.SqlBasedExtractor.<init>(SqlBasedExtractor.java:31)

at com.netapp.wfa.cache.execution.ETLRunner.getExtractor(ETLRunner.java:142)

at com.netapp.wfa.cache.execution.ETLRunner.extractToFiles(ETLRunner.java:98)

at com.netapp.wfa.cache.job.CacheJobWorkerImpl.extractToFiles(CacheJobWorkerImpl.java:28)

at sun.reflect.GeneratedMethodAccessor1007.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_972560634.invoke(InvocationContextInterceptor_z_fillMethod_972560634.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_972560634.invoke(InvocationContextInterceptor_z_setup_972560634.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$Never.invoke(TxInterceptor.java:63)

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 $Proxy499.extractToFiles(Unknown Source)

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

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

... 126 more

Caused by: java.sql.SQLWarning: SQL Anywhere Error -103: Invalid user ID or password

at com.sybase.jdbc3.jdbc.SybConnection.convertToWarnings(Unknown Source)

at com.sybase.jdbc3.jdbc.SybConnection.chainWarnings(Unknown Source)

at com.sybase.jdbc3.tds.Tds.for(Unknown Source)

at com.sybase.jdbc3.tds.Tds.case(Unknown Source)

at com.sybase.jdbc3.tds.Tds.login(Unknown Source)

at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)

at com.sybase.jdbc3.jdbc.SybConnection.handleHAFailover(Unknown Source)

at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)

at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)

at com.sybase.jdbc3.jdbc.SybDriver.createConnection(Unknown Source)

at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)

at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)

at com.sybase.jdbc3.jdbc.SybDataSource.getConnection(Unknown Source)

at com.netapp.wfa.util.SqlShell.getConnection(SqlShell.java:1094)

... 182 more

1 ACCEPTED SOLUTION

sinhaa
3,403 Views

willwalsh4,

       Looking at the logs you posted and the error message, it looks like the username-password combination is not correct and that itself is the only reason.

I would suggest you run the wfa_ocsetup.exe again on your DFM5.1 server and re-create the Database username/password again and then try to acquire it in WFA.

Downloading it is available at : http://<your_WFA_server>/download/wfa_ocsetup.exe

Also if you have an DB client software which can connect to a SYBASE SQL Anywhere (e.g. DB visualizer with SYBASE SQL Anywhere Jconnect driver) , you can verify this by connecting to your DFM server using the Database username/password you just added to your DFM using the wfa_ocsetup.exe This will make sure everything is fine without WFA in picture.

Let me know how this worked for you.

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

2 REPLIES 2

sinhaa
3,404 Views

willwalsh4,

       Looking at the logs you posted and the error message, it looks like the username-password combination is not correct and that itself is the only reason.

I would suggest you run the wfa_ocsetup.exe again on your DFM5.1 server and re-create the Database username/password again and then try to acquire it in WFA.

Downloading it is available at : http://<your_WFA_server>/download/wfa_ocsetup.exe

Also if you have an DB client software which can connect to a SYBASE SQL Anywhere (e.g. DB visualizer with SYBASE SQL Anywhere Jconnect driver) , you can verify this by connecting to your DFM server using the Database username/password you just added to your DFM using the wfa_ocsetup.exe This will make sure everything is fine without WFA in picture.

Let me know how this worked for you.

sinhaa

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

willwalsh4
3,403 Views

Yes, this fixed it. I had forgotten that this setup the database credentials.

Thanks so much!!!

Public