Mail import error (6.3.9. Community Edition)

We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
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.
Post Reply
MKochS
Senior Boarder
Senior Boarder
Posts: 66
Joined: Wed Nov 13, 2013 10:40 am
Location: Hessen, Germany

Mail import error (6.3.9. Community Edition)

Post by MKochS »

Mail import fail s on a fresh 6.3.9 install ( on Debian Buster). Here's a section of catalina.out:

Code: Select all

2020-04-13 19:00:08,118 [Thread-80] INFO  com.openkm.util.MailUtils - ======= ======= 26 ======= =======
2020-04-13 19:00:08,119 [Thread-80] INFO  com.openkm.util.MailUtils - Folder: INBOX
2020-04-13 19:00:08,126 [Thread-80] INFO  com.openkm.util.MailUtils - Subject: Topic reply notification - "Database error OKM-013024 ndex OKM_DASHBOA
RD_ACTIVITY is corrupted"
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - From: forum@openkm.com
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - Received: Thu Apr 09 12:23:35 CEST 2020
2020-04-13 19:00:08,127 [Thread-80] INFO  com.openkm.util.MailUtils - Sent: Thu Apr 09 12:23:33 CEST 2020
2020-04-13 19:00:08,182 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,182 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.stuff.DbSimpleAccessManager -> isGranted (DbSimpleAccessManager.java:67)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.stuff.SecurityHelper -> checkRead (SecurityHelper.java:98)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.dao.NodeFolderDAO -> findByPk (NodeFolderDAO.java:202)
2020-04-13 19:00:08,183 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.module.db.DbFolderModule -> create (DbFolderModule.java:84)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.api.OKMFolder -> createSimple (OKMFolder.java:68)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.api.OKMFolder -> createMissingFolders (OKMFolder.java:200)
2020-04-13 19:00:08,184 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.MailUtils -> importMessages (MailUtils.java:665)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.MailUtils -> importMessages (MailUtils.java:583)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.UserMailImporter -> runAs (UserMailImporter.java:89)
2020-04-13 19:00:08,185 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.UserMailImporter -> run (UserMailImporter.java:60)
2020-04-13 19:00:08,186 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.util.ExecutionUtils -> runScript (ExecutionUtils.java:106)
2020-04-13 19:00:08,186 [Thread-80] WARN  c.o.m.db.stuff.DbSimpleAccessManager - com.openkm.core.Cron$RunnerBsh -> run (Cron.java:99)
2020-04-13 19:00:08,186 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,187 [Thread-80] INFO  c.o.m.db.stuff.DbSimpleAccessManager - ***************************
2020-04-13 19:00:08,192 [Thread-80] WARN  com.openkm.util.MailUtils - null
java.lang.NullPointerException: null
        at com.openkm.module.db.DbFolderModule.create(DbFolderModule.java:101) ~[classes/:6.3.9]
        at com.openkm.api.OKMFolder.createSimple(OKMFolder.java:68) ~[classes/:6.3.9]
        at com.openkm.api.OKMFolder.createMissingFolders(OKMFolder.java:200) ~[classes/:6.3.9]
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:665) [classes/:6.3.9]
        at com.openkm.util.MailUtils.importMessages(MailUtils.java:583) [classes/:6.3.9]
        at com.openkm.core.UserMailImporter.runAs(UserMailImporter.java:89) [classes/:6.3.9]
        at com.openkm.core.UserMailImporter.run(UserMailImporter.java:60) [classes/:6.3.9]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_252-ea]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_252-ea]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_252-ea]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_252-ea]
        at bsh.Reflect.invokeMethod(Reflect.java:166) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Reflect.invokeObjectMethod(Reflect.java:99) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimarySuffix.doName(BSHPrimarySuffix.java:176) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimarySuffix.doSuffix(BSHPrimarySuffix.java:120) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:80) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:47) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:664) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:758) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at bsh.Interpreter.eval(Interpreter.java:747) [beanshell2-2.1.8.jar:2.1.8 2014-02-20 03:56:17]
        at com.openkm.util.ExecutionUtils.runScript(ExecutionUtils.java:106) [classes/:6.3.9]
        at com.openkm.core.Cron$RunnerBsh.run(Cron.java:99) [classes/:6.3.9]
        at java.lang.Thread.run(Thread.java:748) [na:1.8.0_252-ea]
The mail is available on request.

So far, not a single mail has been imported.


TIA
Matthias

Richard LU
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Thu Apr 16, 2020 7:37 am

Re: Mail import error (6.3.9. Community Edition)

Post by Richard LU »

You can configure mail filters. Take a look at http://wiki.openkm.com/index.php/Administring_users

jllort
Moderator
Moderator
Posts: 11193
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: Mail import error (6.3.9. Community Edition)

Post by jllort »

First, you should not use wiki.openkm.com the documentation from there is deprecated you should use docs.openkm.com

How are you importing the email? with outlook addin, the msg or eml file ?

Post Reply