Hyland Connect

gk17 · ‎10-07-2009

Hi everyone, just joined the forum here. We have Alfresco running here under RedHat Linux Enterprise Edition. Not sure if this will be needed as well, but it's running in a virtual machine (ESX server).

It has been working fine until recently when there was a network problem. The network issue seems to be resolved now and we can get full access to the server. The administrator who installed this on the ESX server is no longer working with us. I usually just go to the alfresco directory and start up the service from there using ./alfresco.sh start. We then wait about 10 minutes and the Alfresco web page works (http://ip_address:8080/alfresco/faces/jsp/login.jsp). Now we get the following error in Internet Explorer:

HTTP Status 404 - /alfresco/faces/jsp/login.jsp——————————————————————————–type Status reportmessage /alfresco/faces/jsp/login.jspdescription The requested resource (/alfresco/faces/jsp/login.jsp) is not available.——————————————————————————–Apache Tomcat/5.5.23‍‍‍‍‍‍‍‍‍‍‍‍‍‍

One thing I did notice is that there is no faces directory. Not sure if that can be the cause of this problem (seems to be logically). If so, how can we fix this?

I also noticed that the "web server service" wasn't running either. So I went into the init.d directory and started httpd service. I also increased the size of the file handling block (suggested by the Alfresco administrator before he left) by running ulimit -n 4096.

I am not a big Linux user but do know the basic commands and have no problems working in the command prompt which I have been doing for the most part.

I have tried to search online for a solution but couldn't find one. Some mentioned not connecting to the database but from the error shown, it doesn't seem to be related.

Please advise and let us know how to proceed from here.

Thanks.

gronfelt · ‎10-07-2009

There's no need to start the webserver, since you are connecting directly to Tomcat (on port 8080), which is the application server running Alfresco. The "faces" directory is not a real directory, it's just a part of the URL that Alfresco uses.

The 404 error you're getting could mean just about anything, what you need to do is to look in the alfresco.log file and see what it says when you start up the server. That file is normally located in the same directory as alfresco.sh.

gk17 · ‎10-07-2009

Thanks for the reply.

I was actually looking at the file yesterday but couldn't really make out what it means (maybe Java). I just tried to open it up again using vi and it says there was another swap file using it. I just opened it up as read-only. Below is a chunk of the errors in the alfresco.log file:

        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)        at org.apache.catalina.core.StandardService.start(StandardService.java:448)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)        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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: java.lang.IllegalStateException: No user transaction is active        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:479)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:276)        … 44 more16:27:29,638 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListenerorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dictionaryRepositoryBootstrap' defined in class path resource [alfresco/core-services-context.xml]: Invocation of init method failed; nested exception is org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@13fc437Caused by:org.alfresco.error.AlfrescoRuntimeException: Failure during rollback: org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap$1@13fc437        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:281)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:155)        at org.alfresco.repo.dictionary.DictionaryRepositoryBootstrap.bootstrap(DictionaryRepositoryBootstrap.java:134)        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 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1160)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1122)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)        at org.apache.catalina.core.StandardService.start(StandardService.java:448)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)        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 org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)Caused by: java.lang.IllegalStateException: No user transaction is active        at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:479)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:276)        … 44 more"alfresco.log" [readonly] 504L, 48627C                                                                                                                                             504,2-9       Bot‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Thanks for explaining the webserver part also. Was running out of options yesterday and one of the searches came up with running that service. Good to know that it's not required because of Tomcat.

gronfelt · ‎10-08-2009

I assume that you are running a pretty old version of Alfresco, do you know what version?

A database issue seems like a likely cause to the problem, you should check that your database server is up and running. I believe that you can find out what database type you are using by looking in this file:

<alfresco install dir>tomcat/shared/classes/alfresco/extension/custom-repository.properties

Look for any lines that begins with db (you could post them here if you need help interpreting them). When you know the database type (MySQL for instance), you need to check that it's up and running, that the adress is correct and that the username and password is correct.

That's where I'd begin looking. If that doesn't help you may need to provide more information from the log. You could rename the old log file, so that Alfresco will start with a fresh one on startup, then use tail -f alfresco.log to follow the log during startup and post the entire log content, from server startup to the failed attempt to load the page.

gk17 · ‎10-08-2009

It looks like it's using MySQL. Most of the other lines are commented out. I have the following:

db.driver=org.gjt.mm.mysql.Driver
db.url=jdbc:mysql://localhost/alfresco

I'm not sure where to look for the database information or even where the DB is located in RedHat. Did some searching and found a mention of alfresco-global.properties but don't know where it is. It's not located in the extension directory. After a little more digging online, it looks like the data is stored at /alfresco/alf_data. But when I go there, I'm not sure what I'm looking at. Thought it would just be a .sql file or the scanned documents we saved (which is a lot).

OK…was doing this step by step and I think you nailed it. At first, starting the MySQL service didn't seem to do the job as I was still getting the 404 HTTP status error page. I stopped the Alfresco service and then launched it again to run the tail command. I hit refresh on the web portal and voila, it's back up and running now

How do I make the MySQL service run at startup? Read something about using a mysql.server file to do this but got a litlte confused on how to properly use it.

Not sure what version I'm using here, but I think the guy that installed it was using the latest one (could be wrong). Bottom copyright says 2005-2007 though…Nothing else regarding the version.

Thank you gronfelt for the quick replies. Couldn't have done this without your help. It's greatly appreciated. I just hope they don't make me the Alfresco administrator here now because it's fixed :lol:

gronfelt · ‎10-08-2009

Glad I could be of any help.

If you've got mysqld setup as a service you could probably configure it to start at computer startup with the command:

chkconfig mysqld on‍

As for the Alfresco version, the copyright line on the current version says 2005-2009. You could maybe check what version you have in the Administration Console, under System Information. The Administration Console is opened with one of the icons in the upper right corner, if you are logged in as an administrative user. At least that's how it looks in version 3 and onwards, I'm not sure about older versions.

gk17 · ‎10-08-2009

Perfect. That did the job.

Looks like it's verson 2.1.0. Not upgrading it until I know what I'm doing

Just noticed another problem. Since Alfresco was down, we had the users scan their documents to the local drive. I pointed these stations back to the server and was about to copy those documents to it when I noticed a huge lag when I try to open up the network drive to Alfresco. Is this an issue on the Alfresco end by any chance or maybe just our network? It was performing at almost optimal speed before this issue arose a few days ago.