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.

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

Find more posts tagged with

Comments

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

karakal

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

karakal

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

mikeh

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

karakal

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…

mikeh

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

karakal

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?