• After updating to 5.0 stable file icons are broken

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #7721  by zac
 
Hi,

We had OpenKM 5.0 beta running. When 5.0 stable came out we decided to upgrade. I upgraded to 5.0RC1 following the migration instructions and then updated to 5.0 stable again following the migration instructions to the letter (so from 5.0RC1 to stable I only copied OpenKM.war, run the sql query and clicked reset mime type)

Thank you for your help
Silviu
 #7844  by zac
 
Happy new year! I hope you had a good time :)

Here it is the (relevant I hope) section of the console log:
Code: Select all

# =========================================================================

  JBoss Bootstrap Environment

  JBOSS_HOME: /opt/openkm

  JAVA: java

  JAVA_OPTS: -Dprogram.name=run.sh -Xms256m -Xmx1024m -XX:PermSize=64m -XX:MaxPermSize=128m -Djava.awt.headless=true -Djava.net.preferIPv4Stack=true

  CLASSPATH: /opt/openkm/bin/run.jar

=========================================================================

04:40:39,078 INFO  [Server] Starting JBoss (MX MicroKernel)...
04:40:39,080 INFO  [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181439)
04:40:39,081 INFO  [Server] Home Dir: /opt/openkm
04:40:39,081 INFO  [Server] Home URL: file:/opt/openkm/
04:40:39,082 INFO  [Server] Patch URL: null
04:40:39,082 INFO  [Server] Server Name: default
04:40:39,082 INFO  [Server] Server Home Dir: /opt/openkm/server/default
04:40:39,082 INFO  [Server] Server Home URL: file:/opt/openkm/server/default/
04:40:39,082 INFO  [Server] Server Log Dir: /opt/openkm/server/default/log
04:40:39,083 INFO  [Server] Server Temp Dir: /opt/openkm/server/default/tmp
04:40:39,083 INFO  [Server] Root Deployment Filename: jboss-service.xml
04:40:39,348 INFO  [ServerInfo] Java version: 1.6.0_17,Sun Microsystems Inc.
04:40:39,348 INFO  [ServerInfo] Java VM: OpenJDK 64-Bit Server VM 14.0-b16,Sun Microsystems Inc.
04:40:39,348 INFO  [ServerInfo] OS-System: Linux 2.6.18-92.1.22.el5,amd64
04:40:39,620 INFO  [Server] Core system initialized
04:40:41,429 INFO  [WebService] Using RMI server codebase: http://ZAC1D06WWL.mgmt.local:8083/
04:40:41,431 INFO  [Log4jService$URLWatchTimerTask] Configuring from URL: resource:jboss-log4j.xml
04:40:44,305 INFO  [EJB3Deployer] Starting java:comp multiplexer
04:40:46,292 INFO  [NativeServerConfig] JBoss Web Services - Native
04:40:46,293 INFO  [NativeServerConfig] jbossws-3.0.1-native-2.0.4.GA (build=200803312044)
04:40:46,983 INFO  [Embedded] Catalina naming disabled
04:40:47,114 INFO  [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64/server:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/amd64:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
04:40:47,167 INFO  [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
04:40:47,168 INFO  [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-0.0.0.0-8009
04:40:47,168 INFO  [Catalina] Initialization processed in 184 ms
04:40:47,168 INFO  [StandardService] Starting service jboss.web
04:40:47,169 INFO  [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.1.GA
04:40:47,230 INFO  [Catalina] Server startup in 62 ms
04:40:47,319 INFO  [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jboss-web.deployer/ROOT.war/
04:40:47,897 INFO  [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
04:40:48,018 INFO  [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../deploy/jbossws.sar/jbossws-context.war/
04:40:48,129 INFO  [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
04:40:48,773 INFO  [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
04:40:49,204 INFO  [MailService] Mail Service bound to java:/Mail
04:40:49,205 INFO  [STDOUT] DEBUG: JavaMail version 1.4ea
04:40:49,206 INFO  [STDOUT] DEBUG: java.io.FileNotFoundException: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/javamail.providers (No such file or directory)
04:40:49,208 INFO  [STDOUT] DEBUG: !anyLoaded
04:40:49,208 INFO  [STDOUT] DEBUG: not loading resource: /META-INF/javamail.providers
04:40:49,209 INFO  [STDOUT] DEBUG: successfully loaded resource: /META-INF/javamail.default.providers
04:40:49,209 INFO  [STDOUT] DEBUG: Tables of loaded providers
04:40:49,209 INFO  [STDOUT] DEBUG: Providers Listed By Class Name: {com.sun.mail.smtp.SMTPSSLTransport=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Sun Microsystems, Inc], com.sun.mail.smtp.SMTPTransport=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun Microsystems, Inc], com.sun.mail.imap.IMAPSSLStore=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Sun Microsystems, Inc], com.sun.mail.pop3.POP3SSLStore=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Sun Microsystems, Inc], com.sun.mail.imap.IMAPStore=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc], com.sun.mail.pop3.POP3Store=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun Microsystems, Inc]}
04:40:49,209 INFO  [STDOUT] DEBUG: Providers Listed By Protocol: {imaps=javax.mail.Provider[STORE,imaps,com.sun.mail.imap.IMAPSSLStore,Sun Microsystems, Inc], imap=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc], smtps=javax.mail.Provider[TRANSPORT,smtps,com.sun.mail.smtp.SMTPSSLTransport,Sun Microsystems, Inc], pop3=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun Microsystems, Inc], pop3s=javax.mail.Provider[STORE,pop3s,com.sun.mail.pop3.POP3SSLStore,Sun Microsystems, Inc], smtp=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun Microsystems, Inc]}
04:40:49,210 INFO  [STDOUT] DEBUG: successfully loaded resource: /META-INF/javamail.default.address.map
04:40:49,210 INFO  [STDOUT] DEBUG: !anyLoaded
04:40:49,210 INFO  [STDOUT] DEBUG: not loading resource: /META-INF/javamail.address.map
04:40:49,210 INFO  [STDOUT] DEBUG: java.io.FileNotFoundException: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/jre/lib/javamail.address.map (No such file or directory)
04:40:49,211 INFO  [MailService] Mail Service bound to java:/mail/OpenKM
04:40:49,305 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
04:40:49,363 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
04:40:49,398 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
04:40:49,424 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
04:40:49,501 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
04:40:49,524 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
04:40:49,551 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar
04:40:49,557 INFO  [QuartzResourceAdapter] start quartz!!!
04:40:49,609 INFO  [SimpleThreadPool] Job execution threads will use class loader of thread: main
04:40:49,626 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
04:40:49,629 INFO  [RAMJobStore] RAMJobStore initialized.
04:40:49,629 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
04:40:49,629 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2
04:40:49,630 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
04:40:50,104 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
04:40:50,383 INFO  [A] Bound to JNDI name: queue/A
04:40:50,384 INFO  [B] Bound to JNDI name: queue/B
04:40:50,386 INFO  [C] Bound to JNDI name: queue/C
04:40:50,387 INFO  [D] Bound to JNDI name: queue/D
04:40:50,388 INFO  [ex] Bound to JNDI name: queue/ex
04:40:50,403 INFO  [testTopic] Bound to JNDI name: topic/testTopic
04:40:50,404 INFO  [securedTopic] Bound to JNDI name: topic/securedTopic
04:40:50,406 INFO  [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
04:40:50,408 INFO  [testQueue] Bound to JNDI name: queue/testQueue
04:40:50,440 INFO  [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
04:40:50,469 INFO  [DLQ] Bound to JNDI name: queue/DLQ
04:40:50,576 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
04:40:51,456 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=OpenKMDS' to JNDI name 'java:OpenKMDS'
04:40:54,466 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMNote
04:40:54,468 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMWorkflow
04:40:54,469 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMPropertyGroup
04:40:54,470 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMFolder
04:40:54,471 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMNotification
04:40:54,472 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMProperty
04:40:54,473 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMAuth
04:40:54,474 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMMail
04:40:54,475 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMDocument
04:40:54,476 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMSearch
04:40:54,477 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMTest
04:40:54,478 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMRepository
04:40:54,480 INFO  [DefaultEndpointRegistry] register: jboss.ws:context=OpenKM,endpoint=OKMBookmark
04:40:54,726 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.RepositoryStartupServlet
04:40:54,726 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.WebdavServlet
04:40:54,726 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: org.jbpm.web.ProcessUploadServlet
04:40:54,727 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMWorkspaceServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMDocumentServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMAuthServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMRepositoryServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMFolderServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMPropertyGroupServlet
04:40:54,728 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMDownloadServlet
04:40:54,735 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMDashboardServlet
04:40:54,735 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMGeneralServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMNotifyServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMWorkflowServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMSearchServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMFileUploadServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMBookmarkServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMMailServlet
04:40:54,737 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMThesaurusServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMPropertyServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMChatServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMUserConfigServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.OKMNoteServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.mobi.HandlerServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.SyndicationServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.MimeIconServlet
04:40:54,739 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.TextToSpeechServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.StatsGraphServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.RepositoryBackupServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.RepositoryCheckerServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.WorkflowGraphServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.RegisterWorkflowServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.ReportServlet
04:40:54,741 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.CronTabServlet
04:40:54,743 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.BenchmarkServlet
04:40:54,743 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.LogCatServlet
04:40:54,743 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.RepositoryViewServlet
04:40:54,743 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.DatabaseQueryServlet
04:40:54,743 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.AuthServlet
04:40:54,744 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.PropertyGroupsServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.ActivityLogServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.LoggedUsersServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.MailAccountServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.TwitterAccountServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.WorkflowServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.MimeTypeServlet
04:40:54,745 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.ProfileServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.UserConfigServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.ActiveSessionsServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.RepositorySearchServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.admin.CheckEmailServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.frontend.server.extension.OKMStaplingServlet
04:40:54,747 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.extension.StaplingDownloadServlet
04:40:54,749 INFO  [DefaultWebAppDesciptorModifierImpl] Ignore servlet: com.openkm.servlet.TestServlet
04:40:54,797 INFO  [TomcatDeployer] deploy, ctxPath=/OpenKM, warUrl=.../tmp/deploy/tmp7755277428861806252OpenKM-exp.war/
04:40:55,835 INFO  [RepositoryImpl] Starting repository...
04:40:55,850 INFO  [LocalFileSystem] LocalFileSystem initialized at path /opt/openkm/repository/repository
04:40:56,022 INFO  [LocalFileSystem] LocalFileSystem initialized at path /opt/openkm/repository/version
04:40:58,086 INFO  [ConnectionRecoveryManager] Database: Apache Derby / 10.5.3.0 - (802917)
04:40:58,086 INFO  [ConnectionRecoveryManager] Driver: Apache Derby Embedded JDBC Driver / 10.5.3.0 - (802917)
04:40:58,694 INFO  [RepositoryImpl] initializing workspace 'default'...
04:40:58,694 INFO  [LocalFileSystem] LocalFileSystem initialized at path /opt/openkm/repository/workspaces/default
04:40:58,744 INFO  [ConnectionRecoveryManager] Database: Apache Derby / 10.5.3.0 - (802917)
04:40:58,744 INFO  [ConnectionRecoveryManager] Driver: Apache Derby Embedded JDBC Driver / 10.5.3.0 - (802917)
04:40:59,787 INFO  [SearchIndex] Index initialized: /opt/openkm/repository/repository/index Version: 3
04:40:59,952 INFO  [SearchIndex] Index initialized: /opt/openkm/repository/workspaces/default/index Version: 3
04:40:59,954 INFO  [RepositoryImpl] workspace 'default' initialized
04:40:59,954 INFO  [RepositoryImpl] Repository started
04:40:59,966 INFO  [SimpleSecurityManager] init: using JAAS LoginModule configuration for OpenKM
04:40:59,971 INFO  [RepositoryImpl] SecurityManager = class org.apache.jackrabbit.core.security.simple.SimpleSecurityManager
04:41:04,177 WARN  [JDBCExceptionReporter] SQL Error: -95, SQLState: 22003
04:41:04,177 ERROR [JDBCExceptionReporter] Type Conversion not supported
04:41:04,178 WARN  [Config] could not insert: [com.openkm.dao.bean.MimeType]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.MimeType]
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:64)
        at com.openkm.core.Config.resetMimeTypes(Config.java:733)
        at com.openkm.core.Config.loadMimeTypes(Config.java:685)
        at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:158)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4375)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
        at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
        at org.jboss.web.WebModule.startModule(WebModule.java:83)
        at org.jboss.web.WebModule.startService(WebModule.java:61)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy44.start(Unknown Source)
        at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
        at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
        at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
        at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
        at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy45.start(Unknown Source)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy9.deploy(Unknown Source)
        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy5.deploy(Unknown Source)
        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
        at org.jboss.Main.boot(Main.java:200)
        at org.jboss.Main$1.run(Main.java:508)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.MimeType]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:52)
        ... 141 more
