This worked exactly how I needed it to, thanks!
This worked exactly how I needed it to, thanks!
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?
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...
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...
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...
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...
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 ...
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...
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; +--------------...
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.
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...
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?
Thanks for adding this. I think it fills in some of the holes.
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 ...
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 ...