Essential Import Utility v2.3 errors

Post Reply
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello


I have been trying out the Import Utility v2.3 with no success.
I used Protege to save a snapshot of our mulit-user database repository.
I created a ZIP using the 3 Protege files.
I created a new Live Target Environment using the ZIP file.
I created a new DEVELOPMENT Target Environment using the ZIP file as the related production environment.
I created an Import Activity of type Excel.
I Openned the Import Activity and specified the DEVELOPMENT Target Environment and proceeded to Test Import.

The import did not work. Wondering what is wrong...
Files attached.

Sincerely,
John Nordien
You do not have the required permissions to view the files attached to this post.
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

More on this issue.
I have a prototype server and I ran the import on that system just fine!
The only difference I can see is that my production system is using Tomcat9 whereas the prototype system is using Tomcat8.
All the other components in the solution are the same.

John Nordien.
User avatar
jonathan.carter
Posts: 1087
Joined: 04 Feb 2009, 15:44

Hi,

Thanks for your post - especially for the log files that you included.

It looks like with Tomcat 9, the Import Utility is unable to load and include the file of library functions used by the import engine. Thanks also for testing Import Utility 2.3 with Tomcat 8 and showing that all works fine.

I've tried a fresh install of Tomcat 9 and then installed Essential Import Utility 2.3. I ran our example import and this ran just fine without any errors.

This seems to point towards some configuration on your platform. Could you tell me what operating system you are using?

Make sure that Tomcat applications are allowed to read and write within the Tomcat 9 directory and subdirectories (file system permissions), as this might interfere with the loading of the library file.

In addition to the logs that you have already sent, have a look in the <Tomcat 9 install directory>/logs/catalina.out (catalina.log) for any messages that are reported in there that might provide more clues as to what's not working. Please do forward those on if you don't see anything obvious in there.

Jonathan
Essential Project Team
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello.
Thanks for the reply.
Will have a look at the logs and the filesystem permissions.
Basically I am running on
Linux Mint 19.3
Openjdk 11
Tomcat 9
Mariadb 10

Due to use of Openjdk I had to manually add missing jaxb jar file into Tomcat's lib folder.

John Nordien.
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

And also activation[xxx].jar...
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello.