Caused by: java.sql.SQLException: Type Conversion not supported
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setCharacterStream(Unknown Source)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.setCharacterStream(CachedPreparedStatement.java:226)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:745)
        at org.hibernate.type.TextType.set(TextType.java:22)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1974)
        at org.hibernate.persister.entity.AbstractEntityPersister$3.bindValues(AbstractEntityPersister.java:2152)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:32)
        ... 157 more
04:41:04,226 ERROR [STDERR] Jan 5, 2011 4:41:04 AM org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is UnixProcessManager
04:41:04,284 WARN  [RepositoryStartupServlet] failed to start and connect
org.artofsolving.jodconverter.office.OfficeException: failed to start and connect
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:61)
        at org.artofsolving.jodconverter.office.PooledOfficeManager.start(PooledOfficeManager.java:102)
        at org.artofsolving.jodconverter.office.ProcessPoolOfficeManager.start(ProcessPoolOfficeManager.java:59)
        at com.openkm.util.DocConverter.start(DocConverter.java:115)
        at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:212)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4375)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
        at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
        at org.jboss.web.WebModule.startModule(WebModule.java:83)
        at org.jboss.web.WebModule.startService(WebModule.java:61)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy44.start(Unknown Source)
        at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
        at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
        at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
        at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
        at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy45.start(Unknown Source)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy9.deploy(Unknown Source)
        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy5.deploy(Unknown Source)
        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
        at org.jboss.Main.boot(Main.java:200)
        at org.jboss.Main$1.run(Main.java:508)
        at java.lang.Thread.run(Thread.java:636)
