topic Re: Problem with Office Integration in Alfresco Archive

Problem with Office Integration

karakal — Fri, 06 Jul 2007 13:19:02 GMT

I replaced some names and ids in the following text with <>….I have a problem with the Word Plugin for Office Integration.Install worked perfect and the plugin actived itself after starting Word.I put my path-Variables in the fields:Webclient: http://<servername>:8080/alfresco/WebDAV: ht

Re: Problem with Office Integration

mikeh — Fri, 06 Jul 2007 13:36:50 GMT

Hi,

Regarding the first error - does the document open correctly from the web client?

re: And if I open some document from the CIFS-Share, the Plugin says: This document is not managed by Alfresco…

Could you double-check the CIFS config URL? Has "servername" been entered as "servername_a"?

Thanks,
Mike

Re: Problem with Office Integration

karakal — Fri, 06 Jul 2007 13:48:10 GMT

Hi,

Regarding the first error - does the document open correctly from the web client?

re: And if I open some document from the CIFS-Share, the Plugin says: This document is not managed by Alfresco…

Could you double-check the CIFS config URL? Has "servername" been entered as "servername_a"?

Thanks,
Mike

Yes. The document opens correctly in the Webclient and WebDAV (using Firefox with the same URLs) and it opens correctly from the CIFS-Share using Windows Explorer…

The server is accessible with \\<servername> and \\<servername>_a
I have tried both urls…

But I came across another error… In the alfresco_log there appears an error, at the same time I click on the search result:

14:49:08,413 ERROR [org.alfresco.repo.avm.OrphanReaper] Garbage collector error
org.hibernate.exception.SQLGrammarException: could not execute query
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2214)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at org.alfresco.repo.avm.hibernate.AVMNodeDAOHibernate.getOrphans(AVMNodeDAOHibernate.java:143)
        at org.alfresco.repo.avm.OrphanReaper$1TxnWork.doWork(OrphanReaper.java:252)
        at org.alfresco.repo.transaction.TransactionUtil.executeInTransaction(TransactionUtil.java:189)
        at org.alfresco.repo.transaction.TransactionUtil.executeInUserTransaction(TransactionUtil.java:89)
        at org.alfresco.repo.avm.OrphanReaper.doBatch(OrphanReaper.java:344)
        at org.alfresco.repo.avm.OrphanReaper.execute(OrphanReaper.java:57)
        at org.alfresco.repo.avm.OrphanReaperJob.execute(OrphanReaperJob.java:44)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select childentry1_.child_id from avm_child_entries childentry1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
        at org.hibernate.loader.Loader.doQuery(Loader.java:662)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        … 16 more

Which version of mysql has to be used for Alfresco???

Re: Problem with Office Integration

mikeh — Fri, 06 Jul 2007 13:58:49 GMT

Which version of mysql has to be used for Alfresco???

We'd recommend v5+ - I notice the current version is 5.0.41

Could you post the exact three URLs in the config panel please? PM them to me if you don't want them made public.

Thanks,
Mike

Re: Problem with Office Integration

karakal — Fri, 06 Jul 2007 14:03:08 GMT

Which version of mysql has to be used for Alfresco???
We'd recommend v5+ - I notice the current version is 5.0.41

Could you post the exact three URLs in the config panel please? PM them to me if you don't want them made public.

Thanks,
Mike

I've pmed you the exact three URLs…

And I've upgraded to 5.0.32-Debian_7etch1-log…

