Problem with Office Integration

[karakal]

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: http://<servername>:8080/alfresco/webdav
CIFS: \\<servername>\Alfresco\

The plugin itself is working allright (searching, checkin/checkout,…). But when I try to open a Document (e.g. after searching in the search-panel) I get the following error written in the document:
The node's content is missing:
   node: workspace://SpacesStore/<some id>
   reader: null 
   Please contact your system administrator.

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

The server-URLs are correct and each of them is working…

What am I doing wrong??

[mikeh]

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

[karakal]

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???

[mikeh]

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

[karakal]

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)

[mikeh]

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

[karakal]

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… 😞

[mikeh]

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

[steve]

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)

[steve]

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