Caused by: java.util.concurrent.ExecutionException: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
        at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:252)
        at java.util.concurrent.FutureTask.get(FutureTask.java:111)
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess.startAndWait(ManagedOfficeProcess.java:59)
        ... 142 more
Caused by: org.artofsolving.jodconverter.office.OfficeException: could not establish connection
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:123)
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess.access$000(ManagedOfficeProcess.java:31)
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess$1.run(ManagedOfficeProcess.java:55)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        ... 1 more
Caused by: java.lang.IllegalStateException: a process with acceptString 'socket,host=127.0.0.1,port=2002' is already running; pid 9157
        at org.artofsolving.jodconverter.office.OfficeProcess.start(OfficeProcess.java:59)
        at org.artofsolving.jodconverter.office.ManagedOfficeProcess.doStartProcessAndConnect(ManagedOfficeProcess.java:112)
        ... 8 more
04:41:04,293 WARN  [ExecutionUtils] Unable to read script: /opt/openkm/start.bsh
04:41:04,294 WARN  [ExecutionUtils] Unable to read jar: /opt/openkm/start.jar
04:41:04,325 INFO  [SimpleWebdavServlet] resource-path-prefix = '/repository'
04:41:04,326 INFO  [SimpleWebdavServlet] WWW-Authenticate header = 'Basic realm="OpenKM Webdav Server"'
04:41:10,787 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMNoteService3165061913169462468.wsdl
04:41:10,807 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMWorkflowService4356614093488704232.wsdl
04:41:10,838 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMPropertyGroupService7658375647447854793.wsdl
04:41:10,848 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMFolderService3843548243684693557.wsdl
04:41:10,852 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMNotificationService2463998027969468965.wsdl
04:41:10,857 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMPropertyService2420828062133772869.wsdl
04:41:10,863 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMAuthService7519445682372617188.wsdl
04:41:10,870 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMMailService356779475629701916.wsdl
04:41:10,884 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMDocumentService186848132607839609.wsdl
04:41:10,892 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMSearchService297446914267578821.wsdl
04:41:10,895 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMTestService3237080423456911190.wsdl
04:41:10,900 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMRepositoryService6077166162827394127.wsdl
04:41:10,903 INFO  [WSDLFilePublisher] WSDL published to: file:/opt/openkm/server/default/data/wsdl/OpenKM.war/OKMBookmarkService5492055771857175032.wsdl
04:41:11,412 INFO  [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
04:41:11,670 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
04:41:11,702 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-0.0.0.0-8009
04:41:11,788 INFO  [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181439)] Started in 32s:703ms
04:42:04,551 INFO  [DocNumberCache] size=28/1024, #accesses=1001, #hits=919, #misses=82, cacheRatio=92%
04:42:07,327 INFO  [LRUNodeIdCache] num=0/10240 hits=0 miss=10000
04:42:07,327 INFO  [BundleCache] num=1495 mem=8188k max=8192k avg=5608 hits=6665 miss=3335
04:42:09,178 INFO  [LRUNodeIdCache] num=0/10240 hits=0 miss=20000
04:42:09,179 INFO  [BundleCache] num=1494 mem=8187k max=8192k avg=5611 hits=13332 miss=6668


 #7935  by jllort
 