Reset filesystem permissions on folder tomcat9/webapps/essential_import_utility just to be sure.
Just tried an import to capture fresh tomcat log entries.
-------------
Dec 04 07:50:28 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:28 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:50:28 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
Dec 04 07:50:28 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:28 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:50:28 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
Dec 04 07:50:28 essentialam tomcat9[5220]: Loading labels for en_US
Dec 04 07:50:28 essentialam tomcat9[5220]: Loading labels for en
Dec 04 07:50:28 essentialam tomcat9[5220]: Opening file:/var/lib/tomcat9/webapps/essential_import_utility/WEB-INF/i3-label.properties
Dec 04 07:50:47 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:47 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:47 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:47 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:50:48 essentialam tomcat9[5220]: INITIALISING IMPORT UTILITY APPLICATION
Dec 04 07:50:48 essentialam tomcat9[5220]: java.nio.file.FileSystemException: /java0.log.lck: Read-only file system
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.translateToIOException(UnixException.java:100)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:111)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:116)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixFileSystemProvider.newFileChannel(UnixFileSystemProvider.java:182)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/java.nio.channels.FileChannel.open(FileChannel.java:292)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.base/java.nio.channels.FileChannel.open(FileChannel.java:345)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.logging/java.util.logging.FileHandler.openFiles(FileHandler.java:511)
Dec 04 07:50:48 essentialam tomcat9[5220]: at java.logging/java.util.logging.FileHandler.<init>(FileHandler.java:278)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.integration.ProtegeIntegrationManager.initLoggingProperties(ProtegeIntegrationManager.java:623)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.integration.ProtegeIntegrationManager.<init>(ProtegeIntegrationManager.java:167)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.EssentialImportInterface.getProtegeManager(EssentialImportInterface.java:408)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.EssentialImportInterface.initEssentialClassMap(EssentialImportInterface.java:442)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.EssentialImportInterface.initImportUtilityAppData(EssentialImportInterface.java:191)
Dec 04 07:50:48 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.ManageImportActivityListComposer$3.onEvent(ManageImportActivityListComposer.java:337)
Dec 04 07:50:48 essentialam tomcat9[5220]: at org.zkoss.zk.ui.event.impl.DesktopEventQueue$AsyncListenerThread.run(DesktopEventQueue.java:218)
Dec 04 07:50:48 essentialam tomcat9[5220]: Plugins directory not found: /var/lib/tomcat9/plugins
Dec 04 07:50:48 essentialam tomcat9[5220]: Plugins directory not found: /var/lib/tomcat9/plugins
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:04 essentialam tomcat9[5220]: IMPORT UTILITY APPLICATION INITIALISED
Dec 04 07:51:14 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:51:14 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:51:14 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:51:14 essentialam tomcat9[5220]: CURRENT IMPORT ACTIVITY: OM2_MBLL_Essential_Launchpad_V55_Capture_Spreadsheet - JMN
Dec 04 07:51:15 essentialam tomcat9[5220]: REDRAWING WORKSHEET GRID
Dec 04 07:51:35 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:51:35 essentialam tomcat9[5220]: java.nio.file.FileSystemException: /java0.log.lck: Read-only file system
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.translateToIOException(UnixException.java:100)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:111)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:116)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/sun.nio.fs.UnixFileSystemProvider.newFileChannel(UnixFileSystemProvider.java:182)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.nio.channels.FileChannel.open(FileChannel.java:292)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.nio.channels.FileChannel.open(FileChannel.java:345)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.logging/java.util.logging.FileHandler.openFiles(FileHandler.java:511)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.logging/java.util.logging.FileHandler.<init>(FileHandler.java:278)
Dec 04 07:51:35 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.integration.ProtegeIntegrationManager.initLoggingProperties(ProtegeIntegrationManager.java:623)
Dec 04 07:51:35 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.integration.ProtegeIntegrationManager.<init>(ProtegeIntegrationManager.java:167)
Dec 04 07:51:35 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.EssentialImportInterface.getProtegeManager(EssentialImportInterface.java:408)
Dec 04 07:51:35 essentialam tomcat9[5220]: at com.enterprise_architecture.essential.importutility.ui.TestImportActivityComposer.onClick$runImportBtn(TestImportActivityComposer.java:569)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.lang.reflect.Method.invoke(Method.java:566)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.event.GenericEventListener.onEvent(GenericEventListener.java:80)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:3162)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3132)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3074)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:343)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.event.Events.sendEvent(Events.java:367)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent$ForwardListener.onEvent(AbstractComponent.java:3611)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:3162)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3132)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:3074)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:138)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1846)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1618)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1321)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:606)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:482)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:490)
Dec 04 07:51:35 essentialam tomcat9[5220]: at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
Dec 04 07:51:35 essentialam tomcat9[5220]: at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
Dec 04 07:51:35 essentialam tomcat9[5220]: at psiprobe.Tomcat90AgentValve.invoke(Tomcat90AgentValve.java:35)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
Dec 04 07:51:35 essentialam tomcat9[5220]: at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
Dec 04 07:51:35 essentialam tomcat9[5220]: at java.base/java.lang.Thread.run(Thread.java:834)
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:51:50 essentialam tomcat9[5220]: Unable to load class: edu.stanford.smi.protegex.widget.graph.GraphPoint
Dec 04 07:52:08 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:52:08 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:52:08 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:52:08 essentialam tomcat9[5220]: INITIALISING IMPORT UTILITY APPLICATION
Dec 04 07:52:09 essentialam tomcat9[5220]: IMPORT UTILITY APPLICATION INITIALISED
Dec 04 07:52:10 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@2d40d2d
Dec 04 07:52:10 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@250fc4fb
Dec 04 07:52:10 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:52:10 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
Dec 04 07:52:10 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@250fc4fb
Dec 04 07:52:10 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:52:10 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
Dec 04 07:52:11 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@250fc4fb
Dec 04 07:52:11 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:52:11 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
Dec 04 07:52:11 essentialam tomcat9[5220]: GETTING USER MANAGER FROM SESSION: org.zkoss.zk.ui.http.SimpleSession@250fc4fb
Dec 04 07:52:11 essentialam tomcat9[5220]: Could not connect to Neo4j, reason: Invalid address format ``
Dec 04 07:52:11 essentialam tomcat9[5220]: No bearer token or refresh token, can be caused by user manually logging out which removes the OAuth token cookies.
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello.
I have noticed that Essential Import Utility is not logging to the configured log file according to log4j.properties.
I even have tried to set the log level to INFO.

------ log4j.properties
#log4j.rootLogger=WARN, file
#log4j.rootLogger=ERROR, file
log4j.rootLogger=INFO, file
#log4j.rootLogger=DEBUG, file

### Redirect log messages to console
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d | %5p | %m | %X{tenantId}:%X{userId} | %F | %L%n

### Redirect log messages to a log file
log4j.appender.file=org.apache.log4j.RollingFileAppender
### outputs to Tomcat home
log4j.appender.file.File=${catalina.home}/logs/essential-import-utility.log
log4j.appender.file.MaxFileSize=5MB
log4j.appender.file.MaxBackupIndex=10
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d | %5p | %m | %X{tenantId}:%X{userId} | %F | %L%n

### set the log level on a specific log file
log4j.logger.com.enterprise_architecture.essential.importutility.integration.ProtegeIntegrationManager=debug
log4j.logger.com.enterprise_architecture.essential.importutility.ui.EssentialImportInterface=debug
User avatar
jonathan.carter
Posts: 1087
Joined: 04 Feb 2009, 15:44