You should define somewhere (I haven't found it yet) that you can't use Alfresco with MySQL 4x (because of the error I posted and another error: You can't delete Spaces)

Re: Problem with Office Integration

mikeh — Fri, 06 Jul 2007 14:40:56 GMT

Hi,

Thanks for the PM.

As I had half expected, you've found a bug. Could you change your CIFS config to all lower-case, i.e. change the uppercase "A" of "Alfresco" and try again please? There's a case-sensitive compare happening where there shouldn't be one.

Take your point about MySQL version - I'll pass it onto the QA department to make a decision on.

Thanks,
Mike

Re: Problem with Office Integration

karakal — Fri, 06 Jul 2007 14:48:08 GMT

Hi,

Thanks for the PM.

As I had half expected, you've found a bug. Could you change your CIFS config to all lower-case, i.e. change the uppercase "A" of "Alfresco" and try again please? There's a case-sensitive compare happening where there shouldn't be one.

Take your point about MySQL version - I'll pass it onto the QA department to make a decision on.

Thanks,
Mike

Nice… 😉 I am working for QA in my company and I am supposed to find bugs 😉

So… I've changed everything to Lowercase… but the problem persists…

sorry… 😞

Re: Problem with Office Integration

mikeh — Fri, 06 Jul 2007 15:15:14 GMT

Can I just check which problem we're on at the moment…

The case-sensitivity change should fix the plug-in stating "This document is not managed by Alfresco" if you open the document via CIFS directly into Word.

WebDAV won't work correctly with Firefox, because it first downloads the document into it's local file cache and then launches Word using that path. It's not "true" WebDAV integration, it's more like downloading from the web client; you have to use MSIE or webdav directly from within Word.

I'm concerned by the AVM database exception however - where exactly is the document you're trying to open stored?

Thanks,
Mike

Re: Problem with Office Integration

steve — Fri, 06 Jul 2007 15:24:06 GMT

Hi,

MySQL 4 should be fine - I have 4.1.12a on my local machine.
However, we would recommend the latest versions of software to help guarantee you are getting the best out of the whole Alfresco stack (apart from where we specifically state).

If the CIFS share needs to be changed to lowercase to work then this is a bug.

Steve
Alfresco QA Manager

(BTW, nice to see another another QA engineer in the forums)

Re: Problem with Office Integration

steve — Fri, 06 Jul 2007 15:27:27 GMT

Hi,

Just to add that our recommendations, and stacks that we support for Enterprise can be found on our website here: http://www.alfresco.com/services/support/stacks/

Steve

Re: Problem with Office Integration

karakal — Mon, 09 Jul 2007 07:01:14 GMT

Can I just check which problem we're on at the moment…

The case-sensitivity change should fix the plug-in stating "This document is not managed by Alfresco" if you open the document via CIFS directly into Word.

WebDAV won't work correctly with Firefox, because it first downloads the document into it's local file cache and then launches Word using that path. It's not "true" WebDAV integration, it's more like downloading from the web client; you have to use MSIE or webdav directly from within Word.

I'm concerned by the AVM database exception however - where exactly is the document you're trying to open stored?

Thanks,
Mike

I changed everything to lowercase, but the same error message appear instead of the content of the file. I get the correct filename of my document, but no content. And if I open a file directly from the CIFS-Share, the message "The current document is not managed by Alfresco" is displayed in the Plugin.
I downloaded Alfresco 2.1 and the Plugin on Thursday and installed them on a new machine… What could I have done wrong in the installation?

The AVM-database exception was displayed only in MySQL 4.0.something and 4.1.something. Since I migrated to MySQL 5, no exception is thrown anymore. But what do you mean, with "Where ist the document stored??"

Re: Problem with Office Integration

karakal — Mon, 09 Jul 2007 07:02:54 GMT

Hi,

Just to add that our recommendations, and stacks that we support for Enterprise can be found on our website here: http://www.alfresco.com/services/support/stacks/

Steve

Sorry, I didn't look under "stacks"…
I expected the recommended systemconfiguration and versions of software within the product-topic or anywhere in the wiki or in the release-versions… I didn't expect them within the services-topic… 😉

Re: Problem with Office Integration

mikeh — Mon, 09 Jul 2007 07:53:11 GMT

But what do you mean, with "Where ist the document stored??"

I mean the relative path within Alfresco, e.g. "/Company Home/User Homes/karakal/My Documents/…" etc.

Essentailly the Add-In does a path match between the CIFS path you configured and the beginning of the CIFS path of the current document. Once it determines you've (a) loaded the file via CIFS and (b) it's a CIFS share it knows about, it passes the relative path to the Web Scripts to display the UI.

Mike

Re: Problem with Office Integration

karakal — Mon, 09 Jul 2007 08:06:29 GMT

But what do you mean, with "Where ist the document stored??"
I mean the relative path within Alfresco, e.g. "/Company Home/User Homes/karakal/My Documents/…" etc.

Essentailly the Add-In does a path match between the CIFS path you configured and the beginning of the CIFS path of the current document. Once it determines you've (a) loaded the file via CIFS and (b) it's a CIFS share it knows about, it passes the relative path to the Web Scripts to display the UI.

Mike

I've sent the path via pm… but in it are mixed lower/upper case and spaces…

Re: Problem with Office Integration

mikeh — Mon, 09 Jul 2007 16:29:50 GMT

Hi,

Thanks for your help with tracking down these problems. We found a couple of UTF-8 related issues within the web client and also the Word Add-In itself (as well as an annoying bug in the Web Browser control!)

If you are compiling yourself, you can get the latest HEAD from SVN, or wait for a nightly build to get these updates.

Thanks,
Mike

Re: Problem with Office Integration

karakal — Mon, 09 Jul 2007 17:02:21 GMT

Hi,

Thanks for your help with tracking down these problems. We found a couple of UTF-8 related issues within the web client and also the Word Add-In itself (as well as an annoying bug in the Web Browser control!)

If you are compiling yourself, you can get the latest HEAD from SVN, or wait for a nightly build to get these updates.

Thanks,
Mike

Thx. No, I don't compile myself. I have to replace the WebClient (IMHO the whole Alfresco-Installation???) and the Word Add-In?