AnsweredAssumed Answered

Save files back from Office 2010

Question asked by mb1811 on Feb 12, 2015
Hi Folks!

Just made my way setting up Alfresco on Debian 7 [Current version: 5.0.0 (c r91299-b145) schema 8.009] with AD Support and finally got the file preview for Office 2010 files running.

Now I try to open a file to edit from Alfresco. Word / Excel pops up and I can edit my file. By trying to safe that file back I enter http://201.12.111.111:7070/alfresco - I enter my credits - and I get an HTTP ERROR 500 (see attached file).

This is what I found in alfresco.log

14:12:30,215 ERROR [org.mortbay.log] [687171519@qtp-2048132524-6] /alfresco/_vti_bin/owssvr.dll
java.lang.NullPointerException
        at java.io.Reader.<init>(Unknown Source)
        at java.io.InputStreamReader.<init>(Unknown Source)
        at org.alfresco.module.vti.web.fp.FileOpenDialog.doExecute(FileOpenDialog.java:126)
        at org.alfresco.module.vti.web.fp.AbstractMethod.execute(AbstractMethod.java:85)
        at org.alfresco.module.vti.web.actions.VtiBinAction.processVtiMethod(VtiBinAction.java:128)
        at org.alfresco.module.vti.web.actions.VtiBinAction.doGet(VtiBinAction.java:78)
        at org.alfresco.module.vti.web.actions.VtiBaseAction.doGet(VtiBaseAction.java:73)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
        at org.alfresco.module.vti.web.actions.VtiBaseAction.execute(VtiBaseAction.java:230)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.executeAction(VtiRequestDispatcher.java:257)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.doActions(VtiRequestDispatcher.java:230)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.service(VtiRequestDispatcher.java:148)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
        at org.alfresco.module.vti.web.VtiFilter.doFilter(VtiFilter.java:188)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)



I got no idea where to start.
Do I have to setup my  alfresco-global.properties?


dir.root=/opt/alfresco-5.0.c/alf_data

alfresco.context=alfresco
alfresco.host=201.12.111.111
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=201.12.111.111
share.port=8080
share.protocol=http

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=XXXXXXX
db.name=alfresco
db.url=jdbc:postgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=TEST

### FTP Server Configuration ###
ftp.port=21

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=/opt/alfresco-5.0.c/libreoffice/program/soffice
#ooo.exe=/usr/lib/libreoffice/program/soffice
ooo.enabled=true
ooo.port=8100
img.root=/opt/alfresco-5.0.c/common
img.dyn=${img.root}/lib
#img.exe=${img.root}/bin/convert
img.exe=/usr/bin/convert

swf.exe=/opt/alfresco-5.0.c/common/bin/pdf2swf
swf.languagedir=/opt/alfresco-5.0.c/common/japanese

jodconverter.enabled=false
jodconverter.officeHome=/opt/alfresco-5.0.c/libreoffice
#jodconverter.officeHome=/usr/lib/libreoffice
jodconverter.portNumbers=8100

### Initial admin password ###
alfresco_user_store.adminpassword=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

### E-mail site invitation setting ###
notification.email.siteinvite=false

### License location ###
dir.license.external=/opt/alfresco-5.0.c

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443

### BPM Engine ###
system.workflow.engine.jbpm.enabled=false

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Mail Config ###
mail.host=192.168.1.100
mail.port=25
#mail.username=administrator
#mail.password=
mail.encoding=UTF-8
mail.from.default=administrator@mydomain.local
mail.smtp.auth=false


### Authentication ###
authentication.chain=passthru1:passthru,ldap-ad1:ldap-ad

### Passthru Config ###
passthru.authentication.useLocalServer=false
passthru.authentication.domain=
passthru.authentication.servers=DOMAIN\\dmc1.mydomain.local,DOMAIN\\dmc2.mydomain.local
passthru.authentication.guestAccess=false
passthru.authentication.defaultAdministratorUserNames=Administrator,admin
#Timeout value when opening a session to an authentication server, in milliseconds
passthru.authentication.connectTimeout=5000
#Offline server check interval in seconds
passthru.authentication.offlineCheckInterval=300
passthru.authentication.protocolOrder=NetBIOS,TCPIP
passthru.authentication.authenticateCIFS=true
passthru.authentication.authenticateFTP=true

ntlm.authentication.sso.enabled=false
ntlm.authentication.mapUnknownUserToGuest=false

