topic Cant save dokument through MS Excel 2003. in Alfresco Archive

Cant save dokument through MS Excel 2003.

kase — Thu, 27 Sep 2007 18:42:52 GMT

Hi again!IÃ‚Â´m running Alfresco 2.1 and I have mapped my alfrescoserver with the share \\server\alfresco to X:\.I start my Excel with a new dokument and I want to save as but I get error-message "The file Book1.xls already exists. Do you want to replace the existing file?" I choose yes and I get a

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 06:21:36 GMT

Anyone?

Re: Cant save dokument through MS Excel 2003.

mikeh — Mon, 01 Oct 2007 08:03:55 GMT

Hi

Have you got any rules on the space you're trying to save to? Excel saves files in a slightly odd way, which maybe causing rules to fire when you don't expect.

Does this happen in all spaces you've got permissions to save to?

Does it happen if you map the drive as the admin user?

Thanks,
Mike

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 08:07:36 GMT

Hi!

I have no rules at all and it doesnÃ‚Â´t matter on which space.
I logged in as admin user.

One other thing, when I save a excel it take about 30 sec to save, even when its a small document.

Re: Cant save dokument through MS Excel 2003.

mikeh — Mon, 01 Oct 2007 08:49:27 GMT

I've just tried the same scenario with a mapped X:\ drive and v2.1 is working as expected.

Are there any messages in the Alfresco log file?

When you access the X:\ drive from Explorer (e.g. Start/Run X:\) is there a prompt for a username, or any sort of delay?

Thanks,
Mike

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 09:00:41 GMT

Hi Mike!

I use v2.1 with mysql and have about 60GB of data.

I have authentication thru NTLM so I donÃ‚Â´t get any prompt for username or password.

No, I donÃ‚Â´t get any direct messages on my log when I try to save the excel file.
Here are my startup-log.

Oct 1, 2007 10:53:52 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1602 ms
Oct 1, 2007 10:53:53 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Oct 1, 2007 10:53:53 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Oct 1, 2007 10:53:53 AM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Oct 1, 2007 10:53:55 AM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@9b86ea)
   LogAbandoned: false
   RemoveAbandoned: true
   RemoveAbandonedTimeout: 30
10:54:46,466 ERROR [transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
   os:         Linux
   command:    convert /opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_3391.gif /opt/Alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_3392.png
   succeeded: false
   exit code: 1
   out:
   err:        java.io.IOException: convert: not found
10:54:52,239 WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
10:55:04,640 INFO [domain.schema.SchemaBootstrap] No changes were made to the schema.
10:55:12,349 INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/Alfresco/alf_data
10:55:14,579 INFO [admin.patch.PatchExecuter] Checking for patches to apply …
10:55:14,977 INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
10:55:15,340 INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_08-b03; maximum heap size 986.125MB
10:55:15,341 INFO [service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 2.1.0 (R1 443) schema 62 - Installed version 2.1.0 (R1 443) schema 62
Oct 1, 2007 10:55:29 AM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Oct 1, 2007 10:55:29 AM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Oct 1, 2007 10:55:30 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 97206 ms

Billy

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 09:01:46 GMT

Btw…
this message I get all the time, I donÃ‚Â´t know if it have to do with it.

10:58:20,341 ERROR [quartz.core.JobRunShell] Job DEFAULT.ftsIndexerJobDetail threw an unhandled Exception:
org.alfresco.service.cmr.repository.ContentIOException: Failed to open stream onto channel:
   accessor: ContentAccessor[ contentUrl=store://2007/10/1/10/58/73106c0c-6ffc-11dc-b34e-61b8ea7e9447.bin, mimetype=null, size=0, encoding=UTF-8, locale=en_US]
        at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:337)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:893)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:547)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1286)
        at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
        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:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy9.index(Unknown Source)
        at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.UnsupportedOperationException: The content never exists
        at org.alfresco.repo.content.EmptyContentReader.getDirectReadableChannel(EmptyContentReader.java:59)
        at org.alfresco.repo.content.AbstractContentReader.getReadableChannel(AbstractContentReader.java:226)
        at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:330)
        … 18 more
10:58:20,349 ERROR [quartz.core.ErrorLogger] Job (DEFAULT.ftsIndexerJobDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.service.cmr.repository.ContentIOException: Failed to open stream onto channel:
   accessor: ContentAccessor[ contentUrl=store://2007/10/1/10/58/73106c0c-6ffc-11dc-b34e-61b8ea7e9447.bin, mimetype=null, size=0, encoding=UTF-8, locale=en_US]]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.alfresco.service.cmr.repository.ContentIOException: Failed to open stream onto channel:
   accessor: ContentAccessor[ contentUrl=store://2007/10/1/10/58/73106c0c-6ffc-11dc-b34e-61b8ea7e9447.bin, mimetype=null, size=0, encoding=UTF-8, locale=en_US]
        at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:337)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.indexProperty(ADMLuceneIndexerImpl.java:893)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.createDocuments(ADMLuceneIndexerImpl.java:547)
        at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerImpl.updateFullTextSearch(ADMLuceneIndexerImpl.java:1286)
        at org.alfresco.repo.search.impl.lucene.fts.FullTextSearchIndexerImpl.index(FullTextSearchIndexerImpl.java:188)
        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:585)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
        at $Proxy9.index(Unknown Source)
        at org.alfresco.repo.search.impl.lucene.fts.FTSIndexerJob.execute(FTSIndexerJob.java:52)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        … 1 more
Caused by: java.lang.UnsupportedOperationException: The content never exists
        at org.alfresco.repo.content.EmptyContentReader.getDirectReadableChannel(EmptyContentReader.java:59)
        at org.alfresco.repo.content.AbstractContentReader.getReadableChannel(AbstractContentReader.java:226)
        at org.alfresco.repo.content.AbstractContentReader.getContentInputStream(AbstractContentReader.java:330)
        … 18 more

Re: Cant save dokument through MS Excel 2003.

mikeh — Mon, 01 Oct 2007 09:43:16 GMT

Those empty files are probably the failed Excel saves.

Are you using 2.1 Community Final? You could try registering for v2.1 Enterprise and seeing if that fixes the problem, or try 2.2dev from the nightly builds. If possible, install these separately from your main server for testing.

Thanks,.
Mike

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 09:47:07 GMT

Mike!

I using Alfresco-Community-2.1R1-Linux-x86-Install, how to I find 2.1 Community Final?

Billy

Re: Cant save dokument through MS Excel 2003.

mikeh — Mon, 01 Oct 2007 10:03:24 GMT

The downloads are linked from the main page of the wiki.

http://wiki.alfresco.com/wiki/Main_Page

Thanks,
Mike

Re: Cant save dokument through MS Excel 2003.

kase — Mon, 01 Oct 2007 10:08:05 GMT

I am confused.
There arenÃ‚Â´t any bundle-version?

Re: Cant save dokument through MS Excel 2003.

kase — Wed, 03 Oct 2007 08:24:43 GMT

Hi Mike!

I downloaded the latest version and it work with Excel now.
Thank you!

regards,
Billy

Re: Cant save dokument through MS Excel 2003.

mikeh — Wed, 03 Oct 2007 09:57:29 GMT

Excellent - thanks for letting us know!

Mike