Hi
We are facing an error when we are trying to run our PLC. (please see the error trace from content_center.log below)
The sql server has been freshly installed. The passsword for the user is the same as the previous one.
Am not sure what is causing the error. PLC was working initially. It stopped after the fresh installation of SQl server took place.
I looked at the livesite_database.xml in opendeployng/etc, unfortunately the database pwd provided there is encrypted.
------------------------------------------------------------------------------------------------------------------------------------
WARN com.interwoven.ui.datacapture.core.dcxp.DTDNodeOrderingStrategy () - Error reading DTD
http://localhost/iw-cc/datacapture6.0.dtd. Message:
http://localhost/iw-cc/datacapture6.0.dtd2011-06-30 04:17:32,420 [http-0.0.0.0-8080-1] WARN org.hibernate.util.JDBCExceptionReporter () - SQL Error: 0, SQLState: null
2011-06-30 04:17:32,421 [http-0.0.0.0-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter () - Cannot create PoolableConnectionFactory (Login failed for user 'sa'.)
2011-06-30 04:17:32,421 [http-0.0.0.0-8080-1] WARN org.hibernate.util.JDBCExceptionReporter () - SQL Error: 0, SQLState: null
2011-06-30 04:17:32,421 [http-0.0.0.0-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter () - Cannot create PoolableConnectionFactory (Login failed for user 'sa'.)
2011-06-30 04:17:32,421 [http-0.0.0.0-8080-1] ERROR com.interwoven.livesite.workflow.web.task.SetMetaTagsWebTask () - Error during task execution: Could not invoke method: setTags, reason: Error while executing method: public java.util.List com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject.findBySearchArguments(java.util.List)
java.lang.RuntimeException: Could not invoke method: setTags, reason: Error while executing method: public java.util.List com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject.findBySearchArguments(java.util.List)
at com.interwoven.livesite.workflow.web.task.AbstractDispatchWebTask.handleExecution(AbstractDispatchWebTask.java:105)
at com.interwoven.livesite.workflow.web.task.AbstractAjaxWebTask.execute(AbstractAjaxWebTask.java:72)
at com.interwoven.livesite.workflow.web.action.CSWebTaskAction.execute(CSWebTaskAction.java:110)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.interwoven.livesite.spring.hibernate.web.filter.OpenSessionsInViewFilter.doFilterInternal(OpenSessionsInViewFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.interwoven.ui.base.impl.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:203)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.interwoven.ui.base.util.SetRequestEncodingFilter.doFilter(SetRequestEncodingFilter.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.interwoven.livesite.workflow.web.task.AbstractDispatchWebTask.handleExecution(AbstractDispatchWebTask.java:94)
... 39 more
Caused by: java.lang.RuntimeException: Error while executing method: public java.util.List com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject.findBySearchArguments(java.util.List)
at com.interwoven.livesite.aop.intercept.ConditionalMethodExecutionInterceptor.invoke(ConditionalMethodExecutionInterceptor.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject$$EnhancerByCGLIB$$16a13b38.findBySearchArguments()
at com.interwoven.livesite.iw.metadata.TeamSiteAssetUniqueIdMetaTag.executeInResolutionTargetEnvironments(TeamSiteAssetUniqueIdMetaTag.java:96)
at com.interwoven.livesite.iw.metadata.TeamSiteAssetUniqueIdMetaTag.getValue(TeamSiteAssetUniqueIdMetaTag.java:186)
at com.interwoven.livesite.iw.metadata.TeamSiteMetadataService.tagFileInternal(TeamSiteMetadataService.java:179)
at com.interwoven.livesite.iw.metadata.TeamSiteMetadataService.tagFilesInternal(TeamSiteMetadataService.java:148)
at com.interwoven.livesite.iw.metadata.TeamSiteMetadataService.retagFiles(TeamSiteMetadataService.java:125)
at com.interwoven.livesite.iw.metadata.TeamSiteMetadataService$$FastClassByCGLIB$$7f5a067e.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.interwoven.livesite.concurrent.ReentrantReadWriteLockInterceptor.invoke(ReentrantReadWriteLockInterceptor.java:114)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at com.interwoven.livesite.iw.metadata.TeamSiteMetadataService$$EnhancerByCGLIB$$8b11bc8e.retagFiles()
at com.interwoven.livesite.workflow.web.task.SetMetaTagsWebTask.setTags(SetMetaTagsWebTask.java:82)
... 44 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject.findBySearchArguments(BaseHibernateDataAccessObject.java:293)
at com.interwoven.livesite.hibernate.dao.impl.BaseHibernateDataAccessObject$$FastClassByCGLIB$$46b41f9d.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
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 com.interwoven.livesite.aop.intercept.ConditionalMethodExecutionInterceptor.invoke(ConditionalMethodExecutionInterceptor.java:60)
... 61 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Login failed for user 'sa'.)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 80 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:156)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:240)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:78)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2636)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2046)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2034)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4003)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1550)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1207)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
... 83 more
2011-06-30 04:17:37,812 [pool-12-thread-1] ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: received failure result for deployment: ImageMetadata
2011-06-30 04:17:37,812 [pool-12-thread-1] ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: serviceResponseMessage: Completed with errors
2011-06-30 04:17:37,812 [pool-12-thread-1] ERROR com.interwoven.livesite.deployment.impl.DeploymentRunner () - deployFiles: failOnError is true; no other deployments will be executed.
2011-06-30 04:17:37,812 [pool-12-thread-1] ERROR com.interwoven.livesite.workflow.task.DeploymentTaskUtils () - deployFiles: found one or more errors while processing target node(s): [development]
2011-06-30 04:18:01,623 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,663 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,698 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,731 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,769 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,808 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,841 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,875 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,908 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,946 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:01,980 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:02,014 [pool-14-thread-1] ERROR com.interwoven.wcm.service.iwovregistry.adaptorclients.IWLicenseAdaptorClient () - Exception while hitting serverAdaptor-IWLicenseAdaptor Invalid ServiceId/ClientId - Authentication failed
2011-06-30 04:18:02,014 [pool-14-thread-1] WARN com.interwoven.ui.teamsite.util.TeamSiteLicenseUtils () - Problem(s) reading current TeamSite License info from Registry:
2011-06-30 04:18:02,014 [pool-14-thread-1] WARN com.interwoven.ui.teamsite.util.TeamSiteLicenseUtils () - Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
Invalid ServiceId/ClientId - Authentication failed
------------------------------------------------------------------------------------------------------------------------------------