### LDAP-AD Auth ###
ldap.authentication.active=false
ldap.authentication.allowGuestLogin=false
ldap.authentication.userNameFormat=%s
#ldap.authentication.userNameFormat=%s@domain
#ldap.authentication.userNameFormat=
ldap.authentication.java.naming.factory.initial=com.sun.jndi.ldap.LdapCtxFactory
ldap.authentication.java.naming.provider.url=ldap://201.12.222.222:3268
ldap.authentication.java.naming.security.authentication=simple
ldap.authentication.escapeCommasInBind=false
ldap.authentication.escapeCommasInUid=false
ldap.authentication.defaultAdministratorUserNames=Administrator,admin

### LDAP-AD Sync ###
ldap.synchronization.active=true
ldap.synchronization.java.naming.security.authentication=simple
ldap.synchronization.java.naming.security.principal=user@mydomain.local
ldap.synchronization.java.naming.security.credentials=XXXXXX
ldap.synchronization.queryBatchSize=1000
ldap.synchronization.attributeBatchSize=1000
ldap.synchronization.groupQuery=(objectclass\=group)
ldap.synchronization.groupDifferentialQuery=(&(objectclass\=group)(!(modifyTimestamp<\={0})))
ldap.synchronization.personQuery=(&(objectclass\=user)(userAccountControl\:1.2.840.113556.1.4.803\:\=512))
ldap.synchronization.personDifferentialQuery=(&(objectclass\=user)(userAccountControl\:1.2.840.113556.1.4.803\:\=512)(!(modifyTimestamp<\={0})))

ldap.synchronization.groupSearchBase=ou\=Security Gruppen,ou\=company,dc\=mydomain,dc\=LOCAL
ldap.synchronization.userSearchBase=ou\=Benutzer,ou\=company,dc\=mydomain,dc\=LOCAL

ldap.synchronization.modifyTimestampAttributeName=modifyTimestamp
ldap.synchronization.timestampFormat=yyyyMMddHHmmss'.0Z'
ldap.synchronization.userIdAttributeName=sAMAccountName
ldap.synchronization.userFirstNameAttributeName=givenName
ldap.synchronization.userLastNameAttributeName=sn
ldap.synchronization.userEmailAttributeName=mail
ldap.synchronization.userOrganizationalIdAttributeName=company
ldap.synchronization.defaultHomeFolderProvider=largeHomeFolderProvider
ldap.synchronization.groupIdAttributeName=cn
ldap.synchronization.groupDisplayNameAttributeName=displayName
ldap.synchronization.groupType=nogroup
ldap.synchronization.personType=user
ldap.synchronization.groupMemberAttributeName=member
ldap.synchronization.enableProgressEstimation=true

### Konverter ###
content.transformer.OpenOffice.extensions.docx.pdf.maxSourceSizeKBytes=102400
content.transformer.OpenOffice.extensions.doc.pdf.maxSourceSizeKBytes=102400

# Transforms to PDF
# =================
content.transformer.OpenOffice.mimeTypeLimits.txt.pdf.maxSourceSizeKBytes=5120
content.transformer.OpenOffice.mimeTypeLimits.doc.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.mimeTypeLimits.docx.pdf.maxSourceSizeKBytes=768
content.transformer.OpenOffice.mimeTypeLimits.docm.pdf.maxSourceSizeKBytes=768
content.transformer.OpenOffice.mimeTypeLimits.dotx.pdf.maxSourceSizeKBytes=768
content.transformer.OpenOffice.mimeTypeLimits.dotm.pdf.maxSourceSizeKBytes=768
content.transformer.OpenOffice.mimeTypeLimits.ppt.pdf.maxSourceSizeKBytes=6144
content.transformer.OpenOffice.mimeTypeLimits.pptx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.pptm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppsx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppsm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.potx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.potm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.ppam.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.sldx.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.sldm.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.vsd.pdf.maxSourceSizeKBytes=4096
content.transformer.OpenOffice.mimeTypeLimits.xls.pdf.maxSourceSizeKBytes=10240
content.transformer.OpenOffice.mimeTypeLimits.xlsx.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xltx.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlsm.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xltm.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlam.pdf.maxSourceSizeKBytes=1536
content.transformer.OpenOffice.mimeTypeLimits.xlsb.pdf.maxSourceSizeKBytes=1536



Hope someone can give me some hints?

Outcomes