• Problems with 5.1.3

  • 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.
 #10951  by gvillaran
 
hi, i erased 5.0.4 and installed OpenKm 5.1.3 and i have some problems that i didnt have with 5.0.4 :

1. You cant login to the system if i dont have admin role.
2. You cant Preview files anymore, it always show "Preview unavailable"
3. You cant assign permissions by group only by user (Groups dont show in the security window)

i tried to post the entire config but i couldnt cause something saying that my post looked as spam, so i tried attaching the config as a txt
or doc and wont let me either, what kind of file i can attach?

i run OpenKm with Ubuntu 10.02 64bits.

* BTW everything was fine in 5.0.4, the only thing i found in this version is that the preview sometimes cant show certain files, but thats it.
 #10961  by pavila
 
The OpenKM 5.0.4 to 5.1.3 transition can't be performed only replacing the WAR. Have you downloaded the JBoss + OpenKM bundle? Note also that OpenKM.cfg only is user for basic database configuration. The configuration now is manager from the administration tab.

Note: Try to attach a zip archive.
 #11011  by joako
 
I had a similar issue, like the pdf2swf path was hardcoded.

So I saw the error, and created a symlink of where OpenKM thinks pdf2swf is to where it actually is.

But another issue I have is the scrolling in the PDF previews doesn't work. If you scroll the preview goes blank.
 #11024  by jllort
 
about scroll preview ... which browser version are you using ?
 #11032  by joako
 
Firefox 4.

Also for the preview, it seems the first used value from OpenKM.cfg is imported into the database? Because under administration I see this configurable.
 #11058  by pavila
 
Some configuration values get the default values from OpenKM.cfg but once the database is created, the only can be modified from administration.
 #11064  by kizs
 
I did a fresh install of 5.1.3 on Oracle 11g and i can't login because got this error message: "java.lang.ClassCastException: javax.jcr.RepositoryException cannot be cast to javax.jcr.LoginException".

Got this error when I try okmAdmin/admin, with wrong username or password I got normally "Authentication error".

log file:
Code: Select all
org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: deadbeef-face-babe-cafe-babecafebabe
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:588)
        at org.apache.jackrabbit.core.version.VersionManagerImpl.<init>(VersionManagerImpl.java:153)
        at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:469)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:319)
        at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:627)
        at com.openkm.module.direct.DirectRepositoryModule.getRepository(DirectRepositoryModule.java:112)
        at com.openkm.util.JCRUtils$1.run(JCRUtils.java:342)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:337)
        at com.openkm.util.JCRUtils.getSession(JCRUtils.java:337)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:65)
        at com.openkm.api.OKMAuth.login(OKMAuth.java:52)
        at org.apache.jsp.frontend.index_jsp._jspService(index_jsp.java:59)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:336)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
        at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.jackrabbit.core.state.ItemStateException: failed to write bundle: deadbeef-face-babe-cafe-babecafebabe
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1251)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:711)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.storeInternal(AbstractBundlePersistenceManager.java:651)
        at org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:515)
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:568)
        ... 37 more
Caused by: java.lang.IllegalStateException: Unable to insert index for string: versionStorage
        at org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:63)
        at org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex.stringToIndex(DbNameIndex.java:98)
        at org.apache.jackrabbit.core.persistence.bundle.util.BundleBinding.writeBundle(BundleBinding.java:270)
        at org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:1242)
        ... 41 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: Az üres (NULL) ide nem szúrható be: ("OPENKM"."VERSION_NAMES"."ID")

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:371)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmtInternal(ConnectionRecoveryManager.java:298)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:261)
        at org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager.executeStmt(ConnectionRecoveryManager.java:239)
        at org.apache.jackrabbit.core.persistence.bundle.util.NGKDbNameIndex.insertString(NGKDbNameIndex.java:61)
        ... 44 more
 #11070  by pavila
 
There was an error in initial repository creation. Stop JBoss, clean database, delete $JBOSS_HOME/repository folder and start JBoss again.
 #11073  by kizs
 