Yes, there's something missing in migration guide ( we'll update ). Go to administration tab, at mime type section, and execute the "reset" option at top right, that will re-generate all mime type with their images.

Sorry for the inconvenience.
 #7939  by zac
 
Hi,

Thank you for the reply. Unfortunately doing this was written in the migration guide and I did it at the time. I have tried it again now but nothing new happens. The problem persists.

Anything else I should try?

Thank you.
 #7948  by jllort
 
It's really strange.

1- Put
Code: Select all
hibernate.hbm2ddl=update 
2- Stop jboss

3- Ensure you've executed it
Code: Select all
ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE;
4- Start jboss

5- Login and go to admin tab, execute reset

Which database are you using ?
 #7958  by zac
 
Hi,

As written above I'm using the built in java:/OpenKMDS .

I don't know how I could run an sql query with openkm stopped (is there a way?)

What I did was:

STOP openkm

Set hibernate.hbm2ddl=update

Went to admin and ran the sql query in the window and got:

Application error
Class: org.hibernate.QueryException
Message: unexpected char: ';' [ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE;]
Date: Thu Jan 13 01:06:45 PST 2011

if I remove the ; char I get

Application error
Class: java.lang.IllegalArgumentException
Message: node to traverse cannot be null!
Date: Thu Jan 13 01:07:18 PST 2011


