• Search

  • Search it up!

Search found 120 matches

 Go to advanced search

Re: SQL Report in iReport

 by dferguson ¦  Thu Jul 12, 2018 1:31 pm ¦  Forum: Usage ¦  Topic: SQL Report in iReport ¦  Replies: 6 ¦  Views: 5401

This worked exactly how I needed it to, thanks!

Filter nodes in Category view not available

 by dferguson ¦  Wed May 16, 2018 5:05 pm ¦  Forum: Usage ¦  Topic: Filter nodes in Category view not available ¦  Replies: 1 ¦  Views: 1225

I have noticed that the filter options aren't available when looking at nodes in the Categories view. Is this a feature, bug or misconfiguration?

Screenshot from 2018-05-16 13-05-30.png
Screenshot from 2018-05-16 13-05-30.png (64.83 KiB) Viewed 1225 times

Re: Scipt to edit database values?

 by dferguson ¦  Tue May 15, 2018 2:58 pm ¦  Forum: Usage ¦  Topic: Scipt to edit database values? ¦  Replies: 2 ¦  Views: 1500

I think I accomplished the same result by the following.... SELECT NSB_NODE, NBS_NAME FROM OKM_NODE_SUBSCRIPTOR inner join OKM_NODE_BASE on OKM_NODE_SUBSCRIPTOR.NSB_NODE = OKM_NODE_BASE.NBS_UUID where NBS_PARENT = '46209ab6-4629-4d39-978d-935f993fa3f8'; to verify I had the correct list. Then the fol...

Scipt to edit database values?

 by dferguson ¦  Tue May 15, 2018 1:49 pm ¦  Forum: Usage ¦  Topic: Scipt to edit database values? ¦  Replies: 2 ¦  Views: 1500

I would like to bulk remove subscriptions to documents based on their parent folder. I am using this to delete the subscription to an individual document based on the UUID. DELETE FROM OKM_NODE_SUBSCRIPTOR WHERE NSB_NODE = 'a621eb44-3136-467f-8848-de904147f709'; This works well, but I have an entire...

Re: SQL Report in iReport

 by dferguson ¦  Wed Apr 18, 2018 12:47 pm ¦  Forum: Usage ¦  Topic: SQL Report in iReport ¦  Replies: 6 ¦  Views: 5401

Thank for that, but I still get this error... Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'okmdb.OKM_NODE_BASE.NBS_NAME' which is not functionally dependent on columns in GROUP BY claus...

SQL Report in iReport

 by dferguson ¦  Mon Apr 16, 2018 8:18 pm ¦  Forum: Usage ¦  Topic: SQL Report in iReport ¦  Replies: 6 ¦  Views: 5401

I have really struggled to get a filtered view of some SQL query results to put in a iReport for one of our users. We are using the subscription feature AND the 'GET_DOCUMENT_CONTENT to verify that users have self-trained on required documents. Using iReport I built this query... SELECT OKM_ACTIVITY...

Re: Openkm/Catalina not stopping

 by dferguson ¦  Mon Apr 16, 2018 12:44 pm ¦  Forum: Usage ¦  Topic: Openkm/Catalina not stopping ¦  Replies: 6 ¦  Views: 7680

Here is my tomcat script... #!/bin/sh ### BEGIN INIT INFO # Provides: tomcat # Required-Start: $remote_fs $syslog # Required-Stop: $remote_fs $syslog # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Short-Description: Start and stop Apache Tomcat # Description: Enable Apache Tomcat service provided ...

Openkm/Catalina not stopping

 by dferguson ¦  Wed Apr 11, 2018 12:54 pm ¦  Forum: Usage ¦  Topic: Openkm/Catalina not stopping ¦  Replies: 6 ¦  Views: 7680

I am having a reoccurring issue where OpenKM isn't stopping as it should during backups and this morning I found the site was down. A simple service tomcat start/stop would not reset the instance. I had to "kill -9 PID" to kill the java PIDs holding the ports used for OpenKM. I am not sure...

Error: Data too long for column 'PS_TO' at row 1

 by dferguson ¦  Tue Apr 03, 2018 1:16 pm ¦  Forum: Usage ¦  Topic: Error: Data too long for column 'PS_TO' at row 1 ¦  Replies: 1 ¦  Views: 1752

We are getting the error when trying to send document subscriptions to several users at once: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PS_TO' at row 1 I did some digging and found this: Database changed mysql> show columns from OKM_PROP_SUB_SENT; +--------------...

Re: Backup with rsync questions

 by dferguson ¦  Tue Apr 03, 2018 1:14 pm ¦  Forum: Usage ¦  Topic: Backup with rsync questions ¦  Replies: 12 ¦  Views: 4590

Ok, thanks. I have had reliable operation with both Ubuntu and Openkm since deleting the catalina.pid file that last time. I will monitor in the future.

Re: Backup with rsync questions

 by dferguson ¦  Mon Mar 26, 2018 5:06 pm ¦  Forum: Usage ¦  Topic: Backup with rsync questions ¦  Replies: 12 ¦  Views: 4590

I assume OpenKM starts as a service, because I don't actively have to do anything at boot. Occasionally my Ubuntu 16.04 crashes/freezes and I have no keyboard/mouse control and monitor is black. Furthermore I can't SSH to the machine either. My only solution is a hard reboot. Sometimes everything re...

Re: Backup with rsync questions

 by dferguson ¦  Thu Mar 22, 2018 2:06 pm ¦  Forum: Usage ¦  Topic: Backup with rsync questions ¦  Replies: 12 ¦  Views: 4590

I have developed an issue where my backups arent happening. The backup cron job gets executed but nothign happens. When I open the log I see...

Stopping TomcatPID file found but no matching process was found. Stop aborted.
How can I solve this?

Re: Create Metadata in Workflow - Exercise 8

 by dferguson ¦  Wed Mar 21, 2018 1:51 pm ¦  Forum: Configuration ¦  Topic: Create Metadata in Workflow - Exercise 8 ¦  Replies: 29 ¦  Views: 22573

Thanks for adding this. I think it fills in some of the holes.

Re: Document Wizard lauching when creating document from template

 by dferguson ¦  Wed Mar 21, 2018 1:48 pm ¦  Forum: Usage ¦  Topic: Document Wizard lauching when creating document from template ¦  Replies: 8 ¦  Views: 3616

Well, I can still put doc files in the okm:templates and still use the "create from template" feature. However the automatic entry of metadata doesn't execute. This is fine. However, with a pdf that has not been previously assigned a metadata group, this feature is adding metadata entries ...

Re: Creating Workflows

 by dferguson ¦  Mon Mar 19, 2018 5:57 pm ¦  Forum: Configuration ¦  Topic: Creating Workflows ¦  Replies: 10 ¦  Views: 6696

I have done both. I have settled on installing the portable dev on a virtual machine separate from the machine which only runs OpenKM. That makes backup and maintenance of OpenKM easier and less messier if I have to rebuild and frees up my portable dev environment for me to experiment and try risky ...

  • 1
  • 2
  • 3
  • 4
  • 5
  • 8

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.