Thanks for these details.

I think the cause of your problems that you’ve found could be the OpenJDK 11. Whilst we support Tomcat 9 etc. currently the supported Java version is Java 8. You could try using OpenJDK 8.

OpenJDK 11, could be the cause of some of the messages that you’re seeing in that log, presumably, catalina.out.

In terms of the logging configuration, you are correct. At the moment, the Essential Import Utility does not use the log4j configuration for all its logging. Some of the Import Utility classes are configured to use log4J but in general, application logging goes into catalina.out right now.

Jonathan
Essential Project Team
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Thanks for the reply.
The prototype system where Import Utility v2.3 is running in Tomcat8 and was performing imports is also using OpenJDK v11.
I am still, as time permits, working the issue.

John Nordien.
User avatar
jonathan.carter
Posts: 1087
Joined: 04 Feb 2009, 15:44

Thanks for posting back - and the confirmation that Open JDK 11 works happily.

We've done a lot within the Import Utility to support Unicode etc. and have worked successfully with non-latin character sets etc. but I wonder if actually the issue is down to the 'data' that's being imported, or the import specification itself.

Would you be happy to share your Import Specification and your source spreadsheet with us to try to replicate your issue?

Feel free to email us directly rather than posting here.

Thanks

Jonathan
Essential Project Team
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello.
Have been using Launchpad v5. The same errors occur whether attempting the University Example or using the blank Capture Worksheet, along with the supplied import spec.
I built both systems/servers. Followed my notes etc each time. Don't know what is different between the system builds, except that the "production" system is running on VMware and the prototype is running on my desktop within Virtualbox on Windows 10.

John Nordien.
User avatar
jonathan.carter
Posts: 1087
Joined: 04 Feb 2009, 15:44

Thanks.

You mentioned that you needed to add 2 JAR files to get this working - JAXB and Activation.jar.

Did you have to add these when running with Tomcat 8?

When I built my Tomcat 9 environment, I didn't need to introduce any additional components. I'm wondering whether these additional JARs could be causing some unexpected behaviour

Jonathan
Essential Project Team
john.nordien
Posts: 56
Joined: 17 Sep 2019, 14:50
Location: Winnipeg, Manitoba, CANADA
Contact:

Hello.
This has been a real fun trip into the world of Java webapps on Tomcat. (^_^)

I had a multi-user solution of Protege+Essential and Essential Viewer working back in early 2019.
While wrestling with deploying the updated Essential Viewer 6.9, originally on Tomcat 8 with OpenJDK 11, I noticed the catalina.out errors pointing to missing jaxb libraries not on the classpath. I had backups of the previous working version and in the WEB-INF/lib folder I found 2 files; jaxb-api.jar and jaxb-impl.jar. These files were not included in the new Essential Viewer war file.
I copied them to the new deployment of Essential Viewer WEB-INF/lib folder and restarted TOMCAT. Essential Viewer was running normally again.

Over time I have updated the deployment to Essential Viewer v9, v10, and now v11, all running on OpenJDK 11. It was a plodding administrative task to manually supplement the prod, test, and dev versions of Essential Viewer I had deployed with the missing jar files in each WEB-INF/lib, but it worked. I eventually figured out that these jar files should be copied into Tomcat's lib folder in $TOMCAT_HOME/lib, which is also part of the classpath. In Linux Mint 19.3, this folder is /var/lib/tomcat[8|9]/lib.

When trying to deploy Import Utility I again had errors regarding missing jar files. I eventually found the GitHub site for jaxb-v2 (https://github.com/javaee/jaxb-v2) and downloaded the Standalone Distribution using the links at the end of the page. I copied the following jar files from jaxb-v2 to $TOMCAT_HOME/lib; jaxb-core.jar, jaxb-api.core, jaxb-impl.jar.
When Tomcat was started there was indication of a missing "activation" jar file. I looked at Essential Viewer and found activation-1.1.jar. Copied this to $TOMCAT_HOME/lib. Import_Utility is now running.

So, for Essential Viewer and Import Utility, whether running Tomcat8 or Tomcat9 with openJDK 11, you need to have the jaxb libs and activation lib in $TOMCAT_HOME/lib.
I presume that this is true for any Java newer than Java 8.

This setup for Tomcat and Essential Viewer v11 & Import Utility v2.3 is the same for both my prototype server in Virtualbox and the production server running on VMware.
There is a needle in the haystack on the production server regarding the Tomcat 9 installation, which was installed using the built-in package manager.

John Nordien.
mooncat
Posts: 2
Joined: 25 Feb 2021, 00:09

I noticed the JAXB errors and took the easy route - ran Tomcat 9 with OpenJDK 1.8. Is that cheating?
Post Reply