Clicked reset (at mimetimes) anyway.

Shut down openkm

Set hibernate.hbm2ddl=none

Started openkm

Same problem!

This part of the start log seems relevant:
Code: Select all
01:09:04,708 WARN  [JDBCExceptionReporter] SQL Error: -95, SQLState: 22003
01:09:04,708 ERROR [JDBCExceptionReporter] Type Conversion not supported
01:09:04,709 WARN  [Config] could not insert: [com.openkm.dao.bean.MimeType]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.MimeType]
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:64)
        at com.openkm.core.Config.resetMimeTypes(Config.java:733)
        at com.openkm.core.Config.loadMimeTypes(Config.java:685)
        at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:158)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4071)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4375)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
        at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
        at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
        at org.jboss.web.WebModule.startModule(WebModule.java:83)
        at org.jboss.web.WebModule.startService(WebModule.java:61)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy44.start(Unknown Source)
        at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
        at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
        at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
        at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
        at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy45.start(Unknown Source)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy9.deploy(Unknown Source)
        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
        at $Proxy0.start(Unknown Source)
        at org.jboss.system.ServiceController.start(ServiceController.java:417)
        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy4.start(Unknown Source)
        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)
        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
        at $Proxy5.deploy(Unknown Source)
        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
        at org.jboss.Main.boot(Main.java:200)
        at org.jboss.Main$1.run(Main.java:508)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.MimeType]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:52)
        ... 141 more
Caused by: java.sql.SQLException: Type Conversion not supported
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setCharacterStream(Unknown Source)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.setCharacterStream(CachedPreparedStatement.java:226)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:745)
        at org.hibernate.type.TextType.set(TextType.java:22)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1974)
        at org.hibernate.persister.entity.AbstractEntityPersister$3.bindValues(AbstractEntityPersister.java:2152)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:32)
        ... 157 more
01:09:04,762 ERROR [STDERR] Jan 13, 2011 1:09:04 AM org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is UnixProcessManager
01:09:04,825 ERROR [STDERR] Jan 13, 2011 1:09:04 AM org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir '/tmp/.jodconverter_socket_host-127.0.0.1_port-2002'
 #9001  by zac
 
You're kidding right? :)

As answered above two times now I'm using the built in database. No special configuration, just the default package.

Also as a side note I've updated to 5.0.2 and the problem persists. I have also tried doing a mime type reset after upgrading to 5.0.2 still of no use.

Thank you
 #9003  by jllort
 
The problem seems you've not executed successfully
Code: Select all
 ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE;
Use some dbms client as datastudio to connecting hypersonic database ( jboss must be stopped and dms is on server/default/data/hypersonic )

Other way for doing with jboss started here http://wiki.openkm.com/index.php/Browsi ... d_database
 #9007  by zac
 
I was under the impression that this query must be ran inside the Database Query window in the administration tab.

I've ran in there now again and I get:
Class: java.sql.SQLException
Message: Column not found: MT_ACTIVE in statement [ALTER TABLE OKM_MIME_TYPE DROP COLUMN MT_ACTIVE]
Date: Mon Feb 21 02:49:48 PST 2011
If I do
Code: Select all
SELECT * FROM OKM_MIME_TYPE;
I can see the empty table:

MT_ID MT_NAME MT_IMAGE_CONTENT MT_IMAGE_MIME


I've tried getting the database management window to appear like described in the link but I can't get it to show.
Best regards,
Silviu Vulcan
 #9020  by jllort
 
OK, The table columns are right. Now go to administrator tab / mime types and execute the reset option.

If some error happens on doing it, it'll be showed in server.log, post it here.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.