Open Source Document Management System | OpenKM

Using OpenKM 6.2.2 , on a Redhat Linux server and Oracle 10g DB

I did the configuration. And program generated the tables automatically.


Getting these errors:

OKM-013024 (getLastWeekTopDownloadedDocuments):Database Error

could not execute query using iterate


OKM-013024 (getLastMonthTopDownloadedDocuments):Database Error

could not execute query using iterate


OKM-013024 (getLastWeekTopModifiedDocuments):Database Error

could not execute query using iterate


OKM-013024 (getLastMonthTopModifiedDocuments):Database Error

could not execute query using iterate

OKM-013024 (getLastModifiedDocuments):Database Error

could not execute query using iterate

OKM-013024 (callBackgetLastUploadedDocuments):Database Error

could not execute query using iterate


These are the tables created. Is there any missing tables ?

JBPM_ACTION
JBPM_BYTEARRAY
JBPM_BYTEBLOCK
JBPM_COMMENT
JBPM_DECISIONCONDITIONS
JBPM_DELEGATION
JBPM_EVENT
JBPM_EXCEPTIONHANDLER
JBPM_JOB
JBPM_LOG
JBPM_MODULEDEFINITION
JBPM_MODULEINSTANCE
JBPM_NODE
JBPM_POOLEDACTOR
JBPM_PROCESSDEFINITION
JBPM_PROCESSINSTANCE
JBPM_RUNTIMEACTION
JBPM_SWIMLANE
JBPM_SWIMLANEINSTANCE
JBPM_TASK
JBPM_TASKACTORPOOL
JBPM_TASKCONTROLLER
JBPM_TASKINSTANCE
JBPM_TOKEN
JBPM_TOKENVARIABLEMAP
JBPM_TRANSITION
JBPM_VARIABLEACCESS
JBPM_VARIABLEINSTANCE
OKM_ACTIVITY
OKM_AUTO_ACTION
OKM_AUTO_ACTION_PARAMS
OKM_AUTO_METADATA
OKM_AUTO_RULE
OKM_AUTO_VALIDATION
OKM_AUTO_VALIDATION_PARAMS
OKM_BOOKMARK
OKM_CONFIG
OKM_CRON_TAB
OKM_CSS
OKM_DASHBOARD
OKM_DB_METADATA_SEQUENCE
OKM_DB_METADATA_TYPE
OKM_DB_METADATA_VALUE
OKM_EXTENSION
OKM_LANGUAGE
OKM_MAIL_ACCOUNT
OKM_MAIL_FILTER
OKM_MAIL_FILTER_RULE
OKM_MIME_TYPE
OKM_MIME_TYPE_EXTENSION
OKM_NODE_BASE
OKM_NODE_CATEGORY
OKM_NODE_DOCUMENT
OKM_NODE_DOCUMENT_VERSION
OKM_NODE_FOLDER
OKM_NODE_KEYWORD
OKM_NODE_MAIL
OKM_NODE_MAIL_BCC
OKM_NODE_MAIL_CC
OKM_NODE_MAIL_REPLY
OKM_NODE_MAIL_TO
OKM_NODE_NOTE
OKM_NODE_PROPERTY
OKM_NODE_ROLE_PERMISSION
OKM_NODE_SUBSCRIPTOR
OKM_NODE_USER_PERMISSION
OKM_PROFILE
OKM_PROFILE_MSC_EXTENSION
OKM_PROFILE_MSC_REPORT
OKM_PROFILE_MSC_WORKFLOW
OKM_PROFILE_WZRD_PROP_GRP
OKM_PROFILE_WZRD_WORKFLOW
OKM_QUERY_PARAMS
OKM_QUERY_PARAMS_CATEGORY
OKM_QUERY_PARAMS_KEYWORD
OKM_QUERY_PARAMS_PROPERTY
OKM_QUERY_PARAMS_SHARED
OKM_REG_PROPERTY
OKM_REG_PROPERTY_GROUP
OKM_REPORT
OKM_ROLE
OKM_TRANSLATION
OKM_TWITTER_ACCOUNT
OKM_USER
OKM_USER_CONFIG
OKM_USER_ITEMS
OKM_USER_NODE
OKM_USER_NODE_KEYWORD
OKM_USER_ROLE



Thanks in advance =)

I'm not sure Oracle is supported by community edition, I remember there're some special code in professional to support it. I think this kind of problems do you have are caused by some special queries that need to be done outside hibernate standard.

Follow these steps:

- Stop Tomcat
- Delete $TOMCAT_HOME/logs/*
- Start Tomcat again

Attach the catalina.log file zipped to see the error.