pavila wrote:There was an error in initial repository creation. Stop JBoss, clean database, delete $JBOSS_HOME/repository folder and start JBoss again.
Ok, working, but found these errors in server.log:
Code: Select all
2011-05-20 10:52:28,223 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution at line 1823
	at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:332)
	at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:264)
	at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:353)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1341)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:77)
	at com.openkm.dao.HibernateUtil.getSessionFactory(HibernateUtil.java:62)
	at com.openkm.dao.ConfigDAO.getProperty(ConfigDAO.java:150)
	at com.openkm.dao.ConfigDAO.getBoolean(ConfigDAO.java:193)
	at com.openkm.core.Config.reload(Config.java:567)
	at com.openkm.core.Config.load(Config.java:553)
	at com.openkm.servlet.RepositoryStartupServlet.init(RepositoryStartupServlet.java:86)
        ...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "NOW": érvénytelen azonosító

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
Code: Select all
2011-05-20 11:01:33,676 WARN  [org.apache.jackrabbit.core.query.lucene.JackrabbitTextExtractor] Extractor class not found: com.openkm.extractor.TiffTextExtractor
java.lang.ClassNotFoundException: com.openkm.extractor.TiffTextExtractor
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
	at java.lang.Class.forName0(Native Method)
        ...
Code: Select all
2011-05-20 11:01:33,686 WARN  [org.apache.jackrabbit.core.query.lucene.SearchIndex] Exception initializing indexing configuration from: /opt/OpenKM/repository/workspaces/default/../../../indexing_configuration.xml
org.apache.jackrabbit.spi.commons.conversion.IllegalNameException: Internal error.: Unknown namespace URI: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0: Unknown namespace URI: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0: Namespace not registered: http://www.openkm.org/1.0
	at org.apache.jackrabbit.core.query.lucene.AbstractNamespaceMappings.translateName(AbstractNamespaceMappings.java:55)
	at org.apache.jackrabbit.core.query.lucene.IndexingConfigurationImpl.init(IndexingConfigurationImpl.java:165)
	at org.apache.jackrabbit.core.query.lucene.SearchIndex.createIndexingConfiguration(SearchIndex.java:1067)
	at org.apache.jackrabbit.core.query.lucene.SearchIndex.doInit(SearchIndex.java:499)
	at org.apache.jackrabbit.core.query.AbstractQueryHandler.init(AbstractQueryHandler.java:66)
        ...
Last edited by kizs on Fri May 20, 2011 9:08 am, edited 1 time in total.
 #11080  by joako
 
pavila wrote:Some configuration values get the default values from OpenKM.cfg but once the database is created, the only can be modified from administration.

This I never know. It explains some issues. Maybe in the next release in OpenKM.cfg you can put a comment that notes that?
 #11092  by jllort
 
The relevant error is, don't worry for others.
Code: Select all
2011-05-20 10:52:28,223 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] schema export unsuccessful
org.hibernate.JDBCException: Error during import script execution at line 1823
   at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:332)
   at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:264)
Here indicates de import.sql has not been executed totally. You might take a look where has been stopped. Into OpenKM.war /WEB-INF/import.sql
 #11106  by gvillaran
 
Ok i confifured the preview thing in the web admin page and is working now, now how can i check this other two:

1. You cant login to the system if i dont have admin role.
2. You cant assign permissions by group only by user (Groups dont show in the security window)

i have no errors starting the program i saw some warnings but no errors.

the file i downloaded is the one that downloads with the link that is in the first page, is called OpenKM-5.1.3_JBoss-4.2.3.GA

im dowloading the 5.1.4 and will do a fresh install to see if the same happens

Thanks for the help
 #11112  by gvillaran
 
5.1.4 is working pretty good, no problems even with groups, 5.1.3 have some issues it seems.
 #11144  by jllort
 
hi gvillaran all users need have AdminRole or UserRole ( that are used as connection grants ). UserRole must not be propagated to repository because all users have it, the idea is that a user haver UserRole and other roles, these are really propagated but not UserRole

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.