nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Alfresco 2.0 mysql Error

burner

Hello i followed the instructins to install the war file.

I use Tomcat 5.5.20 and mysql 4.1.12.

After doing everything i got this error:

17:26:22,714 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
17:26:25,886 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
17:26:29,245 INFO [domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-46567.sql
17:26:29,339 INFO [domain.schema.SchemaBootstrap] Executing database script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-46567.sql
17:26:55,685 INFO [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql
17:27:40,723 WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
17:27:45,927 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   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:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more
17:27:45,942 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   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:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more
17:27:45,942 ERROR [[Catalina].[localhost].[/alfresco]] Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextListener
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:444)
   at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:666)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   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:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to read zip file due to Cp437
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:83)
   at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:227)
   at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:430)
   … 33 more
Caused by: java.util.zip.ZipException: Cp437
   at org.apache.tools.zip.ZipFile.getString(ZipFile.java:454)
   at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:298)
   at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:142)
   at org.alfresco.repo.importer.ACPImportPackageHandler.startImport(ACPImportPackageHandler.java:79)
   … 35 more

Can someone help me?

Find more posts tagged with

Comments

melkor_kp

I am using Ubuntu (Concretely XUbuntu), I installed mysql from the ubuntu
repositories, I installed the java virtual machine 1.5 revision 11 and I get
exactly the same error.

I installed alfresco from AlfrescoCommunity-2.0-Linux-x86-Install

I deleted the files explained in the directory, I removed all the directories in
Alf_data and I created the database tables. This process worked properly
for the version 1.4.AlfrescoCommunity-2.0-Linux-x86-Install

Does anybody know what is happening.

melkor_kp

Ok, It is working for me.
What you should do is the following:

Install the java jdk 1.5 (in my case version 11)
Add the java to the variable $PATH 
Define the variable JAVA_HOME pointing to the java machine directory
Delete the directory content of /opt/Alfresco/alf_data/
Delete the files custom-db-and-data-context.xml
                            custom-db-connection.properties
                            custom-hibernate-dialect.properties
This files are stored in /opt/Alfresco/tomcat/shared/classes/alfresco/extension
mysql -u root -p < /opt/Alfresco/extras/databases/mysql/db_remove.sql
mysql -u root -p < /opt/Alfresco/extras/databases/mysql/db_setup.sql
Then ensure is not tomcat running with /etc/init.d/tomcat5 stop
And ensure that it is not any instance of alfresco runnig with
ps -aux | grep java. With killall java you can stop any instance running.‍‍‍‍‍‍‍‍‍‍‍‍‍

Following this instructions it worked to me in a Ubuntu distro. I hope this
would be useful for you.

burner

Hi thanx dor the reply.Thats what i thought too, that its because i took JAva 11 update but why?

I removed the update to have it runn.

But i still have some warnings:

15:26:42,465 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
15:27:00,512 WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
15:27:05,106 INFO [domain.schema.SchemaBootstrap] Generating unmodified schema creation script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-34335.sql
15:27:05,231 INFO [domain.schema.SchemaBootstrap] Executing database script: C:\webserver\runtime\Tomcat 5.5\temp\Alfresco\AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-34335.sql
15:27:31,778 INFO [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql
15:28:11,090 WARN [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.
15:29:59,465 INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: c:\alf_data
15:29:59,512 INFO [admin.patch.PatchExecuter] Checking for patches to apply …
15:29:59,715 INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
15:30:01,137 INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_10-b03; maximum heap size 63,313MB
15:30:01,137 WARN [service.descriptor.DescriptorService] Alfresco JVM - WARNING - maximum heap size 63,313MB is less than recommended 512MB
15:30:01,137 INFO [service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 2.0.0 (build-185) schema 38 - Installed version 2.0.0 (build-185) schema 38

The synchronization with the indexes sounds bad!How can i get it right and how can i make the heapsize bigger?

heckle

If you do not have any data on this system (i.e. this system is NOT already in production) try deleting the alf_data directory and delete the alfresco database in mysql. Recreate the alfresco database and try to startup tomcat again.

kevinr

how can i make the heapsize bigger?

Edit the values JAVA_OPTS to something like this:
-Xms256m -Xmx512m
in your catalina.bat/catalina.sh files as appropriate.

Thanks,

Kevin

burner

Thank you i got it!