Search found 120 matches

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

Re: SQL Report in iReport

This worked exactly how I needed it to, thanks!
by dferguson
Wed May 16, 2018 5:05 pm
Forum: Usage
Topic: Filter nodes in Category view not available
Replies: 1
Views: 420

Filter nodes in Category view not available

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
by dferguson
Tue May 15, 2018 2:58 pm
Forum: Usage
Topic: Scipt to edit database values?
Replies: 2
Views: 468

Re: Scipt to edit database values?

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...
by dferguson
Tue May 15, 2018 1:49 pm
Forum: Usage
Topic: Scipt to edit database values?
Replies: 2
Views: 468

Scipt to edit database values?

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...
by dferguson
Wed Apr 18, 2018 12:47 pm
Forum: Usage
Topic: SQL Report in iReport
Replies: 6
Views: 1162

Re: SQL Report in iReport

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...
by dferguson
Mon Apr 16, 2018 8:18 pm
Forum: Usage
Topic: SQL Report in iReport
Replies: 6
Views: 1162

SQL Report in iReport

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...
by dferguson
Mon Apr 16, 2018 12:44 pm
Forum: Usage
Topic: Openkm/Catalina not stopping
Replies: 6
Views: 1294

Re: Openkm/Catalina not stopping

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 ...
by dferguson
Wed Apr 11, 2018 12:54 pm
Forum: Usage
Topic: Openkm/Catalina not stopping
Replies: 6
Views: 1294

Openkm/Catalina not stopping

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 where to ...
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: 631

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

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; +--------------...
by dferguson
Tue Apr 03, 2018 1:14 pm
Forum: Usage
Topic: Backup with rsync questions
Replies: 12
Views: 1810

Re: Backup with rsync questions

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.
by dferguson
Mon Mar 26, 2018 5:06 pm
Forum: Usage
Topic: Backup with rsync questions
Replies: 12
Views: 1810

Re: Backup with rsync questions

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...
by dferguson
Thu Mar 22, 2018 2:06 pm
Forum: Usage
Topic: Backup with rsync questions
Replies: 12
Views: 1810

Re: Backup with rsync questions

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?
by dferguson
Wed Mar 21, 2018 1:51 pm
Forum: Configuration
Topic: Create Metadata in Workflow - Exercise 8
Replies: 22
Views: 5966

Re: Create Metadata in Workflow - Exercise 8

Thanks for adding this. I think it fills in some of the holes.
by dferguson
Wed Mar 21, 2018 1:48 pm
Forum: Usage
Topic: Document Wizard lauching when creating document from template
Replies: 8
Views: 1053

Re: Document Wizard lauching when creating document from template

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 to the new...
by dferguson
Mon Mar 19, 2018 5:57 pm
Forum: Configuration
Topic: Creating Workflows
Replies: 10
Views: 2398

Re: Creating Workflows

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 ...